Copy here only centralized data.vbs: Difference between revisions
Ttenbergen (talk | contribs) m →top: changed to .accdb, replaced: Centralized data front end.mdb → Centralized data front end.accdb |
Ttenbergen (talk | contribs) mNo edit summary |
||
Line 1: | Line 1: | ||
The Copy_only_centralized_data.vbs makes a copy of the files used by [[CFE]] to the directory from which it is launched. | The Copy_only_centralized_data.vbs makes a copy of the files used by [[CFE]] to the directory from which it is launched. | ||
[[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. | |||
* checks for new version of [[Centralized data front end.accdb]] and updates to if available | * checks for new version of [[Centralized data front end.accdb]] and updates to if available | ||
Line 15: | Line 17: | ||
== Change log == | == Change log == | ||
=== 2018-05-18 === | |||
* changed [[DSM Labs Consistency check.accdb]] references [[DSM Labs data.accdb]]Ttenbergen 11:53, 2018 May 18 (CDT) | |||
=== 2017-05-03 === | === 2017-05-03 === | ||
* added [[DSM Labs Consistency check.accdb]] to the process Ttenbergen 10:14, 2017 May 3 (CDT) | * added [[DSM Labs Consistency check.accdb]] to the process Ttenbergen 10:14, 2017 May 3 (CDT) |
Revision as of 10:53, 2018 May 18
The Copy_only_centralized_data.vbs makes a copy of the files used by CFE to the directory from which it is launched.
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.
- 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)
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 article.
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)