PHI copy automation: Difference between revisions
TOstryzniuk (talk | contribs) m →Problem |
TOstryzniuk (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
==What does this scheduled task do?== | |||
As part of the [[:category:2013 data upgrades|2013 data upgrades]], [[CCMDB.mdb]] will now '''move''' the csv [[PHI Data]] files | As part of the [[:category:2013 data upgrades|2013 data upgrades]], [[CCMDB.mdb]] will now '''move''' the csv [[PHI Data]] files | ||
*'''from:''' {{Regionalserver|Output\_PHI}} ''("_" to sort separate from hospitals)'' | *'''from:''' {{Regionalserver|Output\_PHI}} ''("_" to sort separate from hospitals)'' | ||
*'''to:''' <file>X:\CCMDB\PHI</file> | *'''to:''' <file>X:\CCMDB\PHI</file> | ||
The move is done using a scheduled task that runs on [[Trish Ostryzniuk | Trish's]] computer. It calls <file>X:\CCMDB\PHI\copy_PHI.bat</file> (see: [[copy_PHI.bat]]). | |||
The batch file (<file>X:\CCMDB\PHI\copy_PHI.bat</file>) has a line to call the script: 'X:\CCMDB\PHI\Load Data.vbs' which opens the PHI_Loader.accdb and calls the code that imports all csv files found within the directory. The csv loading code also moves the files again into an archive folder <file>X:\CCMDB\PHI\PHI Archive\</file> to prevent duplicate processing. | The batch file (<file>X:\CCMDB\PHI\copy_PHI.bat</file>) has a line to call the script: 'X:\CCMDB\PHI\Load Data.vbs' which opens the PHI_Loader.accdb and calls the code that imports all csv files found within the directory. The csv loading code also moves the files again into an archive folder <file>X:\CCMDB\PHI\PHI Archive\</file> to prevent duplicate processing. | ||
| Line 10: | Line 11: | ||
'''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.''' - This needs to be reviewed as the last line of the batch file has changed the the return value may be altered [[User:Bcloutier|Bcloutier]] 19:47, 2013 November 20 (CST) | '''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.''' - This needs to be reviewed as the last line of the batch file has changed the the return value may be altered [[User:Bcloutier|Bcloutier]] 19:47, 2013 November 20 (CST) | ||
==Where schedule task lives== | |||
[[Trish Ostryzniuk | Trish's]] desktop | |||
==How often does it Run?== | |||
The scheduled task runs every '''10 minutes''' | |||
==Comments== | |||
Hmmm? [[Centralized data.mdb]] vs [[Aggregator.mdb]] | Hmmm? [[Centralized data.mdb]] vs [[Aggregator.mdb]] | ||
== Problem == | == Problem == | ||
| Line 19: | Line 26: | ||
*currently Trish locks her computer each night and reboots it in the AM. Locking does not stop this scheduled task from running. | *currently Trish locks her computer each night and reboots it in the AM. Locking does not stop this scheduled task from running. | ||
*If Trish is away for 2 weeks or more then this task needs to be put on another person's desktop, either Tina, Pagasa or Julie. [[User:TOstryzniuk|Trish Ostryzniuk]] 19:16, 2014 April 23 (CDT) | *If Trish is away for 2 weeks or more then this task needs to be put on another person's desktop, either Tina, Pagasa or Julie. [[User:TOstryzniuk|Trish Ostryzniuk]] 19:16, 2014 April 23 (CDT) | ||
[[Category: 2013 data upgrades]] | [[Category: 2013 data upgrades]] | ||
[[Category:Scheduled Tasks]] | [[Category:Scheduled Tasks]] | ||
Revision as of 10:19, 30 April 2014
What does this scheduled task do?
As part of the 2013 data upgrades, CCMDB.mdb will now move the csv PHI Data files
- from: Regional Server\Output\_PHI\\ad.wrha.mb.ca\WRHA\REGION\SHARED\ICU_DATA_COLLECTION\Output\_PHI ("_" to sort separate from hospitals)
- to: <file>X:\CCMDB\PHI</file>
The move is done using a scheduled task that runs on Trish's computer. It calls <file>X:\CCMDB\PHI\copy_PHI.bat</file> (see: copy_PHI.bat).
The batch file (<file>X:\CCMDB\PHI\copy_PHI.bat</file>) has a line to call the script: 'X:\CCMDB\PHI\Load Data.vbs' which opens the PHI_Loader.accdb and calls the code that imports all csv files found within the directory. The csv loading code also moves the files again into an archive folder <file>X:\CCMDB\PHI\PHI Archive\</file> to prevent duplicate processing.
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. - This needs to be reviewed as the last line of the batch file has changed the the return value may be altered Bcloutier 19:47, 2013 November 20 (CST)
Where schedule task lives
Trish's desktop
How often does it Run?
The scheduled task runs every 10 minutes
Comments
Hmmm? Centralized data.mdb vs Aggregator.mdb
Problem
If the PC that this is scheduled on isn't running (shutdown) 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)
- currently Trish locks her computer each night and reboots it in the AM. Locking does not stop this scheduled task from running.
- If Trish is away for 2 weeks or more then this task needs to be put on another person's desktop, either Tina, Pagasa or Julie. Trish Ostryzniuk 19:16, 2014 April 23 (CDT)