Copy here only centralized data.vbs: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) |
||
(12 intermediate revisions by the same user not shown) | |||
Line 2: | Line 2: | ||
[[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. | [[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 | * checks for new version of [[Centralized data front end.accdb]] and updates to if available | ||
Line 11: | Line 7: | ||
* moves [[PHI.mdb]] from backup to 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 [[TISS28 Data.mdb]] from its master location | ||
* copies down [[ | * copies down [[CCMDB.accdb]] from its master location | ||
== File locations == | == File locations == | ||
Master: | Master: | ||
* \ | * [[X:\]]CCMDB\centralized_front_end\ | ||
== Log file == | == Log file == | ||
Line 21: | Line 17: | ||
== Change 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 === | === 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. | * 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 === | === 2018-05-18 === | ||
* changed [[DSM Labs Consistency check.accdb]] references [[DSM Labs data.accdb]]Ttenbergen 11:53, 2018 May 18 (CDT) | * changed [[DSM Labs Consistency check.accdb]] references [[DSM Labs data.accdb]]Ttenbergen 11:53, 2018 May 18 (CDT) | ||
Line 38: | Line 55: | ||
=== 2015-07-11 === | === 2015-07-11 === | ||
change so | change so [[CCMDB.accdb]] is copied to c:\ccmdb_program\ instead | ||
=== 2015-05-28 === | === 2015-05-28 === | ||
Line 73: | Line 90: | ||
=== 2014-03-18 === | === 2014-03-18 === | ||
original version released today Ttenbergen 15:57, 2014 March 18 (CDT) | original version released today Ttenbergen 15:57, 2014 March 18 (CDT) | ||
== Related articles == | == Related articles == |
Latest revision as of 10:47, 2022 June 1
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)