MCHP Export.accdb

From CCMDB Wiki

Revision as of 12:24, 2017 April 13 by Ttenbergen (talk | contribs) (m)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

See: Manitoba Centre for Health Policy export

file location

X:\CCMDB_Special_Projects\MCHP\2015

Password

Located: <file>M:\Passwords_MainOffice_use</file>

Change log

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)

Retrieved from "https://ccmdb.kuality.ca/index.php?title=MCHP_Export.accdb&oldid=54744"