Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

User can create/Update frozen event of any specimens in bulk through bulk operation, follow below steps to create/update frozen event in bulk:

Table of Contents

Create/Edit Event

Expand
titleExpand...
  1. Go to the collection protocols list page, click on the 'Import' button, and select option 'Biospecimen Data' OR

...

  1. Image Added
  2. Go to the participants list page of the CP, click on the 'More' button, and select the optionĀ 'Biospecimen Data.'

...

  1. Image Added
  2. Select 'Frozen Event' from the 'Select Record Type' specimen's dropdown and click on 'Download Template File' to download the template file.

...

  1. Image Added
  2. Enter all valid data in the template file as mentioned in the below 'Data Dictionary' table
  3. Upload the filled template file in the 'Input Records File' field, select 'Import Type' as 'Create' to create or 'Update' to update

...

  1. specimen frozen event
  2. Click on the 'Validate and Import' button
  3. Refer 'Import status' to check the status of import job

Sample CSV

...

Download

Data Dictionary

Column Name

Datatype
Mandatory?
(Create)
Mandatory?
(Update)
Description
Permissible Values
Validations
Record IDIntegerNoYesUsed to update an existing form record in the system

Required 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 TitleStringYesYesRequired It is required when a unique label per CP setting is enabled.

Specimen LabelStringYesYesSpecimen label of the specimen for which the frozen event is to be added
Specimen The specimen should be existing within the system
BarcodeStringNoNo


Activity StatusStringNoNo

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
Value The value should be 'Active' during creation or kept blank, in which case it will take the default value as 'Active.'
MethodStringYesNoMethod The method used to freeze the sample

Permissible values


UserStringYesNoEmail address of the user who froze the samples

Date and TimeDate and TimeYesNo

Select the correct date and time format from UI based on the data in the file


CommentsStringNoNo


Increment Freeze/Thaw CyclesIntegerNoNoField 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

...