DSM Labs Consistency check.accdb

The program

X:\CCMDB\DSM Labs Imports\DSM Labs Consistency check.accdb

generates request extracts and imports lab data as provided by DSM.

The data is stored in DSM Labs data.accdb.

Requesting/importing

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

Log

changes for next version

_DEV_DSM Next version: the error it gives for there already existing a file needs more helpful text.

• SMW

• Cargo

• Categories

version 2019-12-09

• added automatic reconnecting (on opening the following runs: module DB_Connect, function DB_Connect)

version 2019-05-15

• added query Import_request_matcher to be used as part of Instructions for importing a batch of DSM Data.

version 2019-02-14

• tweaked messaging and button hover overs slightly.
• automated re-linking

version 2018-04-03

• updated table s_mapping_lab to see new fields as PTT as per email from Allan Garland to Tina Tenbergen 2018-02-28

version 2017-11-24

• updating importer to cycle through all files in a directory rather than opening each individually.

version 2017-04-29

• changed the way new labs are checked for

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)