MCHP Export.accdb

From CCMDB Wiki

Revision as of 08:49, 3 May 2017 by Ttenbergen (talk | contribs) (Text replacement - "</file>" to "")

(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\<most recent date>

Password

Located: M:\Passwords_MainOffice_use

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=55093"