DSM Labs Consistency check.accdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) mNo edit summary |
||
(8 intermediate revisions by the same user not shown) | |||
Line 14: | Line 14: | ||
_DEV_DSM | _DEV_DSM | ||
* Next version: | * Next version: | ||
** | ** Nothing right now. | ||
* | }} | ||
*** | |||
** ''' | === version 2019-12-09 === | ||
** the | * 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'') | |||
* improved error messaging when trying to run export a second time the same day, which breaks because it tries to create a directory which already exists. | |||
=== version 2019-05-15 === | === version 2019-05-15 === | ||
Line 44: | Line 49: | ||
local for now | 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) | * 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) | ||
== Related articles == | |||
{{Related Articles}} | |||
[[Category:DSM Labs Extract]] | [[Category:DSM Labs Extract]] | ||
[[Category:DSM Labs Consistency check.accdb | *]] | [[Category:DSM Labs Consistency check.accdb | *]] |
Revision as of 18:39, 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)
- 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)
- improved error messaging when trying to run export a second time the same day, which breaks because it tries to create a directory which already exists.
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)