Instructions for requesting a batch of data from DSM
This article describes how to generate the requestor file for the DSM Lab Extract. The file is stored on a file share that DSM can access.
Instructions
- copy files to local, they are large and won't work well on a share.
- make a new local directory
- Put the following into the directory
- open DSM_Labs_Consistency_check.accdb
- pick the SentDtTm field range for which you want to export
- starting should be the day after the last end date as per log below
- ending date should be at least 28 days ago
- click the "Export requestor file" button
- follow the wizard
- close Access and delete files you had copied
- enter at the top of the log below when you requested data, and for what range
- Where does the request go? in email? or shared folder with Allun?
- Can we have a demo in June (Trish will book)?
- What again is the rational of ending date 28 days ago? I remember we discussed it before.
Log
eg copy/paste and fill in the following: * ~~~~~ - requested labs for SendDtTm from ... until ...
- has there been a batch after Dec 31, 2016? We see version 2017-04-29 but what are the beginning and end dates?
- Need to clarify the test data and the real data.
- 14:10, 2017 March 14 (CDT) - requested labs for SendDtTm from 2016-09-01 until 2016-12-31
- 16:05, 2016 October 17 (CDT) - requested labs for SendDtTm from 2016-08-01 until 2016-08-31
- 2015-12-?? - Discharge date 2015-04-01 - 2015-04-30