LoadCognos.vbs: Difference between revisions

 
(4 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 ==  
Master: {{Regionalserver|\Programs\Master\Cognos scripts}}
Master: {{Regionalserver|\Programs\Master\CognosScripts}}


== 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 ===
* updated to provide better logging to console of where the script is at during execution
=== 2020-08-27 ===
=== 2020-08-27 ===
* first version rolled out to Pagasa
* first version rolled out to Pagasa