Function CognosImport: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) m Text replacement - "query Cognos_import_processor" to "Cognos_import_processor query" |
||
| Line 3: | Line 3: | ||
* 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]] | ||
* runs [[query | * runs [[Cognos_import_processor query]] to turn the data into the format we need | ||
* 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 | ||
Revision as of 10:47, 2020 July 28
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 Cognos_import_processor query 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)