Steps to import CSV
- Go to the containers' list page
- Click on 'Import' button from containers list page and select option 'Containers'
- Click on 'Download Template File' to download the template file from 'Import Containers' page
- Enter all valid data in the template file as mentioned in the below 'Data Dictionary' table
- Upload the filled template file in 'Input Records File' field, select 'Import Type' as 'Create' to create or 'Update' to update containers
- Click on 'Validate and Import' button
- Refer 'Import status' to check the status of import job
Sample CSV
Data Dictionary
Column Name | Datatype | Mandatory? (Create) | Mandatory? (Update) | Description | Permissible Values | Validations |
|---|---|---|---|---|---|---|
| Identifier | Integer | No | Depends | System generated unique identifier for each container. Can be used to update the container name. | ||
| Name | String | Yes | Yes | Should be unique within the system | ||
| Barcode | String | No | No | Should be unique within the system | ||
| Used for | String | No | Type of service provided. |
| ||
| 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. | Should be an existing storage container type | |
| Activity Status | String | No | No |
| The value should be 'Active' during creation or kept blank in which case it will take default value as 'Active' | |
| Site Name | String | Depends | No | The site where the storage container should be stored | Mandatory only for parent containers. Not needed if the parent container is specified. | |
| 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. By default, when not specified, (row, column) coordinates labeling mode is used. |
| |
| Column Labeling Scheme | String | No | No |
| Default Value: Numbers | |
| Row Labeling Scheme | String | No | No |
| Default Value: Numbers | |
| Position Assignment | String | No | No | The position assignments of the containers. |
| Default Value: Horizontal, top down, left to right |
| Allowed Specimen Class#1 | String | No | No | Restrict container by specimen class(es). |
| |
| Allowed Specimen Type#1 | String | No | No | Restrict container by specimen type(s). User 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). | One or more existing collection protocols associated with the site selected | |
| Stores Specimen | Boolean | No | No | Will this container directly store specimens within in? E.g. a "freezer" or a rack does not store specimens, whereas a box stores specimens. |
| |
| Storage Location#Parent Container Name | String | No | No | Should be specified if the created container is a child container. E.g, rack is stored within a freezer. | ||
| Storage Location#Column | 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#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
- Specify the name of the container and site name under which the dimensionless container has to be created in the template file
- Do not specify No. of columns, No. of rows, Labelling schemes etc.