Copy here only centralized data.vbs

The Copy_only_centralized_data.vbs makes a copy of the files used by CFE to the directory from which it is launched.

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.

• checks for new version of Centralized data front end.accdb and updates to if available
• copies Centralized data.mdb from backupto the directory from which it is launched
• moves PHI.mdb from backup to the directory from which it is launched
• copies down TISS28 Data.mdb from its master location
• copies down CCMDB.accdb from its master location

File locations

Master:

• X:\CCMDB\centralized_front_end\

Log file

see Push/Pull log

Change log

2022-06-01

• Master version was still trying to copy DSM, which hasn't been part of push pull since 2018. No idea why this didn't come up before. Removed
• improved console logging to make troubleshooting easier in the future

2021-11-04

• removed processing for TISS28 since that file is now static, after discussion with Julie that she has a set locally and doesn't need to keep pulling this.

v2019_10_24

• more variable fixes from .mdb to .accdb change.

v2019_10_22

• added file version to msgbox at start of script
• corrected .mdb discrepancy .accdb

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.

2019-07-15

• Changed network path for network_backup from \\hsc1msfp0013\SHARED\WRHA_CCMED\Backup to \\ad.wrha.mb.ca\WRHA\HSC\shared\WRHA\WRHA_CCMED\Backup.

2018-05-18

• changed DSM Labs Consistency check.accdb references DSM Labs data.accdbTtenbergen 11:53, 2018 May 18 (CDT)
• detail of what this script does was removed in this update as they are on the Wiki above.

2017-05-03

• added DSM Labs Consistency check.accdb to the process Ttenbergen 10:14, 2017 May 3 (CDT)

2016-11-07

• changed so pulls TISS28 from backup like everything else. Ttenbergen 16:50, 2016 November 7 (CST)
• has detailed documentation of what this does in the script

2016-08-18

• added TISS 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-05-28

in live now Ttenbergen 10:43, 2015 May 28 (CDT)

• changed PHI backup location variable to new location. Ttenbergen 10:43, 2015 May 28 (CDT)

2015-05-25

in live now. Ttenbergen 17:53, 2015 May 25 (CDT)

• updated variable c_backups to reflect new location \\hsc1msfp0013\SHARED\WRHA_CCMED\Backup, see Backups.

2015-04-08

in live now Ttenbergen 14:31, 2015 April 8 (CDT)

• fixed "latest file" function, it failed when .csvs were latest. Ttenbergen 14:31, 2015 April 8 (CDT)

2015-03-30

in live now Ttenbergen 16:43, 2015 March 30 (CDT)

• changed to copy down from backups; these will always be present so one doesn't get stuck when data is in "pull" state
• update to include a error_quit_tell function to streamline messaging

2014-11-04

in live now Ttenbergen 16:51, 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-18

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