Specimens Shipment CSV

You can create specimens shipment in bulk through a bulk operation.

Steps to import CSV

 Expand...
  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

Download

Data Dictionary

Column Name

Datatype

Mandatory?

(Create)

Mandatory?

(Update)

DescriptionPermissible ValuesValidations

Identifier

NumberNoDepends

System auto-generated unique number for every shipment


Can be left blank during add, this is used only during edit 
NameStringYesDependsName of the shipment

Courier NameStringNoNoCourier name of the shipment

Tracking NumberStringNoNoTracking number of the shipment

Tracking URLStringNoNoTracking URL of the shipment

Sending SiteStringYesYesThe sending site of the shipment
Should exist within OS
Receiving SiteStringYesYes

The receiving site of the shipment


Should exist within OS
Shipped DateDate & TimeNoNoThe date on which the container is shipped from sending site

Sender CommentsStringNoNo


Received DateDate & TimeNoNoThe date on which the container is received at receiving site

Receiver CommentsStringNoNo


StatusStringNoNo
  • Pending
  • Shipped
  • Received

Sender#Email AddressEmail AddressNoNoEmail address of the sender
Should exist within OS
Receiver Name#Email AddressEmail AddressNoNoEmail address of the receiver
Should exist within OS
Shipment Item#QualityStringNoNo
  • Acceptable
  • Unacceptable
Default Value: Pending
Shipment Item#Specimen#CP Short TitleStringYesNoThe short title of the CP whose specimens has to be shipped

Shipment Item#Specimen#Specimen LabelStringYesYesThe label of the specimens to be shipped

Shipment Item#Specimen#BarcodeStringNoNoThe barcode of the specimens to be shipped

Shipment Item#Specimen#Location#ContainerStringNoNoThe name of the container in which the received specimen is to be store

Shipment Item#Specimen#Location#RowStringNoNoRow position of the storage container

Shipment Item#Specimen#Location#ColumnStringNoNoColumn position of the storage container