Instructions for exporting data using MCHP Export.accdb: Difference between revisions

← Older edit

@@ Line 23: / Line 23: @@
 ** if error message comes up due to large size issue, close the accdb.  Get a copy again of the master MCHP Export, open, purge the data and run the MCHP Export button again.
 * '''delete the modules and forms, they contain [[:Category:Password | Passwords]]'''
+==== Contents of the export files ====
+* [[MCHP Export.accdb]] : before 2020-05-05, the exported file contains from the beginning of the database to the current time. Starting 2020-05-05, the data file being sent start always from 2019-01-01 to current.
+* [[PHI.mdb]]  contains always  from the beginning of the database to current.
+==== Temporary instruction re:[[LAU Collection Project]] ====
+* starting 2025-03-01, Non-medicine wards or Lower Acute units [[LAU]]  have been collected as a temporary project [[LAU Collection Project]] and incorporated into [[CCMDB.accdb]].  These records need to be excluded manually from the export files before sending.
+** How? create a sub-folder under the S:\MED\MED_CCMED\CCMDB_Special_Projects\MCHP and label it by yyyy-mm-dd (the date when the export files were done). Copy the [[MCHP Export.accdb]] and the [[PHI.mdb]]   from the desktop into the sub-folder.
+*** Open the [[MCHP Export.accdb]] and click L_LOG_MCHP table. Filter  those records having service location with loc_type LAU  or right click any record under [[D ID field]] and choose '''text filters contains LAU''' ).  Then delete them all and consequently the related tables should clear out as well.
+*** Similarly open [[PHI.mdb]] and click L_PHI table. Filter those records by right clicking  any record under [[D ID field]]  and choose '''text filters contains LAU'''.  Then delete them all.
+* End date: none yet
 === sending ===
 * review to make sure there are no big outstanding questions that will make our data look bad; a page on the wiki that might help with this is [[Portal related pages with questions]]
-* Zip the individual files by using the 7-zip file manager - find the files and click '''ADD''' and it will open a screen. Rename the files into CCMDB_MCHP_export_date and CCMDB_phi_date.   Encrypt the zip files by using the passwords indicated from the excel file of Passwords_MainOffice from the shared folder.
+* Zip the individual files by using the 7-zip file manager - find the files and click '''ADD to archive''' and it will open a screen. Rename the files into CCMDB_MCHP_export_date and CCMDB_phi_date.   Encrypt the zip files by using the passwords indicated from the excel file of Passwords_MainOffice from the shared folder.
 * after zipping the files in the next two steps, try opening them on a different computer before sending them out of office; we had a problem with the zipped file during the 2020-04-30 send.
 * the zipped [[MCHP Export.accdb]] and password protected
 ** send via  MCHP sFTP server .  Julie has been given a temporary account by Rod McRae, IManager, Manitoba Centre for Health Policy. Every time needed, Julie has to request and email Rod McRae <Rod_McRae@cpe.umanitoba.ca> and Dave Towns.
-*** go to  https://collab.mchp.ca/sites/sft. Enter the provided username and password by MCHP (see Passwords_MainOffice). Double click document CriticalCare_Medicine. Drag the zipped file to upload or choose the file to start uploading. logout.
+*** go to  https://collab.mchp.ca/sites/sft. Enter the provided username and password by MCHP (see Passwords_MainOffice). Double click document CriticalCare_Medicine. Drag the zipped file to upload or choose the file to start uploading.   Sign out once done.
 ** email  the password to Dave Towns (Dave_Towns@cpe.umanitoba.ca).
 * the zipped [[PHI.mdb]] and password protected
@@ Line 54: / Line 63: @@
 {{Related Articles}}
-[[Category: MCHP]]
+[[Category:MCHP]]