Cognos data import: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
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.


{{TT |_DEV -  
# save the ''CCMdb Sample.xlsx'' file that Chastity sends to the desktop
* Need to make this so the code can be run from button-press, or better yet, from script that includes roll-out and start of email.
# go to the {{Regionalserver|Programs\Master}}
** started files doCognosImport.bat and LoadCognos.vbs to automate this, testing in progress
# 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
}}
}}



Revision as of 17:35, 2020 June 24

This page explains how to get data from the Cognos EPR Report into CCMDB.accdb and rolled out to collectors.

Process

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.

  1. save the CCMdb Sample.xlsx file that Chastity sends to the desktop
  2. go to the Regional Server\Programs\Master (full address: \\ad.wrha.mb.ca\WRHA\REGION\SHARED\ICU_DATA_COLLECTION\Programs\Master)
  3. double-click on the file doCognosImport.bat and wait for it to finish (this can take a few minutes)
  4. email collectors that the data has been imported

this could still also start an email automatically, find code in the Limesurvey processor

  • added: no added date
  • action: no action date
  • Cargo


  • Categories

Background

doCognosImport.bat runs LoadCognos.vbs to automate this, testing in progress

  • added: no added date
  • action: no action date
  • Cargo


  • Categories

Related articles

Related articles: