Pull down centralized data.vbs: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m →top: changed to .accdb, replaced: Centralized data front end.mdb → Centralized data front end.accdb |
|||
| Line 21: | Line 21: | ||
== Change log == | == Change log == | ||
=== 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 === | === 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 09:02, 2017 September 14
The Pull_down_centralized_data.vbs moves the files used by CFE from their various server locations to the local disk.
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
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)