Function CognosImport

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)