User Tools
Sidebar
CSV Plugin
This is a simple plugin that will display CSV data in table form. The data can either be inline between <csv> and </csv> or be read from a file in the media area using <csv namespace:test.csv></csv>. You can also give an HTTP URL to a CSV file instead of an uploaded media file.
If you are planning to use csv files in the media area, you will most likely need to include the .csv file extension in mime.local.conf so you can upload .csv files. Something like this should get you started:
csv text/csv
The <csv> tag allows for additional options to be specified as well as a file reference.
| Option | Description | Default value |
|---|---|---|
file=<filename> | where <filename> can be any <namespace:file.csv> or <http url> | |
hdr_rows=<n> | Format the first <n> rows of data from the CSV as column headers | 1 |
hdr_cols=<n> | Format the first <n> columns of each row as column headers | 0 |
span_empty_cols=[01] | Create colspans for each empty (two adjacent commas) cell following a cell with content | 0 |
delim=<char> | The delimiter used between cells. Specify tab for a tab separated file. | , |
Other options of the form <key>=<value> are possible but not used for displaying csv data yet.
Cells that include a comma as part of the data are expected to be contained between double quotes, which is the typical behaviour of most systems when exporting .csv files.
Empty lines in the csv file or data are displayed as horizontal separators in the table.
Use with a Google Docs Spreadsheet
The HTTP URL can be a shared Google Docs Spreadsheet. The following explains how to export a spreadsheet in CSV format via a URL.
To link to a Google spreadsheet:
- Open your spreadsheet in Google Docs.
- Click the “Share” botton in the toolbar, and choose “Anyone with the link” for Visibility.
- Open your spreadsheet in Google Docs.
- From the spreadsheet menu select: File | Publish as a Web Page
- Sheets to Publish: “All Sheets”, and check the box “Automatically republish when changes are made” to ensure your data is auto updated.
- Click “Start Publishing”. This will activate the options in the box “Get a link to the published data”, below.
- Change the export type from “Web Page” to “CSV (comma-separated values)”.
- Change “All sheets” to “Sheet1” (or select the sheet you want to export)
- Change “All Cells” to the specific range you want to export, beginning with the header row. Use Excel-style notation, like “A1:C6” for the first 3 columns and the first 6 rows.
- Click “Republish now”
- Copy the link (check it ends with output=csv) and paste it into your dokuwiki CSV table using the file= attribute described above.
Outline of steps adapted from:
