FastFinder Orders CSV
Importing orders into FastFinder via CSV
Lab management 1.5
Purpose of this document
This document describes the default FastFinder Lab management orders CSV import available to use orders from external systems in FastFinder.
In this document, we will cover the specification of the FastFinder Orders CSV import. In addition, several examples will be provided.
Orders import specification
On uploading of an orders CSV file, FastFinder retrieves the information of the individual orders from the file and makes the orders available to be used in FastFinder to drive the assays executed on samples that are processed.
The file starts with a header specifying the type and format version of the orders CSV file.
|
FastFinder Orders Version,1.0 Date,20210311110813 (empty line) |
Furthermore, the orders CSV file includes an entry for each combination of Sample, Sample type, Test code & Order.
|
Header name |
Description |
|
SampleID* |
Barcode of the sample tube |
|
PrimarySampleType* |
Type of the sample. This must be one of the following values:
|
|
TestCode* |
Code that represents the test that is ordered for the sample. Based on this code FastFinder determines which assays must be executed on the sample. |
|
OrderID |
Identifier of the order which is used to group multiple tests or samples. If this parameter is empty FastFinder generates a unique order ID for each combination of Sample, Sample type and Test code. |
* required fields
Examples
One sample per order
Example of an orders file in which each sample has a unique order.
|
1 |
FastFinder Orders Version,1.0 Date,20210311110813 SampleID,PrimarySampleType,TestCode,OrderID Sample1,Urine,CMV,Order1 Sample2,Urine,CMV,Order2 Sample3,Urine,CMV,Order3 Sample4,Urine,CMV,Order4 Sample5,Urine,CMV,Order5 Sample6,Urine,CMV,Order6 Sample7,Urine,CMV,Order7 Sample8,Urine,CMV,Order8 |
Download the example CSV here.
One order with multiple tests
Example of an orders file in which one order contains multiple test codes.
|
1 |
FastFinder Orders Version,1.0 Date,20210311110813 SampleID,PrimarySampleType,TestCode,OrderID Sample1,Plasma,CMV,Order1 Sample1,Plasma,EBV,Order1 Sample1,Plasma,BKV,Order1 Sample2,SwabInPBS,SARSCOV2,Order2 Sample2,SwabInPBS,FLU,Order2 Sample2,SwabInPBS,RSV,Order2 |
Download the example CSV here.
Not using order ID
Example of an orders file in which order ID is empty.
|
1 |
FastFinder Orders Version,1.0 Date,20210311110813 SampleID,PrimarySampleType,TestCode,OrderID Sample1,Urine,CMV, Sample2,Urine,CMV, Sample3,Urine,CMV, Sample4,Urine,CMV, Sample5,Urine,CMV, Sample6,Urine,CMV, Sample7,Urine,CMV, Sample8,Urine,CMV, |
Download the example CSV here.
Comments
0 comments
Article is closed for comments.