Connecting to CSV

After formatting your CSV data and setting data types for fields, you can start connecting to the data.

In this guide, you can learn how to:

• Connect to CSV via UI
• Connect to CSV programmatically
  • Specify a custom field separator
• Set a CSV data source for all reports

Connect to CSV via UI

Step 1. Go to the Connect tab () on the Toolbar.

Step 2. Choose to which CSV you want to connect:

• To local CSV. Use this option to load a file from your local file system.
• To remote CSV. Use this option to load a file by its URL.

Here’s an example of connecting to a remote CSV file:

Connect to CSV programmatically

To get your CSV data from a file, specify the file’s URL in the dataSource.filename property:

const pivot = new WebDataRocks({
  container: "#pivot-container",
  report: {
    dataSource: {
      filename: "URL-to-your-CSV-file"
    }
  }
});

Specify a custom field separator

By default, WebDataRocks supports a comma (,) or a semicolon (;) as a field separator. If fields in your data are separated by another character, e.g., a colon (:), you need to specify this character in the dataSource.fieldSeparator property. For example:

const pivot = new WebDataRocks({
  container: "#pivot-container",
  report: {
    dataSource: {
      filename: "URL-to-your-CSV-file",
      fieldSeparator: ":"
    }
  }
});

Set a CSV data source for all reports

To set a CSV data source for all reports, specify it in the Global Object:

const pivot = new WebDataRocks({
  container: "#pivot-container",
  // Other parameters
  global: {
    dataSource: {
      type: "csv",
      filename: "URL-to-your-CSV-file"
    },
  },
  report: {
    // Your report
  }
});

See an example on CodePen.

See also

• Supported CSV format
• Setting data types in CSV
• Data type prefixes