Instructions for exporting data using MCHP Export.accdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) m →sending: cleaned up to only have current info in instructions, put the past process into legacy section in the bottom. |
||
| Line 21: | Line 21: | ||
* 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. | ||
* zip the [[MCHP Export.accdb]] and password protected | * zip the [[MCHP Export.accdb]] and password protected | ||
** | ** send via MCHP sFTP server. Julie has been given a temporary account by Rod McRae,IT Manager,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). | ||
* zip the PHI.mdb and password protected | * zip the 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. | ||
== Legacy info == | |||
{{LegacyContent | |||
|explanation=old process | |||
|successor=see above | |||
|content= | |||
* We used to hand deliver this data: | |||
** copying to a memory stick or CD and hand carry the memory stick or CD to Dave Towns, Senior Data Management Analyst, of Manitoba Centre for Health Policy (MCHP), Dept of Community Health Sciences, University of Manitoba - stopped Aug 2019 | |||
** starting April 2020, data is transferred via sFTP server as per instructions above | |||
}} | |||
== Related articles == | == Related articles == | ||
Revision as of 09:12, 2020 May 5
This article contains the instructions to generate data for Manitoba Centre for Health Policy export using MCHP Export.accdb
Instructions
Preparations
- Pull down the data to the usual location (desktop/CentralizedFrontEndLive)
- copy MCHP Export.accdb to the same location
generating the export file
- open MCHP Export.accdb
- edit the code to set the date range
- in the program, click the "Database Tools" button bar tab a the top, then the "Visual Basic" button
- edit the start_threshold and end_threshold variables
- accommodate any data structure changes that might have occurred since the last export (or confirm there are no such changes)
- one thing to consider each time would be whether any new tmp projects should be included
- one thing to consider just the next time is to comment out the old code that exports the pre-idc10 dx/px structure, and the old tasks.
- Click the "Run MCHP Export" button
- delete the modules and forms, they contain Passwords
sending
- review MCHP_Cleanup to make sure there are no big outstanding questions that will make our data look bad
- 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.
- zip the MCHP Export.accdb and password protected
- send via MCHP sFTP server. Julie has been given a temporary account by Rod McRae,IT Manager,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).
- zip the 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.
Legacy info
Legacy Content
This page contains Legacy Content.- Explanation: old process
- Successor: see above
Click Expand to show legacy content.
- We used to hand deliver this data:
- copying to a memory stick or CD and hand carry the memory stick or CD to Dave Towns, Senior Data Management Analyst, of Manitoba Centre for Health Policy (MCHP), Dept of Community Health Sciences, University of Manitoba - stopped Aug 2019
- starting April 2020, data is transferred via sFTP server as per instructions above
Related articles
| Related articles: |