Cognos data import: Difference between revisions
TOstryzniuk (talk | contribs) mNo edit summary |
|||
| Line 5: | Line 5: | ||
=== Outlook Rule in Tina's profile to get data to Pagasa === | === 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. | 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 from Chastity. | ||
=== Scheduled Task on Pagasa's PC === | === Scheduled Task on Pagasa's PC === | ||
There is a scheduled task on Pagasa's PC that calls [[LoadCognos.bat]] early each morning. | There is a scheduled task on Pagasa's PC that calls [[LoadCognos.bat]] early each morning. | ||
*it pulls the data from and Excel sheet in an email that is sent to Pagasa (from a Chastity who is works in decision support) | |||
'''When run on Tina's computer the process will roll out any current changes in the local file; if anything was changed, update [[log]] saying it has been rolled out! ''' | |||
'''When run on | |||
There should be no instructions required if the scheduled task running [[LoadCognos.bat]] works. Follow the trail through that file if troubleshooting is required. | There should be no instructions required if the scheduled task running [[LoadCognos.bat]] works. Follow the trail through that file if troubleshooting is required. | ||