LoadCognos.vbs
The LoadCognos.vbs runs Function CognosImport in CCMDB.accdb as part of Cognos data import. It is called by LoadCognos.bat.
File locations
Master: Regional Server\\Programs\Master\CognosScripts (full address: \\ad.wrha.mb.ca\WRHA\REGION\SHARED\ICU_DATA_COLLECTION\\Programs\Master\CognosScripts)
Change log
2023-03-15
- changed file name this looks for from "CCMdb Sample.xlsx" to "CCMdb Sample New Version.xlsx". I suspect that must have previously been changed on Pagasa's or Lisa's PCs because the file name has been the new one for some time.
2021-06-01
- removed check that import file is already present on desktop at start of script - there is no reason it should be, since it doesn't get saved until the Access program runs.
2021-03-04
- updated to provide better logging to console of where the script is at during execution
2020-08-27
- first version rolled out to Pagasa
2020-07-24
- original implementation
Related articles
| Related articles: |