How to Import Vineyard Events via CSV file

The Vineyard Event Import action allows you to create new vineyard events via a CSV file. You can create your own CSV file for importing or use the template provided here to get you started (recommended). 

This article covers:

Using the Vineyard Event Import Action

  1. You can select the "Vineyard Event Import" action from the button in the Vineyard Dashboard, Vineyard Details, and Block Details pages (anywhere you can create a vineyard action).
  2. Click "Upload CSV" and choose your file to upload. Make sure the CSV file matches the required format exactly (We recommend using the example csv template within the action).
  3. Click 

Specifications for the CSV import file

  • Each line of the CSV file represents a single 'Vineyard Event'. You can create new and backdated events via the import.
  • Files must be in the same format as the example CSV provided. Columns across the top, in order, include:
    • Date
      • Not required. If left blank, the event date will be recorded as of the upload date.
      • If included, dates must in the following format: MM/DD/YYYY or YYYY-MM-DD
    • Vineyard
      • Required. Must match exactly the name of an existing vineyard in the winery. 
    • Block
      • Required. Must match exactly the name of an existing block in the specified vineyard.
    • Variety
      • Required. Must match exactly the name of a variety in the specified block. 
    • Clone
      • Only required if the Vineyard/Block/Variety combination has an existing clone. 
      • Leave blank if no clone currently exists for the block.
    • Vintage
      • Required. Must be 4-digit year (ex: 2019).
    • Event
      • Required. Must match an existing event within the three main event types. 
    • Percentage
      • Required ONLY if the event type is "Phenology",  otherwise this field must be blank. 
    • Details
      • Optional.

FAQs

Q. I can't get my file to upload! What should I try? 

A. Please be sure to double check the following items: 

  • Make sure all details in the CSV file match your existing vineyards, blocks and varieties. Each line item must match to an existing, unique vineyard/block/variety/clone (or no clone) combination within InnoVint.
  • Be sure you are uploading a .csv file

Q. Can I upload a .txt or .xls file instead? 

A. Currently, we do not accept .txt or .xls files. 

Q. I'm getting this error message:

A. You likely have a typo for an 'exact match' field, or you are missing required fields. Check the list of errors provided on the screen to troubleshoot any issues.