English plugin page
deutsche Plugin-SeiteThe automatic update for WP-Table Reloaded 1.8 should be available in your WordPress admin area shortly. With that, a long period of time without an upgrade has finally ended.
Changes are:
- feature: Updated JavaScript libraries to DataTables 1.7 and TableTools 1.1.4
- enhancement: Template tag functions now accept strings and arrays for passing parameters
- enhancement: Backwards compatibility for deprecated functions, no longer use them
- enhancement: Sort on “Edit” screen no longer moves header or footer row, if they are activated
- enhancement: Added plugin filter hook to change table content prior to rendering
- enhancement: Added “summary” attribute filter for
<table>HTML element - enhancement: RTL-languages supported in frontend CSS
- enhancement: Adjusted default CSS for new default theme “TwentyTen”
- bugfix: Fixed search to not find table IDs with the same beginning
- bugfix: Fixed problem with certain call-by-reference functions in certain versions of PHP
- bugfix: valid HTML on “Plugin Options” screen
- bugfix: Fixed notice due to not initialized variable
- bugfix: Fixed DataTables translations for Danish and Norwegian
- languages: Added Polish and Belarusian
- languages: Added Romanian for DataTables
You can download WP-Table Reloaded 1.8 from the plugin’s page or from the WordPress Plugin Directory.
If you like the plugin, I’d be very happy if you would rate it in the WordPress Plugin Directory. You might also consider a donation or have a look at my Amazon wishlist. This will encourage me to further develop the plugin and keep giving countless hours of support. Thank you!
If you experience any trouble, find bugs or have feature requests, please don’t hesitate to contact me via the means mentioned in the support section. Please make sure to carefully read the plugin’s page as well as the Documentation. A lot of questions are already answered in the Frequently Asked Questions section.
I hope you enjoy the new version! :-)
Congratulations!
Your blog has not been updated for a long time. You must be busy on this update all the time. Thank you for this new version!
Danke für dein gutes Plugin.
Jetzt ist es mal an der Zeit, dir was zu spendieren!
Eine Frage – wie soll man die Datenbanksicherung der Tabellen am schnellsten und besten durchführen?
Alles einzeln zu exportieren ist stressig, unter Optionen in der WP-Exportfunktion etwas problematisch?
Freue mich auf Deinen Tip!
Matthias Henzler
Hallo Matthias,
vielen Dank für deinen Kommentar, schön, das zu hören! :-)
Eine Sicherung der Tabellen des Plugins machst du am besten über eine “WP-Table Reloaded Dump-Datei”, dies kannst du auf der “Plugin-Einstellungen”-Seite tun.
Du erhälst dann eine Datei, in der alle Tabellen und alle Einstellungen/Optionen des Plugins gesichert sind. Diese Datei kannst du dann falls mal etwas schief geht (oder z.B. auch bei einem Umzug auf einen anderen Server) wieder importieren, um genau den Stand der Datei wiederherzustellen.
Schöne Grüße
Tobias
The plugin in fantastic! Since it works from the DataTables jQuery library, is it possible to add in the show/hide row information as shown here: http://www.datatables.net/examples/api/row_details.html
Any help would be apprciated!
Thanks,
Dave
Hi Dave,
yes, it would be possible to use that script, but you would have to integrate it on your on. To start, you’ll need to disable the usage of DataTables for the table in question and then use the code from that site as the initialization code (after adjusting it to the correct HTML ID). That code needs to be manually added to the post/page with the table, or by using a plugin filter hook.
Regards,
Tobias
Greetings,
After upgrading, some (not all) custom CSS does not work anymore. Hover doesn’t use my custom color, nor does the text color in specific rows.
I’ve checked this in several web browsers, cleared cache, different PCs, etc., etc. All CSS is fine and the colors are there, but no love from WP-Table Reloaded.
Ideas?
Hi Michael,
thanks for your report. Indeed, I have made some minor changes to the default CSS, which was necessary to fix a styling problem for the new WordPress default theme “TwentyTen”. In rare cases, these changes might influence some custom CSS. And that happened in your case, I guess. However, it should be easy to fix that again. If you email me the URL of the page with the table, I’ll of course take a look at it and try to find out the necessary adjustments in the Custom CSS.
Best wishes,
Tobias
Hi Tobias. First of all thank you so much for creating this amazing plugin!
Can I update and keep my current tables untouched? Or should I do a backup?
Thanks!
Thiago (from Brazil)
Hi Thiago,
thanks for your nice comment!
Yes, you can update and your tables will be untouched. Just to be safe, I do recommend to make a backup though: That is very easy by creating a “WP-Table Reloaded Dump File”, which you can do on the “Plugin Options” screen. But very likely you won’t need it.
Best wishes,
Tobias
Hi Tobias, great plugin… thank you!
In which CSS template can I change the border color? I just want to get rid of the fine lines in the table.
Thanks again!
Nigel in Los Angeles
Hi Nigel,
thanks for your comment.
Changing CSS is best done in the “Custom CSS” textfield on the “Plugin Options” screen of WP-Table Reloaded. There, you should enter all table related CSS code (instead of messing in any files!). Help on the border removal code can be found in the FAQ section here.
Best wishes,
Tobias
Tobias,
First and foremost, this is a wonderful plugin, so thank you for developing it.
My question: Can I use “alt” tags in the tables?
Thanks again.
David
Hi David,
you mean “alt” tags for the HTML code of images? That is not a problem, you can use any HTML in the table cells.
Best wishes,
Tobias
Hallo,
seit dem Update auf Version 1.8 werden meine Tabellen, wenn ich mit der Maus drüber fahre, nicht mehr farbig angezeigt.
Ich habe folgende Einstellung in der Zusatz-CSS stehen:
Damit soll meine Tabelle Nr. 5 beim drüberfahren gelb werden. Macht sie aber nicht, es ist nur ein dunkles grau.
Hallo Sven,
dieses Problem wird durch eine kleine Änderung im Standard-CSS verursacht, die ich leider für das WordPress Standard-Theme “TwentyTen” vornehmen musste.
Um das ganze bei dir zu korrigieren, ist nur eine kleine Änderung nötig. Bitte probiere es mal mit
Schöne Grüße
Tobias
Ja, nun funktioniert es. Danke!
The zebra background and custom CSS doesn\’t work anymore.
Hi,
there was a slight change in the default CSS of the plugin to make it work nicely with the new WordPress default theme “TwentyTen”. Likely those changes broke the mentioned features on your site. If you provide the URL to your table, I’ll gladly assist in correcting the code to fix it.
Best wishes,
Tobias
Hallo Tobias,
jepp, ein klasse Plugin keine Frage! Meine Seite kann gar nicht mehr ohne ;-)
Was mir aufgefallen ist, ich habe eine Tabelle angelegt und wollte diese ohne Rahmen. Dazu hab ich in deinen Anleitungen folgendes gelesen:
Dazu noch die Tag-Erweiterung für den IE7:
[table id=N cellspacing="0" /]im Artikel eingefügt.Das hat klasse geklappt, bis zu dem Moment als ich nachträglich einen Tabellenkopf definierte. Dann gab es links eine Linie bis zum Seitenende.
Konnte das aber durch den zusätzlichen Eintrag von
lösen.
Evtl. liegt hier noch was im Dunkeln…
Gruß Thomas
Hallo Thomas,
vielen Dank für deinen Kommentar und die Hinweise.
Ja, das mit dem Rahmen ist leider nicht immer ganz so einfach :-) Problem ist einfach, dass es da so viele Möglichkeiten für gibt. Beispielsweise kann eben die ganze Tabelle, aber auch jede Zelle und sogar jede Zeile einen Rahmen haben. Zusätzlich kann man den Effekt sogar über Zellenabstände und den Tabellenhintergrund nachbauen. Und dann kommt noch dazu, dass eben sowohl das Theme als auch mein Plugin CSS-Code dafür laden. Dabei ist es eben nicht immer möglich, alle Konstellationen zu berücksichtigen, ohne gleichzeitig noch was anderes kaputt zu machen.
Schöne Grüße
Tobias
Hallo Tobias,
zuerst: Super!
Das Interface, das Tool selber, die Dokumentation, und der Service!
Den Tabellenrand konnte ich unsichtbar machen. Nun möchte ich Bilder und Text ohne Abstand zu den Rändern platzieren.
Damit ist es mir möglich, das Layout jenem der Seite anzupassen.
Viele Dank
arts
Hallo,
vielen Dank für das Lob.
Den Abstand zu den Rändern müsstest du mit diesem Zusatz-CSS entfernen können:
Wenn das noch nicht klappt, würde ich dich bitten, mal mit der URL zu deiner Tabelle im WordPress-Support-Forum zu schreiben. Dort kann ich “gebündelter” helfen.
Gruß
Tobias
Wirklich ein super Plugin! Wenn ich wieder Geld habe, dann werde ich endlich auch mal was spenden! Nutze ich schließlich auch auf fast allen meinen Blogs.
Mach weiter so!
Hello Tobias,
Thanks for your great plugin. The import option reduces lot of man power and time to add tables in a WordPress theme. God bless you.
2 out of 3 tables on this webpage have shrunk in width, I don’t know why, they used to be fine… Any way I can fix it? The “Open” table is fine, the ones under “Youth” and “Senior” are distorted.
http://www.nc07.com/?page_id=135
Hi,
weird, but I suspect a bug in the updated DataTables library. However, you should be able to fix it with a small line of “Custom CSS”:
Best wishes,
Tobias
Worked like a charm! Thanks a ton!
Hey Tobias!
I was wondering if version 1.8 includes a fix to the zebra striping issue fixed by “Alternating Row Highlighting DataTables Fix” or if I still need to use that when I upgrade.
Hi Ray,
yes, that issue was fixed in the latest DataTables version which is now included in WP-Table Reloaded 1.8. You should no longer need that custom fix.
Best wishes,
Tobias
Hi Tobias,
Thanks for a great plugin! I have found one small, but annoying problem with my installation.
I installed the plugin through the WP admin, imported a CSV table, but cannot edit it. Every time I try, I am logged out of WP. Logging directly back in takes me straight to the “Edit” page again, but no changes saved…
Any ideas?
Cheers
Andy
Hi Andy,
thanks for your comment.
Very likely this is due to a security extension that is installed on your server, either “Suhosin” or “mod_security”. I suspect that they somehow either don’t like the content of your table (because they think that it is security related) or they don’t like the variables that my plugin uses. For example, your table might contain “trigger words” like “select”, “insert”, and similar that are used in SQL queries.
In such cases, the extension will simply not pass any data to the receiving PHP scripts (including HTTP POST, HTTP GET and cookies), which leads to you being logged out.
Can you check if any of such security extensions might be the reason?
Regards,
Tobias
Hi Tobias,
Yes… the server is protected with “Suhosin Extension 0.9.6″. Do you know anyway around this type of issue – other than removing Suhosin?
Your help is much appreciated!
Thanks
Andy
Okay… it had something to do with the CSV file, I imported – it was created in MS Excel… must have inserted invalid characters!
Anyway, the problem is solved and it’s all working.
Keep up the good work!
Andy
Hi Andy,
thanks for the follow-up!
Great to hear that!
Best wishes,
Tobias
Thank you for this excellent plugin.
Vielen Dank für dieses ausgezeichnete Plugin.
Hi Jordun,
you are very welcome! :-)
Best wishes,
Tobias
Vielen Dank für dieses ausgezeichnete Plugin.
Faleminderit për këtë shtojcë të shkëlqyer.
Благодаря ви за тази отлична Plug-in.
謝謝你對這個出色的插件。
Mèsi pou sa a Plugin ekselan.
Kiitos tästä hyvästä plugin.
Asante kwa Plugin hii bora.
Diolch i chi am y plugin rhagorol.
یہ بہت اچھا پلگ ان کے لئے آپ کا شکریہ.
Grazas por este excelente plugin.
Hi Tobias, wondering if you’d be available to do some custom work for me based on your plugin. Please contact me if interested. Thanks.
I’m a Java and C++ programmer, new to WP. WP-Table Reloaded has saved me a great deal of time. Thank you.
It works flawlessly for all the themes I’ve tried. Column sorting works on all themes as well, except one. That one is, of course, the theme I’ve been messing with. I’ve spent hours trying to resolve the issue: Is there something obvious I should look for?
Thanks!
Hi Joe,
the theme needs to have a call to
in its “footer.php” file. Can you check if that is there?
If that is not the reason, can you maybe set up an example page for me to check out, where the table is not working as expected?
Best wishes,
Tobias
That was it.
I inserted and all is well with the world.
Thanks!
Hi Tobias,
Still enjoying your plugin daily, also the filter extension.
I have noticed that using the filter option in the table, the export to clipboard, CSV and Excel are disabled.
Only the printing option works.
Is this fixable?
Kind regards,
Ton de Gier
Hi Ton,
as far as I can tell, the export options are not disabled. They just need a second click to work. I don’t know the reason however, nor how this can be fixed for good. The options are offered by the TableTools extension of the DataTables library, and I offer both as an add-on only. You might try contacting the developer in the forums at http://www.datatables.net/forums.
Best wishes,
Tobias
Hello Tobias and thank you for the extension. It’s simply marvelous.
I just have one little question. I have managed to export the table data in XLS format using DataTables+TableTools. But the exported XLS file, when opened in Excel, has default column widths. If the data in the cells of the table is wide, the exported Excel file does not adapt the widths. No doubt the extension you made is wonderful, but maybe you could advise how to adjust the export settings for the Excel file, so that column widths are adapted. Thank you :)
Hi Jad,
thanks for your comment.
The DataTables and TableTools libraries are external libraries that were not developed by me, I just offer them as an add-on to my plugin. Therefore, I do not know all the internals about them, and need to refer you to the libraries’ developer in the DataTables forums at http://www.datatables.net/forums.
However, you’ll like get disappointed there about this question as well: The Excel export does only export the data in the table, but not the structure or any design features. Thus, I don’t believe that it is possible at all to also export the columns widths.
Best wishes,
Tobias
Oh, that’s bad. But anyway, the plugin still scores a 10/10 for its usability. You’re a genius.
Hi,
I just had an important question. I do understand that when it comes to software, one size may not fit all. So I wanted to ask will this plugin import huge Excel files with a lot of rows? I’m making a site where there could be more than 2000 rows. Also, in the WordPress control panel, I was unsure whether such a large number could be handled and how would the WP plugin settings panel display that. Would be a very long page. But since you are the author, you can comment better on it.
Hi Jad,
you are right, large sizes can lead to trouble. Over the last months I had to learn that large tables can indeed mean trouble. That is in different places: The database (the entire table is stored in one DB field), the server side (PHP configuration, memory limits, security extensions), and the browser side (all cells are shown on the page, so that would mean at least 2000 textareas which is a lot to handle).
So, to make things short: I’d rather recommend a custom solution with a custom database table and some PHP for such large amounts of data.
Best wishes,
Tobias
Thanks for the reply. Yes, exactly; 2000 textareas would be crazy for WP. If you have future plans for the plugin, may be you can include an option to connect it to a custom mySQL database so each time the user updates that database table (maybe via phpMyAdmin) the changes (new rows etc.) are automatically loaded by your plugin. That would be awesome.
By the way, I can get you book from your wishlist. It’s old and you might already have it though. WordPress Plugin Development (Beginner’s Guide) I read some of it a few months ago.
Hi Jad,
thanks for the suggestion, however, I don’t think that I will and can integrate such a feature into the plugin. In my opinion, that is way out of the scope of the plugin, as I see it. It would also only be useful for a handful of users, while everybody else would just get more confused.
Best wishes,
Tobias
Hi Tobias,
I have a client using an old version your plugin – version 1.4.2a., on an older version of WordPress (2.8, I think)
They have over 500 tables on their site created with your plugin.
I would like to upgrade them to WordPress to 3.0.1 or whatever it is now, and I would like to update your plugin.
With so many tables and no way to backup the original tables (just wasn’t an option at the time) without downloading each individual table, I’m a bit nervous! :)
So my question is: When I upgrade will all the tables be lost?
Do I need to turn the plugin off to upgrade and if I turn your plugin off will all the tables disappear?
I guess my big question is: What is the best way for me to upgrade without losing any of their current tables?
Thanks in advance!
Hi Susan,
thanks for your question.
Usually, it is pretty safe to hit the “Update” button. WP-Table Reloaded will not (on purpose) delete any of your data or settings. Of course I can’t give any guarantees, especially with such a large amount of tables, however, I have not heard of any real trouble with the update process.
To be really on the safe side beforehand, you should create a database backup (you should do that for the WordPress update anyways), especially of the “wp_options” table, as that is where all tables are stored.
Best wishes,
Tobias
Hi Tobias,
WP-Table Reloaded is an amazing plugin. It was just what I needed for a site, I’m currently developing, so thanks very much!
A couple of questions:
Firstly, is there any way to automatically display all available tables in ascending order by ID from within a page/post so that if a new table is created, it automatically appears beneath the previous table?
And secondly, I was wondering if you knew of a plugin with a similar functionality but just for WYSIWYG text rather than tables?
I’d like a create a new Top-level Admin menu item called “Website Text” where a user can edit specific areas of text displayed on pages of their website.
Then I’d like to reference it from within pages in the same way your plugin works.
e.g. [text-content id=1]
Many thanks,
Rik
Hi Rik,
thanks for your comment. Unfortunately I don’t have good news :-( I don’t know an easy way to show all tables ordered by ID automatically. It should be possible with custom programming though.
Unfortunately I also don’t know a plugin for displaying such text-content fragments. Have you thought about the idea of using 1-by-1-tables?
Best wishes,
Tobias
Ok, no problem. Thanks for the quick reply.
Where in the database is the table information stored? Perhaps I could query the database to find out how many tables there are?
I need WYSIWYG editors for the page content so 1-by-1 tables wouldn’t work for this application.
Hi Rik,
tables are stored as “options” in the “wp_options” table. However, I don’t recommend manually querying those. Instead, you might want to take a look at the source code of the “controller-admin.php” file, where you can see, how the “List of Tables” (which does contain every table) is created. You could use the same method to generate a page with all tables (instead of just a list of the titles, as in the admin area).
And another idea for the text content thing: You might want to take a look at WordPress’s new “Custom Post Types” feature, which basically allows easy managing of what you want, you would just need to create the Shortcode.
Best wishes,
Tobias
Hi Tobias,
Thanks so much for your help. Custom Post Types and Shortcodes is exactly what I was looking for.
Going to have a look into the controller-admin.php file now. Will let you know how I get on.
All the best,
Rik
Hi Tobias,
Working with your WP-Table Reloaded is still a great plesure.
Again, I want to do some things and am not sure if it is possible.
I made a plugin for builing a mailing report. The result from this I present on a page. What I really want to do is put the result in your table and than represent it on my page. Of course input in the table directly in my build plugin, not via the import CSV function.
Can you tell me if this is possible?
Thanks,
Ton
Hi Ton,
so, what you want is to use a WP-Table Reloaded table as the data storage for your plugin?
Well, in theory it is of course possible, but unfortunately there is no API available at the moment that would allow such a creation of tables from a different source. You could analyse the code from my plugin (especially the controller-admin.php file), to see how tables are stored, but I would not really recommend this as it is not very reliable to just copy some of that code.
A better approach in my opinion would be to create your own data structure and store that in the database and then use your own Shortcode to show those on the page.
Best wishes,
Tobias
Hi Tobias,
Thank you for this marvellous plugin – with a little CSS tweaking, it works wonderfully well for displaying football tournament tables.
Interestingly, I am building an English language history of the Nationalmannschaft…
MfG
Rick
Tobias, I’m tired and have given up hope of help in the WP support forum. I’m new to WP and I can read (but not write very well) HTML. I am using the new 2010 Weaver for template (extended of basic theme). I want to insert a table on the top of the page of posts and then have the posts show under table. The plugin doesn’t do that so I know I need to add the table ID in the template editor-but which element? I only want the table on that one page, not on any other pages. I know this is simple, but I’m afraid I will mess up the template.
Thanks
Leslie
Hi Leslie,
I’m not sure if I understood everything, but it sounds as if you will need the WP-Table Reloaded template tag function
You should paste that at the top of the template file that is displaying your posts.
Best wishes,
Tobias
Thanks for the reply. Yes, I figured that out, my confusion is that the template I’m using has more than one page template in the admin editor page. Here is the top of the template – so where? Only show on post page, not all other pages!
[Code stripped by WordPress]
Again, thanks so much for your response and your help!
Leslie
Sorry, I don’t see the whole code in the last comment – might be limit on space in your comments section, can I e-mail to you?
Hi Leslie,
no, that is actually a security restriction feature in WordPress, which does not allow HTML code to be posted in comments.
Unfortunately I can not help with the placing of the code in your template, as I don’t know the template, sorry. Just from your code, I can’t tell if that is the correct file, as there might be a different template used for your page. You should contact the developer of the theme and ask him for the correct place. Likely it is in front of the loop, after some sort of header.
Best wishes,
Tobias
Great idea, thanks! This post might actually help others with this frustration. Also, did not know about the security thing, also makes sense.
Again, thanks for your time!
Leslie
Hi Tobias,
Congrats on the excellent plugin!
It’s the first time I use it and I really like it.
Unfortunately I have a problem :(.
I’ve created a table, entered the data, but there are no sorting options in the header row.
“Yes, enable the use of a JavaScript library.” is checked.
“The first row of your table is the table head” is checked.
Also all options from “DataTables JavaScript features” are checked.
I tried the different JavaScript libraries without any luck.
The table is here:
http://test.marketing-forge.com/?page_id=25
Can you help me?
P.S.: I intend to use the plugin in other pages as well, so I may translate it into Bulgarian.
Hi Peter,
thanks for your comment. Nice to hear that you like the plugin.
As you mentioned that you have tried all three JavaScript libraries, and after checking your site’s source code, I strongly believe that there is a problem with the inclusion of the jQuery library.
As it seems, you are loading jQuery as part of the “wp-minify” plugin process. Additionally, you are loading the library from the Google CDN.
Due to including the library multiple times, very likely something got into a conflict.
Can you please try disabling other plugins that maybe deal with jQuery? Especially, please try without the wp-minify plugin and with loading WordPress’s default jQuery library.
Best wishes,
Tobias