Versions Compared

Key

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

...

...

...

...

User can create aliquot specimens in bulk through bulk operation, follow below steps to create aliquot specimens in bulk:

  1. Go to collection protocols list page, click on 'Import' button and select option 'Import' OR
    Image Added
  2. Go to participants list page of the CP whose aliquot specimens has to be created, click on 'More' button and select option 'Import
    Image Added
  3. Select 'Specimen Aliquots' from 'Select Record Type' dropdown and click on 'Download Template File' to download the template file
    Image Added
  4. Enter all valid data in the template file as mentioned in the below table
  5. Upload the filled template file in 'Input Records File' field
  6. Click on 'Validate and Import' button
  7. Refer 'Import status' to check the status of import job

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

Datatype

Mandatory?

(Create)

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


...