Versions Compared

Old Version 22

changes.mady.by.user Nidhi Harmukh

Saved on

compared with

New Version 23

changes.mady.by.user Ankita Chavan

Saved on

Key

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

Table of Contents

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.

Steps to import CSV

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

...

Column Name

Datatype

Mandatory?

(Create)

DescriptionPermissible ValuesValidations
CP Short TitleStringNoThe collection protocol short title under which specimens have to be created
This is mandatory only if specimen labels are not unique across collection protocols. 
Parent Specimen LabelStringYes

Specimen The specimen should be existing exist within the system
Quantity per AliquotDouble

Yes, if parent quantity is not specified or the number of aliquots is 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 is not specified or quantity per aliquot is not specified

When left blank, the number of aliquots=(parent quantity/quantity per aliquots)
ContainerStringNoNeeds It needs to be specified if the specimen is not virtually located
  1. Container specified should be existingexist.
  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 labeling 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, the system will allocate the next available position.

Start ColumnString or IntegerNoDatatype depending on the column labeling scheme (Numbers, Alphabets Upper Case, Alphabet Lower Case, Roman Upper Case, Roman Lower Case)
Start PositionNumberNoThe single number or linear position labels to identify slots within the 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


...