Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

SAMPLE.csv

Note

This template is used when specimen label auto-generation is on for aliquots. Refer 'Label Configuration' to set label format to auto-generate specimen labels.


Column Name

DatatypeMandatory?DescriptionPermissible ValuesValidations
CP Short TitleStringNoCollection protocol short title under which specimen is collected
This is mandatory only if specimen labels are not unique across collection protocols. This is a setting user can set in Admin settings. By default labels are unique across the system.
Parent Specimen LabelStringYes

Specimen should be existing within the system
Quantity per AliquotDouble

Yes if parent quantity not specified or number of aliquots not specified



If not specified, it divides the entire parent specimen available quantity into equal amounts amongst all the aliquots
Number of AliquotsIntegerYes if parent quantity not specified or quantity per aliquot not specified

When left blank the number of aliquots=(parent quantity/quantity per aliquots)
ContainerStringNoNeeds to be specified if the specimen is not virtually located
  1. Container specified should be existing
  2. Suitable to hold the specimen (based on type and protocol)
  3. Should have available positions.
  4. The specimen gets stored at the next available position within the container
Start RowString or IntegerNoDatatype depending on the row labelling scheme (Numbers, Alphabets Upper Case, Alphabet Lower Case, Roman Upper Case, Roman Lower Case)
Position within the container at which the specimen is to be stored. If left blank, system will allocate next available position.

Start ColumnString or IntegerNoDatatype depending on the column labelling scheme (Numbers, Alphabets Upper Case, Alphabet Lower Case, Roman Upper Case, Roman Lower Case)
Start PositionNumberNosingle number or linear position labels to identify slots within container for storing specimen
Created OnDateNo

Select the correct date format from UI based on the data in the file


Freeze/Thaw CyclesNumberNoFreeze/Thaw Cycle of the aliquot

Increment Parent Freeze/Thaw CyclesNumberNoNumber by which parent freeze/thaw cycle is to be incremented

Close ParentStringNoOptions - Yes/No or true/false
Parent specimen should be in collected- collection status
Specimen Additional Fields#Media VolumeNumberNo


Specimen Additional Fields#Cell Viability (%)NumberNo


...