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]] . | ||
* cleans out [[table | * cleans out [[Cognos_import table]] and [[Cognos_processed table]] | ||
* imports "page1_1!" and "page2_2!" from [[ | * imports "page1_1!" and "page2_2!" from [[Cognos EPR Report]] | ||
* runs [[query Cognos_import_processor]] to turn the data into the format we need | * runs [[query Cognos_import_processor]] to turn the data into the format we need | ||
* again cleans out temporary table [[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 | ||
* runs the [[Cognos_dispo_translator_additions_needed query]] to notify if new locations are in the data that are not in [[table | * runs the [[Cognos_dispo_translator_additions_needed query]] to notify if new locations are in the data that are not in [[Cognos_dispo_translator table]] yet (these are then sent to collector to find out what entries in [[s_dispo table]] they correspond to) | ||
== Related articles == | == Related articles == | ||
Revision as of 20:19, 2020 July 24
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
- runs query Cognos_import_processor to turn the data into the format we need
- again cleans out temporary table Cognos_import table
- starts the email that will tell collectors that the new data is now available
- runs the Cognos_dispo_translator_additions_needed query to notify if new locations are in the data that are not in Cognos_dispo_translator table yet (these are then sent to collector to find out what entries in s_dispo table they correspond to)