Steps to import CSV

Expand...

Go to the participants list page of the collection protocol whose specimens custom form values have to be added/updated.
Click on the 'More' button and select the option 'Biospecimen Data.'
Select desired form, E.g. 'Specimen Additional Rule' from 'Select Record Type' specimen's dropdown, 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 the '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 the '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 the 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			The 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