Please read the Frequently Asked Questions and the documentation before asking for support. Thank you!
For help or support questions, use the WordPress Support Forums. Please open a new topic there (with the tag “wp-table-reloaded”). You should include as many information as possible, like version information, a URL to your site, etc. This makes it much easier for me to help you. You may write in English or German. Before posting though, please search through the existing topics. Maybe your question has been answered before? Thank you!
If my answer helps you to solve your problem, it is recommend to do a small donation, as I invest a lot of free time in answering support questions.
If you find a bug or have a feature request, please tell me about it by email with an explanation, as detailed as possible.
It would help a lot if you could add an issue ticket in the issue tracker on Google Code.
Below you can find all comments made thus far. Please keep in mind that most of the issues described here are solved in current releases. Also some pieces of advice I gave might not be valid anymore for the current release. It is no longer possible to add a comment. Use the Support Forums for your questions.


Tobias,
Sweet plugin, but I would like to have some additional work performed on it for my site. Please contact me and I will provide you with detailed specs for changes.
Thanks,
Keith
I am having problems importing CSV files with € (Euro symbol) in it. It becomes an unrecognizable square. Any ideas on how to resolve this?
Hi,
this is probably caused by different character encodings between the file and your database.
You could try changing the CSV files character encoding to UTF-8 (e.g. by “Saving as” with the Windows Editor).
If that doesn’t work, you could open the file and replace all € chars with the HTML equivalent “€” which should work in all browsers.
Otherwise, your only way is to manually fix it afterwards in the input fields.
Best wishes,
Tobias
The table does not show up on webpage, only the Shortcode [table id=2 /].
Hi,
this is most likely caused by your theme, which probably shows your posts by using the template tag “the_excerpt()” or a modified version of “the_content()”.
Are other plugins with shortcodes working?
Regards,
Tobias
Well… Another way is to type the text with Visual Tab instead of the HTML. :#
Then what you think you have, really is not.
Vielen Dank… This is a very nice plugin.
Hi Tobias,
Great plugin. Really makes tables easy. What I have noticed though, is that on a Mac in Safari, the table expands really wide outside of the theme template. Windows IE and Firefox are great. Is there anything simple I can do to correct this without having to be a coding expert?
Hi Jeff,
this might be caused by the different interpretation of CSS by the browsers. The CSS that ships with my plugin is generally not the problem, in most cases it is a conflict with the theme’s CSS.
Unfortunately I don’t have a Mac, so I won’t be able to test this and maybe find a fix. Could you ask in a CSS related web forum, maybe?
Regards,
Tobias
Hallo Tobias, bietet das Plugin eine Möglichkeit zur Massenänderung von Tabellen-Einträgen? Ist eine Änderung per SQL über die Datenbank möglich?
Danke im Voraus.
Hallo,
was meinst du denn mit “Massenänderung von Tabellen-Einträgen”? Natürlich kannst du den Inhalt mehrerer Zellen gleichzeitig ändern.
Änderungen per SQL sind leider nicht möglich, da Tabellen als sogenannte WordPress-Options gespeichert werden. Jede Tabelle liegt sozusagen in einem einzelnen Feld, daher ist auch kein einzelner Zugriff auf Inhalte möglich.
Gruß
Tobias
Hallo,
ein tolles Plugin. Kann man den Tabellenhintergrund auch transparent machen?
Gruß Elfenstern
Hi,
gute Frage… Das müsste mit folgendem CSS gehen:
Gruß
Tobias
Hi there,
Firstly congrats for such a successful plugin.
I am using this plugin at a finance blog here http://www.forum4finance.com
Here is an error which comes when using the search
http://www.forum4finance.com/?s=tax&x=18&y=8
and its been discussed here as well http://forums.digitalpoint.com/showthread.php?t=1658328
Please, if you can, have a look.
Hi,
thanks a lot for reporting this! That seems to be a really weird problem… From what I can see in the code, this could only happen, if all the rows of your tables would be hidden.
So: Are you using the “hide rows” or “hide columns” feature? And please email me the Dump File that you can export on the “Plugin Options” screen.
Thanks!
Tobias
I have a plugin question: How do you move the sorting arrows, so they’re not blocking the text?
Note table here:
http://bit.ly/8zBU4q
Thanks
Hi,
the arrows are included as a background image into the cell. Thus, text will be over it, if it is too long. In your case, you’ll either need to shorten your table headers or add manual line breaks into them, so that they don’t span the complete width.
Regards,
Tobias
Hi
I want to enter text/numbers in a cell. And I want them to appear in the center of each cell.
Example: I want to display “500″ in the center of a cell.
Thanks
Hi,
Please try this CSS code for the “Custom CSS” section in the “Plugin Options”:
Regards,
Tobias
Hi Tobias,
Great plugin I like it very much. I want to specify something in the custom CSS, but I don’t know how, so I hoped that you could help me.
As you can see on my page, the two tables that I created have different widths. I want to insert custom CSS, so that every table has the same width properties. On this occasion this should be 80% of the total width for the left column and 20% for the right column. Is this possible and how?
Thank you in advance,
Marko
Custom CSS commands are entered in the “Custom CSS” textarea on the
“Plugin Options” screen.
For changing your widths, try this:
(M and N need to be changed to your table’s IDs.)
You could also use
if you want it to be applied ID independent (i.e. on ALL tables of
WP-Table Reloaded).
Furthermore, it might be necessary to first set the width of the table to
100% with this:
Best wishes,
Tobias
Hi Tobias!
I’ve been using this plugin a bit and I think it’s great. I wonder if there is a way to make the table header static and the rest (tbody) scrollable like the way displayed here: http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=357
I tried to add “height: 100px” and “overflow: auto” to the CSS for .wp-table-reloaded tbody, but it didn’t work.
This feature is very useful for long tables where you want to keep the header always visible.
Thank you in advance!
/Magnus in Schweden :)
Hi Magnus,
thanks for that link! That’s indeed a really cool feature! But after looking at their code, I have to say that it is not easily implemented in my plugin. If you look closely, they are actually using two tables (one for the header and one for the data).
So if you wanted to build this feature in my plugin, I suggest that you also create two tables and put the Shortcodes in corresponding
divelements. Then you should be able to use the CSS as on the page.Best wishes,
Tobias
We love this plugin. I wish we could donate more but we are so broke – but this plugin is wonderful for us and when we actually start to make some money, we’ll donate more to you, because I use it every day for a few minutes!
Thanks for making it!
Hi Cori,
you are welcome! Thanks for your nice words! And I’m looking forward to your donation!
Best wishes to you and your project,
Tobias
Having trouble “deleting” an image after placing it in a cell. No matter what I do, the image stays there. I have tried deleting the row, deleting the image from the cell, deleting the image from my image folder…
Regardless what I do, it sticks there.
I had no choice, but to delete the entire table and start over.
Can you shed any light on this? As it stands, I don’t want to insert any more images w/o knowing how to easily delete them.
Thanks
Hi Sam,
your issue sounds very weird, and I have never heard anything similar!
My plugin does not handle images any different than text (after all the commands for inserting images, the HTML code, is all text, and my plugin does not care about what the text really means).
So, removing images is just the same as removing text: Press “Backspace” or “Del” until the code/text is gone.
Just a few questions to make sure that the problem is not within my plugin: What happened after you deleted the row and clicked “Update Changes”? Was the row gone or did it appear again?
I can only imagine this: Either your server (e.g. with the WP SuperCache plugin) or your browser (or a proxy server) where still caching the old version of the table with the image. This comes from the fact that you even deleted the image from its folder. (Imagine: How could my plugin show an image if it is not even there?) So, it really has to be a caching problem.
To check that, you could either use a different computer to check the contents of the page or clear your browser’s cache.
Best wishes,
Tobias
You are right, Tobias. And I meant to check it out on my laptop and got sidetracked. I agree it makes no sense, but such weird things can happen.
After I tried to delete the row and updated changes, the row was still there. However, I also simultaneously added some rows and updated changes and the added rows appeared.
Thanks for responding. I will look at it again tomorrow.
Donation to follow. Quite worth it.
Tobias, I really like your plugin and have used it for over 50 tables on a site I am building for a friend. In fact I like the plugin so much that I just made a donation. On these tables the text in some cells needs to be made red. The text on some cells needs to be in bold. I have spent hours over the past few days reading FAQ’s, documentation, forum comments and still I have not been able to get these changes to show up. I am positive it is me doing something wrong. Perhaps you can explain in simple terms how to make these changes.
Hi Terry,
thanks for your donation! I really appreciate it!
Regarding your question: The best way would be to start with the question “How can I highlight certain cells or their content?” from the FAQ. Basically you have two possibilities as described there. As you say that you have several cells that need special formatting, I would recommend the
<span>tag.If you email me the link to your page with the table and what cells shall be highlighted, I’ll be happy to give you more detailed instructions. That way I could also check if something else on your page (i.e. CSS commands in your theme) are messing up the styling that you have tried so far.
Best wishes,
Tobias
Tobias, sorry for the delay in thanking you for helping me. The tables are working fantastic, look great and I am anxious for my friend to get his site online so that it can be shared with others. Now using the tables at a site being built for our communities youth baseball league. http://pleasanthillbaberuth.com/ Players are to be assigned teams soon and at that time the tables will be online. Thank you once again for the work, you have put into this fantastic plugin.
Hello Tobias,
The plugin is working really well. I want to use the following command from DataTables though: http://datatables.net/examples/api/multi_filter.html
I have inserted it into “Plugin Options” > “Custom CSS”, but it doesn’t work.
Do you know where I can insert this code and get it to work? If it works, I will definitely make a donation.
Best regards,
Cas
Hi Cas,
thanks for your question! It looks like your mixing about CSS code and JavaScript here :-)
JavaScript (i.e. additional DataTables commands) can not be entered in the Custom CSS section!
Instead they can be entered in the “Custom Commands” textfield on the “Edit” screen of the table.
However this will only work for small pieces of code, but your code probably spans several lines.
This means that you’ll need to go a different way, by using a “WP-Table Reloaded Extension” that inserts the necessary code into the page for you.
The easiest way to achieve this would be to email me your code, and I will then try to wrap it into an Extension for you. That would be easier and quicker, because I don’t know how detailed your knowledge in PHP and WordPress plugin filters is, and there are a few things that you would need to watch for.
Regards,
Tobias
The plugin looks great, just starting to play around with it and would like to use it in a sports site. One major need however, is the ability to compile data. Is there any way that you know of that at the bottom of the table it could add up wins or losses or any number. Lets say I have a team schedule table and it adds up all of the points scored per game (column) at the bottom? Am I way off base or is this a possible extension? Thanks!
Hi Matt,
thanks for your question.
Unfortunately I have to disappoint you. This is not easily possible with the plugin. (It is designed to be used for showing tables, but not really to replace a full-featured spreadsheet program.)
Mentioned that, I recommend the following procedure for your table:
Set it up and update it in e.g. Excel or OpenOffice Calc. You can do any calculations there. Then use the export feature to export as a CSV file. Then you can import that file into WP-Table Reloaded. This is especially useful with the “Replace existing table” feature, so that you can update your table on the web easily with the data from your spreadsheet table.
Hope that helps!
Best wishes,
Tobias
Hey, thanks for the work on this plugin, really nice! I am just wondering how I would go about doing a few things.
1. remove the search box
2. remove the show entries
3. make the default show entries infinite
Thanks
Hi Alex,
thanks for your comment. You can find checkboxes for all three features on the “Edit” screen of the tables, in the “DataTables JavaScript Features” section.
Best wishes,
Tobias
Hi,
I have installed your plugin through WordPress and then always get the error:
Fatal error: Call to undefined function plugin_dir_path(). I guess, I’ll have to install it manually. Right?Hi George,
manual installation will not help in this case.
The problem is that you are still using an old version of WordPress. That mentioned function was added in WordPress 2.8 and does not exist in prior versions. Thus, you’ll need to update your WordPress (I recommend to using WP 2.9.1.) Then, WP-Table Reloaded will work just fine.
Best wishes,
Tobias
Danke für das tolle Plugin, Tobias.
Wozu dienen eigentlich die Button “Link einfügen” und “Bild einfügen” im Backend unter “Bearbeitungsfunktionen”?
Wenn ich darauf klicke geschieht einfach nichts.
WP 2.9.1
Mit quedlinburgigen Grüßen
jwqlb
Hallo,
die Buttons sind natürlich da, um Links und Bilder in die Tabelle einzufügen :-) Beim Klick darauf wird normalerweise ein kleiner Dialog gestartet, der dich nach den nötigen Daten (URL, Text, …) fragt, bzw. dich ein Bild wählen lässt.
Wenn bei dir wirklich gar nichts beim Klick auf die Buttons passiert, hast du entweder JavaScript deaktiviert, oder es fehlt eine benötigte Script-Datei, oder eine andere macht Probleme.
Gruß
Tobias
Great plugin, Tobias.
I started using it for our site. I use Firefox and finished the table and thought, wow, that looks good, but then I looked in IE and the table spreads accross the right going under the right column. Any ideas? I’m sure you’ve seen this before. (I couldn’t find the answer anywhere.)
http://www.kwikchex.com/2009/12/annette-brooke-mp/
Thanks
Mark
Hi Mark,
thanks for your question. I had a quick glance in IE 7 and can confirm the problem. (Not in IE8 and Firefox though.) This probably means that IE7 doesn’t really like the CSS code.
I don’t have a definite solution, but you could try this:
If it doesn’t help, I recommend asking in a more CSS related forum somewhere on the web, as this is more of a problem with your theme.
Best wishes,
Tobias
Danke für die schnelle Antwort.
JavaScript habe ich in Deinen Menus aktiviert.
Was kann ich sonst noch machen?
Mit quedlinburgigen Grüßen
jwqlb
Tobias,
Fantastic plugin. One feature I have been looking for ALL over the web, maybe you can help or point me in the right direction. I would like to present a list of products to the user with checkboxes. They could then pick 3 and then a table would show them side by side, similar to this:
http://naturaltravelkit.com/saludguide/green/multivitamins/
(I created that one by hand)
CNET Reviews is an example of a site that has the functionality, I’m trying to describe:
http://reviews.cnet.com/cell-phone-reviews/?sa=100021&tag=centerColumnArea1.0
Thanks in advance,
Harry
Hello Harry,
I’m afraid I can’t help with this. I also don’t know a solution that delivers what you need.
You will probably need to program the feature yourself, e.g. with JavaScript.
You’ll need a button that takes the checked checkboxes and then removes/hides unneeded columns from the products table (for which you can of course use my plugin).
Best wishes,
Tobias
Hi,
great plugin! Is there a way to integrate Google Maps? For example, my data table consists of places around the world. It would be cool to have the Google Maps API integrated to show the locations on the map!
Hi chip,
thanks for your question.
Sorry, but Google Maps integration is not available. My plugin is designed to show table data, what happens after that is up to the user. I compare showing maps to making graphs of the data, which both is just out of the scope of the plugin. There would just be to many things related to this, so both these features will likely not be included by me.
Of course you could try adding the API yourself, by developing a plugin that grabs your locations from the table with some JavaScript and passes them to the Google Maps API.
Regards,
Tobias
This is a great plugin!
I would like to change the description that precedes the search input box from “Search:” to something else. I can’t locate the right script to change it in. Where would I find it?
Thanks,
Kristin
Hi Kristin,
thanks for your question. Changing that “Search” text is possible, but requires some work (changing a file, writing an Extension).
As this would be very useful to others as I could imagine, I’d love to write a blog post about this, giving step by step instructions on how to change those strings.
Does that sound good to you? It would probably be ready within the next week.
Best wishes,
Tobias
Thanks Tobias,
I looked through every single file. Now I know why I couldn’t find it. Just to make sure we are talking about the same thing. I am wanting to change the word “Search:”, preceding the search input box to “To check property price and availability, type partial address here:” (I was thinking that I would just be able to find the word and replace it with this statement.)
We just launched this new site last month and this page of the site is the most commonly visited. I will definitely make a donation to your cause! One other thing you might consider is adding a column that is not published but just a reference for the user to note what is in each row. When we want to change the status of the properties we are managing on this list, we have to look at the picture file to figure out which property is which. Otherwise, it’s very easy to use!
Thank you again,
Kristin
Hi Kristin,
well actually you are able to modify this string and have it replaced instantly. How that is not the recommended way, because your changes would be gone everytime when upgrading the plugin. That’s why I really suggest using the way with the Extension. But until then, you could of course change it in the original file. The file is called “lang-[lang].txt” in the “datatables” subfolder of the “languages” folder of WP-Table Reloaded. “[lang]” is the language that is set in your wp-config.php, probably “en_US” or “default”. In that file, you’ll find the “sSearch” string that needs to be edited.
Regarding your second question: This is exactly what the “Hide columns” feature is designed to be used for. Just create your column, select it with the checkbox under it and click “Hide” for “Selected columns”. The column will then not be shown on frontend tables, but only in the admin part. To better see that, it will be highlighted in red.
And thanks for your willingness to donate, I really appreciate that!
Best wishes,
Tobias
Tobias, thanks for a nice plugin.
I am (still) working offline with my WordPress blog and fell on the first hurdle with your table plugin. I can not inport a Excel (.xls) table. I have tried all different import methods, i.e. CSV, etc. I have tried using both a .xls file and resaving the Excel file as CSV. The best output is a wing ding look a like table. Is there any words/symbols that should be avoided for instance Swedish å,ä,ö?
Most of the questions in this forum is phase 2, I am stuck on phase 1.
All help appreciated.
Br,
Stephan
Hi Stephan,
thanks for your comment.
It looks like you hit a known problem, for which unfortunately there is no real fix yet.
Importing a table from Excel requires an export to CSV within Excel. That CSV file can then be imported in WP-Table Reloaded. However, it looks like the import mechanism (for which I use an external library) is not very robust. Mostly this is because of different character encodings in files, due to some special characters or symbols (as you mention some). The weird thing is that this is not always the case and that the same file can work on one server, but does not on the other.
Thus, I do not have any real fix for this. For most people this works: Open the file in the Windows Editor (Notepad) and click “Save as”. In that dialog you can choose the character encoding. You should now try all of them (one after another), i.e. change it, save, try to import and eventually repeat if necessary.
If that does not help, try removing the special characters (which you would have to insert again later).
Sorry for not being a great help with this problem.
Best wishes,
Tobias
Congratulations for the plugin! I’m not a programmer and I’m doing some tests. I would like to ask one question. Is it possible to copy a row from one table and paste the row into another table?
Thanks
Hi,
great to hear that you like the plugin. :-)
No, it is not possible to copy one row to another table. As most users have rather small tables, I don’t really see the benefit of programming this (as it is not trivial), because it is much easier to open the two tables in two separate browser tabs and copy and paste from the input fields.
Regards,
Tobias
Hi Tobias,
I think your plugin is fantastic. However, I am having trouble with a margin or padding setting. On the http://www.arlingtonvt.org/listers/grand-list/ site, the table wants to create an awful gap between it and the title of the page.
Lastly, I imported the grand list but every time I actually go into the backend to access the data, it crashes both Safari and Firefox.
Tobias, other than these factors, you have a great plugin. Yes, once I actually get these fixes in, I will donate!
I hope to hear from you.
Cheers, Fonda
Hi Fonda,
thanks for your question. Unfortunately I don’t know if they can be solved easily. The padding/margin problem might have several sources, e.g. a conflict of CSS with your theme. I was not able to find the reason, but it might be the large width of the table, compared to the available space. Have you tried with a different theme, like e.g. the WordPress Default theme?
For the problem of crashing browsers: This has never happened to me (nor as anyone reported this). Thus, I don’t know what might be causing it. From your description and taking into consideration the size of your table, it might just be that the available memory on your computer is not enough, so that the browsers crash.
Regards,
Tobias
Hallo,
unter dem Bereich zum Anpassen der Tabellen-Eigenschaften fehlt mir der “Speichern”-Knopf.
Dadurch kann ich die erste Zeile nicht als Header definieren, etc.
Was tun?
Viele Grüße,
Steff
Hi Steff,
einfache Antwort: Irgendeinen anderen “Speichern”-Knopf auf der Seite nehmen :-) Sie speichern alle das gleiche und nicht nur den jeweiligen Bereich.
Ich habe einfach unter den “Einstellungen zum Tabellen-Layout” keinen hingebaut, weil ja schon nach dem anfangs geschlossenen “Funktionen der DataTables-JavaScript-Bibliothek” wieder einer kommt.
Gruß
Tobias
I also like the plugin, but the website’s tables, I am trying to import don’t work. Could you make a way to support Google Spreadsheets?
http://spreadsheets.google.com/pub?key=pyEb9ECTWOWOIklKtQDhLDg&gid=0
This is one of the sheets I have tried to do. I also tried exporting to CSV, converting to XML, but CSV didnt work right, I got one column of all the data. And XML didn’t work at all. So if you can import the spreadsheets directly (from a published web page,) it would help a lot.
Thank you for a wonderful plugin.
Hi Spitt,
thanks for your comment. Direct support for Google Spreadsheets is not possible at the moment. It would just be to much work, especially as the other import methods are usually working fine.
The problem with the import as HTML from Google is that the table HTML they use is not simple enough to be imported (they have several tables inside each other).
Thus, your only chance for importing a table from Google Spreadsheets is, to save it as CSV. You say that you got one column of all the data only. That means that the CSV file is somehow corrupted, I guess. You could try opening it in Excel and exporting it again from there.
Best wishes,
Tobias
Thank you for an excellent plugin. Once I get it configured, it will save me hours of work in future posts.
I have one problem. Under “Table Style Options/Row Highlighting”, I have that option unchecked, however upon saving and then refreshing my site, it still highlights each row, when I hover over them. How can I get it to stop doing this?
One other thing. If I start at “Home”, I see the tables, but if I click on one of the categories, the table goes away.
Thanks!
Hi Shane,
thanks for your questions!
Those issues are caused by your theme as it seems. I had a quick look at your page and saw the following JavaScript in the page (and it seems that it was added by your theme):
This JavaScript will add the row hover, no matter what see setting is within my plugin (in fact that setting is applied correctly, it just has no chance against this JavaScript, so to speak). Thus, if you find this JavaScript and remove it, your tables should be good. (Additionally to the row hover, the script will also add the alternating row colors again, by the way.)
For your second question: It looks like your theme’s “category.php” does not show posts in their entirety, but modified. In this case, it seems to apply an additional function that removes HTML (i.e. the table commands) from the post.
To check both of these issues, you could try testing again with the default theme of WordPress enabled. Both issues should be gone then.
Best wishes,
Tobias
Wonderful plugin… Bravo! Is there a way to have the owner of the website update the table via the page instead of the tools in the admin? I’m a web developer and I’m not sure all of my clients can handle being in the admin section of the WP site. Would be great to have an option where they can add/delete and change records in the table right from the page they are displayed in… Of course it would need to ask for a username and password and be contingent on them successfully entering that data.
Hi Paul,
thanks for the question. Editing right on the page where the table is shown is not possible and I don’t know, if it will be. As you already said, security is a large concern in this, therefore this would have to be developed with great caution. But I will put it on my list of ideas for future versions.
Until then, you have the possibility to make the plugin add an “Edit” link beneath the table, that will take the user directly to the “Edit” screen for that table (if he has the appropriate rights to do so). Additionally you might consider moving the “WP-Table Reloaded” menu entry to the main menu, instead of having it under the “Tools” section. This should help your clients find it. And usually the WordPress admin UI is pretty easy to use, so I don’t really see this as a problem (well except maybe, if your clients have never used computers before ;-) ).
Best wishes,
Tobias
Hi!
Is it possible to have PHP inside table cells? I’m trying to fill one cell with a little bit of PHP that returns a “rating” of sorts. At present state, part of the PHP gets erased and result is incomplete code in the cell.
Hi Tuomas,
thanks for your comment and email. It is not possible (by default) to have PHP executed in cells. Mainly this is for security reasons, as it would to hard to add a suitable and secure user access management. After all, also non-admin users can create tables by default, and severe security issues could be introduced when allowing PHP code in cells.
But there is a way to have PHP in cells evaluated, with a WP-Table Reloaded Extension.
I’ll publish details in a future blog post in the Extension series.
Best wishes,
Tobias
Hi Tobias,
first of all thanks, thanks, thanks for your great plugin. I’ve been searching for something like this for ages… Finally I found it and it works great, only one thing is missing: Sorting arrows are not showing and even if I found many places where you say “modify CSS ../img/bg.gif” etc., I can’t make them appear. Maybe I’m missing something… Could you please help me?
The page is this:
http://pro2.unibz.it/projects/informateria/nuovo-glossario-interlingua/
Bye!
Hi Gianpietro,
thanks for your comment.
I had a quick look at your site and have good news: The problem is caused by some CSS code of your theme.
In your theme’s “style.css”, you’ll find the lines
That CSS code is removing the sort arrows from the tables. Thus, if you remove the CSS from the file, the arrows will show :-)
Best wishes,
Tobias
You are the best!
Solved! Thank you so much!
Keep my address, if somehow you need a contact at Bolzano University. I’m teaching there.
Good luck.
Hi Gianpietro,
no problem, you’re welcome! And thanks for the offer! Maybe I’ll visit Italy soon :-)
Regards,
Tobias
Great plugin.
I want to change the default “10″ in the “show entries” dialogue to make the default “100″. Is that possible?
Thanks much…
Hi Dennis,
that question is answered in the FAQ section.
Best wishes,
Tobias
Simply adding this plugin to my plugins folder causes Error 500, when I try to activate it from the “Plugins” page. It also conflicts with the WP Stats java page, causing it to not display. After turning off and then ultimately deleting WP-Table Reloaded, my stats page worked again.
(Using 2.9.1)
Hi mahvin,
that error when trying to activate the plugin is very likely caused by insufficient memory that your WordPress can use. Depending on the number of plugins on your site, the default memory that your server grants to PHP scripts might not be enough. Please try increasing the limits with the instructions from the Codex. You should also check, if your server is running PHP5 and not the outdated PHP4 to execute WordPress. Depending on your webhost, you might have an option for both these settings in the webhost config menu.
Regarding the WP Stats issue: I don’t yet know what causes this, but it might be related to the other issue.
Best wishes,
Tobias
I’ve just upgraded to your latest version and now my tables have borders and I don’t see an option to remove them. I’ve defined column width size in the CSS of the plugin and added border-style: none; and it’s still showing. Can you let me know how to remove it?
Hi Elisha,
thanks for your question. This happened because I had to apply some changes to the border handling in the latest version, for better compatibility with certain CSS.
Therefore, I added your question and the answer to the FAQ. The relevant question is “How do I remove the borders from a table?”.
Best wishes,
Tobias
Hello Tobias,
Excellent Plugin, exactly what I was looking for. I wanted to ask, how I can align cells or columns vertically. Would it be this?
Thanks
Hi Anthony,
thanks for the question.
You got it almost right.
.wp-table-reloaded-id-Nwill only select the entire table, but not the single cells. That’s why you’ll have to addtdto the selector, likeBest wishes,
Tobias
How can I combine cells with “rowspan” and “colspan”?
Thanks a lot.
Hi Javier,
you can use the buttons “Add rowspan” and “Add colspan” (located under the table data input fields on the “Edit” screen) for that. The little “?” button explains how to do it.
Basically you’ll just need to add “#rowspan#” or “#colspan#” to the cells.
Best wishes,
Tobias
Hi Tobias,
Just installed the plugin and doing things “by the book” … but no joy.
I created a table, got the shortcode
[table id=1 /], then tried inserting it into the HTML editor (just straight copy) of a post – all I get is the line of code[table id=1 /]:-(I tried using the ‘Table’ button in HTML, clicked on the table shown to insert… all I get is the line of code :-(
You say in the instructions to “insert the shortcode in the appropriate place in the editor”. Sorry, but “appropriate” isn’t clear to me.
I am a complete dummy with code…so please be gentle :-P
Please help, much appreciated. Thanks :-)
Regards
Hi Tomaz,
thanks for your question.
From your description, it sounds that you have done everything right.
(The “appropriate place in the editor” is actually refering to the position of your table in the text (i.e. after a headline or whereever). It does not refer to the screen where the editor is in.)
The problem seems to be more with your theme, or another plugin, that break the Shortcodes.
Can you try switching to the WordPress Default theme and see if the Shortcode works there?
Also, please provide the URL of a post where the problem happens.
Best wishes,
Tobias
Hello Tobias.
First of all thank you for spending all this time to make a plugin for WP. I’ve been using WP a lot and every time I install a new site I find out more and more usefull products!
My current “problem” lies with the color coding of the header of the table. (I’m using the table a s a DKP listing for a guild in “World of Warcraft”.) As seen on this page:
http://perseverance-eonar.eu/?page_id=19
the Field bar (Name, Class, Rank, Current standing, total earned & total spent) is in white letters. Is there a way I can change this to black letters? Because now it’s hardly readable.
Thank you in advance and have a nice weekend!
Best of wishes,
Thomas
Hi Thomas,
thanks for the question.
That’s easily possible. Just add the following code to the “Custom CSS” textfield in the “Plugin Options”:
Best wishes,
Tobias
Hi Tobias,
First of all I have to say I’m very impressed by your plugin. Who’d know tables could be so well integrated into websites. Chapeau!
I have just a little question; is there a way to set the default “Show entries” to 100?
Oh and while you are at it :) I would like to use it to show people a table without the “Show entries”, “Search”, “Showing * to * of * entries” and the buttons. It’s less neat I guess. This information isn’t necessary if the default “Show entries” is set to 100.
Kind regards,
Sjoerd
Hi Sjoerd,
to change the “Show entries” value to something different, please take a look at the question “How do I get the table to display all the rows or change the default of 10?” in the FAQ.
To disable those features (“Show entries”, “Search”, etc.), just take a look at the checkboxes in the “DataTables JavaScript Features” section on the “Edit” screen of your table. You can turn them on/off there individually.
Best wishes,
Tobias
Hi Tobias,
I am reasonably new to WordPress (and especially plugins).
I have your plugin functioning (more or less), however there are no plugin CSS styles at all. Or any plugin JavaScript. Am I supposed to manually reference these additional files?
I had assumed that all I needed to do was to upload the “wp-table-reloaded” folder to “plugins” and click “Activate” in the admin. Is that not correct?
Hi Jared,
thanks for your comment.
I don’t really understand yet, what you mean or expect with the “plugin CSS styles” or the “plugin JavaScript”. Could you maybe describe that a little?
Are the files not included?
Currently I assume that your theme is missing either the
wp_head();orwp_footer();call in the header.php or footer.php. Could you check that?Other than that, it’s is in fact enough to upload the plugin folder and activate it.
Best wishes,
Tobias
Hi,
I would like to add pagination to my table, but I can’t.
I did as follow:
1. in the “Plugin Options” > Frontend options > JavaScript library,
I checked “Yes, enable the use of a JavaScript library. WP-Table Reloaded includes three JavaScript libraries that can add useful features, like sorting, pagination, and filtering, to a table.”
2.in “Edit table” > DataTables JavaScript Features > Custom Commands,
I wrote:
"iDisplayLength": 25It doesn’t work. What is my mistake, please? I am complete novice, so if you could tell me what to do exactly, it would be very nice.
Tthanks a lot,
ruben
Hi Ruben,
thanks for your comment.
Have you enabled the “Pagination” checkbox in the “DataTables JavaScript Features”?
Also, does the sorting work?
What is the URL of the page with the table?
Regards,
Tobias
Tobias,
First, this is a great plugin and it is both clean and well thought (not that I’m a programmer, but users know when things are bloated). I actually have a practical application for this outside of displaying database tables as simple tables, but I have a question about that before I make the attempt to get it to work.
Is it possible to have the data of the table display as a graph, like a doughnut graph? Would it be possible to sort of mix in “protovis 3.1″? (http://vis.stanford.edu/protovis/)
I ask because I run a video gaming website and being able to let my editors create a table, input their score and then have it display in the post as a doughnut graph would be… well, completely awesome.
If this is possible, then I guess… I sort of have to figure out how exactly to do all of that… BUT, it could I guess be a “feature request”?
Either way, thanks for the plugin. If I can use it for the purpose I’m looking for effectively, I’ll be more than welcome to give a much deserved donation.
Hi Shawn,
thanks for your question. The Protovis library definitely is pretty cool!
However, I won’t be able integrate it directly into WP-Table Reloaded, due to the just too many features and options it has. I would need some kind of user interface for them and that would make it just too much work. Also, the plugin is currently designed to show table data, while visualization is out-of-scope.
However there is nothing really that speaks against using Protovis together with WP-Table Reloaded from what I can see. It seems to be as simple as adding additional JavaScript to the page, which could be automated with the WP-Table Reloaded plugin hooks. Then, the main work would be to extract the data from the shown table and pass it to Protovis, but that should be possible with some JavaScript, too.
Regards,
Tobias
Thanks for the response, Tobias. Hm, that does sound like a bit of complications. I’ll see what I can figure out with it.
Thanks again,
Shawn
Hi,
I have deleted a few tables and now the table ID is out of sync. My first table has an ID of 1 and the next an ID of 5. I know, I can manually change the ID, but would prefer to edit a file and remove the unused table IDs. Ideally, I want to delete all the tables and then create a new one starting at 1.
I am detailing my visits to a show, so want table ID 1 for visit number 1, table ID 2 for visit number 2 etc.
Thanks and keep up the great work.
Perry
Hi Perry,
thanks for your comment.
Removing unused IDs is not easily possible. With some programming it would be possible to reset the ID counter, but I don’t really recommend that as it is not trivial.
If you really need to reset the IDs, you could export all your tables to CSV files and then uninstall the plugin (with the button in the “Plugin Options”). Then all plugin data gets deleted from the DB. Then you can reactivate the plugin and re-import all those files in the correct order. Then your IDs will start again from 1 and are consecutive.
Regards,
Tobias
First of all, your plugin is amazing! However, I’m having trouble with ThemeRoller, because I have no clue on how to use it. I still don’t know where to start after reading all the documentation on your site, DataTables site, and the ThemeRoller site.
I want the Smoothness theme (default) on my site and I downloaded it, but where do I put it? Any help would be appreciated, I know this doesn’t really pertain to your plugin specifically, but I think a lot of people could have the same question.
Thanks!
Ben
Hi Benjamin,
thanks for your question. So far, I have not yet worked with ThemeRoller or jQuery UI, so I don’t know the exact steps yet.
From what I can see from the example, all you need to do is download the theme and load the CSS file in your theme’s header.
Then the DataTables script needs to be passed the parameter
"bJQueryUI": true. This can be done by pasting this parameter into the “Custom Commands” textfield of the “DataTables JavaScript Features” section on the “Edit” screen of your table.Let me know if this works, otherwise I’ll investigate more.
Best wishes,
Tobias
Hello Tobias,
thank you for your quick response. I downloaded the theme and there is a folder with some .png images and I am unsure what to do with the folder, if I just copy the CSS into the themes header. I also have a few other questions:
- Do I need to load the JQuery UI, or is it embedded into DataTables or some other place?
- Where in the theme’s header do I place the initialization code?
Thanks,
Ben
Hi Benjamin,
thanks for the follow up.
From what I know, you’ll only need the “smoothness” folder of the download. Put that for example in your theme’s folder (the complete folder with the CSS file and the images subfolder).
Then find out the URL of the CSS file, it should be something like “http://www.example.com/wp-content/themes/your-theme/smoothness/jquery-ui-1.7.2.custom.css”.
You should not need any of the jQuery UI JavaScript as DataTables will add the necessary CSS classes to the HTML (that’s what the “bJQueryUI” parameter is triggering).
Then put the following command into the “Custom CSS” textarea in the “Plugin Options” of WP-Table Reloaded, where you need to adjust the URL of the CSS file to the one you found above:
@import url("http://www.example.com/wp-content/themes/your-theme/smoothness/jquery-ui-1.7.2.custom.css");I have not tested this, but it should work.
Regards,
Tobias
This worked! Thank you! However, for your readers there are some other things I had to do to make it look correctly.
First paste this code into the “Custom CSS” text area:
(from http://datatables.net/forums/comments.php?DiscussionID=676&page=1#Item_0)
Then, you have to edit the “wp-table-reloaded/css/plugin.css” file to show :
Also, the CSS of the ThemeRoller theme needs to show:
After all that the the ThemeRoller theme will work with TableTools and not be separated from WP-Table Reloaded.
Many thanks to Tobias and all who helped with ThemeRoller and DataTables.
Thanks,
Ben
Hi Ben,
thanks for posting that solution. Looks pretty good.
One addition: You should not directly edit the CSS code in “wp-table-reloaded/css/plugin.css”, because you will lose the changes after WP-Table Reloaded is updated (the automatic WordPress update mechanism just overwrites the file with the new one). Instead, you should simply paste that CSS code into the “Custom CSS” textarea on the “Plugin Options” screen. (You could also put it into a separate CSS file, located outside the “wp-table-reloaded” folder, and have that file load with a
@importcommand in the “Custom CSS” textarea.)Best wishes,
Tobias
Hi Tobias,
I have a similar problem to the one that Tomaz Lasic described: When I insert a table, it only shows the Shortcode.
I have changed over from wp-Table and it doesn’t seem to work. I’ve done all options, as Tomaz described. How can I switch to the WordPress Default theme as you suggested?
Many thanks,
Lena
Hi Lena,
thanks for your question.
Unfortunately Tomaz never replied, so I don’t know if the issue was solved for him.
You can change your them in the “Appearance” -> “Themes” menu in the WordPress admin menu.
Could you try that?
Regards,
Tobias
Tobias,
Awesome plugin! One of the best ever I’ve came across.
Question: Is there any way to set the width of the table? And how about backgrounds?
Given what you’ve done already – surely adding the above would be a very minor thing?
Maybe going a bit far, but you could add some AJAX and allow the user to pull the table and expand and contract table sizes – that would be great.
Would be great to hear what you think.
Thanks,
Omar
Hi Omar,
thanks for your nice words!
Regarding your questions:
You can change the table width (and the column widths) with CSS. There’s an example in the FAQ, if you want to have a look. Changing backgrounds is also possible with CSS. If it’s just the colors, I also suggest taking a look at the FAQ where I explain how to change row colors.
Adding AJAX to the frontend is not on my list currently, but I will experiment with it for the admin area in the future.
Best wishes,
Tobias
Tobias, thanks for the reply,
I meant to say in my post: It would be great to be able to edit widths from the admin section – I’m sure that should be quite easy to do?
I’ll have a go at doing this myself, if I have time.
Keep up the great work!
Omar
Hi Omar,
oh, ok. Thanks for the clarification.
However, I have to disappoint you. I do not plan to add such input fields to the admin area. The reason is that I would like to follow the principle of separation of content and layout, which is especially important to web development, with the growing use of CSS and new HTML types (like HTML5). Adding input fields to the admin area would be working against this. Also, changing the widths should not be necessary very often, so that I regard it as ok to use CSS in those cases. And if CSS can not be used in certain cases, there’s also a parameter to the Shortcode that can be used to set the column widths (please see the documentation for more on this).
Does my explanation sound reasonable?
Best wishes,
Tobias
Yes: all makes sense and very good answer.
Though: I was thinking from the users point of view.
It’s ok for techies to edit CSS and PHP – but for the rest of the world, who can just about use the CMS, it’s more of a daunting task and it goes away from the point of having a GUI CMS.
Let me know what you think.
Hi Omar,
your thoughts are correct, from the user experience point of view, input fields would be nice. However, I’d like to educate people a little bit. If they really feel that they must change the width (which in most cases is just not needed – speaking from a few example I solved in support questions), it should be worth having at least a small look at CSS. Some users are actually grateful then for having been shown the possibilities of this, as they are then able to change other things, i.e. with their theme styling.
I agree though, that there should be a more user friendly GUI, preferably one that will still lead to CSS output (and not hardcoded widths in the table HTML). And that’s something I have on my list for future versions. I’m planning to introduce something like “Table Groups”, or in other words “themes for tables”. Those can be used to style tables in the same look, while still being easily editable and adhering to the principle mentioned before. I don’t know yet, when I’ll be able to work on this, so it might still need some time.
Kind regards,
Tobias
Great tool. Looking at your wish list and didn’t see Stratomatic Baseball! Have you played?
Mark
Hi Mark,
nope, never played that. Do you mean the Fantasy Baseball game?
Regards,
Tobias
Fantastic plugin – it’s saved me loads of time so far! I’m hoping there’s an easy fix to the issue, I’m having so that I can continue using it –
I am attempting to use another plugin’s shortcode to embed flash video within the cells of the table. The shortcode is not being parsed within the table, however, and is just displaying the shortcode itself.
Is there anything I can do to get shortcodes to work within the table?
Thanks in advance for your help and again, great work on the plugin!
Hi Chris,
thanks for your question.
Other plugin’s Shortcodes are supported within table cells — if they are native WordPress Shortcodes. The Embed Flash Video plugin has a custom algorithm to search for its Shortcodes in posts/pages, therefore it does not recognize its Shortcodes in tables of WP-Table Reloaded.
However, that’s easy to fix, as all that needs to be done is to tell the plugin to also search in WP-Table Reloaded tables’ cells. Please take a look at this forums thread where I explain that solution. (You will only need the second line of the code mentioned there.) And of course, the answer only applies if the mentioned plugin really is the one you are using. If it is a different one, just let me know and I’ll look up the answer (should be pretty similar).
Best wishes,
Tobias
Hi,
is this possible?
Show the created tables with WP-Table Reloaded 1.6.1. somewhere in a sidebar?
The normal way to show the table is, to add the following code into the article: [table id=1 /]
My idea:
1. I created a Custom Field called “linescore1″.
2. Put the “ID of the WP-Table Reloaded” in the value field.
On my sidebar I have something like that
[stripped by WordPress]
What code do I have to add to the “linescore.php” so that it will show the right table?
Hi Alex,
thanks for your question. Unfortunately WordPress has stripped out the code from your comment so that I can not see it :-(
Could you maybe email it to me? Thanks.
Anyway, from the text that’s left, I assume that you are looking for the template tag function
wp_table_reloaded_print_table()(please see the documentation for details). That function just needs to be passed a query string with the ID in it and it will display the table as if it were printed by the Shortcode.Regards,
Tobias