PHI copy automation: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 1: | Line 1: | ||
As part of the [[:category:2013 data upgrades|2013 data upgrades]], [[CCMDB.mdb]] will now move [[PHI Data]] from the <file>\\Ad.wrha.mb.ca\wrha\REGIONWRHA\SHARED\ICU_DATA_COLLECTION\Output\_PHI</file> directory on the [[Regional Server]] ("_" to sort separate from hospitals) to <file>X:\CCMDB\PHI</file> which is done by a scheduled task on Trish's computer calling <file>X:\CCMDB\PHI\copy_PHI.bat</file> (see: [[copy_PHI.bat]]) every '''10 minutes'''. | As part of the [[:category:2013 data upgrades|2013 data upgrades]], [[CCMDB.mdb]] will now move [[PHI Data]] from the <file>\\Ad.wrha.mb.ca\wrha\REGIONWRHA\SHARED\ICU_DATA_COLLECTION\Output\_PHI</file> directory on the [[Regional Server]] ("_" to sort separate from hospitals) to <file>X:\CCMDB\PHI</file> which is done by a scheduled task on Trish's computer calling <file>X:\CCMDB\PHI\copy_PHI.bat</file> (see: [[copy_PHI.bat]]) every '''10 minutes'''. | ||
{{Regionalserver|Output\_PHI}} | |||
This batch file has a line to call the 'Load Data.vbs' which opens the PHI_Loader.accdb and calls the code that imports all csv files found within the directory. | This batch file has a line to call the 'Load Data.vbs' which opens the PHI_Loader.accdb and calls the code that imports all csv files found within the directory. | ||
Revision as of 19:39, 20 November 2013
As part of the 2013 data upgrades, CCMDB.mdb will now move PHI Data from the <file>\\Ad.wrha.mb.ca\wrha\REGIONWRHA\SHARED\ICU_DATA_COLLECTION\Output\_PHI</file> directory on the Regional Server ("_" to sort separate from hospitals) to <file>X:\CCMDB\PHI</file> which is done by a scheduled task on Trish's computer calling <file>X:\CCMDB\PHI\copy_PHI.bat</file> (see: copy_PHI.bat) every 10 minutes.
Regional Server\Output\_PHI (full address: \\ad.wrha.mb.ca\WRHA\REGION\SHARED\ICU_DATA_COLLECTION\Output\_PHI)
This batch file has a line to call the 'Load Data.vbs' which opens the PHI_Loader.accdb and calls the code that imports all csv files found within the directory.
If the task runs and there are no problems the task will list "0x0" in the last results column. Any other code would require review.
Hmmm? Centralized data.mdb vs Aggregator.mdb
Problem
If the PC that this is scheduled on isn't running then data might be left on the server for some time. Probably OK for now since it would still only be temporary. Ttenbergen 16:32, 2013 July 29 (CDT)