Pull down centralized data.vbs: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
|||
Line 1: | Line 1: | ||
The Pull_down_centralized_data.vbs moves the files used by [[CFE]] from their various server locations to the local disk. | 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 | Pull_down_centralized_data.vbs does the following, writing progress to a log file | ||
Line 21: | Line 23: | ||
== 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-09-14 === | === 2017-09-14 === | ||
removed some of the msgboxes so there is not so much clicking each time. (Tina, 10:02, 2017 September 14 (CDT)) | removed some of the msgboxes so there is not so much clicking each time. (Tina, 10:02, 2017 September 14 (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 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)