Function CognosImport: Difference between revisions

Line 6:

* 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]]~~

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

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

* imports the correct tab (3) from [[Cognos EPR Report]] into raw data 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 [[Cognos3_import_Cognos2_Units query]]

* runs [[Cognos3_import_Cognos2_Services query]]

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

* again cleans out temporary raw data tables

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

** 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 [[S Cognos Units table]]

@@ Line 6: / Line 6: @@
 * 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]]
+* cleans out the tmp tables where raw Cognos data is stored
-* imports "page1_1!" and "page2_2!" from [[Cognos EPR Report]] into [[Cognos_import table]]
+* imports the correct tab (3) from [[Cognos EPR Report]] into raw data 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 [[Cognos3_import_Cognos2_Units query]]
 * runs [[Cognos3_import_Cognos2_Services query]]
-* again cleans out temporary table [[Cognos_import table]]
+* again cleans out temporary raw data tables
 * starts the email that will tell collectors that the new data is now available
 ** 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 [[S Cognos Units table]]