Copy here only centralized data.vbs: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
m →‎2015-04-08: updated
 
(30 intermediate revisions by 4 users not shown)
Line 1: Line 1:
The Copy_only_centralized_data.vbs makes a copy of the files used by [[CFE]] to the directory from which it is launched.  
The Copy_only_centralized_data.vbs makes a copy of the files used by [[CFE]] to the directory from which it is launched.  


* checks for new version of [[Centralized data front end.mdb]] and updates to if available
[[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
* 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
* 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 [[ccmdb.mdb]] from its master location
* copies down [[CCMDB.accdb]] from its master location


== File locations ==  
== File locations ==  
Master:  
Master:  
* \\Hsc1msfp0001\med_ccmed\CCMDB\centralized_front_end\
* [[X:\]]CCMDB\centralized_front_end\


== Log file ==
== Log file ==
Line 15: 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 ===
* 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.accdb]]Ttenbergen 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 ===
=== 2015-05-25 ===
in live now. Ttenbergen 17:53, 2015 May 25 (CDT)
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 article]].
* updated variable c_backups to reflect new location \\hsc1msfp0013\SHARED\WRHA_CCMED\Backup, see [[Backups]].


=== 2015-04-08 ===
=== 2015-04-08 ===
Line 45: Line 91:
original version released today Ttenbergen 15:57, 2014 March 18 (CDT)
original version released today Ttenbergen 15:57, 2014 March 18 (CDT)


 
== Related articles ==
[[Category:Batch Files]]
{{Related Articles}}
 
 
 
 
 
 


[[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]]

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.

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

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

2017-05-03

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)

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Copy_here_only_centralized_data.vbs&oldid=156292"