Pull down centralized data.vbs: Difference between revisions
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m Text replacement - "X:\" to "{{S:\MED\CCMED}}" |
||
| (17 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
The Pull_down_centralized_data.vbs moves the files used by [[CFE]] from their various server locations to the local disk. | 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 | 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. | * 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 [[ | * copies down [[CCMDB.accdb]] from its master location | ||
== File locations == | == File locations == | ||
Master: | Master: | ||
* \\Hsc1msfp0001\med_ccmed\CCMDB\centralized_front_end\ | * \\Hsc1msfp0001\med_ccmed\CCMDB\centralized_front_end\ | ||
* ''' | * '''{{S:\MED\CCMED}}'''CCMDB\centralized_front_end | ||
*[[Data Processor]] uses a shortcut to this on her desktop | *[[Data Processor]] uses a shortcut to this on her desktop | ||
Local, where copies to: | Local, where copies to: | ||
* C:\Centralized_CCMDB | * 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== | ==Log file of push and pull of centralized== | ||
| Line 21: | Line 41: | ||
== 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 === | === 2015-04-20 === | ||
in live now Ttenbergen 12:21, 2015 April 20 (CDT) | in live now Ttenbergen 12:21, 2015 April 20 (CDT) | ||
| Line 26: | Line 75: | ||
Ttenbergen 12:21, 2015 April 20 (CDT) | Ttenbergen 12:21, 2015 April 20 (CDT) | ||
* added variable p_regsrv. Ttenbergen 12:21, 2015 April 20 (CDT) | * added variable p_regsrv. Ttenbergen 12:21, 2015 April 20 (CDT) | ||
=== 2014-11-04 === | === 2014-11-04 === | ||
in live now Ttenbergen 16:50, 2014 November 6 (CST) | in live now Ttenbergen 16:50, 2014 November 6 (CST) | ||
| Line 45: | Line 94: | ||
[[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]] | |||