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.


# the process will roll out the current changes in the local file; if anything was change, update [[log]] saying it has been rolled out Ttenbergen 23:19, 2020 July 24 (CDT)
# save the ''CCMdb Sample.xlsx'' file that Chastity sends to the desktop
# save the ''CCMdb Sample.xlsx'' file that Chastity sends to the desktop
# go to the {{Regionalserver|Programs\Master}}
# double-click on [[LoadCognos.bat]] and wait for it to finish (this can take a few minutes)
# double-click on the file '''doCognosImport.bat''' and wait for it to finish (this can take a few minutes)
# at some point it will list the current date/time and the newest Cognos record's date/time; the newest record should be from late last night. If it is not, you may not have saved the file right, or there may have been problems with the ETL that drives Cognos. If so, press ctrl-c to stop the process
# email collectors that the data has been imported
# if data is good, click enter in the shell window to proceed with copy
{{TT | this could still also start an email automatically, find code in the Limesurvey processor}}
# if copy goes OK, press enter in the next shell window to roll out to all collectors
# the process will have automatically started 1 or possibly 2 emails; send them


== Background ==
== Background ==
{{TT|
* [[Cognos EPR Report]]
* doCognosImport.bat runs LoadCognos.vbs to automate this, testing in progress
* [[LoadCognos.bat]]
}}
* [[LoadCognos.vbs]]
* [[Sub CognosImport]]
* [[Cognos_dispo_translator_additions_needed query]]  
* [[Cognos_dispo_translator_additions_needed query]]  
* [[Sub CognosImport]]


== Related articles ==  
== Related articles ==  

Revision as of 23:19, 2020 July 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. the process will roll out the current changes in the local file; if anything was change, update log saying it has been rolled out Ttenbergen 23:19, 2020 July 24 (CDT)
  2. save the CCMdb Sample.xlsx file that Chastity sends to the desktop
  3. double-click on LoadCognos.bat and wait for it to finish (this can take a few minutes)
  4. at some point it will list the current date/time and the newest Cognos record's date/time; the newest record should be from late last night. If it is not, you may not have saved the file right, or there may have been problems with the ETL that drives Cognos. If so, press ctrl-c to stop the process
  5. if data is good, click enter in the shell window to proceed with copy
  6. if copy goes OK, press enter in the next shell window to roll out to all collectors
  7. the process will have automatically started 1 or possibly 2 emails; send them

Background

Related articles

Related articles: