Pull down centralized data.vbs: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
 
(33 intermediate revisions by 3 users not shown)
Line 1: Line 1:
{{Discussion}}
The Pull_down_centralized_data.vbs moves the files used by [[CFE]] from their various server locations to the local disk.
Tina, need to add a check for locked file before pulling. [[User:TOstryzniuk|Trish Ostryzniuk]] 14:33, 2014 April 10 (CDT)


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


Pull_down_centralized_data.vbs does the following, writing progress to a log file
Pull_down_centralized_data.vbs 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 master to local  
* moves [[Centralized data.mdb]] from master to local  
* moves [[PHI.mdb]] from master to local
* moves [[PHI.mdb]] from master to local
* copies down [[CCMDB.accdb]] from its master location


== file location ==
== File locations ==  
Master file lives at:  
Master:  
\\Hsc1msfp0001\med_ccmed\CCMDB\centralized_front_end\
* \\Hsc1msfp0001\med_ccmed\CCMDB\centralized_front_end\
* '''[[X:\]]'''CCMDB\centralized_front_end
*[[Data Processor]] uses a shortcut to this on her desktop


Location also referred to as: X:\CCMDB\centralized_front_end
Local, where copies to:
* C:\Centralized_CCMDB
 
== Windows script Host Error ==
* Title: Windows Script Host Error
* Body:
:: Script: S:\Med\Med_CCMED\CCMDB\centralized_front_end\Pull_down_centralized_data.vbs
:: Line: 193
:: Char: 4
:: Error: Unknown runtime error
:: Code: 800A9D9F
:: Source: Microsoft VbScript runtime error
 
This error happens on the line
:: access.run "loadAllCSVFiles"
which is part of [[PHI Loader.accdb]].
 
The problem happens when Microsoft Access is not set up to trust the location of the .mdb and the script.
 
To fix, add "S:\Med\Med_CCMED\"  to Trusted location in addition to the usual ones. Use instructions in [[Changing settings in MS Access after first open]].
 
==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.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.
=== 2018-05-18 ===
* changed [[DSM Labs Consistency check.accdb]] references [[DSM Labs data.accdb]]Ttenbergen 11:53, 2018 May 18 (CDT)
=== 2017-09-14 ===
removed some of the msgboxes so there is not so much clicking each time. (Tina, 10:02, 2017 September 14 (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-05-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)
=== 2015-04-20 ===
in live now Ttenbergen 12:21, 2015 April 20 (CDT)
* script didn't copy newly sent PHI information from [[Regional Server]]\output\_phi. Now it does.
Ttenbergen 12:21, 2015 April 20 (CDT)
* added variable p_regsrv. Ttenbergen 12:21, 2015 April 20 (CDT)
=== 2014-11-04 ===
in live now Ttenbergen 16:50, 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 ===
=== 2014-03-31 ===
released Ttenbergen 12:57, 2014 March 31 (CDT)
released Ttenbergen 12:57, 2014 March 31 (CDT)
Line 24: Line 93:
original version released today Ttenbergen 15:57, 2014 March 18 (CDT)
original version released today Ttenbergen 15:57, 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 11:36, 2021 July 27

The Pull_down_centralized_data.vbs moves the files used by CFE from their various server locations to the local disk.

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.

Pull_down_centralized_data.vbs does the following, writing progress to a log file

File locations

Master:

  • \\Hsc1msfp0001\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

Windows script Host Error

  • Title: Windows Script Host Error
  • Body:
Script: S:\Med\Med_CCMED\CCMDB\centralized_front_end\Pull_down_centralized_data.vbs
Line: 193
Char: 4
Error: Unknown runtime error
Code: 800A9D9F
Source: Microsoft VbScript runtime error

This error happens on the line

access.run "loadAllCSVFiles"

which is part of PHI Loader.accdb.

The problem happens when Microsoft Access is not set up to trust the location of the .mdb and the script.

To fix, add "S:\Med\Med_CCMED\" to Trusted location in addition to the usual ones. Use instructions in Changing settings in MS Access after first open.

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-09-14

removed some of the msgboxes so there is not so much clicking each time. (Tina, 10:02, 2017 September 14 (CDT))

2017-05-03

2016-08-18

  • added TISS28 to the process Ttenbergen 16:51, 2016 August 18 (CDT)

2015-05-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)

2015-04-20

in live now Ttenbergen 12:21, 2015 April 20 (CDT)

  • script didn't copy newly sent PHI information from Regional Server\output\_phi. Now it does.

Ttenbergen 12:21, 2015 April 20 (CDT)

  • added variable p_regsrv. Ttenbergen 12:21, 2015 April 20 (CDT)

2014-11-04

in live now Ttenbergen 16:50, 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-17

original version released today Ttenbergen 15:57, 2014 March 18 (CDT)

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