DokuWiki

It's better when it's simple

User Tools

Site Tools


plugin:csv

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
plugin:csv [2021-02-18 23:50] – version upped andiplugin: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 : 2021-02-18 +lastupdate : 2022-01-03 
-compatible : Frusterick Manners, Hrun, Ponder Stibbons, Binky, Weatherwax, Adora Belle, Angua, Detritus, 2018-04-22 "Greebo", Hogfather+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://www.cosmocode.de/en/open-source/dokuwiki-plugins/|{{ http://cosmocode.de/static/img/dokuwiki/dwplugins.png?recache|A CosmoCode Plugin}}]]+[[http://www.cosmocode.de/en/open-source/dokuwiki-plugins/|{{ https://www.cosmocode.de/static/img/dokuwiki/dwplugins.png?recache|A CosmoCode Plugin}}]]
  
 This is a simple plugin that will display CSV data in table form.  The data can either be inline between ''%%<csv>%%'' and ''%%</csv>%%''  This is a simple plugin that will display CSV data in table form.  The data can either be inline between ''%%<csv>%%'' and ''%%</csv>%%'' 
Line 44: Line 44:
 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|mime.local.conf]] so you can upload .csv files. Something like this should get you started: 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|mime.local.conf]] so you can upload .csv files. Something like this should get you started:
 <code - mime.local.conf> <code - mime.local.conf>
-  csv     text/csv+csv     text/csv
 </code> </code>
  
 The ''%%<csv>%%'' tag allows for additional options to be specified as well as a file reference. The ''%%<csv>%%'' tag allows for additional options to be specified as well as a file reference.
  
-^ Option                                   ^ Description                                                                                                                                                                                                        ^ Default value  ^ +^ Option                                           ^ Description                                                                                                                                                                                                                               ^ Default value  ^ 
-| ''file=<filename>''                      | where ''<filename>'' can be any ''<namespace:file.csv>'' or ''<http url>''. The ''file='' prefix is optional. Any option without a name is assumed to be the file name                                             |  ''''          | +| ''file=<filename>''                              | where ''<filename>'' can be any ''<namespace:file.csv>'' or ''<http url>''. The ''file='' prefix is optional. Any option without a name is assumed to be the file name                                                                    |  ''''          | 
-| ''hdr_rows=//<n>//''                     | Format the first //<n>// rows of data from the CSV as column headers                                                                                                                                               |  ''1''         | +| ''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''         | +| ''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''         | +| ''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.                                                                                                                                        |  '',''         | +| ''delim=//<char>//''                             | The delimiter used between cells. Specify ''tab'' for a tab separated file.                                                                                                                                                               |  '',''         | 
-| ''maxlines=//<n>//''                     | limiting the result set to a certain number of rows                                                                                                                                                                |  ''0''         | +| ''maxlines=//<n>//''                             | limiting the result set to a certain number of rows                                                                                                                                                                                       |  ''0''         | 
-| ''offset=//<n>//''                       | skipping the given number of rows before output                                                                                                                                                                    |  ''0''         | +| ''offset=//<n>//''                               | skipping the given number of rows before output                                                                                                                                                                                           |  ''0''         | 
-| ''filter[//<n>//][//t//]="//<text>//"''  | Allows you to filter the rows. //<n>// is the column number you want to filter on. The first column is 1. //t// can either be an ''g'' for globbing or an ''r'' for regexp. Use simple ''*'' in the globbing mode to find partial texts.  |                |+| ''filter[//<n>//][//t//]=%%"%%//<text>//%%"%%''  | Allows you to filter the rows.\\ \\ //<n>// is the column number you want to filter on. The first column is 1.\\ \\ //t// can either be an ''g'' for globbing or an ''r'' for regexp. Use simple ''*'' in the globbing mode to find partial texts.  |                |
  
 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.
Line 102: Line 102:
   * <del>Use of smileys (for example traffic light based on values)</del> see [[https://github.com/cosmocode/csv/issues/10|Issue #10]]   * <del>Use of smileys (for example traffic light based on values)</del> see [[https://github.com/cosmocode/csv/issues/10|Issue #10]]
   * read data from a csv-file stored at Windows Shares like [[wiki:syntax#windows_shares]]   * read data from a csv-file stored at Windows Shares like [[wiki:syntax#windows_shares]]
 +  * 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.1613688619.txt.gz · Last modified: 2021-02-18 23:50 by andi

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki