.. You may want to use the usual include line. Uncomment and adjust the path. .. include:: ../Includes.txt ========== EXT: geoIP ========== :Author: Kasper Skårhøj :Created: 2002-11-01T00:32:00 :Changed by: Kurt Kunig :Changed: 2017-02-05T13:28:42.980000000 :Author: Georg Ringer (just2b) :Email: http://www.ringer.it :Info 3: :Info 4: .. _EXT-kk-csv2table: EXT: kk\_csv2table ================== Extension Key: **kkcsv2table** Copyright 2008, Kurt Kunig “kupix web-design”, ` `_ This document is published under the Open Content License available from http://www.opencontent.org/opl.shtml The content of this document is related to TYPO3 \- a GNU/GPL CMS/Framework available from www.typo3.com .. _Table-of-Contents: Table of Contents ----------------- **`EXT: kk\_csv2table <#1.EXT:%20kk_csv2table|outline>`_ 1** **`Introduction <#1.2.Introduction|outline>`_ 2** `What does it do? <#1.2.1.What%20does%20it%20do_|outline>`_ 2 `Screenshots <#1.2.2.Screenshots|outline>`_ 2 **`Configuration <#1.4.Configuration|outline>`_ 4** `Reference <#1.4.1.Reference|outline>`_ 4 `Classes <#1.4.2.Classes|outline>`_ 4 `CSS <#1.4.3.CSS|outline>`_ 4 **`Known problems <#1.5.Known%20problems|outline>`_ 4** **`To-Do list <#1.6.To-Do%20list|outline>`_ 4** **`Changelog <#1.8.Changelog|outline>`_ 5** .. _Introduction: Introduction ------------ .. _What-does-it-do: What does it do? ^^^^^^^^^^^^^^^^ This small extensions provides a very simple conversion of a flat input-file (\*.csv = excel export or \*.txt) to a table construct in the TYPO3 content area. .. _Screenshots: Screenshots ^^^^^^^^^^^ The main purpose of the extension is to simplify the display of table contents out of Excel or Open-Office-Calc for a user. Instead of putting data via drag and drop from Excel / Calc to a RTE-table or simple “table-CType” you offer the extension a csv- or txt-file, put some more small parameters in and go.Users manual **Since version 3.0.1 you'll find this function under “C-type” General Plugin and plugin “Excel-table (kk\_csv2table)”** |img-1| **Image 1:** Extension is a Ctype extension (look under “Type”) To use this extension you need to follow these steps: Install the extension from TER Insert a new content object in your page and choose page type “CSV- table” **Since version 3.0.1 you'll find this function under “C-type” General Plugin and plugin “Excel-table (kk\_csv2table)”** |img-2| Upload a csv- or txt-file from your desktop or out of the select-box of the TYPO3 file-area or put in one concrete file within the whole path relative to “fileadmin”. The 2nd has a higher priority. Put the column delimiter-sign in (eg; “;” or “,” or “\|” or “[T]” for a tabulator-sign etc.) Put in a possible text-delimiter, mostly a quotation marks Choose the code the csv-file is encoded with (e.g. Western ISO-8859-1) Choose the character code the html-page is encoded with (e.g. UTF-8) Put a table summary – string in Put in a table-class (if wanted) and decide if there are column-headers in the first row or not Put in your own column headers (the very same delimiter as above), if wanted .. _Configuration: Configuration ------------- .. _Reference: Reference ^^^^^^^^^ plugin.tx\_kkcsv2table\_pi1. .. ### BEGIN~OF~TABLE ### .. _debug: debug """"" .. container:: table-row Property debug Data type boolean Description Prints debug information if set (= 1) Default 0 .. _allowTags: allowTags """"""""" .. container:: table-row Property allowTags Data type string Description Comma separated list of allowed tags in the input file. **e.g.** **plugin.tx\_kkcsv2table\_pi.allowTags = b,u,i,span** Default Empty (only
is accepted .. ###### END~OF~TABLE ###### .. _Classes: Classes ^^^^^^^ .. ### BEGIN~OF~TABLE ### .. _div: div """ .. container:: table-row Tag div Class kk\_csv2table Description The container around the whole table .. _table: table """"" .. container:: table-row Tag table Class No own static class Description Set by content of the resp. flexform field .. _tr: tr "" .. container:: table-row Tag tr Class tr-headline tr-odd tr-even Description For an alternate display (posible different background-colors!?) “tr-headline” only inserted in a possible first-row-header or self defined header (flexform) with tag “” (Field “Header data in 1 :sup:`st` row” = 1). .. _td: td "" .. container:: table-row Tag td Class td-0 / td-1 ... td-last Description For all table-cells .. ###### END~OF~TABLE ###### .. _CSS: CSS ^^^ one suggestion for a cascading-style-sheet: div.kk\_csv2table { font-size:1.2em; } div.kk\_csv2table table { border-collapse:collapse; empty-cells;:show; border:1px solid gray; } div.kk\_csv2table tr.headline { background:#666; color:white; } div.kk\_csv2table tr.odd { background:#d8d8d8; } div.kk\_csv2table tr.even { background:white; } div.kk\_csv2table td, div.kk\_csv2table th { border-bottom:1px dotted #ccc; padding:2px 5px 2px 5px; font-size:0.8em; } div.kk\_csv2table th { border-bottom:3px double #ccc; } .. _Known-problems: Known problems -------------- No problems found up to now .. _To-Do-list: To-Do list ---------- Nothing planned, did I miss anything? .. _Changelog: Changelog --------- **2017-02-04: Look into the extensions ChangeLog file** **2009-06-19: Kurt Kunig** :: Thanks to Daniel Minder for the support - 1 more flexform field: “CSV-Code” - combo-box - field: “UTF8 encode” is now a combo-box - convert html with “htmlentities(... + direct Code-parameters)” **2009-06-16: Kurt Kunig** :: Thanks to Daniel Minder (University of Bonn, Institute of Computer Science IV) for the hints! - 1 more flexform field: “UTF8 encode” Yes or No - minor bugs fixed: Column-Delimiter within a text - convert html with “htmlentities(...)” **2008-06-20: Kurt Kunig** - 2 more flexform fields: “File incl. path rel. to fileadmin” and “Text delimiter” (if desired) - Tabs as delimiters are allowed, take [T] as the delimiter-sign - doesn't matter if utf-8- or ANSI-coded input data - Line-feed within a cell in a text-field (text-delimiters!!!) are allowed **2008-06-04: Kurt Kunig** - 2 flexform fields more: “own column-headers” and “table class” (if desired) - empty rows will be ignored - max. csv- or txt-file-size = 5 MB - last -tag with colspan if the one or other row has less cols than maximum cols **2008-05-30: Kurt Kunig** Initial release |img-3| Ext: kk\_csv2table - 5 .. ######CUTTER_MARK_IMAGES###### .. |img-1| image:: img-1.png .. :align: left .. :border: 0 .. :height: 707 .. :id: Grafik1 .. :name: Grafik1 .. :width: 517 .. |img-2| image:: img-2.png .. :align: left .. :border: 0 .. :height: 565 .. :id: Grafik2 .. :name: Grafik2 .. :width: 520 .. |img-3| image:: img-3.png .. :align: left .. :border: 0 .. :height: 32 .. :id: Graphic1 .. :name: Graphic1 .. :width: 102