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:

Cognos data import ‎ (← links) LoadCognos.bat ‎ (← links) CCMDB.accdb Change Log 2021 ‎ (← links)