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

Timestamp:

Sep 20, 2016, 1:33:18 PM (8 years ago)

Author:

Nicklas Nordborg

Comment:

Added update note about ticket #906

net.sf.basedb.reggie/notes47

@@ -13 +13 @@
 
 All boxes should have the ususal 9x9 geometry and it is recommended that a freezer location is specified.
+
+=== 2. Assign external ID values to patient, cases, blood, specimen and nospecimen items ===
+
+Ticket #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.
+
+ ||  '''Item type'''  ||  '''Prefix'''  || 
+ ||  Patient  ||  Q  ||
+ ||  Case     ||  C  ||
+ ||  Blood    ||  B  ||
+ ||  Specimen & !NoSpecimen ||  S  ||
+
+
+All 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.