Function CognosImport: Difference between revisions

(21 intermediate revisions by the same user not shown)

Line 1:

'''{{PAGENAME}}''' is the sub that accomplishes the [[Cognos EPR Report]] importing as part of [[Cognos data import]] .

'''{{PAGENAME}}''' is the sub that accomplishes the [[Cognos EPR Report]] importing as part of [[Cognos data import]].

* cleans out [[~~Cognos_import~~ table]] ~~and~~ [[~~Cognos_processed table~~]]

== Approximate algorithm==

* ~~imports "page1_1!" and "page2_2!" from~~ [[~~Cognos EPR Report~~]]

Check the sub itself for the actual current process.

* runs [[query ~~Cognos_import_processor~~]] ~~to turn the data into the format we need~~

* again cleans out temporary ~~table [[Cognos_import table]]~~

* tries for an hour to save file "CCMdb Sample.xlsx" from an email from [[Chastity]]

** if email is not found in that timeframe, it will send an email to dc cc and quit

* cleans out the tmp tables where raw Cognos data is stored

* imports the correct tab (3) from [[Cognos EPR Report]] into raw data table [[Cognos_import3 table]]

* runs [[Cognos2_import_Cognos2_OneTime query]]

* runs [[Cognos3_import_Cognos2_Units query]]

* runs [[Cognos3_import_Cognos2_Services query]]

* again cleans out temporary raw data tables

* starts the email that will tell collectors that the new data is now available

* ~~runs the~~ [[~~Cognos_dispo_translator_additions_needed~~ query]] ~~to notify~~ if new ~~locations are in~~ the ~~data that are not in~~ [[~~Cognos_dispo_translator~~ table]] ~~yet (these are then~~ sent to ~~collector~~ to find out what ~~entries in~~ [[~~s_dispo~~ table]] ~~they correspond~~ to)

** checks [[s_Cognos_Units_additions_needed query]]; if it finds new entries, an email is sent to a the [[Data Collection Manager]] and the [[Process Analyst]] to find out what should be added to [[s_Cognos_Units table]] to map the new entries to entries of [[s_dispo table]]; the email will be sent each time this is run until the answer is added to [[S Cognos Units table]]

** checks [[s_Cognos_Services_additions_needed query]]; if it finds new entries, an email is sent to a Tina to find out what should be added to [[s_Cognos_Services table]]; the email will be sent each time this is run until the answer is added to [[s_Cognos_Services table]]

== Related articles ==

Line 12:

Line 20:

[[Category:Cognos Report Integrator]]

[[Category:CCMDB.accdb]]

@@ Line 1: / Line 1: @@
-'''{{PAGENAME}}''' is the sub that accomplishes the [[Cognos EPR Report]] importing as part of [[Cognos data import]] .
+'''{{PAGENAME}}''' is the sub that accomplishes the [[Cognos EPR Report]] importing as part of [[Cognos data import]].
-* cleans out [[Cognos_import table]] and [[Cognos_processed table]]
+== Approximate algorithm==
-* imports "page1_1!" and "page2_2!" from [[Cognos EPR Report]]
+Check the sub itself for the actual current process.
-* runs [[query Cognos_import_processor]] to turn the data into the format we need
-* again cleans out temporary table [[Cognos_import table]]
+* tries for an hour to save file "CCMdb Sample.xlsx" from an email from [[Chastity]]
+** if email is not found in that timeframe, it will send an email to dc cc and quit
+* cleans out the tmp tables where raw Cognos data is stored
+* imports the correct tab (3) from [[Cognos EPR Report]] into raw data table [[Cognos_import3 table]]
+* runs [[Cognos2_import_Cognos2_OneTime query]]
+* runs [[Cognos3_import_Cognos2_Units query]]
+* runs [[Cognos3_import_Cognos2_Services query]]
+* again cleans out temporary raw data tables
 * starts the email that will tell collectors that the new data is now available
-* runs the [[Cognos_dispo_translator_additions_needed query]] to notify if new locations are in the data that are not in [[Cognos_dispo_translator table]] yet (these are then sent to collector to find out what entries in [[s_dispo table]] they correspond to)
+** checks [[s_Cognos_Units_additions_needed query]]; if it finds new entries, an email is sent to a the [[Data Collection Manager]] and the [[Process Analyst]] to find out what should be added to [[s_Cognos_Units table]] to map the new entries to entries of [[s_dispo table]]; the email will be sent each time this is run until the answer is added to [[S Cognos Units table]]
+** checks [[s_Cognos_Services_additions_needed query]]; if it finds new entries, an email is sent to a Tina to find out what should be added to [[s_Cognos_Services table]]; the email will be sent each time this is run until the answer is added to [[s_Cognos_Services table]]
 == Related articles ==
@@ Line 12: / Line 20: @@
 [[Category:Cognos Report Integrator]]
+[[Category:CCMDB.accdb]]