Instructions for requesting a batch of data from DSM: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (cleanup) |
|||
Line 17: | Line 17: | ||
# close Access and delete files you had copied | # close Access and delete files you had copied | ||
# enter at the top of the log below when you requested data, and for what range | # enter at the top of the log below when you requested data, and for what range | ||
{{Discussion}} | |||
*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 == | == Log == |
Revision as of 11:01, 2017 June 8
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 ...
- 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