DSM Labs Consistency check.accdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (→changes for next version: we are sending all records, so nothing to lock) |
Ttenbergen (talk | contribs) |
||
Line 19: | Line 19: | ||
=== version 2019-12-09 === | === version 2019-12-09 === | ||
* added automatic reconnecting (on opening the following runs: module DB_Connect, function DB_Connect) | * added automatic reconnecting (on opening the following runs: module DB_Connect, function DB_Connect) | ||
* removed old queries: | |||
** s_group_ListNewFound (replaced by ''s_group_imported_today'') | |||
** s_group_ListNewlyAdded (replaced by ''s_group_imported_today'') | |||
** s_mapping_lab_NewFound (replaced by ''s_mapping_lab_today'') | |||
** s_mapping_lab_ListNewlyAdded (replaced by ''s_mapping_lab_today'') | |||
=== version 2019-05-15 === | === version 2019-05-15 === |
Revision as of 18:25, 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
_DEV_DSM
|
version 2019-12-09
- added automatic reconnecting (on opening the following runs: module DB_Connect, function DB_Connect)
- removed old queries:
- s_group_ListNewFound (replaced by s_group_imported_today)
- s_group_ListNewlyAdded (replaced by s_group_imported_today)
- s_mapping_lab_NewFound (replaced by s_mapping_lab_today)
- s_mapping_lab_ListNewlyAdded (replaced by s_mapping_lab_today)
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)