Function CognosImport: Difference between revisions

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]].

* tries for an hour to save file CCMdb Sample.xlsx from email from Chastity Cleofas

== Approximate algorithm==

Check the sub itself for the actual current process.

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

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

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

* imports "page1_1!" and "page2_2!" from [[Cognos EPR Report]] into [[Cognos_import table]]

* runs [[Cognos_import_processor query]] to turn the data into the format we need and store it in [[Cognos_processed table]]

* runs [[Cognos2_import_Cognos2_OneTime query]]

* runs [[Cognos2_import_Cognos2_Units query]]

* runs [[Cognos2_import_Cognos2_Services query]]

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

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

** [[s_Cognos_Units_additions_needed query]] ~~runs automatically~~; if it finds new entries, an email is sent to a Lisa Kaita 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 [[Cognos Admit filter table]]

** checks [[s_Cognos_Units_additions_needed query]]; if it finds new entries, an email is sent to a Lisa Kaita 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 [[Cognos Admit filter table]]

** [[s_Cognos_Services_additions_needed query]] ~~runs automatically~~; 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 [[~~Cognos_SubServices~~ 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 [[Cognos_Services table]]

== Related articles ==

@@ 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]].
-* tries for an hour to save file CCMdb Sample.xlsx from email from Chastity Cleofas
+== Approximate algorithm==
+Check the sub itself for the actual current process.
+* tries for an hour to save file "CCMdb Sample.xlsx" from an email from Chastity Cleofas
 ** if email is not found in that timeframe, it will send an email to dc cc, dc med and quit
 * cleans out [[Cognos_import table]] and [[Cognos_processed table]]
 * imports "page1_1!" and "page2_2!" from [[Cognos EPR Report]] into [[Cognos_import table]]
 * runs [[Cognos_import_processor query]] to turn the data into the format we need and store it in [[Cognos_processed table]]
+* runs [[Cognos2_import_Cognos2_OneTime query]]
+* runs [[Cognos2_import_Cognos2_Units query]]
+* runs [[Cognos2_import_Cognos2_Services query]]
 * again cleans out temporary table [[Cognos_import table]]
 * starts the email that will tell collectors that the new data is now available
-** [[s_Cognos_Units_additions_needed query]] runs automatically; if it finds new entries, an email is sent to a Lisa Kaita 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 [[Cognos Admit filter table]]
+** checks [[s_Cognos_Units_additions_needed query]]; if it finds new entries, an email is sent to a Lisa Kaita 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 [[Cognos Admit filter table]]
-** [[s_Cognos_Services_additions_needed query]]  runs automatically; 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 [[Cognos_SubServices 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 [[Cognos_Services table]]
 == Related articles ==