Add CSV file - DataV

This document outlines the steps for adding a CSV file to DataV.

Prerequisites

Ensure the CSV file intended for addition is prepared.

Procedure

Access the DataV console.
On the Workbench page, click Data Preparation > Data Source to navigate to the Data Source page, then click Create Data Source.
From the Type dropdown, select CSV File.
Upload the CSV file.
Note
The file size must not exceed 512KB. CSV files larger than this limit are not supported.
Click OK to finalize the addition of the data source.

FAQ

CSV File Format Concerns
Ensure to save the original Excel or other data format files as CSV. Merely changing the file extension will not convert the format and may cause errors.
DataV Console Compatibility
Due to Google Chrome's HTTP protocol restrictions, access the DataV console using an HTTPS URL to add a CSV file data source.

Static data example

[
  {
    "x": "January",
    "y": 2,
    "s": "Precipitation"
  },
  {
    "x": "January",
    "y": 2.6,
    "s": "Evaporation"
  },
  {
    "x": "February",
    "y": 4.9,
    "s": "Precipitation"
  },
  {
    "x": "February",
    "y": 5.9,
    "s": "Evaporation"
  },
  {
    "x": "March",
    "y": 7,
    "s": "Precipitation"
  },
  {
    "x": "March",
    "y": 9,
    "s": "Evaporation"
  },
  {
    "x": "April",
    "y": 23.2,
    "s": "Precipitation"
  },
  {
    "x": "April",
    "y": 26.4,
    "s": "Evaporation"
  },
  {
    "x": "May",
    "y": 25.6,
    "s": "Precipitation"
  },
  {
    "x": "May",
    "y": 28.7,
    "s": "Evaporation"
  },
  {
    "x": "June",
    "y": 76.7,
    "s": "Precipitation"
  },
  {
    "x": "June",
    "y": 70.7,
    "s": "Evaporation"
  },
  {
    "x": "July",
    "y": 135.6,
    "s": "Precipitation"
  },
  {
    "x": "July",
    "y": 175.6,
    "s": "Evaporation"
  }
]

Data format example

In the CSV file, the first line should contain the field names such as x, y, s. Subsequent lines should represent the corresponding field values. Refer to the static data example above for the CSV file content format.

Case demo

Using the Line Chart as an example, consider a CSV dataset with monthly precipitation and evaporation from January to July. Follow the steps below to import it into DataV.

Logon - Figure
DataV console .
Navigate to the Workbench page, select a dashboard, and click Edit.
In the canvas editor, add the Line Chart widget.
Open the data source panel and set the data source type to CSV File.
Click Create to add a new CSV data source.
Import the Precipitation And Evaporation.csv file into the system and click OK.
In the Select Existing Data Source panel, choose the newly imported CSV data source. You may notice the chart initially displays no content.
Click Data Mapping and assign the Edition field to s. The chart should now display correctly as illustrated.