Function CognosImport

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)