Container Shipments CSV
Got feedback or spotted a mistake?

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

Container Shipments CSV

You can create shipment of containers holding specimens in bulk through a bulk operation.

Steps to import CSV

  1. Go to home page and click on 'Shipments' card

  2. Click on 'Import' button and select option 'Container Shipments' from shipments list page

  3. Click on 'Download Template File' link to download the template file

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

  5. Upload the filled template file in 'Input Records File' field, select 'Import Type' as 'Create' to create or 'Update' to update container shipments

  6. Click on 'Validate and Import' button

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

Sample CSV

Download

Data Dictionary

Column Name

Datatype

Mandatory?

(Create)

Mandatory?

(Update)

Description

Permissible Values

Validations

Column Name

Datatype

Mandatory?

(Create)

Mandatory?

(Update)

Description

Permissible Values

Validations

Identifier

Number

No

Yes

System auto-generated unique number for every shipment



Can be left blank during add, this is used only during edit 

Name

String

Yes

Yes

Name of the shipment





Courier Name

String

No

No

Courier name of the shipment





Tracking Number

String

No

No

Tracking number of the shipment





Tracking URL

String

No

No

Tracking URL of the shipment





Sending Site

String

Yes

Yes

The sending site of the shipment



Should exist within OS

Receiving Site

String

Yes

Yes

The receiving site of the shipment



Should exist within OS

Shipped Date

Date & Time

No

No

The date on which the container is shipped from sending site





Sender Comments

String

No

No







Received Date

Date & Time

No

No

The date on which the container is received at receiving site





Receiver Comments

String

No

No







Status

String

No

No



  • Shipped

  • Received



Sender#Email Address

Email Address

No

No

Email address of the sender



Should exist within OS

Receiver Name#Email Address

Email Address

No

No

Email address of the receiver



Should exist within OS

Shipment Item#Quality

String

No

No



  • Acceptable

  • Unacceptable



Shipment Item#Container#Name

String

Yes

Yes

The name of the container to be shipped





Shipment Item#Container#Storage Location#Name

String

No

No

The name of the container in which the received container is to be store



  1. Container specified should be existing

  2. Suitable to hold the container

  3. Should have available positions.

If left blank, the system will store the received container in the virtual container of that site.

Shipment Item#Container#Storage Location#Row

String

No

No

Row position of the storage container





Shipment Item#Container#Storage Location#Column

String

No

No

Column position of the storage container





Shipment Item#Container#Storage Location#Position

String

No

NO

Linear position in its parent container





Got feedback or spotted a mistake?

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