Function CognosImport: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m Ttenbergen moved page Sub CognosImport to Function CognosImport without leaving a redirect: Text replacement - "Sub CognosImport" to "Function CognosImport" |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 5: | Line 5: | ||
* tries for an hour to save file "CCMdb Sample.xlsx" from an email from [[Chastity]] | * 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 | ** 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 | * cleans out the tmp tables where raw Cognos data is stored | ||
* imports the correct tab (3) from [[Cognos EPR Report]] into raw data table | * imports the correct tab (3) from [[Cognos EPR Report]] into raw data table [[Cognos_import3 table]] | ||
* runs [[Cognos2_import_Cognos2_OneTime query]] | * runs [[Cognos2_import_Cognos2_OneTime query]] | ||
* runs [[Cognos3_import_Cognos2_Units query]] | * runs [[Cognos3_import_Cognos2_Units query]] | ||
* runs [[Cognos3_import_Cognos2_Services query]] | * runs [[Cognos3_import_Cognos2_Services query]] | ||
* again cleans out temporary raw data tables | * again cleans out temporary raw data tables | ||
* starts the email that will tell collectors that the new data is now available | * 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 | ** 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]] | ** 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]] | ||
Latest revision as of 11:39, 2024 January 7
Function CognosImport is the sub that accomplishes the Cognos EPR Report importing as part of Cognos data import.
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
- 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
- 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