Analysis Import: Format Guidelines for csv file

Analysis data can be imported via a .csv upload using the "Analysis Import" action. This action is available in your Record Action menus.  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 at the two layouts, and pick the one that works for you based on the format in which you receive or record your lab results. 

Analysis results may be exported by laboratory equipment (e.g. FOSS, WineLab, etc.) or provided by outside laboratories in .csv or excel files. We recommend copying/pasting these results into the best fit InnoVint import template. For example, the "original" Analysis Import template is the ideal fit for the FOSS export. 

If you are creating your own spreadsheet for tracking in-house analysis,  we'd recommend starting with one of the templates at the bottom of this page to make it easy to import results. 

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 template: 

• 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. you would keep one template copied for Juice panels, one for finished wine, one for monthly analysis panels, 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 template will support a timestamp if included as MM/DD/YY 00:00 (using 24 hour time format).

• 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.
• If you are utilizing "special characters", such as the letter mu for micro (i.e. µS), be sure you are saving the file as CSV UTF-8. This is a special csv file type that supports more international characters (some csv files can't save them properly). 

Modified Analysis Import

Guidelines for importing analysis files via the modified Analysis Import template: 

• 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). 
   

• If you are utilizing "special characters", such as the letter mu for micro (i.e. µS), be sure you are saving the file as CSV UTF-8. This is a special csv file type that supports more international characters (some csv files can't save them properly). 
  
• 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