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]] | ||