Analysis Import: Format Guidelines for csv file

Analysis data can be imported via a .csv upload using the "Analysis Import" action. Find out more about how the import action works here.

There are two different formatting styles available for import: the original Analysis Import template and the "modified" Analysis Import template. These templates are set up differently (rows versus columns for each type of analysis), so have a look, and pick the one that works for you based on the format in which you receive or record your lab results. 

A .csv file may be provided by laboratory equipment (e.g. FOSS, WineLab, etc.) or by outside laboratories. You can copy/paste these results into the best fit InnoVint import template. We recommend the "original" Analysis Import template for the FOSS.  You may also create your own .csv file for tracking in-house analysis, and if you are starting fresh, we'd recommend using one of the templates at the bottom of this page to get you started. 

This article covers:

• The original Analysis Import
  • Accepted column headers
  • Accepted analyses & units
• The modified Analysis Import
  • Accepted column headers
  • Accepted analyses & units
• Templates 
• FAQ

Original Analysis Import

Guidelines for importing analysis files via the original Analysis Import: 

• This is the template to use that most closely matches the data export from a FOSS. 
• Files must be in the format as pictured here (i.e. analysis names across the top row and lot or vessel codes in the first column "ID"). 
  This is a good template to use when you are running a series of standard panels, i.e. keep one template copied for Juice panels, one for finished wine, one for monthly analysis, etc. 
  
  
  • The ID column header must match the format above, and may contain either lot or vessel codes.  The file may contain either lot codes OR vessel codes, but not both. You will be able to choose Lot Composite or Individual Vessels analysis once the file is uploaded. 

• • The analysis names in the headers must match those in the table below. This import only supports selected analyses types.
  • A date column is not required, but must be in the following format if used: MM/DD/YY. If dates are not entered on the import file, then all analyses will upload as of the date the action is submitted. 

• The analysis column headers of your .csv must match the accepted .csv analysis names  EXACTLY as they are listed in the table below. 
  
  • Pay close attention to the units associated with the accepted analysis names. If multiple units are accepted for an analysis type, i.e. mg/L or ppm, please include the desired units in the analysis header (per the table below). 
  • If the .csv column header does not match an accepted analysis type, the corresponding analysis in that column will be ignored. You will receive a warning pop-up if there is a matching issue. 
    
• InnoVint does not currently accept less than (<) or greater than (>) analysis values.

Modified Analysis Import

Guidelines for importing analysis files via the modified Analysis Import: 

• This file format is ideal for importing analyses exported from InnoVint via the Recent Analysis Report or the Lot details All Analysis in a List export. It may also be useful for importing ad hoc analysis. 
• Files must be in the format as pictured here (i.e. Date, Analysis Type, Value, Unit, and Performed On across the top header row, with a row per analysis result). If a column is not being used, leave it empty, but do not delete it.
  • All column headers are necessary for the upload to be successful. 
  • If you are using lot codes or vessel codes, the file may contain either lot codes or vessel codes in Column E - "Performed On," but not both in the same file. 
     

• If no date is entered, then the current date and time of the "Analysis Import" action submittal will be entered. 

• All analyses that are available within InnoVint are accepted via this format. The analysis type and spelling must match the current format in InnoVint. Reference the list available via the Analysis action > +Add Analysis. If the analysis type exists with an alternative accepted name via the "original" Analysis Import table above, those will be permitted (i.e. Glu/Fru or G/F). You will receive a warning pop-up if there is a matching issue.
• Pay close attention to the units associated with the analysis names. Only units that are currently an option for that analysis type will be accepted. To view the units currently available per analysis, go to an Analysis action > add the desired analysis > click on the caret under units to see all available options. Be mindful that these are case sensitive (i.e. MG/L must be mg/L). 
   

• InnoVint does not currently accept less than (<) or greater than (>) analysis values.

Templates

We've pre-populated a couple basic options for the "original Analysis import" template (one row per lot, with multiple analysis types and results in columns):

• Template - Brix and Temps.csv
• Template - Harvest Chemistry.csv
• Template - Wine Chemistry.csv

Here is the "modified Analysis import" template (one row per lot and per analysis result):

• Template - Modified Analysis Import.csv 

Find out how to adjust your FOSS output analysis names:

• OenoFoss Test Name Change.pdf