Pull down centralized data.vbs

The Pull_down_centralized_data.vbs moves the files used by CFE from their various server locations to the local disk.

Copy_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

• checks for new version of itself
• checks for new version of Centralized data front end.accdb
• moves Centralized data.mdb from master to local
• moves PHI.mdb from master to local
• copies down ccmdb.mdb from its master location

File locations

Master:

• \\Hsc1msfp0001\med_ccmed\CCMDB\centralized_front_end\
• X:\CCMDB\centralized_front_end
• Data Processor uses a shortcut to this on her desktop

Local, where copies to:

• C:\Centralized_CCMDB

Log file of push and pull of centralized

see Push/Pull log

Change log

2018-05-18

• changed DSM Labs Consistency check.accdb references DSM Labs data.accdbTtenbergen 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

released Ttenbergen 12:57, 2014 March 31 (CDT)

• added code to check if phi is locked, to bail if so and to import csvs if not locked Ttenbergen 12:09, 2014 March 31 (CDT)
• updated line calling firefox upon update to work properly Ttenbergen 12:09, 2014 March 31 (CDT)

2014-03-17

original version released today Ttenbergen 15:57, 2014 March 18 (CDT)