Push up centralized data.vbs: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) Created page with "Push_up_centralized_data.bat makes backup and moves centralized to regional and copies PHI to x, writes to push_pull.log. == file location == == Change log == Not yet implem..." |
|||
(28 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
Push_up_centralized_data. | The Push_up_centralized_data.vbs moves the files used by [[CFE]] to their various server locations. | ||
== file | [[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. | ||
Push_up_centralized_data.bat 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 local to master | |||
* moves [[PHI.mdb]] from local to master | |||
== File locations == | |||
Master: | |||
* \\ad.wrha.mb.ca\WRHA\HSC\shared\MED\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 == | == Change log == | ||
=== 2021-07-27 === | |||
* removed processing for [[TISS28]] since that file is now static | |||
=== 2019-09-18 === | |||
* changed CCMDB.mdb to [[CCMDB.accdb]] and centralized_data.mdb to [[Centralized data.mdb]] | |||
=== 2019-08-29 === | |||
* updated file path for x:\ after Shared Health made server changes. | |||
=== 2018-05-18 === | |||
* changed [[DSM Labs Consistency check.accdb]] references [[DSM Labs data.accdb]]Ttenbergen 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-08-18 === | |||
* added [[TISS28]] 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-Sep-28 === | |||
in live location now Ttenbergen 10:02, 2015 September 28 (CDT) | |||
* edited some spots where "pull" was used in stead of push, eg log file generation Ttenbergen 10:02, 2015 September 28 (CDT) | |||
=== 2015-May-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) | |||
=== 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-17 === | |||
original version released today Ttenbergen 16:00, 2014 March 18 (CDT) | |||
[[Category:Batch Files]] | [[Category: Centralized data push pull]] | ||
[[Category: Data processing batch files]] | |||
[[Category: Batch Files]] | |||
[[Category: Backup]] |
Latest revision as of 14:14, 2023 September 28
The Push_up_centralized_data.vbs moves the files used by CFE to their various server locations.
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.
Push_up_centralized_data.bat 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 local to master
- moves PHI.mdb from local to master
File locations
Master:
- \\ad.wrha.mb.ca\WRHA\HSC\shared\MED\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
2021-07-27
- removed processing for TISS28 since that file is now static
2019-09-18
- changed CCMDB.mdb to CCMDB.accdb and centralized_data.mdb to Centralized data.mdb
2019-08-29
- updated file path for x:\ after Shared Health made server changes.
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-08-18
- added TISS28 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-Sep-28
in live location now Ttenbergen 10:02, 2015 September 28 (CDT)
- edited some spots where "pull" was used in stead of push, eg log file generation Ttenbergen 10:02, 2015 September 28 (CDT)
2015-May-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)
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-17
original version released today Ttenbergen 16:00, 2014 March 18 (CDT)