MCHP Export.accdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m Text replacement - "<file>" to ""
m Text replacement - "</file>" to ""
Line 5: Line 5:


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


== Change log ==
== Change log ==

Revision as of 08:49, 2017 May 3

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