Versions Compared

Old Version 25

changes.mady.by.user Aditi Kavimandan

Saved on

compared with

New Version 26

changes.mady.by.user Aditi Kavimandan

Saved on

Key

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

Table of Contents

...

Introduction

Using this CSV, you can create bulk unplanned aliquots only. 

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
    ›fi
  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.'
  3. Select 'Specimen Aliquots' from the 'Select Record Type' dropdown and click on 'Download Template File' to download the template file
  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 TitleStringYesThe 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

The specimen should exist within the system
Specimen labelStringNo

Note: While using this CSV the specimen label auto-generation should be on

Depends

Depending on the system setting, it should be unique within the system or CP.

Mandatory when the auto label generation is OFF OR 'Manual Input' is set to 'Yes.'


Specimen BarcodeStringNoDepends

It should be unique within the system.

Manual input is not supported for this fieldDepending on the CP settings. If barcode is enabled auto label generation for aliquots is mandatory.

In case of manual input the barcode field is disabled.

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)
ContainerStringNo

It needs to be specified if the specimen is not virtually located

Note: If container has few empty spaces left and aliquots are more in number. Then, create two separate rows with each container name and number of aliquots to be stored.


  1. Container specified should exist.
  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


...