Cognos data import: Difference between revisions

Line 7:

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 ===

=== Importing and rolling out to [[Data Collector]s ===

~~There is~~ a scheduled ~~task~~ on ~~Pagasa's~~ PC ~~that calls~~ [[LoadCognos.bat]] ~~early each morning~~.

{{Collapsable | always=Expand this for the scheduled task process that we used to run and hope to run again | full=

Before the main office moved to work from home, we had a task scheduled on the [[Data Processor PC]] to take care of the import and roll-out process as soon as the data arrived.

With work from home we can no longer rely on a PC being available to run this task so it is done manually for now.

}}

==== Steps to import and roll out ====

Each morning the [[Data Processor]] runs [[LoadCognos.bat]]. If the data collector is unavailable, Tina does this. Anyone who has the requisite email in their mailbox would be able to run this, but for now only Lisa receives it as a final fall-back.

==== What happens in the process ====

{{Collapsable | always=This information is only relevant for troubleshooting and should not usually be done manually. | full=

* [[LoadCognos.bat]] calls

* [[LoadCognos.vbs]] which calls

Line 14:

Line 24:

* 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

~~====~~ Fallback process ~~====~~

'''Fallback process'''

The import can also be manually run on any ~~laptop~~ that has [[CCMDB.accdb]] using the [[Cognos2_Service_Starter#Cognos_Import_Button]] and the data can be manually sent out to collectors following the same process as [[Rolling out changes]].

The import can also be manually run on any computer that has [[CCMDB.accdb]] using the [[Cognos2_Service_Starter#Cognos_Import_Button]] and the data can be manually sent out to collectors following the same process as [[Rolling out changes]].

'''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! '''

}}

=== newly encountered units ===

@@ Line 7: / Line 7: @@
 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 ===
+=== Importing and rolling out to [[Data Collector]s ===
-There is a scheduled task on Pagasa's PC that calls [[LoadCognos.bat]] early each morning.
+{{Collapsable | always=Expand this for the scheduled task process that we used to run and hope to run again | full=
+Before the main office moved to work from home, we had a task scheduled on the [[Data Processor PC]] to take care of the import and roll-out process as soon as the data arrived.
+With work from home we can no longer rely on a PC being available to run this task so it is done manually for now.
+}}
+==== Steps to import and roll out ====
+Each morning the [[Data Processor]] runs [[LoadCognos.bat]]. If the data collector is unavailable, Tina does this. Anyone who has the requisite email in their mailbox would be able to run this, but for now only Lisa receives it as a final fall-back.
+==== What happens in the process ====
+{{Collapsable | always=This information is only relevant for troubleshooting and should not usually be done manually. | full=
 * [[LoadCognos.bat]] calls
 * [[LoadCognos.vbs]] which calls
@@ Line 14: / Line 24: @@
 * 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
-==== Fallback process ====
+'''Fallback process'''
-The import can also be manually run on any laptop that has [[CCMDB.accdb]] using the [[Cognos2_Service_Starter#Cognos_Import_Button]] and the data can be manually sent out to collectors following the same process as [[Rolling out changes]].
+The import can also be manually run on any computer that has [[CCMDB.accdb]] using the [[Cognos2_Service_Starter#Cognos_Import_Button]] and the data can be manually sent out to collectors following the same process as [[Rolling out changes]].
 '''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! '''
+}}
 === newly encountered units ===