DSM Labs Consistency check.accdb: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
(8 intermediate revisions by the same user not shown)
Line 14: Line 14:
_DEV_DSM
_DEV_DSM
* 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?
** Nothing right now.
** fix auto email it says "Hi, \n \n here is a new data request file for the CCMDB export. Could you please generate the lab export and let us know when done? \n \n Thanks!"
}}
*** why would I change it and to what?
 
** '''Add a debug.stop after the new-lab-finding part so the import can just continue.'''
=== version 2019-12-09 ===
** the error it gives for there already existing a file needs more helpful text.
* added automatic reconnecting (on opening the following runs: module DB_Connect, function DB_Connect)
** automate reconnecting; I thought this was done but it's not. }}
* 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

_DEV_DSM

  • Next version:
    • Nothing right now.
  • SMW


  • Cargo


  • Categories

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: