Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 79 Next »

Steps to Import CSV

 Expand...
  • Navigate to 'Containers'.

  • Click on the 'Import' button → Containers.

  • Click on 'Download Template File' to download the template file from the 'Import Containers' page.

  • Enter all valid data in the template file as mentioned in the 'Data Dictionary' table below.

  • Upload the filled template file in the 'Input Records File' field, select 'Import Type' as 'Create' or 'Update'.

  • Click on the 'Validate and Import' button.

  • Refer 'Import status' to check the status of the import job.

Sample CSV

Download

Data Dictionary

When updating a child container, make sure to include 'Storage Location#Parent Container Name' to avoid moving it outside its parent container.

Column Name

Datatype

Mandatory?

(Create)

Mandatory?

(Update)

Description

Permissible Values

Validations

Identifier

Integer

No

No

System generated unique identifier for each container. 

Mandatory only while updating container name.

Display Name

String

No

No

Name

String

Yes

Yes

It should be unique within the system.

Barcode

String

No

No

It should be unique within the system.

Used for

String

No

Type of service provided.

  • STORAGE

  • DISTRIBUTION

Type Name

String

No

No

On 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 Status

String

No

No

Closed → for Archived containers

Disabled → for containers to be deleted

  • Active

  • Closed

  • Disabled

The value should be 'Active' during creation or kept blank, in which case it will take the default value as 'Active'.

Site Name

String

Depends

No

The 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

Temperature

Integer

No

No

No. of Columns

Integer

Depends

No

Mandatory if it is not a dimensionless container

No. of Rows

Integer

Depends

No

Mandatory if it is not a dimensionless container

Position Labeling Mode

String

No

No

Specifies whether to use (row, column) coordinates or integers like 1, 2, 3, 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 Scheme

String

No

No

  • Numbers

  • Alphabets Upper Case

  • Alphabets Lower Case

  • Roman Upper Case

  • Roman Lower Case

Default Value: Numbers

Row Labeling Scheme

String

No

No

  • Numbers

  • Alphabets Upper Case

  • Alphabets Lower Case

  • Roman Upper Case

  • Roman Lower Case

Default Value: Numbers

Position Assignment

String

No

No

The 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#1

String

No

No

Restrict container by specimen class(es).

  • Fluid

  • Molecular

  • Tissue

  • Cell

Allowed Specimen Type#1

String

No

No

Restrict container by specimen type(s). The specimen added will only be allowed to be stored in the container. 

You can add more restrictions by adding new columns 'Allowed Specimen Type#2', 'Allowed Specimen Type#3' etc

Permissible Values File

Allowed Collection Protocol#1

String

No

No

Restrict container by collection protocol(s).

The container will only be available for storage only for the collection protocols added in the field.

One or more existing collection protocols associated with the site selected.

Allowed Distribution Protocol#1

String

No

No

Restrict container by distribution protocol(s).

One or more existing distribution protocols associated with the site selected.

Stores Specimen

Boolean

No

No

Will 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 Name

String

No

No

Please see the note, above the table

It should be specified if the created container is a child container. E.g., the rack is stored within a freezer.

Storage Location#Column

No

No

The 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#Row

Integer

No

No

The 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#Position

Integer

No

No

Linear position in its parent container

Create dimensionless storage containers

  1. Specify the name of the container and site name under which the dimensionless container has to be created in the template file

  2. Do not specify No. of columns, No. of rows, Labelling schemes, etc.

Sample CSV

Download

  • No labels