Function CognosImport: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| 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 | |||
** 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 [[Cognos_import table]] and [[Cognos_processed table]] | ||
* imports "page1_1!" and "page2_2!" from [[Cognos EPR Report]] into [[Cognos_import table]] | * imports "page1_1!" and "page2_2!" from [[Cognos EPR Report]] into [[Cognos_import table]] | ||
| Line 6: | Line 8: | ||
* again cleans out temporary table [[Cognos_import table]] | * again cleans out temporary table [[Cognos_import table]] | ||
* 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 | ||
** [[Cognos_dispo_translator_additions_needed query]] runs automatically; if it finds new entries, an email is | ** [[Cognos_dispo_translator_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 [[Cognos_dispo_translator 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]] | ||
** [[Cognos_SubServices_additions_needed query]] runs automatically; if it finds new entries, an email is | ** [[Cognos_SubServices_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 [[Cognos SubServices table]]; the email will be sent each time this is run until the answer is added to [[Cognos_SubServices table]] | ||
== Log == | == Log == | ||
Revision as of 13:34, 2020 August 27
Function CognosImport 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
- 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
- again cleans out temporary table Cognos_import table
- starts the email that will tell collectors that the new data is now available
- Cognos_dispo_translator_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 Cognos_dispo_translator 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
- Cognos_SubServices_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 Cognos SubServices table; the email will be sent each time this is run until the answer is added to Cognos_SubServices table
Log
2020-07-30 - added Cognos_SubServices_additions_needed query and code to generate email if it has content.