Uploading results and COAs to Metrc

Uploading results and COAs to Metrc

Batches and their Samples have a new state, Exported, and attribute Date Exported. Like with their other states Batches can be listed as Exported or not

Date Exported is available as a sortable column on Batch lists

There is a new Export function for Batches. The user selects the Batches to export and presses [Export]

When a Sample is successfully exported, the LIMS transitions it from Published to Exported. When the last Sample in a Batch transitions to Exported, its parent Batch does too.

The LIMS steps through the Samples and exports their results sequentially in a CSV, referencing the Samples by Metrc Package ID. It is called Bika Results <Manifest ID>.csv

It lists Date Published, Metrc Package ID, Analysis concatenated from AS Title, (unit) and Sample Type, Results and Pass/Fail state limits

It also lists all the Samples included, referenced by Sample ID and Package ID and their COA PDFs filenames in a second CSV, Bika COAs <Manifest ID>.csv

The objective is to have the CSVs and the PDFs in the same folder where the Track & Trace importer picks them up

The LIMS compresses all these files, and the COA PDFs, into a single Zip file that has to be unzipped first

In Metrc

Upload the CSV results file as per standard Metrc procedure. Metrc Manual

To upload the COA PDFs, use the functionality created for this in Track&Trace and load the PDFs file. Track&Trace video, slow it down:) Screenshots