Steps to import CSV

Expand...

Go to participants list page of the collection protocol whose specimens custom form values has to be added/updated
Click on 'More' button and select option 'Biospecimen Data'
Select desired form, E.g. 'New Diagnosis Health Annotation' 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 add or 'Update' to update values of the custom forms or 'Update Else Create' to either create or update record. For the 'Update Else create' feature please refer to Create & Update in Single Bulk Operation.
Click on 'Validate and Import' button
Refer 'Import status' to check the status of import job

Example Form

Column Name	Datatype	Mandatory? (Create)	Mandatory? (Update)	Description	Permissible Values	Validations
Record ID	Integer	No	No	Should be specified while updating a record		Support to get this ID from a query is yet to be implemented. Right now, this ID can be retrieved from events/forms tab in UI. For multiple records update the record id required
CP Short Title	String	Yes	Yes			Should Be existing within the system
Specimen Label	String	Yes	Yes			Specimen should be existing within the system
Name Of Procedure	String	No	No		Permissible Values File	Valid value from the list
Date Of Examination	Date	No	No			Select the correct date format from UI based on the data in the file
Other Procedure	String	No	No