DSM Labs Consistency check.accdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (→changes for next version: checking for labs is a separate step now) |
Ttenbergen (talk | contribs) m (→changes for next version: not changing email since no info to what to change it.) |
||
Line 15: | Line 15: | ||
* Next version: | * 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? | ** 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? | ||
** the error it gives for there already existing a file needs more helpful text. | ** the error it gives for there already existing a file needs more helpful text. | ||
}} | }} |
Revision as of 18:19, 2019 December 9
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
Log
changes for next version
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)