DSM Labs Consistency check.accdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (m)
Line 2: Line 2:


The program  
The program  
:: X:\CCMDB\DSM Labs comparison of test data\DSM Labs Consistency check.accdb
:: '''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 ===
Local for now
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)