Table of Contents

Expand

title	Expand...

Go to the collection protocols list page, click on the 'Import' button, and select option 'Biospecimen Data' OR
Image RemovedImage Added
Go to the participants list page of the CP, click on the 'More' button, and select the option 'Biospecimen Data.'
Image RemovedImage Added
Select 'Molecular Review Event' from the 'Select Record Type' specimen's dropdown and click on 'Download Template File' to download the template file.
Image RemovedImage Added
Enter all valid data in the template file as mentioned in the below 'Data Dictionary' table below.
Upload 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 the import job.

Sample CSV

Data Dictionary

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
CP Short Title	String	Yes	Yes	Required It is required when a unique label per CP setting is enabled.
Specimen Label	String	Yes	Yes			Specimen The specimen should be existing exist 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 it as an update.	Active Disabled	The value should be 'Active' during creation or kept blank, in which case it will take the default value as 'Active.'
Gel Image URL	String	No	No
Quality Index	String	No	No
Gel Number	Integer	No	No
Lane Number	Integer	No	No
Absorbance At 260	Double	No	No
Absorbance At 280	Double	No	No
Ratio 28S To 18S	Double	No	No
User	Email Adress	Yes	No			The user should be existing within the system
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