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 participants list page of the CP under which the derived specimens have to be created/updated, click on the 'More' button, and select the option 'Biospecimen Data'.

Select 'Specimen Derivatives' 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 'Data Dictionary' table below.
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?	Description	Permissible Values	Validations
CP Short Title	String	Yes	The collection 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 users can set in Admin settings. By default, labels are unique across the system.
Parent Specimen Label	String	Yes			Should label of a collected parent within the system
Specimen Label	String	Depends			Mandatory when the auto label generation is OFF or 'Manual Inputs Allowed For' is selected.
Barcode	String	No
Class	String	No		Tissue Molecular Cell Fluid	If left blank system will add class based on specimen type in the input.
Type	String	Yes		Permissible Values File	Field not applicable to the aliquot as aliquot type would always be same as that of parent
Collection Status	String	No		Collected Pending Missed Collection
Pathological Status		No		Non-Malignant Non-Malignant, Diseased Pre-Malignant Malignant, Pre-Invasive Malignant, Invasive Malignant Metastatic Not Specified
Initial Quantity	Double	No			Default Value: Not Specified
Available Quantity	Double	No
Concentration	Double	No	This field applies only to molecular specimens
Biohazard#1	String	No	Multiple values can be specified as: Biohazard#1, Biohazard#2, Biohazard#3 and so on	Hepatitis A Hepatitis B Hepatitis C HIV Tuberculosis	Valid value from the list
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 derivative
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
Comments	String	No
Location#Container	String	No	It needs to be specified if the specimen is not virtually located.		The container specified should be existing. Suitable to hold the specimen (based on type and protocol) Should have available positions.
Location#Row	String	No			Position within the container at which the specimen is to be stored. If left blank, the system will allocate the next available position.
Location#Column	String	No
Location#Position	Number	No	The single number or linear position labels to identify slots within the container for storing specimen

OpenSpecimen

Specimen Derivative CSV

Steps to Import CSV

Sample CSV

Data Dictionary