DSM Labs Consistency check.accdb

Preliminary information, this is not active yet

The program

X:\CCMDB\DSM Labs comparison of test data\DSM Labs Consistency check.accdb

generates request extracts and imports lab data as provided by DSM

Requesting/importing

• Instructions for requesting a batch of data from DSM
• Instructions for importing a batch of DSM Data

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 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)