Versions Compared

Old Version 26

changes.mady.by.user Aditi Kavimandan

Saved on

compared with

New Version Current

changes.mady.by.user Ashish Vishwakarma

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 onlySpecimen Aliquot CSV is used to create unplanned specimens. 

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 Removed›fi
  1. Image Added

  2. Go to the

participants

  1. CP's participant list page

of the CP

  1. under which the aliquot specimens have to be created/updated, click on the 'More' button and select the option 'Biospecimen Data.'

Image Removed
  1. Image Added

  2. Select 'Specimen Aliquots' from the 'Select Record Type' dropdown and click on 'Download Template File' to download the template file

Image Removed
  1. Image Added

  2. Enter all valid data in the template file as mentioned in the below 'Data Dictionary' table

  3. Upload the filled template file in the 'Input Records File' field

  4. Click on the 'Validate and Import' button

  5. Refer 'Import status' to check the status of the import job

Sample CSV

Download

Data Dictionary

Column Name

Datatype

Mandatory?

(Create)

Description

Permissible Values

Validations

CP Short Title

String

Yes

Depends

The collection protocol is a short title under which specimens

have to

must be created.

This is mandatory only if specimen labels are not unique across collection protocols i.e. if 'Unique Specimen Label per CP' system setting is enabled.

Parent Specimen Label

String

Yes

The specimen label of the parent specimen under which the aliquot is to be created.

The specimen should exist within the system

Specimen

label

Labels

String

Depends

Depending on the system setting, it

The labels of each aliquot of the parent specimen. 

It should be unique within the system or CP, depending on the system setting.

Mandatory when the auto

When Auto-label generation is

OFF OR 'Manual Input' is set to 'Yes.'Specimen Barcode

off:

  • The Specimen Labels is mandatory

  • The number of Specimen Labels should match the number of aliquots you wish to create.

Specimen Barcodes

String

Depends

The barcodes of each aliquot of the parent specimen.

It should be unique within the system.

Depending on the CP settings. If the barcode is enabled, auto-label generation for aliquots is mandatory.

In the case of manual input, the barcode field is disabled.

Quantity per Aliquot

Double

Yes, if the parent quantity is not specified or the number of aliquots is not specified.

Quantity of the sample in each aliquot.

Note

Required even if “Mandatory Aliquot Quantity” is already disabled in the system settings.

If not specified, it divides the entire parent specimen available quantity into equal amounts

amongst

among all the aliquots

Info

The value for this cannot be set to 0.

Number of Aliquots

Integer

Yes, if parent quantity is not specified or quantity per aliquot is not specified.

The number of aliquots to be created.

When left blank, the number of aliquots=(parent quantity/quantity per

aliquots)

aliquot)

If the manual input is set to yes for specimen labels, then this field is disabled. The number of rows with data equals the number of aliquots generated.

Container

String

No

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

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

Container

  1. The 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 Row

String or Integer

No

Datatype 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 Column

String or Integer

No

Datatype depending on the column labeling scheme (Numbers, Alphabets Upper Case, Alphabet Lower Case, Roman Upper Case, Roman Lower Case)

Start Position

Number

No

The single number or

linear position labels

linear position labels to identify slots within the container for storing specimen

Created On

Date

No

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

Freeze/Thaw Cycles

Number

No

Freeze/Thaw Cycle of the aliquot

Increment Parent Freeze/Thaw Cycles

Number

No

Number by which parent freeze/thaw cycle is to be incremented

Close Parent

String

No

Options - Yes/No or true/false

Parent specimen should be in collected- collection status

Specimen Additional Fields#Media Volume

Number

No

Custom Field

Specimen Additional Fields#Cell Viability (%)

Number

No

Custom Field