Function CognosImport: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
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]] .


* tries for an hour to save file CCMdb Sample.xlsx from email from Chastity Cleofas
** if email is not found in that timeframe, it will send an email to dc cc, dc med and quit
* 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]] into [[Cognos_import table]]
* imports "page1_1!" and "page2_2!" from [[Cognos EPR Report]] into [[Cognos_import table]]
Line 6: Line 8:
* 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
** [[Cognos_dispo_translator_additions_needed query]] runs automatically; if it finds new entries, an email is started to a collector to find out what should be added to [[Cognos_dispo_translator table]] to map the new entries to entries of [[s_dispo table]]
** [[Cognos_dispo_translator_additions_needed query]] runs automatically; if it finds new entries, an email is sent to a Lisa Kaita to find out what should be added to [[Cognos_dispo_translator table]] to map the new entries to entries of [[s_dispo table]]; the email will be sent each time this is run until the answer is added to [[Cognos Admit filter table]]  
** [[Cognos_SubServices_additions_needed query]]  runs automatically; if it finds new entries, an email is started to a Tina to find out what should be added to [[Cognos SubServices table]]
** [[Cognos_SubServices_additions_needed query]]  runs automatically; if it finds new entries, an email is sent to a Tina to find out what should be added to [[Cognos SubServices table]]; the email will be sent each time this is run until the answer is added to [[Cognos_SubServices table]]  


== Log ==
== Log ==

Revision as of 14:34, 2020 August 27

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

Log

2020-07-30 - added Cognos_SubServices_additions_needed query and code to generate email if it has content.

Related articles

Related articles: