DSM Labs Consistency check.accdb: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) |
Ttenbergen (talk | contribs) |
||
Line 10: | Line 10: | ||
== Log == | == Log == | ||
==2019-02-14 == | |||
* tweaked messaging and button hover overs slightly. | |||
* automated re-linking | |||
=== changes for next version === | === changes for 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? | ||
* 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!" | * 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.''' | * '''Add a debug.stop after the new-lab-finding part so the import can just continue.''' | ||
* 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 17:10, 2019 February 14
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
2019-02-14
- tweaked messaging and button hover overs slightly.
- automated re-linking
changes for 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?
- 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.
- the error it gives for there already existing a file needs more helpful text.
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)