Cognos data import: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
(→‎Background: Cognos issue Sept 4.20)
(2 intermediate revisions by 2 users not shown)
Line 2: Line 2:


== 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]] master on Regional server and provided to collectors via regular roll-out and news and backup.


=== Outlook Rule in Tina's profile to get data to Pagasa ===
=== Outlook Rule in Tina's profile to get data to Pagasa ===
Line 19: Line 19:
* [[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.
* [[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 [[Rolling out changes | roll it out]] to all collectors
* process then returns to [[LoadCognos.bat]] which copies [[CCMDB.accdb]] to the [[Regional Server]] and then calls [[Updt all.bat]] to [[Rolling out changes | roll it out]] to all collectors
== Cognos Error/ ProblemLog ==
{{Discuss| Tina, not sure where you want keep and error log and trouble shooting steps.}}
'''2020_Sep_04''' - task ran on Pagasa computer however the error message was:  for Access  TYPE mismatch...13.  We did not know where to look for the field mismatch issue to find out which it was.
*other bug that appeared after Cognos ran today was the CCMDB PROGRAM was popping up a PW message box when you EXIT. Had to press cancel to get rid of it. [[User:TOstryzniuk|Trish Ostryzniuk]] 15:15, 2020 September 4 (CDT)


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

Revision as of 15:15, 2020 September 4

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 master on Regional server 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.

Scheduled Task on Pagasa's PC

import not yet set up on Pagasa's PC. 
  • SMW


  • Cargo


  • Categories

Data import instructions

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.

Background

Cognos Error/ ProblemLog

Tina, not sure where you want keep and error log and trouble shooting steps.
  • SMW


  • Cargo


  • Categories

2020_Sep_04 - task ran on Pagasa computer however the error message was: for Access TYPE mismatch...13. We did not know where to look for the field mismatch issue to find out which it was.

  • other bug that appeared after Cognos ran today was the CCMDB PROGRAM was popping up a PW message box when you EXIT. Had to press cancel to get rid of it. Trish Ostryzniuk 15:15, 2020 September 4 (CDT)

Related articles

Related articles: