Specimens Shipment CSV
Got feedback or spotted a mistake?

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

Specimens Shipment CSV

You can create specimens shipment 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 'Specimen Shipments' from shipments list page

  3. Click on 'Download Template File' 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 specimens shipment

  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

Depends

System auto-generated unique number for every shipment

 

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

Name

String

Yes

Depends

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

 

  • Pending

  • 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

Default Value: Pending

Shipment Item#Specimen#CP Short Title

String

Yes

No

The short title of the CP whose specimens has to be shipped

 

 

Shipment Item#Specimen#Specimen Label

String

Yes

Yes

The label of the specimens to be shipped

 

 

Shipment Item#Specimen#Barcode

String

No

No

The barcode of the specimens to be shipped

 

 

Shipment Item#Specimen#Location#Container

String

No

No

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

 

 

Shipment Item#Specimen#Location#Row

String

No

No

Row position of the storage container

 

 

Shipment Item#Specimen#Location#Column

String

No

No

Column position of the storage container

 

 

Got feedback or spotted a mistake?

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