CCMDB Wiki

Pull down centralized data.vbs: Difference between revisions

← Older edit
m log file
m Text replacement - "X:\" to "{{S:\MED\CCMED}}"
 
(25 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{Discussion}}
The Pull_down_centralized_data.vbs moves the files used by [[CFE]] from their various server locations to the local disk.
#Tina, need to add a check for locked file before pulling. [[User:TOstryzniuk|Trish Ostryzniuk]] 14:33, 2014 April 10 (CDT)


[[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.mdb]] from master to local  
{{Discussion}} what is the folder called on Data processors local desktop?
* moves [[PHI.mdb]] from master to local
* moves [[PHI.mdb]] from master to local
* copies down [[CCMDB.accdb]] from its master location


==Master VBS file lives at==  
== File locations ==  
\\Hsc1msfp0001\med_ccmed\CCMDB\centralized_front_end\
Master:
* \\Hsc1msfp0001\med_ccmed\CCMDB\centralized_front_end\
* '''{{S:\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


Location also referred to as: '''X''':\CCMDB\centralized_front_end
Local, where copies to:
* 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.
 
To fix, add "S:\Med\Med_CCMED\"  to Trusted location in addition to the usual ones. Use instructions in [[Changing settings in MS Access after first open]].


==Log file of push and pull of centralized==
==Log file of push and pull of centralized==
Line 20: 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 ===
* added [[DSM Labs Consistency check.accdb]] to the process Ttenbergen 10:14, 2017 May 3 (CDT)
=== 2016-08-18 ===
* added [[TISS28]] to the process Ttenbergen 16:51, 2016 August 18 (CDT)
=== 2015-05-20 ===
in live location now Ttenbergen 17:06, 2015 May 20 (CDT)
* changed backup locations
** network_backup = "M:\Backup"
** c_Backups = network_backup & "\Centralized_data"
** p_Backups = network_backup & "\PHI"
** t_Backups = network_backup & "\TISS28" (added)(not used yet)
=== 2015-04-20 ===
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.
Ttenbergen 12:21, 2015 April 20 (CDT)
* added variable p_regsrv. Ttenbergen 12:21, 2015 April 20 (CDT)
=== 2014-11-04 ===
in live now Ttenbergen 16:50, 2014 November 6 (CST)
* always get CFE, not only if newer
=== 2014-10-09 ===
in live location now Ttenbergen 15:18, 2014 October 9 (CDT)
* added lock checks to the copy-to-local of phi.mdb and centralize_data.mdb Ttenbergen 15:08, 2014 October 9 (CDT)
* making the three sister scripts consistent Ttenbergen 15:08, 2014 October 9 (CDT)
=== 2014-03-31 ===
=== 2014-03-31 ===
released Ttenbergen 12:57, 2014 March 31 (CDT)
released Ttenbergen 12:57, 2014 March 31 (CDT)
Line 29: 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]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Pull_down_centralized_data.vbs"