Push up centralized data.vbs: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
 
(18 intermediate revisions by 2 users not shown)
Line 1: Line 1:
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
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 itself
* checks for new version of [[Centralized data front end.mdb]]
* checks for new version of [[Centralized data front end.accdb]]
* moves [[Centralized data.mdb]] from local to master  
* moves [[Centralized data.mdb]] from local to master  
* moves [[PHI.mdb]] from local to master  
* moves [[PHI.mdb]] from local to master  
Line 7: Line 11:
== File locations ==  
== File locations ==  
Master:  
Master:  
* \\Hsc1msfp0001\med_ccmed\CCMDB\centralized_front_end\
* \\ad.wrha.mb.ca\WRHA\HSC\shared\MED\MED_CCMED\CCMDB\centralized_front_end
* '''[[X:\]]'''CCMDB\centralized_front_end
* '''[[X:\]]'''CCMDB\centralized_front_end
*[[Data Processor]] uses a shortcut to this on her desktop
*[[Data Processor]] uses a shortcut to this on her desktop
Line 18: Line 22:


== 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 ===
=== 2014-03-17 ===
original version released today Ttenbergen 16:00, 2014 March 18 (CDT)
original version released today Ttenbergen 16:00, 2014 March 18 (CDT)
Line 23: Line 65:




[[Category:Centralized data push pull]]
[[Category: Centralized data push pull]]
[[Category: Data processing batch files]]
[[Category: Data processing batch files]]
[[Category: 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

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

2019-08-29

  • updated file path for x:\ after Shared Health made server changes.

2018-05-18

2017-05-03

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)

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Push_up_centralized_data.vbs&oldid=160239"