Changes between Version 1 and Version 2 of net.sf.basedb.reggie/notes47


Ignore:
Timestamp:
Sep 20, 2016, 1:33:18 PM (4 years ago)
Author:
Nicklas Nordborg
Comment:

Added update note about ticket #906

Legend:

Unmodified
Added
Removed
Modified
  • net.sf.basedb.reggie/notes47

    v1 v2  
    1313
    1414All boxes should have the ususal 9x9 geometry and it is recommended that a freezer location is specified.
     15
     16=== 2. Assign external ID values to patient, cases, blood, specimen and nospecimen items ===
     17
     18Ticket #906 is assigning unique external ID values to all patients, cases, blood, specimen and nospecimen items. The external ID is a text value consisting of a single-letter prefix and six digits.
     19
     20 ||  '''Item type'''  ||  '''Prefix'''  ||
     21 ||  Patient  ||  Q  ||
     22 ||  Case     ||  C  ||
     23 ||  Blood    ||  B  ||
     24 ||  Specimen & !NoSpecimen ||  S  ||
     25
     26
     27All existing items need to be assigned external ID values. A simple procedure is to export 4 data files with the internal ID of each item. One file for patients, one file for cases, one file for blood and one file for specimen and nospecimen items. Use a spreadsheet program to add a second column with auto-generated external ID values. Import the text files back into BASE using the built-in batch importer plug-ins.