DSM data testing

From CCMDB Wiki
Revision as of 15:29, 2014 December 29 by Ttenbergen (talk | contribs) (m)
Jump to navigation Jump to search

currently in "DSM labs comparison" on Tina's desktop

  1. open DSM_Labs_Consistency_check
  2. import data into a new table "Trial_export" (import into existing table goes wrong it seems, field testresult must be memo; access file needs to be well under 2GB or error)
  3. run query 1_requester_maker to populate Labs_requester; too slow to do with query
  4. run query 2_labs_reformed_maker to deal with date formats and to split out MRNs etc