Introduction

Specimen Aliquot CSV is used to create unplanned specimens.

Steps to import CSV

Expand...

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

Sample CSV

Data Dictionary

Column Name	Datatype	Mandatory? (Create)	Description	Validations
CP Short Title	String	Depends	The collection protocol is a short title under which specimens 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	String	Depends	The label of the specimen.	It should be unique within the system or CP, depending on the system setting. Mandatory when the auto label generation is OFF OR 'Manual Input' is set to 'Yes.'
Specimen Barcode	String	Depends		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.		If not specified, it divides the entire parent specimen available quantity into equal amounts amongst all the aliquots
Number of Aliquots	Integer	Yes, if parent quantity is not specified or quantity per aliquot is not specified.A number	r of aliquots to be created.	When left blank, the number of aliquots=(parent quantity/quantity per 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.	The container specified should exist. Suitable to hold the specimen (based on type and protocol) Should have available positions. 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 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

OpenSpecimen

Specimen Aliquots CSV

Introduction

Steps to import CSV

Sample CSV

Data Dictionary