DSM Labs Consistency check.accdb

From CCMDB Wiki
Jump to navigationJump to search

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

nothing right now

version 2020-09-30

  • updated the specs for the importer so it will work with the RecordStatus field added to requestor in last change. Ttenbergen 14:22, 2020 September 30 (CDT)

version 2020-08-13

version 2020-06-04

version 2020-05-06

  • added "DAO.DBEngine.SetOption dbmaxlocksperfile, 15000" to prevent out-of-diskspace error [1]
  • changed query 2_dedupe_appender_group to set DSM_TestCode to 0 rather than "not from group" for records arriving as test; this would have generated a hidden error all along but there would be no consequence to the data, this just cleans up that hidden error

version 2019-12-18

  • Added several labs as per Allan Garland, incl the ABG labs.
  • fixed a bug from last time, re-imported queries I had misunderstood
    • s_group_ListNewFound - used when labs first arrive to mark them with date
    • s_mapping_lab_NewFound - used when labs first arrive to mark them with date

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

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)

Related articles

Related articles: