Instrument Results Import

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

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
Instrument Interfacing video

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

The traceback reports as such:

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

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

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

• 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

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
It reports any calculations performed:
The Sample Analyses imported:

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 ()

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