Cognos data import: Difference between revisions

Line 9:

=== Scheduled Task on Pagasa's PC ===

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)~~

* [[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 [[Rolling out changes | roll it out]] to all collectors

==== Fallback process ====

The import can also be manually run on Tina's laptop 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! '''

~~There should be no instructions required if the scheduled task running [[LoadCognos.bat]] works. Follow the trail through that file if troubleshooting is required.~~

=== newly encountered units ===

Line 17:

Line 23:

=== newly encountered services ===

If a service is encountered that isn't in [[S Cognos Services table]] an email will be sent to Tina. The new service then needs to be added to [[~~Cognos_SubServices~~ table]] with the other fields filled in appropriately. [[Service tmp entry]] entries need to be considered to see if they need to be updated.

If a service is encountered that isn't in [[S Cognos Services table]] an email will be sent to Tina. The new service then needs to be added to [[s_Cognos_Services table]] with the other fields filled in appropriately. [[Service tmp entry]] entries need to be considered to see if they need to be updated.

~~== 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 [[Rolling out changes | roll it out]] to all collectors

== Known problems with data import ==

@@ Line 9: / Line 9: @@
 === Scheduled Task on Pagasa's PC ===
 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)
+* [[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 [[Rolling out changes | roll it out]] to all collectors
+==== Fallback process ====
+The import can also be manually run on Tina's laptop 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! '''
-There should be no instructions required if the scheduled task running [[LoadCognos.bat]] works. Follow the trail through that file if troubleshooting is required.
 === newly encountered units ===
@@ Line 17: / Line 23: @@
 === newly encountered services ===
-If a service is encountered that isn't in [[S Cognos Services table]] an email will be sent to Tina. The new service then needs to be added to [[Cognos_SubServices table]] with the other fields filled in appropriately. [[Service tmp entry]] entries need to be considered to see if they need to be updated.
+If a service is encountered that isn't in [[S Cognos Services table]] an email will be sent to Tina. The new service then needs to be added to [[s_Cognos_Services table]] with the other fields filled in appropriately. [[Service tmp entry]] entries need to be considered to see if they need to be updated.
-== 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 [[Rolling out changes | roll it out]] to all collectors
 == Known problems with data import ==