PHI copy automation: Difference between revisions

Line 1:

~~As part of the [[:category:2013 data upgrades|2013 data upgrades]],~~

*The data collectors SENDing process from ccmdb.mdb also sends a file [[PHI Data]] (patient identifiers) to: {{Regionalserver|Output\_PHI}}

~~''("_" to sort separate from hospitals)''~~

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

*'''from:''' {{Regionalserver|Output\_PHI}} ''("_" to sort separate from hospitals)''

*'''to:''' <file>X:\CCMDB\PHI</file>

*It is not clear how is the copy of csv sent created from output folder to _PHI folder on regional server before scheduled task copies to X? [[User:TOstryzniuk|Trish Ostryzniuk]] 17:26, 2014 June 17 (CDT)

** the .csvs are generated by [[sending]]. Ttenbergen 14:25, 2014 June 19 (CDT)

~~'''~~[[~~copy PHI.bat~~]]~~''' moves the data from {{Regionalserver|Output\_PHI}} to:~~

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

**X:\~~ccmdb~~/~~PHI~~

*copy.phi.bat ~~then calls~~ the '''Load Data.vbs''' and ~~move~~ the csv ~~[[PHI Data]] it~~ into:

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.

**x:\~~ccmdb~~\~~phi~~.~~mdb~~

*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 [[User:Bcloutier|Bcloutier]] 19:47, 2013 November 20 (CST)

==Where schedule task lives==

~~A scheduled task on~~ [[Trish Ostryzniuk | Trish's]] ~~computer:~~

[[Trish Ostryzniuk | Trish's]] desktop

==How often does it Run?==

@@ Line 1: / Line 1: @@
-As part of the [[:category:2013 data upgrades|2013 data upgrades]],
-*The data collectors SENDing process from ccmdb.mdb also sends a file [[PHI Data]] (patient identifiers) to: {{Regionalserver|Output\_PHI}}
-''("_" to sort separate from hospitals)''
 ==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
+*'''from:''' {{Regionalserver|Output\_PHI}} ''("_" to sort separate from hospitals)''
+*'''to:''' <file>X:\CCMDB\PHI</file>
+{{Discussion}}
+*It is not clear how is the copy of csv sent created from output folder to _PHI folder on regional server before scheduled task copies to X? [[User:TOstryzniuk|Trish Ostryzniuk]] 17:26, 2014 June 17 (CDT)
+** the .csvs are generated by [[sending]]. Ttenbergen 14:25, 2014 June 19 (CDT)
-'''[[copy PHI.bat]]''' moves the data from {{Regionalserver|Output\_PHI}} to:
+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]]).
-**X:\ccmdb/PHI
-*copy.phi.bat then calls the '''Load Data.vbs''' and move the csv [[PHI Data]] it into:
+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.
-**x:\ccmdb\phi.mdb
-*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 [[User:Bcloutier|Bcloutier]] 19:47, 2013 November 20 (CST)
 ==Where schedule task lives==
-A scheduled task on [[Trish Ostryzniuk | Trish's]] computer:
+[[Trish Ostryzniuk | Trish's]] desktop
 ==How often does it Run?==