plugin:csv
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
plugin:csv [2017-04-12 12:01] – version upped andi | plugin:csv [2024-02-10 21:12] (current) – Aleksandr | ||
---|---|---|---|
Line 6: | Line 6: | ||
email : dokuwiki@cosmocode.de | email : dokuwiki@cosmocode.de | ||
type : syntax | type : syntax | ||
- | lastupdate : 2017-04-12 | + | lastupdate : 2022-01-03 |
- | compatible : Hrun, Ponder Stibbons, Binky, Weatherwax, Adora Belle, Angua, Detritus | + | compatible : Hrun, Ponder Stibbons, Binky, Weatherwax, Adora Belle, Angua, Detritus, Greebo, Hogfather, Igor, Jack Jackrum |
depends | depends | ||
conflicts | conflicts | ||
similar | similar | ||
tags : csv, tables, file | tags : csv, tables, file | ||
- | |||
downloadurl: | downloadurl: | ||
Line 23: | Line 22: | ||
===== Description ===== | ===== Description ===== | ||
- | [[http:// | + | [[http:// |
- | This is a simple | + | |
+ | This is a simple plugin that will display CSV data in table form. The data can either be inline between '' | ||
< | < | ||
<csv> | <csv> | ||
Line 32: | Line 33: | ||
</ | </ | ||
</ | </ | ||
+ | |||
or be read from a file in the media area using | or be read from a file in the media area using | ||
+ | |||
< | < | ||
<csv namespace: | <csv namespace: | ||
</ | </ | ||
+ | |||
You can also give an HTTP URL to a CSV file instead of an uploaded media file. | 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 [[: | If you are planning to use csv files in the media area, you will most likely need to include the .csv file extension in [[: | ||
- | + | <code - mime.local.conf> | |
- | csv | + | csv |
+ | </ | ||
The '' | The '' | ||
- | ^ Option | + | ^ Option |
- | | '' | + | | '' |
- | | '' | + | | '' |
- | | '' | + | | '' |
- | | '' | + | | '' |
- | | '' | + | | '' |
- | | '' | + | | '' |
- | | '' | + | | '' |
- | + | | '' | |
- | 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. | 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. | Empty lines in the csv file or data are displayed as horizontal separators in the table. | ||
+ | |||
+ | Example for a table using a filter. This will look for values beginning with " | ||
+ | < | ||
+ | <csv hdr_rows=0 filter[3][g]=" | ||
+ | ABC,DEF,GHI | ||
+ | JKL,MNO,PQR | ||
+ | </ | ||
+ | </ | ||
+ | |||
+ | There is a second syntax mode to grab a **single value** from a CSV. This mode does not support inline CSV data! | ||
+ | |||
+ | < | ||
+ | <csvval some.csv output=3, | ||
+ | </ | ||
+ | |||
+ | In addition to all the options supported in the ''< | ||
===== Download ===== | ===== Download ===== | ||
- | To install | + | Search and install |
* https:// | * https:// | ||
Line 70: | Line 90: | ||
==== Enhancement Considerations ==== | ==== Enhancement Considerations ==== | ||
+ | |||
* is it possible to add a download-button so that the csv-file could be directly downloaded (especially for inline-data) | * is it possible to add a download-button so that the csv-file could be directly downloaded (especially for inline-data) | ||
* might be nice to be able to have gridlines | * might be nice to be able to have gridlines | ||
Line 80: | Line 101: | ||
* Integration with the bootstrap theme -> header is not in the right colour. Global style of the table looks different than if you use the default syntax. | * Integration with the bootstrap theme -> header is not in the right colour. Global style of the table looks different than if you use the default syntax. | ||
* < | * < | ||
- | * read data from a csv-file stored at Windows Shares like https:// | + | * read data from a csv-file stored at Windows Shares like [[wiki: |
+ | * Add row/column header via parameter | ||
+ | * Make table sortable by different columns | ||
==== Use with a Google Docs Spreadsheet ==== | ==== Use with a Google Docs Spreadsheet ==== | ||
plugin/csv.1491991268.txt.gz · Last modified: 2017-04-12 12:01 by andi