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

Steps to import CSV

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

...

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

...

  1. Image Added
  2. Select 'Frozen Event' from '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 table
  3. Upload the filled template file in 'Input Records File' field, select 'Import Type' as 'Create' to create or 'Update' to update

...

  1. specimen frozen event
  2. Click on '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 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 query results view.

CP Short TitleStringYesYesRequired when unique label per CP setting is enabled.

Specimen LabelStringYesYesSpecimen label of the specimen for which the frozen event is to be added
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 as an update

  • Active
/
  • Disabled
Value The value should be 'Active' during creation or kept blank in which case it will take 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 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

...