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.mdb from its master location
File locations
Master:
- \\Hsc1msfp0001\med_ccmed\CCMDB\centralized_front_end\
Log file
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-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)
Template:Discussion - some confusion here. Say this script has been updated after this date, however, Pagasa, Julie and Trish have this version on their desktop which has better explanation in the script as to what it does.
2016-08-18
- added TISS to the process Ttenbergen 16:51, 2016 August 18 (CDT)
2015-07-11
change so ccmdb.mdb 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)