plugin:csv
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
plugin:csv [2018-07-09 21:54] – Aleksandr | 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 : 2018-04-27 | + | lastupdate : 2022-01-03 |
- | compatible : Frusterick Manners, | + | compatible : Hrun, Ponder Stibbons, Binky, Weatherwax, Adora Belle, Angua, Detritus, Greebo, Hogfather, Igor, Jack Jackrum |
depends | depends | ||
conflicts | conflicts | ||
Line 22: | Line 22: | ||
===== Description ===== | ===== Description ===== | ||
- | [[http:// | + | [[http:// |
This is a simple plugin that will display CSV data in table form. The data can either be inline between '' | This is a simple plugin that will display CSV data in table form. The data can either be inline between '' | ||
Line 43: | Line 43: | ||
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 |
- | | '' | + | | '' |
- | | '' | + | | '' |
- | | '' | + | | '' |
- | | '' | + | | '' |
- | | '' | + | | '' |
- | | '' | + | | '' |
- | | '' | + | | '' |
- | | '' | + | | '' |
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! | There is a second syntax mode to grab a **single value** from a CSV. This mode does not support inline CSV data! | ||
Line 93: | Line 102: | ||
* < | * < | ||
* read data from a csv-file stored at Windows Shares like [[wiki: | * 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.1531166077.txt.gz · Last modified: 2018-07-09 21:54 by Aleksandr