Steps to import CSV

Expand...

Go to the collection protocols list page, click on 'Import' button and select option 'Biospecimen Data' OR
Go to participants list page of the CP, click on 'More' button and select option 'Biospecimen Data'
Select 'Frozen 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
Upload the filled template file in 'Input Records File' field, select 'Import Type' as 'Create' to create or 'Update' to update specimen frozen event
Click on 'Validate and Import' button
Refer 'Import status' to check the status of import job

Sample CSV

Column Name	Datatype	Mandatory? (Create)	Mandatory? (Update)	Description	Permissible Values	Validations
Record ID	Integer	No	Yes	Used to update an existing form record in the system		Required only when updating. Record ID is system generated ID for every form record. To retrieve record ID, create a query to retrieve form records and include the form ID for the frozen event form in the columns of query results view.
CP Short Title	String	Yes	Yes	Required when unique label per CP setting is enabled.
Specimen Label	String	Yes	Yes	Specimen label of the specimen for which the frozen event is to be added		Specimen should be existing within the system
Barcode	String	No	No
Activity Status	String	No	No	Activity status of the record. To remove the existing records for the form add 'Disabled' along with the record ID of the form and import as an update	Active Disabled	The value should be 'Active' during creation or kept blank in which case it will take default value as 'Active'
Method	String	Yes	No	The method used to freeze the sample	Permissible values
User	String	Yes	No	Email address of the user who froze the samples
Date and Time	Date and Time	Yes	No			Select the correct date and time format from UI based on the data in the file
Comments	String	No	No
Increment Freeze/Thaw Cycles	Integer	No	No	The field used to increment the freeze-thaw cycle of the specimen. 0 - no increment, 1 - increment the freeze-thaw cycle (Freeze thaw of parent +1)		Default value 0