Function CognosImport: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m Text replacement - "Cognos_dispo_translator table" to "s_Cognos_Locations table" |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (15 intermediate revisions by the same user not shown) | |||
| 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 | == Approximate algorithm== | ||
** if email is not found in that timeframe, it will send an email to dc cc | Check the sub itself for the actual current process. | ||
* cleans out | |||
* imports | * tries for an hour to save file "CCMdb Sample.xlsx" from an email from [[Chastity]] | ||
* runs [[ | ** if email is not found in that timeframe, it will send an email to dc cc and quit | ||
* again cleans out temporary | * 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 | * 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]] | ||
== Related articles == | == Related articles == | ||
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