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.
Enter Company Name, assign the Laboratory Role, and then click Edit to bring up the options to Configure Laboratory Settings.
Click on Configure metric names.
Click on Add line 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.
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
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 Actions – Print lab label.
Alternatively, you can request analysis on multiple wines by selecting them from Search – Product Search and then click on Lab Work button.
Select Chemwell as the Laboratory from the drop down, select the appropriate Analysis Template; tick the Print Labels checkbox, then click OK button.
The Lab ID that is generated will need to be entered into the Chemwell software as the Name/ID.
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:
- Mean (in Conc)
To upload the results into vintrace, open the Lab Console. On the bottom left of the window, select Chemwell under Import Format dropdown menu.
Click on Choose File to browse for the report you wish to import then click Load from File.
The completed analysis will automatically be imported into vintrace. Double check the values to ensure they are correct.
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.