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' table
Click on the 'Validate and Import' button.
Refer 'Import status' to check the status of import job.

Sample CSV

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

...

...

Column name	Datatype	Mandatory? (Update)	Description	Permissible Values	Validations
Event ID	String	Yes	Unique ID of the event.	-	Select the correct event ID.
Date and Time	Date and Time	No		-	Select the correct format for the date, similar to the one in UI.
Reason	String	No		-	The minimum character added to the field should at least be 10.
Comments	String	No		-
User#Email Address	String	No	The email address of the user	-