Cognos data import: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m →Process |
||
| Line 4: | Line 4: | ||
Tina receives the data in a scheduled, automated email from Chastity every morning as early as possible, usually before 8. The data is then imported into [[CCMDB.accdb]] and provided to collectors via regular roll-out and news and backup. | Tina receives the data in a scheduled, automated email from Chastity every morning as early as possible, usually before 8. The data is then imported into [[CCMDB.accdb]] and provided to collectors via regular roll-out and news and backup. | ||
{{ | # save the ''CCMdb Sample.xlsx'' file that Chastity sends to the desktop | ||
# go to the {{Regionalserver|Programs\Master}} | |||
# double-click on the file '''doCognosImport.bat''' and wait for it to finish (this can take a few minutes) | |||
# email collectors that the data has been imported | |||
{{TT | this could still also start an email automatically, find code in the Limesurvey processor}} | |||
== Background == | |||
{{TT|doCognosImport.bat runs LoadCognos.vbs to automate this, testing in progress | |||
}} | }} | ||