MCHP Export.accdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
| Line 10: | Line 10: | ||
=== 2019-08-26 === | === 2019-08-26 === | ||
* added date thresholds to export (ie include only data up to [[Dispo DtTm]] 2019-01-01) | * added date thresholds to export (ie include only data up to [[Dispo DtTm]] 2019-01-01) | ||
* additional bug fixes | |||
=== 2019-08-14 === | === 2019-08-14 === | ||
Revision as of 17:13, 2019 August 27
The file MCHP Export.accdb contains and is used to generate data for Manitoba Centre for Health Policy export. See Instructions for exporting data using MCHP Export.accdb for info on how to use it.
file location
X:\CCMDB_Special_Projects\MCHP\Master
Password
Located: M:\Passwords_mainoffice\
Change log
2019-08-26
- added date thresholds to export (ie include only data up to Dispo DtTm 2019-01-01)
- additional bug fixes
2019-08-14
Moved to Master
- had to re-write the export code because we didn't keep a version with it. emailed Julie to request review. Ttenbergen 16:58, 2019 August 14 (CDT)
2017-04-12
Starting review
- updated importer to work with current file structure
- added code to remove columns we are not sending, eg. Notes , *_complete, and others no longer used.
2015-04-27
- added "Comfort Care" to query "Create_Tmp" Ttenbergen 09:54, 2015 April 27 (CDT)
- removed several components from 1Main that don't need to be in there Ttenbergen 14:56, 2015 April 27 (CDT)
2015-04-23
copied to master directory
- code to generate export file when "generate output" is clicked
- make-table queries
2015-04-20
- re-conect for relevant files
- initial file (is a modified clone of Legacy_TMS_Data.mdb)