Support for Admeo/Bio systems Y15 lab import format

This feature was added in vintrace Version 6.4.1

This FAQ will cover how to set up vintrace to import Admeo/Bio systems Y15 machine  results from their CSV outputs.

This post should be read in conjunction with the more general post on requesting, exporting and importing lab results.

If you are using alternative metric names in vintrace as compared to the column headers output by your Admeo/Bio systems Y15 you will need to read the following section, otherwise skip ahead to requesting/importing results.

Alternatively you can adjust the metric names on the computer connected to your Admeo/Bio systems Y15 machine or modify the resulting CSV export/report manually.

Mapping metric names between Admeo/Bio systems Y15 to vintrace

Open the Address Book and add a new Organization for Admeo/Bio systems Y15 by clicking Add – Organization.

Import 0.1

Assign the Laboratory Role then click Edit to bring up the options to Configure Laboratory Settings.

Import 1

Click on Configure Metric Names. On the left side are your metrics in the system, the right side Admeo/Bio systems Y15 names for those metrics.  When you are done mapping metrics click the OK button to save them.

Import 2

If your metric names differ from Foss names you can map them here.  We recommend that you configure your Lab with the appropriate metric mappings so that the column names from the Admeo/Bio systems Y15 export file match your metric names in vintrace.

Requesting Analysis

Now when you make analysis requests within vintrace you can select Admeo/Bio systems Y15 as your lab.

You may request Lab work can from any single wine from the Product Overview screen by selecting Actions – Print Lab Label.

Import 4

To request analysis on multiple wines select them from the Bulk wine search, click on Lab Work.

Import 6

Select Admeo/Bio systems Y15 as the Laboratory from the drop down, select the appropriate Analysis Template; check (tick) the box next to Print Labels, then click OK.

Import 5

The Lab ID that is generated will need to enter into the Admeo/Bio system Y15 as the Sample ID, will be the barcode (if using a barcode scanner) or “AT” number.

Import 7

 

Once the analysis is complete you can export the report from the Admeo/Bio system Y15 software as a CSV.

Import 9

To upload the results into vintrace, open the Lab Console.  On the bottom left of the window, there is an Import format box, select Admeo/Bio system Y15 from the drop down.

Import 8

Next select Choose File to browse for the report you wish to import then click Load from File.

Import 10

The completed analysis will automatically be imported into vintrace. Double check the values to ensure they are correct.

Import 11

Once the results have been uploaded, there are three actions available:

  • You can View the analysis
  • Update to temporarily save the analysis without confirming them or saving them against the wine so you can perform other operations first
  • Confirm the analysis to save it against the wine.

Reprinting lab labels in bulk

This feature was added in vintrace Version 6.4.1

You can now reprint lab labels in bulk from the Lab Console by clicking on Print labels or Print all matching labels in the dropdown menu on the bottom of the screen.

Print labels option prints all the lab labels of the jobs in the current page while Print all matching labels prints all the lab labels of all the jobs in all the pages.

Print 1

You can also print the lab label per job by clicking on the dropdown menu on each of the job then click on Print labels.

Print 2

Another way to bulk print lab labels is by going into Consoles – Job management, select the work orders from which you want to print the lab labels, click on Actions – Print labels.

Print 3

Setting default number of results per page for Lab Console

This feature was added in vintrace Version 6.1.3

You can now set how many lab results will appear per page in Lab Console. By default, the number of results per page is set to 50.

Go to Consoles – Lab.

default-size

You can change the number of results per page by typing your desired setting in the results per page text box then clicking on the heart icon. In the example below, we entered 20 and then click on the heart icon.

change-size-1

So next time you hit on Search button, the number of results per page will be set to 20. Please note that any actions such as exporting the results to CSV/PDF, updating, confirming, or reversing the lab results will only be applied to the current page you are viewing.

change-size-4

Another way to change the number results per page for a specific user is by going into Winery Setup – Work-flow – Defaults – User tab. Go to Lab Console Settings section. Then change the Records per page field to your desired number of results per page. Then click on Apply button.

change-size-3jpg

ETS lab tests for mapping to vintrace metrics

To assist you in matching your metrics with ETS for either direct download from their website or importation of their csv file, we are providing tables from which you may copy and paste into the metric mapping dialog box.

The following table represents the most commonly requested ETS analyses:

alcohol at 60F
Allergen-Egg
Allergen-Milk
ammonia
apparent alcohol (at 60F)
basic juice profile
Botrytis Panel
bottled sterility - bacteria only
bottled sterility - yeast and bacteria
brix
Brix (Balling) - densitometer
carbon dioxide
chemistry panel
citric acid
color profile
conductivity test-Davis
copper (AA)
cork sterility (Rankine)
density
dissolved oxygen
ethanol at 20C
ethanol at 20C (GC)
ethylphenols
European Community Export Certificate
fining trial (Pocock & Waters) - control
free sulfur dioxide
glucose + fructose
heat stability (Pocock & Waters)
Japan export analyses
juice yeast culture
L-lactic acid
L-malic acid
pH
potassium
residual sugar
'Scorpion' Juice Bacteria Panel
'Scorpion' Juice Panel
'Scorpion' Juice Yeast Panel
'Scorpion' Wine Bacteria Panel
'Scorpion' Wine Panel
'Scorpion' Wine Yeast Panel
'Smoke Taint' panel
'Smoke Taint' panel- berry sample
specific gravity
tartaric acid
titratable acidity
total acidity
total acidity (as acetic acid)
total sulfur dioxide
turbidity (turbidimeter)
volatile acidity (acetic acid)
volatile acidity(acetic)
wine bacteria culture

 

These metrics can be used for either the direct connection to ETS via the web or for the downloadable csv file.

Please note that this list is subject to change by ETS without prior notice.

For more information on the analyses available from ETS for mapping against your own metrics, please visit https://www.etslabs.com/analyses

Sort analysis export using an analysis template

This feature was added in vintrace version 5.2.3

This feature allows you to select an analysis template to be used to sort the metrics when you export the CSV or PDF from Lab Console, generate the Analysis data export, or generate the Lab job worksheet. You also have the option to exclude metrics not on the selected analysis sort template and to include columns for metrics in the sort template even if there are no requests present.

Using analysis sort template in Lab Console

Firstly, you need to request lab work for some wines you want to run through the lab. Please refer to this post on how to request, export, and import lab jobs.

For our example below, we have requested a lab sample with the following metrics selected: Alcohol, Amino, and Baume.

Lab request

Go to ConsoleLab Console. You can see the lab work you have requested with the three metrics Alcohol, Amino, and Baume.

lab console advanced report options 6

Let’s say you want to export the lab request to a CSV file but you want the metrics to be sorted according to an analysis template that you already have. For this example we have an analysis template, ‘Brix and Alcohol’ where Brix is listed first then Alcohol.

Analysis template

Click on the menu icon beside the CSV button on the lower part of the Lab Console screen.

Lab console advanced report options

In Analysis Sort Template field, click on the magnifying glass icon to search for the analysis template you want to use. In the example below, we have selected ‘Brix and Alcohol’ analysis template, which lists the Brix first then the Alcohol metric.

Lab console advanced report options 2

We also ticked the Exclude metrics not on the selected analysis sort template and Include columns for metrics in the sort template even if there are no requests present checkboxes. Then click on Save button to save the selection. You can also click on the heart icon beside the options so that vintrace will remember your selection.

Lab console advanced report options 3

Click on CSV button to generate the CSV output.

Lab console advanced report options 4

In the CSV output, the metrics are sorted according to how the metrics appear in the Brix and Alcohol analysis template, where Brix is listed first. Amino and Baume is not in the CSV since we have Exclude metrics not on the selected analysis sort template and Include columns for metrics in the sort template even if there are no requests present option selected. Brix is included in the CSV output even though there was no lab request for it because we have selected the Include columns for metrics in the sort template even if there are no requests present option.

Lab console CSV output

Using analysis sort template in Lab job worksheet

Go to Winery Reports – Product analysis – Lab job worksheet. We want to see the lab work requested in the previous section. Under Metrics, select Alcohol, Amino, and Baume.

Lab job worksheet 1

In the Advanced Report Options – Analysis Sort Template, select ‘Brix and Alcohol’. Let’s assume we want to see all the metrics requested plus any metrics that are in the analysis template even though there are no requests for it, so tick on Include columns for metrics in the sort template even if there are no requests present checkbox.

Lab job worksheet 2

Click on Generate button.

Lab job workshee 3t

In the generated results, the metrics is sorted in the following order: Brix, Alcohol, Amino, and Baume. If there are metrics included that are not in the analysis template, it will be added to the end of the list. In this case, Amino and Baume are added after Brix and Alcohol.

Lab job worksheet results

Using analysis sort template in Analysis data export

Go to Winery Reports – Product analysis – Analysis data export. Assuming that the lab requests from the previous sections have been completed and we want to export the analysis data and sort the metrics according to the ‘Brix and Alcohol’ analysis template. In Advanced Report Options, select ‘Brix and Alcohol’ in the Analysis Sort Template. Then click on Generate button.

Analysis data export

In the CSV output, the metrics are sorted in the following order: Alcohol, Amino, and Baume. Brix is not included in the output since we did not have the Include columns for metrics in the sort template even if there are no requests present option selected

Analysis data export output.

 

 

Upload lab results for the Chemwell spectrophotometer

This feature was added in vintrace version 5.2.3

This feature allows you to upload the CSV results from a Chemwell spectrophotometer into vintrace.  We recommend that you read the more general post on requesting, exporting, and importing lab results in conjunction with this article.

If you are using alternative metric names in vintrace as compared to the metric names output by your Chemwell equipment, you will need to read the following section, otherwise skip ahead to Requesting Analysis section.

Mapping metric names between vintrace and Chemwell

Open the Address Book and add a new Organization for Chemwell by clicking Add – Organization.

Add organisation 1

Enter Company Name, assign the Laboratory Role, and then click Edit to bring up the options to Configure Laboratory Settings.

Add organisation 2

Click on Configure metric names.

Add organisation 3

Click on Add line button to add metric mappings. On the left side are your metrics in vintrace, the right side are the Chemwell names for those metrics.  When you are done mapping metrics click the Ok button to save them.

Add organisation 4

If you would like to keep your Chemwell results separate from other analysis results you can also create new metrics and map them on the mapping screen.
E.g. Acetic acid [Chemwell] -> VIN AA Assay to 1.0

Requesting Analysis

Make analysis requests within vintrace and select Chemwell as your lab.

You can request Lab work from any single wine from the Product Overview screen by selecting ActionsPrint lab label.

Request analysis 1

Alternatively, you can request analysis on multiple wines by selecting them from SearchProduct Search and then click on Lab Work button.

Request analysis 2

Select Chemwell as the Laboratory from the drop down, select the appropriate Analysis Template; tick the Print Labels checkbox, then click OK button.

Request analysis 3

The Lab ID that is generated will need to be entered into the Chemwell software as the Name/ID.

Lab label

When you run your analysis make sure to register it with the Lab ID from vintrace; this is important for importing the results back into vintrace.

Uploading Chemwell results into vintrace

Once the analysis is complete you can export the report from the Chemwell software as a CSV and import it into vintrace. The following column headers in the CSV are important as they will be mandatory in vintrace when you upload the file:

  • Name/ID
  • Test
  • Mean (in Conc)

CSV results

To upload the results into vintrace, open the Lab Console.  On the bottom left of the window, select Chemwell under Import Format dropdown menu.

Lab console 1

Click on Choose File to browse for the report you wish to import then click Load from File.

Upload file

The completed analysis will automatically be imported into vintrace. Double check the values to ensure they are correct.

Upload complete

Once the results have been uploaded, there are three actions available:

  • You can View the analysis.
  • Update to temporarily save the analysis without confirming them or saving them against the wine so you can perform other operations first.
  • Confirm the analysis to save it against the wine.

 

Improved Lab tab in Product Overview and Block Overview

This new feature was added in Version 5.1.3

The Lab tab in Product Overview shows the latest lab analyses for the bulk product and has been enhanced to show more useful data such as the current value, last value, the dates they were taken, and the rate of change of the metrics.

Lab tab

You have the option to show the exact date and time the lab analysis was done by ticking on the Show dates checkbox.

Lab tab show dates

There are several options to filter the data to be shown on the table. You can use the Filter button to select which metrics you want to be displayed. You can also filter by Metric validity and the date range the lab work was done.

lab tab filter options

A chart to show metrics data over time can be displayed by ticking on the checkbox beside the metric in the table.

Lab tab show metric chart

Clicking on the chart icon at the line entry for each metric will show a line graph for that specific metric only. And in the metric history chart, you can select a date range you want to show the chart in.

lab tab Metric chart

You can also request for lab work from the Lab tab by either selecting an Analysis template or selecting the metrics from the table and then click on the beaker icon.

Lab tab lab work request

The Lab tab in the Block Overview shows fruit maturity data as recorded into the system for this block each season and has also been enhanced to show data such as the current value, last value, the dates they were taken, and the rate of change of the metrics for analysis entered against this block for a selected vintage.

Block Overview Lab Tab

 

 

How I do delete jobs from the Lab Console?

There are few ways to go about removing analysis jobs scheduled in the lab console. Once these are deleted there is no getting them back. So please make sure you delete the correct tasks.

The first method is from the lab console itself. You can locate the job you no longer need click the View button and then select Cancel Job.

delete_lab_job

 

For analysis jobs that are not on a work order, the alternative method is via the Consoles – Classic Scheduled Tasks and is a much better way to remove multiple jobs. Select Incomplete from the Status drop down list and select Analysis from the Operation Type list. You should then be presented with the list of all scheduled analyses that haven’t been assigned to a work order. Then you can simple click the Delete button to remove an individual task or highlight multiple tasks and use the Delete selected button.

Classic scheduled task worklist

 

For analysis jobs on a work order, go to Consoles – Job management. Select the status of the work order you want to delete (in this case Draft and Ready statuses were selected) and select Analysis from the Operation type. Then click on Search button.

Delete 1

This will bring up a list of all your analysis jobs. Select the work orders you want to delete then click on Actions button then Cancel selected.

Delete 2

Click on Yes button to confirm.

Delete 3

 

 

How to set up metric weightings for the additions calculator

The following support article is to help you set up metric weightings for additions, this allows the additive calculator to work out how much of a addition is required to reach the desired metric level.
Click on images to view a larger version, if you would like to view them in a second window simple click on them with the middle mouse button.

This is commonly used for KMBS or PMS, CUSO4 and a variety of other sulfur additions/solutions.

If you have a demo database available you can set this up in your demo first and test it out before doing the same in your production database.

I’ll be splitting the article into two parts, first setting up the Metric and the Addition, next is using the addition calculator.

Setting up the Metric,

Head into the Winery setup as shown below, into the Production folder and then into the Metrics category.

In this example I am using Free SO2, the important thing on this form is the ppm to g/L factor.
If you know your ppm to g/L factor you can enter it here, otherwise 0.001 will generally do.

Once this is entered save the metric.

Next is the addition,
Head into the Additive category now and select the addition you want to tie to the metric.

In this case I have used PMS/KMBS.
In the screenshot you’ll notice I have outlined three areas in red.
The right hand side is where you select a metric and assign a weighting to it, this weighting is the percentage of this addition that will contribute to the metric.
Clicking the Add button on the centre box will add it to the metric weighting list.
In this case 57% of the PMS addition will contribute to the Free SO2 metric.

Finally the Rate unit field is important as the rate of addition will be set to PPM.

In theory everything is ready to be used now, so next is using the addition calculator.

Now for the Additive calculator.
Exit the winery setup and head into the operations menu, select additive to start a new addition operation.
In the screenshot below I have marked out several areas in red, on the left you’ll see I have selected PMS as the addition.

On the right is the addition calculator, you will need to select the metric you want to use in the calculation (in this case Free SO2).
You will also need to select the additive if there is more than one additive that has a metric weighting for this metric.
Next you will need to fill in the current rate if this metric has not been tested or has been invalidated in the system (via blending for example).
After this fill in the desired rate and press the calculator button.

Double check that the required amount looks right, if you are happy with the amount click the [< < Use this value] button to drop the amount into the left hand side. Remember if you have any questions or come across any problems feel free to contact support.