Importing Lab Data
Last updated
Last updated
Tasting Notes Lab Data can be loaded using the VinoEZ import tool.
To begin the process, go to Tasting Notes > Load Lab Data
The import wizard is now shown.
Lab data can be loaded in a csv or xlsx format.
There are 5 key steps in loading the lab data.
Select the file that contains the lab data to be loaded. The file can be dragged into the green box, or select 'Browse your device' to browse to the file to be uploaded.
The key requirements for the file are only that it be in .csv or .xlsx format, with a row for each blend ID and associated results. A column for each of the following elements is also mandatory:
Site - matching the VinoEZ site code
Test Date/Time - formatted as YYYY-MM-DD HH:MM
Vessel
Blend_ID - matching the VinoEZ blend format
Temp
The following example file can be used as a base if required.
Once the file has been selected, it will begin uploading automatically, and the upload indicator will be displayed.
After the file has uploaded, the mapping screen will be displayed. Here, the columns in the file which was uploaded can be mapped to the Tasting Notes field in VinoEZ. Each tasting notes data element is displayed on the right, and the fields in the loaded file will be available to select on the left.
The 5 mandatory fields are indicated with a red * against the field name.
To map the fields, there are 2 methods.
Use the Wand option.
Selecting the wand will result in VinoEZ attempting to map the data based on the headings in the file. For example, if there is a column named 'Site' in the uploaded file, the wand function will map this to the Site field in VinoEZ.
2. Select the file column from the drop down next to each field.
Once the required fields have been mapped, select 'Continue' to validate.
The data is then validated against the Tasting Notes import rules. Any data that does not meet the validation rules will be highlighted in red.
In this case, the site code does match a valid site.
To resolve the errors, the data can be edited inline by clicking in the required cell. (Note: if there are a large number of validation issues you may wish to resolve them in the base file and re-upload.)
Once a change has been made, the data can be validated again by selecting the 'Validate' button in the bottom right. Rows that now pass will be removed from the view.
Once all data passes validation, the 'Import' button will be enabled.
Select 'Import' and the data will import and now be available to view in Tasting Notes.
Additional Details
At any stage, you can return to a step by selecting the step at the top of the view
