Versions Compared

Old Version 31

changes.mady.by.user Nidhi Harmukh

Saved on

compared with

New Version Current

changes.mady.by.user Ankita Chavan

Saved on

Key

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

Table of Contents

Steps to Import CSV

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

Image Added

  • Go to the participants list page of the CP under which the derived specimens have to be created/updated, click on the 'More' button, and select the option 'Biospecimen Data'.
Image Removed

Image Added

  • Select 'Specimen Derivatives' from the 'Select Record Type' dropdown and click on 'Download Template File' to download the template file.
Image Removed

Image 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.
  • Click on the 'Validate and Import' button.
  • Refer 'Import status' to check the status of the import job.

Sample CSV

Download

Data Dictionary

v4.2v3.4
Added in

Column Name

Datatype

Mandatory?


DescriptionPermissible ValuesValidations
v3.3

CP Short Title

StringYesThe collection protocol short title under which specimen is collected

This is mandatory only if specimen labels are not unique across collection protocols. This is a setting

user

users can set in Admin settings. By default, labels are unique across the system.

Parent Specimen LabelStringYes

Should label of a collected parent within the system
Specimen LabelStringDepends

Needs to be specified Mandatory when the auto label generation is OFF or 'Manual Inputs Allowed For' is selected.
BarcodeStringNo


ClassStringNo
  • Tissue
  • Molecular
  • Cell
  • Fluid
In v3.4, if If left blank system will add class based on specimen type in the input.
TypeStringYes
Permissible Values File
Collection StatusStringNo
  • Collected
  • Pending
  • Missed Collection

Pathological Status


No
  • Non-Malignant
  • Non-Malignant, Diseased
  • Pre-Malignant
    Malignant,
  • Pre-Invasive
  • Malignant, Invasive
  • Malignant
  • Metastatic
  • Not Specified

Initial QuantityDoubleNo

Default Value: Not Specified
Available QuantityDoubleNo


ConcentrationDoubleNoThis field applies only to molecular specimens

Biohazard#1StringNo

Multiple values can be specified as:

Biohazard#1,

Biohazard#2,

Biohazard#3 and so on

  • Hepatitis A
  • Hepatitis B
  • Hepatitis C
  • HIV
  • Tuberculosis
Valid value from the list
Created OnDateNo

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


Freeze/Thaw Cycles

NumberNoFreeze/Thaw Cycle of the derivative

Increment Parent Freeze/Thaw Cycles

NumberNoNumber by which parent freeze/thaw cycle is to be incremented

Close ParentStringNooptions- Yes/No or true/false
Parent specimen should be in collected -collection statusv5.0
CommentsStringNo


Location#ContainerStringNoNeeds It needs to be specified if the specimen is not virtually located.
  1. Container The container specified should be existing.
  2. Suitable to hold the specimen (based on type and protocol)
  3. Should have available positions.
Location#RowStringNo

Position within the container at which the specimen is to be stored. If left blank, the system will allocate the next available position.

Location#ColumnStringNo

Location#Position

NumberNoThe single number or linear position labels to identify slots within the container for storing specimen

...