Cognos data import: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (→Background) |
Ttenbergen (talk | contribs) m (→Process) |
||
| Line 3: | Line 3: | ||
== Process == | == 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. | 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. | ||
=== Outlook Rule in Tina's profile to get data to Pagasa === | |||
Decision Support Services sends a report to Tina. The report needs to go to Pagasa so we can schedule the automated import on a machine that sits on WRHA network at all times. So, there is an outlook rule "Cognos to Pagasa" in Tina's Outlook profile to forward the email to Pagasa. | |||
{{Discuss | import not yet set up on Pagasa's PC. }} | |||
=== Data import instructions === | === Data import instructions === | ||
# the process will roll out any current changes in the local file; if anything was changed, update [[log]] saying it has been rolled out | # the process will roll out any current changes in the local file; if anything was changed, update [[log]] saying it has been rolled out | ||
Revision as of 09:32, 2020 August 20
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.
Outlook Rule in Tina's profile to get data to Pagasa
Decision Support Services sends a report to Tina. The report needs to go to Pagasa so we can schedule the automated import on a machine that sits on WRHA network at all times. So, there is an outlook rule "Cognos to Pagasa" in Tina's Outlook profile to forward the email to Pagasa.
|
import not yet set up on Pagasa's PC. |
Data import instructions
- the process will roll out any current changes in the local file; if anything was changed, update log saying it has been rolled out
- save the CCMdb Sample.xlsx file that Chastity sends to the desktop
- double-click on LoadCognos.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
- if data is good, click enter in the shell window to proceed with copy
- 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
|
|
Currently this process lives on Tina's laptop, and Tina is the only one who can do it. We need a better solution. |
Background
- LoadCognos.bat calls
- LoadCognos.vbs which calls
- CCMDB.accdb.Sub CognosImport for the actual steps performed during import, and how the queries and tables work together and the email to collectors is generated.
- process then returns to LoadCognos.bat which copies CCMDB.accdb to the Regional Server and then calls Updt all.bat to roll it out to all collectors
Related articles
| Related articles: |
|