13.8 Instrument Results Import

If configured, Bika LIMS imports results files automatically from instruments' results destination folder. Here we dis cuss how to do it manually

Disclaimer

Table of Contents...

Import

Instrument results in spreadsheets are imported into Bika | Senaite and the interface easily coded for any instrument capable of delivering results in this way

Interfacing Instruments vastly improve turn around times and accuracy through the elimination of human transcription errors

Sample IDs and Analysis Keywords in the import file are matched to those of the Analysis Requests in the system. The keywords are configured per Analysis Service in the Bika Setup

To import a results file from an instrument, analysts save the results file to a network destination from where Bika imports it automatically, or may do do manually

Manual Instrument imports

The user clicks on the Import tab, selects Instrument Import, the Instrument and browses to the results file to be uploaded

Select Instrument import file in Bika Open Source LIMS

Video
Instrument Interfacing

Only instruments for which import templates are available and configured in the LIMS will be listed.

The LIMS interprets the results file line by line, matching keywords and Sample IDs to upload the data correctly. Results verified earlier won't be overwritten

Keyword Configuration

Since Analysis Keywords cannot contain special characters, most Bika instrument interfaces will strip out these in the keywords obtained from the results files, as in the column headers of the sheets

The ASs in the LIMS must be configured accordingly, e.g. a column with header Nitrate as -NO3 should have a keyword of NitrateasNO3

Instrument Import log

When Importing Instrument results files, the LIMS provides a traceback of the imports success or failure

Import log

In this example, a file Cannabinoids(2).csv, was imported and it contained only one Sample, Flr20-0006

1 Cannabinoid Sample including Calculations

The traceback reports as such:

Parsing file 2D CSV Cannabis - Cannabinoids(2).csv
End of file reached successfully: 1 objects, 11 analyses, 11 results

Only Received Samples were considered, but all Analyses in Unassigned, Assigned and To_be_verified states, meaning that previously captured results will be over written

Allowed Sample states: sample_received
Allowed analysis states: unassigned, assigned, to_be_verified

It reports any calculations performed:

Flr20-0006: calculated result for 'TotalCBD': '410.34'
Flr20-0006: calculated result for 'TtlCannabnd': '1638.28'
Flr20-0006: calculated result for 'TotalTHC': '689.69'

The Sample Analyses imported:

Flr20-0006: ['Analysis CBC', 'Analysis CBD', 'Analysis CBDA', 'Analysis CBDV', 'Analysis CBG', 'Analysis CBGA', 'Analysis CBN', 'Analysis D8THC', 'Analysis D9THC', 'Analysis THCA', 'Analysis THCV'] imported sucessfully
Import finished successfully: 1 Samples, 0 Instruments and 11 results updated

Warnings

In this case only that, since the Analyses were not on a Worksheet, the raw import file could not be attached:

Attachment cannot be linked to analysis as it is not assigned to a worksheet ()

Attachment cannot be linked to analysis as it is not assigned to a worksheet

Import manually captured results form spreadsheet

Please submit specifications and examples of formats you would like to see incorporated to our analysts at info@bikalabs.com

Currently available Interfaces

13.8 Instrument Results Import

Disclaimer

Table of Contents...

Import

Manual Instrument imports

Keyword Configuration

Instrument Import log

Import log

Warnings

Ingozi