Function CognosImport: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) Created page with "'''{{PAGENAME}}''' is the sub that accomplishes the Cognos EPR Report importing as part of Cognos data import . * cleans out table Cognos_import and table Cogno..." |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 6: | Line 6: | ||
* again cleans out temporary table [[table Cognos_import]] | * again cleans out temporary table [[table Cognos_import]] | ||
* 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 Cognos_dispo_translator]] yet | * runs the [[Cognos_dispo_translator_additions_needed query]] to notify if new locations are in the data that are not in [[table Cognos_dispo_translator]] 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 19:59, 2020 July 24
Function CognosImport is the sub that accomplishes the Cognos EPR Report importing as part of Cognos data import .
- cleans out table Cognos_import and table Cognos_processed
- imports "page1_1!" and "page2_2!" from gognos export
- runs query Cognos_import_processor to turn the data into the format we need
- again cleans out temporary table table Cognos_import
- 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 Cognos_dispo_translator yet (these are then sent to collector to find out what entries in s_dispo table they correspond to)