LoadCognos.vbs: Difference between revisions

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 ===