Versions Compared

Key

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

Table of Contents

Steps to Import CSV

Expand
titleExpand...
Go
  • Navigate to
the containers
  • 'Containers'
list page
  • .
  • Click on the 'Import' button
from the containers list page and select the 'Containers' option
  • → Containers.
Image Removed

Image Added

  • Click on 'Download Template File' to download the template file from the 'Import Containers' page.
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, select 'Import Type' as 'Create'
to create
  • or 'Update'
to update containers
  • .
  • Click on the 'Validate and Import' button.
  • Refer 'Import status' to check the status of the import job.

Sample CSV

Download

Data Dictionary

Column Name

Datatype

Mandatory?

(Create)

Mandatory?

(Update)

DescriptionPermissible ValuesValidations
IdentifierIntegerNoDependsNoSystem generated unique identifier for each container. 
Mandatory only while updating container name.
NameStringYesYes

It should be unique within the system.
BarcodeStringNoNo

It should be unique within the system.
Used forStringNo
Type of service provided.
  • STORAGE

  • DISTRIBUTION

Type NameStringNoNoOn providing the storage type name, properties like dimension and labeling scheme are fetched from the type if not provided in the file.
It should be an existing storage container type.
Activity StatusStringNoNo
  • Active
  • Disabled
The value should be 'Active' during creation or kept blank, in which case it will take the default value as 'Active'.
Site NameStringDependsNoThe site where the storage container should be stored
  1. Mandatory only for parent containers. Not needed if the parent container is specified.
  2. Mandatory if moving container from parent to another parent or site
TemperatureIntegerNoNo


No. of ColumnsIntegerDependsNo

Mandatory if it is not a dimensionless container
No. of RowsIntegerDependsNo

Mandatory if it is not a dimensionless container
Position Labeling ModeStringNoNoSpecifies whether to use (row, column) coordinates or integers like 1, 2, 3, etc etc. to identify positions within the container. When not specified, (row, column) coordinates labeling mode is used by default.
  • LINEAR/Linear,
  • TWO_D/two_d/Two_D

Column Labeling SchemeStringNoNo
  • Numbers
  • Alphabets Upper Case
  • Alphabets Lower Case
  • Roman Upper Case
  • Roman Lower Case

Default Value: Numbers

Row Labeling SchemeStringNoNo
  • Numbers
  • Alphabets Upper Case
  • Alphabets Lower Case
  • Roman Upper Case
  • Roman Lower Case
Default Value: Numbers
Position AssignmentStringNoNoThe position assignments of the containers.
  • HZ_TOP_DOWN_LEFT_RIGHT
  • HZ_TOP_DOWN_RIGHT_LEFT
  • HZ_BOTTOM_UP_LEFT_RIGHT
  • HZ_BOTTOM_UP_RIGHT_LEFT
  • VT_TOP_DOWN_LEFT_RIGHT
  • VT_TOP_DOWN_RIGHT_LEFT
  • VT_BOTTOM_UP_LEFT_RIGHT
  • VT_BOTTOM_UP_RIGHT_LEFT
Default Value: Horizontal, top-down, left to right
Allowed Specimen Class#1StringNoNoRestrict container by specimen class(es).
  • Fluid
  • Molecular
  • Tissue
  • Cell

Allowed Specimen Type#1StringNoNoRestrict container by specimen type(s). Users You can add more restrictions by adding new columns 'Allowed Specimen Type#2', 'Allowed Specimen Type#3' etcPermissible Values File
Allowed Collection Protocol#1StringNoNoRestrict container by collection protocol(s).
One or more existing collection protocols associated with the site selected.
Stores SpecimenBooleanNoNoWill this container directly store specimens within? E.g., a "freezer" or a rack does not store specimens, whereas a box stores specimens.
  • true
  • false

Storage Location#Parent Container NameStringNoNoIt should be specified if the created container is a child container. E.g., the rack is stored within a freezer.

Storage Location#ColumnIntegerNoNoThe position of this container in its parent container. E.g. a rack stored in a freezer at (1,1) or (1,a) etc.

Storage Location#RowIntegerNoNoThe position of this container in its parent container. E.g. a rack stored in a freezer at (1,1) or (1,a) etc.

Storage Location#PositionIntegerNoNoLinear position in its parent container

...