Table of Contents

Steps to import CSV

Expand

Go to the collection protocols list page, click on the 'Import' button, and select the option 'Biospecimen Data'

Go to the participants' list page of the CP, click on the 'More' button, and select the option 'Biospecimen Data'

Select 'Specimen Disposal' to create disposal event or "Disposal Event" to update existing disposal event from 'Select Record Type' specimen's 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' tableUpload the filled template file in the 'Input Records File' field, select 'Import Type' as 'Create' to create or 'Update' to update specimens molecular review event
Click on the 'Validate and Import' button
Refer 'Import status' to check the status of import job

...

Data Dictionary

Column Name	Datatype	Mandatory? (Create)	Description	Permissible Values	Validations
CP Short Title	String	Yes	Collection protocol code/short title.
Specimen Label	String	Yes	Specimen label of the specimen for which the disposal event is to be added.		The specimen should exist within the system
Barcode	String	No			Should be unique within the system
Activity Status	String	Yes	Activity status of the specimen.	Closed Disabled
Disposal date	Date and Time	No			Select the correct format for the date, similar to the one in UI.
Disposal reason	String	No	Specify the reason for the disposal of the specimen		The minimum character added to the field should at least be 10.
User email	String	No	The email address of the user

...