Instructions for exporting data using MCHP Export.accdb: Difference between revisions
Ttenbergen (talk | contribs) m Ttenbergen moved page Instructions for exporting data using MCHP Export.mdb to Instructions for exporting data using MCHP Export.accdb without leaving a redirect: Text replacement - "MCHP Export.mdb" to "MCHP Export.accdb" |
Ttenbergen (talk | contribs) m Text replacement - "MCHP Export.mdb" to "MCHP Export.accdb" |
||
| Line 1: | Line 1: | ||
This article contains the instructions to generate data for [[Manitoba Centre for Health Policy export]] using [[MCHP Export. | This article contains the instructions to generate data for [[Manitoba Centre for Health Policy export]] using [[MCHP Export.accdb]] | ||
== Instructions == | == Instructions == | ||
=== Preparations === | === Preparations === | ||
# [[Pull]] down the data to the usual location | # [[Pull]] down the data to the usual location | ||
# copy [[MCHP Export. | # copy [[MCHP Export.accdb]] to the same location | ||
=== generating the export file === | === generating the export file === | ||
* open [[MCHP Export. | * open [[MCHP Export.accdb]] | ||
* edit the code to '''set the date range''' and accommodate any data structure changes that might have occurred since the last export | * edit the code to '''set the date range''' and accommodate any data structure changes that might have occurred since the last export | ||
* Click the "Run MCHP Export" button | * Click the "Run MCHP Export" button | ||
| Line 21: | Line 21: | ||
=== sending === | === sending === | ||
* review [[MCHP_Cleanup]] to make sure there are no big outstanding questions that will make our data look bad | * review [[MCHP_Cleanup]] to make sure there are no big outstanding questions that will make our data look bad | ||
* copy [[MCHP Export. | * copy [[MCHP Export.accdb]] to a memory stick or CD | ||
* send the memory stick or CD to Jason Berry, Privacy Policy Analyst, of Information Management and Analytics, Manitoba Health, Healthy Living & Seniors (4040D -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. | * send the memory stick or CD to Jason Berry, Privacy Policy Analyst, of Information Management and Analytics, Manitoba Health, Healthy Living & Seniors (4040D -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. | ||