PHI copy automation: Difference between revisions

(One intermediate revision by the same user not shown)

Line 1:

We store personal health information separately from our other data. This process is par of managing that data. [[~~Re-platforming~~]] ~~might make this obsolete~~.

We store personal health information separately from our other data. This process is par of managing that data.

We can't have [[PHI.mdb]] on the Regional server because too many people have access and we can't log the access.

==Process==

[[CCMDB.accdb]] exports PHI files ~~during~~ [[~~sending~~]]. ~~This process~~ copies ~~them~~ from {{Regionalserver|Output\_PHI}} to {{S:\MED\MED_CCMED}}CCMDB\PHI. Then it calls the script [[Load Data.vbs]] to integrate them into [[PHI.mdb]].

* During [[sending]], [[CCMDB.accdb]] exports PHI files into {{Regionalserver|Output\_PHI}} .

* Running [[Pull]] or manually running it will run [[Copy PHI.bat]]

~~The script~~ [[Load Data.vbs]] accesses [[PHI Loader.accdb]] and runs the sub ''loadAllCSVFiles'', which 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 {{S:\MED\MED_CCMED}}CCMDB\PHI\PHI Archive\ to prevent duplicate processing.

* [[Copy PHI.bat]] copies the files from {{Regionalserver|Output\_PHI}} to {{S:\MED\MED_CCMED}}CCMDB\PHI. Then it calls the script [[Load Data.vbs]] to integrate them into [[PHI.mdb]].

* [[Load Data.vbs]] accesses [[PHI Loader.accdb]] and runs the sub ''loadAllCSVFiles'', which 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 {{S:\MED\MED_CCMED}}CCMDB\PHI\PHI Archive\ to prevent duplicate processing.

=== Running this manually ===

* navigate to {{S:\MED\MED_CCMED}}CCMDB\PHI'''

* double-click [[copy_PHI.bat]] and let it finish. May take a few (<10) minutes, depending on the build-up of files

* check/refresh {{S:\MED\MED_CCMED}}CCMDB\PHI''' to make sure no *.csv files remain in that directory

** if any are left, troubleshoot; files that remain in there have likely not been integrated into [[PHI.mdb]]

{{DT| there is a data processing instruction for this on the wiki, no time to find it right now. }}

== Future of this process ==

Depending how PHI is stored in the future, [[Re-platforming]] might make this obsolete.

{{LegacyContent

@@ Line 1: / Line 1: @@
-We store personal health information separately from our other data. This process is par of managing that data. [[Re-platforming]] might make this obsolete.
+We store personal health information separately from our other data. This process is par of managing that data.
+We can't have [[PHI.mdb]] on the Regional server because too many people have access and we can't log the access.
 ==Process==
-[[CCMDB.accdb]] exports PHI files during [[sending]]. This process copies them from {{Regionalserver|Output\_PHI}} to  {{S:\MED\MED_CCMED}}CCMDB\PHI. Then it calls the script [[Load Data.vbs]] to integrate them into [[PHI.mdb]].
+* During [[sending]], [[CCMDB.accdb]] exports PHI files into {{Regionalserver|Output\_PHI}} .
+* Running [[Pull]] or manually running it will run [[Copy PHI.bat]]
-The script [[Load Data.vbs]] accesses [[PHI Loader.accdb]] and runs the sub ''loadAllCSVFiles'', which 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 {{S:\MED\MED_CCMED}}CCMDB\PHI\PHI Archive\ to prevent duplicate processing.
+* [[Copy PHI.bat]] copies the files from {{Regionalserver|Output\_PHI}} to {{S:\MED\MED_CCMED}}CCMDB\PHI. Then it calls the script [[Load Data.vbs]] to integrate them into [[PHI.mdb]].
+* [[Load Data.vbs]] accesses [[PHI Loader.accdb]] and runs the sub ''loadAllCSVFiles'', which 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 {{S:\MED\MED_CCMED}}CCMDB\PHI\PHI Archive\ to prevent duplicate processing.
+=== Running this manually ===
+* navigate to {{S:\MED\MED_CCMED}}CCMDB\PHI'''
+* double-click [[copy_PHI.bat]] and let it finish. May take a few (<10) minutes, depending on the build-up of files
+* check/refresh {{S:\MED\MED_CCMED}}CCMDB\PHI''' to make sure no *.csv files remain in that directory
+** if any are left, troubleshoot; files that remain in there have likely not been integrated into [[PHI.mdb]]
+{{DT| there is a data processing instruction for this on the wiki, no time to find it right now.  }}
+== Future of this process ==
+Depending how PHI is stored in the future, [[Re-platforming]] might make this obsolete.
 {{LegacyContent