CCMDB Wiki

Pull down centralized data.vbs: Difference between revisions

← Older edit
m 2017-05-03 log
 
(18 intermediate revisions by 2 users not shown)
Line 1: Line 1:
The Pull_down_centralized_data.vbs moves the files used by [[CFE]] from their various server locations to the local disk.  
The Pull_down_centralized_data.vbs moves the files used by [[CFE]] from their various server locations to the local disk.  
[[Copy here only centralized data.vbs]], [[Pull down centralized data.vbs]] and [[Push up centralized data.vbs]] work as a set, if one is changed the others will likely need to be changed as well.


Pull_down_centralized_data.vbs does the following, writing progress to a log file
Pull_down_centralized_data.vbs does the following, writing progress to a log file
* checks for new version of itself
* checks for new version of itself
* checks for new version of [[Centralized data front end.mdb]]
* checks for new version of [[Centralized data front end.accdb]]
* moves [[Centralized data.mdb]] from master to local  
* moves [[Centralized_data.accdb]] from master to local  
* moves [[PHI.mdb]] from master to local
* moves [[PHI.mdb]] from master to local
* copies down [[ccmdb.mdb]] from its master location
* copies down [[CCMDB.accdb]] from its master location


== File locations ==  
== File locations ==  
Master:  
Master:  
* \\Hsc1msfp0001\med_ccmed\CCMDB\centralized_front_end\
* \\Hsc1msfp0001\med_ccmed\CCMDB\centralized_front_end\
* '''[[X:\]]'''CCMDB\centralized_front_end
* '''{{S:\MED\MED_CCMED}}'''CCMDB\centralized_front_end
*[[Data Processor]] uses a shortcut to this on her desktop
*[[Data Processor]] uses a shortcut to this on her desktop


Local, where copies to:
Local, where copies to:
* C:\Centralized_CCMDB
* C:\Centralized_CCMDB
== Windows script Host Error ==
* Title: Windows Script Host Error
* Body:
:: Script: S:\Med\Med_CCMED\CCMDB\centralized_front_end\Pull_down_centralized_data.vbs
:: Line: 193
:: Char: 4
:: Error: Unknown runtime error
:: Code: 800A9D9F
:: Source: Microsoft VbScript runtime error
This error happens on the line
:: access.run "loadAllCSVFiles"
which is part of [[PHI Loader.accdb]].
The problem happens when Microsoft Access is not set up to trust the location of the .mdb and the script.
See [[Managing Trusted Locations to enable VBA in our Microsoft Access programs]] for fix.


==Log file of push and pull of centralized==
==Log file of push and pull of centralized==
Line 21: Line 41:


== Change log ==
== Change log ==
=== 2021-07-27 ===
* removed processing for [[TISS28]] since that file is now static
=== 2019-09-18 ===
* changed [[CCMDB.accdb]] to [[CCMDB.accdb]] and centralized_data.mdb to centralized_data.accdb
=== 2019-08-29 ===
* updated file path for x:\ after Shared Health made server changes.
=== 2018-05-18 ===
* changed [[DSM Labs Consistency check.accdb]] references [[DSM Labs data.accdb]]Ttenbergen 11:53, 2018 May 18 (CDT)
=== 2017-09-14 ===
removed some of the msgboxes so there is not so much clicking each time. (Tina, 10:02, 2017 September 14 (CDT))
=== 2017-05-03 ===
=== 2017-05-03 ===
* added [[DSM Labs Consistency check.accdb]] to the process Ttenbergen 10:14, 2017 May 3 (CDT)
* added [[DSM Labs Consistency check.accdb]] to the process Ttenbergen 10:14, 2017 May 3 (CDT)
Line 37: Line 72:
=== 2015-04-20 ===
=== 2015-04-20 ===
in live now Ttenbergen 12:21, 2015 April 20 (CDT)
in live now Ttenbergen 12:21, 2015 April 20 (CDT)
* script didn't copy newly sent PHI information from [[Regional Server]]\output\_phi. Now it does.  
* script didn't copy newly sent PHI information from {{Regionalserver|Output\_PHI}}. Now it does.  
Ttenbergen 12:21, 2015 April 20 (CDT)
Ttenbergen 12:21, 2015 April 20 (CDT)
* added variable p_regsrv. Ttenbergen 12:21, 2015 April 20 (CDT)
* added variable p_regsrv. Ttenbergen 12:21, 2015 April 20 (CDT)
Line 59: Line 94:




[[Category: Centralized data push pull]]
[[Category:Centralized data push pull]]
[[Category: Data processing batch files]]
[[Category:Data processing batch files]]
[[Category: Batch Files]]
[[Category:Batch Files]]
[[Category: Backup]]
[[Category:Backup]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Pull_down_centralized_data.vbs"