Documentation menu
JS React Angular Vue
JS React Angular Vue

Connecting to CSV

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

Connect to CSV via UI

Step 1. Go to the Connect tab (
menu_connect ) 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:

<script setup>
  import {Pivot} from "@webdatarocks/vue-webdatarocks";
  import "@webdatarocks/webdatarocks/webdatarocks.css";

  const reportCsv = {
    dataSource: {
      filename: "URL-to-your-CSV-file"
    }
  };
</script>

<template>
  <div>
    <Pivot 
      v-bind:report="reportCsv"
      toolbar
    />
  </div>
</template>

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 reportCsv = {
  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:

<script setup>
  import {Pivot} from "@webdatarocks/vue-webdatarocks";
  import "@webdatarocks/webdatarocks/webdatarocks.css";

  const globalReportCsv = {
    dataSource: {
      type: "csv",
      filename: "URL-to-your-CSV-file"
    }
  };
  const reportCsv = {
    // Your report
  };
</script>

<template>
  <div>
    <Pivot
      v-bind:global="globalReportCsv"
      v-bind:report="reportCsv"
      toolbar
    />
  </div>
</template>

See also