Create/Edit Event

Expand...

Go to the collection protocols list page, click on the 'Import' button, and select option 'Biospecimen Data' OR
Go to the participants list page of the CP, click on the 'More' button, and select the option 'Biospecimen Data.'
Select 'Frozen Event' from the '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 the 'Input Records File' field, select 'Import Type' as 'Create' to create or 'Update' to update specimen frozen event
Click on the '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		It is 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 the query results view.
CP Short Title	String	Yes	Yes	It is required when a 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		The 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 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.'
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 is 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