Versions Compared

Key

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

You can create/Update molecular review 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 'Molecular Review 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 'Data Dictionary' table
  3. Upload the filled template file in 'Input Records File' field, select 'Import Type' as 'Create' to create or 'Update' to update

...

  1. specimens molecular review 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)

DescriptionPermissible ValuesValidations
Record IDIntegerNoYesUsed to update an existing form record in the system
Required only when updating
CP Short TitleStringYesYesRequired when unique label per CP setting is enabled.

Specimen LabelStringYesYes

Specimen should be existing within the system
BarcodeStringNoNo


Activity StatusStringNoNoActivity 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'
Gel Image URLStringNoNo


Quality IndexStringNoNo


Gel NumberIntegerNoNo


Lane NumberIntegerNoNo


Absorbance At 260DoubleNoNo


Absorbance At 280DoubleNoNo


Ratio 28S To 18SDoubleNoNo


UserEmail AdressYesNo

User The user should be existing within the system
Date and TimeDate and TimeYesNo

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


CommentsStringNoNo