Push up centralized data.vbs

The Push_up_centralized_data.vbs moves the files used by CFE to their various server locations.

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.

Push_up_centralized_data.bat 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 local to master
• moves PHI.mdb from local to master

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

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.accdbTtenbergen 11:53, 2018 May 18 (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-07-11

change so CCMDB.accdb is copied to c:\ccmdb_program\ instead

2015-Sep-28

in live location now Ttenbergen 10:02, 2015 September 28 (CDT)

• edited some spots where "pull" was used in stead of push, eg log file generation Ttenbergen 10:02, 2015 September 28 (CDT)

2015-May-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)

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

original version released today Ttenbergen 16:00, 2014 March 18 (CDT)