Cognos data import: Difference between revisions

PTorres (talk | contribs)
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.  
{{Discuss|*where does the scheduled task pull the data from?  Chasity email with excel? }}
 
=== 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)
=== Data import instructions ===
'''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 Tin'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! '''
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.