Differences

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

--- tips:table_editing [2010-03-22 21:20] – 87.210.233.157
+++ tips:table_editing [2016-02-29 10:36] (current) – old revision restored (2014-08-05 15:52) 141.65.129.192
@@ Line 1: / Line 1: @@
 ====== Table Editing ======
-[Also look at plugins if you need enhanced table support]
+Editing tables in DokuWiki can be quite difficult, especially when your wiki contains a lot of them and/or big ones. There are several ways to help you.
-// This is just a note, you are invited to rewrite it in a more elaborated way. //
+===== Plugins =====
-We all know that editing tables in DokuWiki is no feature to promote, but rather a burden.
+  * [[plugin:edittable]] provides a visual table editing and inserting interface
+  * [[plugin:fckg]] WYSIWYG editor.
+  * The [[plugin:csv|CSV plugin]] has the advantage that you can link directly to a CSV file (e.g. a Google Spreadsheet file).
-It seems that the easiest way is editing externally by converting to and from CSV files that can be edited by programs like Excel. Converting can be done by search and replace of %%^%% and %%|%% in any text editor, maybe your CSV editing program also allows to define the cell separator as %%^%% or %%|%%. Note that you should have empty cells at the start and end of each line since DokuWiki needs %%^%% or %%|%% there - defining empty cells should result in separators at the "visible" start and end of lines. The rest is copy & paste (via a text editor).
+===== Openoffice.org extension =====
-NB: I don´t think that I am the inventor of this method, but obviously no one has written it down yet.
+There's an Openoffice.org extension, [[http://www.lucsorel.com/index.php?page=downloads|calc2dokuwiki]], to export to DokuWiki format from Calc.
-I know other wiki tools can edit the table directly, I hope this feature can be improve for DokuWiki.
+===== Manual way =====
+You can edit tables by editing externally by converting to and from CSV files that can be edited by programs like Excel. Converting can be done by search and replace of %%^%% and %%|%% in any text editor, maybe your CSV editing program also allows to define the cell separator as %%^%% or %%|%%. Note that you should have empty cells at the start and end of each line since DokuWiki needs %%^%% or %%|%% there - defining empty cells should result in separators at the "visible" start and end of lines. The rest is copy & paste (via a text editor).
-> Using the WYSIWYG plugin helps a lot to directly edit tables like you'd do it in excel.
-> Hope it can help.
-==== Openoffice.org extension ====
-There's an Openoffice.org extension, [[http://www.lucsorel.com/index.php?page=downloads|calc2dokuwiki]] to export to DokuWiki format from Calc.
-==== CSV plugin ====
-I find The [[plugin:csv|CSV plugin]] for dokuwiki works very well, with the advantage that you can link directly to a CSV file (e.g. a Google Spreadsheet file).