Cognos data import: Difference between revisions

Created page with "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, aut..."
 
Line 2: Line 2:


== Process ==
== Process ==
Tina receives the data in a scheduled, automated email from Chastity every morning at 7:46. 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_CCMDB -  
{{TT |_DEV_CCMDB -  
* 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. }}
* 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.  
 
** started files doCognosImport.bat and LoadCognos.vbs to automate this, testing in progress
}}


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