Function CognosImport: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (Text replacement - "query Cognos_import_processor" to "Cognos_import_processor query") |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 2: | Line 2: | ||
* 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]] | * 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 | * 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]] | * 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 started to a collector to find out what should be added to [[Cognos_dispo_translator table]] to map the new entries to entries of [[s_dispo table]] | ||
** [[Cognos_SubServices_additions_needed query]] runs automatically; if it finds new entries, an email is started to a Tina to find out what should be added to [[Cognos SubServices table]] | |||
== Log == | |||
2020-07-30 - added [[Cognos_SubServices_additions_needed query]] and code to generate email if it has content. | |||
== Related articles == | == Related articles == | ||
Revision as of 16:16, 2020 July 30
Function CognosImport is the sub that accomplishes the Cognos EPR Report importing as part of Cognos data import .
- 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 started to a collector to find out what should be added to Cognos_dispo_translator table to map the new entries to entries of s_dispo table
- Cognos_SubServices_additions_needed query runs automatically; if it finds new entries, an email is started to a Tina to find out what should be added to Cognos SubServices table
Log
2020-07-30 - added Cognos_SubServices_additions_needed query and code to generate email if it has content.