DSM Labs Consistency check.accdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (→version 2016-09-26: made copy) |
Ttenbergen (talk | contribs) m (m) |
||
Line 2: | Line 2: | ||
The program | The program | ||
:: X:\CCMDB\DSM Labs | :: '''X:\CCMDB\DSM Labs Imports\DSM Labs Consistency check.accdb''' | ||
generates request extracts and imports lab data as provided by DSM | generates request extracts and imports lab data as provided by DSM. | ||
== Requesting/importing == | == Requesting/importing == | ||
Line 15: | Line 15: | ||
=== version 2016-09-26 === | === version 2016-09-26 === | ||
Moved to X: | |||
* some tweaks to deal with Alun's new data as of March. Ttenbergen 15:23, 2016 October 17 (CDT) | |||
=== version 2015-12-01 === | === version 2015-12-01 === |
Revision as of 15:23, 2016 October 17
Preliminary information, this is not active yet
The program
- X:\CCMDB\DSM Labs Imports\DSM Labs Consistency check.accdb
generates request extracts and imports lab data as provided by DSM.
Requesting/importing
Log
changes for next version
- lock out sending of request if any sent but not vetted records are present to make sure they are not missed; or send all <> incomplete?
- fix auto email it says "Hi, \n \n here is a new data request file for the CCMDB export. Could you please generate the lab export and let us know when done? \n \n Thanks!"
version 2016-09-26
Moved to X:
- some tweaks to deal with Alun's new data as of March. Ttenbergen 15:23, 2016 October 17 (CDT)
version 2015-12-01
local for now
- adding checks for locations and labs that have not been encountered before. Ran across different field lengths, emailed Alun.Ttenbergen 14:43, 2015 December 1 (CST)