Instructions for exporting data using MCHP Export.accdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
No edit summary |
||
| Line 5: | Line 5: | ||
# [[Pull]] down the data to the usual location (desktop/CentralizedFrontEndLive) | # [[Pull]] down the data to the usual location (desktop/CentralizedFrontEndLive) | ||
# copy [[MCHP Export.accdb]] to the same location | # copy [[MCHP Export.accdb]] to the same location | ||
# copy [[DSM Labs Consistency check.accdb]] to the same location | |||
=== generating the export file === | === generating the export file === | ||
* open [[MCHP Export.accdb]] | * open [[MCHP Export.accdb]] | ||
Revision as of 09:06, 3 August 2023
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
- copy DSM Labs Consistency check.accdb to the same location
generating the export file
- open MCHP Export.accdb
- change extract dates if needed; actually, we don't generally change the dates, we always send 2019-01-01 to current
- edit the VBA 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
- edit the VBA code to set the date range
- accommodate any data structure changes that might have occurred since the last export (or confirm there are no such changes)
- e.g. are there any new tmp projects that should be included?
- Click the "Run MCHP Export" button
- delete the modules and forms, they contain Passwords
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
- 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, 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).
- 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.