LoadCognos.vbs: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
The {{PAGENAME}} runs [[Sub CognosImport]] in [[CCMDB.accdb]] as part of [[Cognos data import]]. It is called by [[LoadCognos.bat]].
The {{PAGENAME}} runs [[Function CognosImport]] in [[CCMDB.accdb]] as part of [[Cognos data import]]. It is called by [[LoadCognos.bat]].


== File locations ==  
== File locations ==  
Line 5: Line 5:


== Change log ==
== 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 ===
=== 2021-03-04 ===
* updated to provide better logging to console of where the script is at during execution  
* updated to provide better logging to console of where the script is at during execution


=== 2020-08-27 ===
=== 2020-08-27 ===

Latest revision as of 09:42, 2023 March 15

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: