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

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