This feature was added in vintrace version 5.2.3.
This feature allows you to import 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 selecting Add > Organization.
Enter Company Name, assign the Laboratory role, and then click Edit to bring up the options for Configure Laboratory Settings.
Click on Configure metric names.
Click Add line to add metric mappings. On the left side are your Metrics in vintrace and on the right side are the Chemwell names for those Metrics. When you are done mapping the Metrics, click Ok 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.
Eg 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 by selecting Actions > Print lab label.
Alternatively, you can request analysis on multiple wines by selecting them from the Bulk Wine Search (select Search > Bulk wine search) and then click Lab Work.
Select Chemwell as the Laboratory from the drop down, select the appropriate Analysis Template; tick the Print Labels checkbox and then click OK.
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.
Importing 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 import the file:
- Mean (in Conc)
To import the results into vintrace, open the Lab Console. On the bottom left of the window, select Chemwell under the Import Format drop down.
Click 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 import, 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.