Instructions for exporting data using MCHP Export.accdb: Difference between revisions
| Line 19: | Line 19: | ||
=== sending === | === 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]] | * 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. | |||
* 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. | * 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 | * 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. | ** 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. | ||
** email the password to Dave Towns (Dave_Towns@cpe.umanitoba.ca). | ** email the password to Dave Towns (Dave_Towns@cpe.umanitoba.ca). | ||
* | * the zipped [[PHI.mdb]] and password protected | ||
** send password encrypted PHI.mdb via MHSAL’s secure file transfer system to Jason Berry, A/Director, of Information Management and Governance Unit, Information Management and Analytics, Resources and Performance, Manitoba Health, Healthy Living & Seniors (4041 -300 Carlton Street, Winnipeg MB R3B 3M9) and email the password to him (Jason.Berry@gov.mb.ca); Manitoba Health with de-identify the data and pass it on to MCHP. Julie has an account to MHSAL secure file transfer system. | ** send password encrypted PHI.mdb via MHSAL’s secure file transfer system to Jason Berry, A/Director, of Information Management and Governance Unit, Information Management and Analytics, Resources and Performance, Manitoba Health, Healthy Living & Seniors (4041 -300 Carlton Street, Winnipeg MB R3B 3M9) and email the password to him (Jason.Berry@gov.mb.ca); Manitoba Health with de-identify the data and pass it on to MCHP. Julie has an account to MHSAL secure file transfer system. | ||
**starting Aug 2023, the contact person has been changed to Fan Zhaopeng (Zhaopeng.Fan@gov.mb.ca), manager of the Axway at MB Health. | |||
=== saving === | === saving === | ||
* make a new sub-folder labelled with the date data was generated in the folder '''S:\MED\MED_CCMED\CCMDB_Special_Projects\MCHP'''. | * make a new sub-folder labelled with the date data was generated in the folder '''S:\MED\MED_CCMED\CCMDB_Special_Projects\MCHP'''. | ||