Copy here only centralized data.vbs: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
 
(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.  
{{Discuss |
* What does it mean work as a set? Does this mean if one change (like the path in the "copy to here only centralized data.vbs"  then push/pull script also needs to have changes?  Pagasa does not seem to have any issue with the push or pull script.--[[User:TOstryzniuk|Trish Ostryzniuk]] 11:44, 2019 July 15 (CDT)
** Yes, when one of the three is changed, e.g. for a path, the others should need to be changed as well. Why would Pagasa be having issues with the scripts? If this is about the changes to the scanning folder, that is not part of push pull so would not expect any problems. Ttenbergen 12:47, 2019 July 18 (CDT)}}


* 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 [[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 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 ccmdb.mdb is copied to c:\ccmdb_program\ instead
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.

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: