Function CognosImport: Difference between revisions

mNo edit summary
Line 5: Line 5:


* 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 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 [[Cognos_import3 table]]
* imports the correct tab (3) from [[Cognos EPR Report]] into raw data table [[Cognos_import3 table]]