Got feedback or spotted a mistake?

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

Distribution orders CSV

Pre-requisites

  1. The specimens to be distributed should be in collected status.
  2. A distribution Protocol should be created.

Steps to import CSV

 Expand...
  1. Go to the orders' list page
  2. Click on 'Import' button and select option 'Orders' 
  3. Select the desired distribution protocol from the 'Distribution Protocols' dropdown and 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 orders
  6. Click on 'Validate and Import' button
  7. Refer 'Import status' to check the status of import job

Sample CSV

Download

Data Dictionary

Column NameDatatype

Mandatory

(Create)?

Mandatory

(Update)?

DescriptionPermissible ValuesValidations
IdentifierNumberNoYesUnique identifier generated by system per order

NameStringYesYesThe Name of the order under which the specimens have to be distributed
The name should be unique across the system
Receiving SiteStringYesYesName of the site where the specimens are distributed

Execution DateDateNoNoDate on which the specimens are distributed

Select the correct date format from UI based on the data in the file


Tracking URLStringNoNoURL to track the order status

CommentsStringNoNo


Order StatusStringYesYesStatus of the created order whether it is already executed or still pending
  • EXECUTED
  • PENDING
Should be valid value from the list
Distribution protocol #Short TitleStringYesYesName of the Distribution Protocol (short title) under which the specimens are distributed

Requestor #Email AddressStringYesYesThe user's (requestor) email address to whom the order is sent

Distributor #Email AddressStringNoYesDistributor's email address, who is executing the order
In v3.4 if left blank system will add a user who created distribution order as a distributor
Order item #QuantityDoubleYesYes

The amount of the specimen being distributed


Mention only the value not the unit. 

For eg. If quantity is 2 ml mention only 2.

Order item #StatusStringYesYesStatus of the specimens being distributed. It is 'DISTRIBUTED' if some amount of the specimen is given and is ' DISTRIBUTED AND CLOSED' if all of the specimens are given away
  • DISTRIBUTED
  • DISTRIBUTED_AND_CLOSED
Should be a valid value from the list
Order item#Specimen#CP Short TitleStringYesNoName of the Collection Protocol (short title) of the specimens to be distributed

Order item#Specimen#LabelStringYesYesThe label of the specimens to be distributed

Order item#Specimen#BarcodeStringNoNoBarcode of the specimens to be distributed


Order item#Holding Location#ContainerStringNoNoTemporary location where the specimen will be transferred to and stored until the researcher picks it up (retrieves) for his use.

Order item#Holding Location#RowStringNoNo

Order item#Holding Location#PositionStringNoNo

Got feedback or spotted a mistake?

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