Function CognosImport: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m Ttenbergen moved page Sub CognosImport to Function CognosImport without leaving a redirect: Text replacement - "Sub CognosImport" to "Function CognosImport"
Line 6: Line 6:
* tries for an hour to save file "CCMdb Sample.xlsx" from an email from [[Chastity]]
* tries for an hour to save file "CCMdb Sample.xlsx" from an email from [[Chastity]]
** if email is not found in that timeframe, it will send an email to dc cc, dc med and quit
** if email is not found in that timeframe, it will send an email to dc cc, dc med and quit
* cleans out the tmp tables where raw Cognos data is stored
* cleans out the tmp tables where raw Cognos data is stored  
* imports the correct tab (3) from [[Cognos EPR Report]] into raw data table
* imports the correct tab (3) from [[Cognos EPR Report]] into raw data table [[Cognos_import3 table]]
* runs [[Cognos2_import_Cognos2_OneTime query]]
* runs [[Cognos2_import_Cognos2_OneTime query]]
* runs [[Cognos3_import_Cognos2_Units query]]
* runs [[Cognos3_import_Cognos2_Units query]]

Revision as of 08:42, 2022 April 13

Function CognosImport is the sub that accomplishes the Cognos EPR Report importing as part of Cognos data import.

Approximate algorithm

Check the sub itself for the actual current process.

Related articles

Related articles: