Please read the Frequently Asked Questions and the documentation before asking for support. Thank you!
For help or support questions, especially with CSS questions, please 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 advise I gave might not be valid anymore for the current release.
Hi Tobias,
Great plugin you created…
I’m wondering if there is a way to automatically align numeric content to the right, overriding the default CSS styling.
Regards,
Jackey
Hi Jackey,
thanks for your question.
I don’t really know if there are CSS selectors that will only detect numeric content. But if your numbers are all in the same column, you could align all content in that column to the right, with some CSS code like
(The “1″ and the “3″ need to be changed accordingly.)
This would just have to be pasted into the “Custom CSS” textarea in the “Plugin Options”.
Hope this helps.
Best wishes,
Tobias
Tobias, first of all – incredible plugin. Powerful, well executed and documented.
On aligning text right, the problem with just using the column class is that it also affects the headings. So the titles in the headings run into the arrows used for sorting. The solution would be to only
text-align: right;the body rows. Is there a way to do that?Hi Bill,
thanks for your comment!
Yes, that’s possible :-) You just need to add a
tbodyinto the selector.This code should do what you want:
Best wishes,
Tobias
Hi Tobias,
Thank you for the perfect plugin.
It works perfect. Only one small problem, which I can not solve by myself.
I use TableTools to export and print the tables’ content. Only the print is not working proporly in IE. It works fine in Firefox. Somehow in IE, not all header information is cleared and nothing is printed.
I work with the theme Atahualpa. Example is http://www.hoogebergschejeugd.nl/?page_id=694. Can you help me with this one?
Regards,
Ton
Hi Ton,
thanks for your question. Unfortunately I won’t be able to help with the TableTools library. It is an external library, not written by me, that I just include.
You could have a look at the documentation on the DataTables website, where there should also be a page on the TableTools somewhere. Does it work there?
Also, WP-Table Reloaded does currently not ship with the latest version of TableTools, but the next version will have an update. It is possible that your problem is fixed then.
Until then, you’ll just have to live with the problem, I guess. I would not be too worried, as there are probably only few IE users who then want to print your table using TableTools.
Kind regards,
Tobias
Tobias,
Thanks for your quick answer.
It does work at the DataTables website, but there it is not divided into subareas.
This options is useful for us, to print by our club members if data is changed or new young people entered our golf club.
Will ask to use Firefox (love this browser).
Look forward to your next version.
Kind regards,
Ton
Hi Ton,
ok, that could mean that the new version will fix it then (might be two more weeks though, as I’m busy right now).
And using Firefox is definitely a very good alternative :-)
Best wishes,
Tobias
I’m probably just suffering an id1ot error here, but I can’t figure out how to make the “Custom CSS” affect all tables, not just the IDed ones. To be exact, The header color, it is currently only changing on one table, and I want it to affect all tables across the board the same way, no IDs. Does that make sense?
Hi Ted,
you are probably using a selector like
.wp-table-reloaded-id-1in your CSS. That will obviously only affect table ID 1. To apply the CSS to all tables, just remove the “-id-1″ from the selector. I.e., this code will change the header color for all tables:Best wishes,
Tobias
Yep, I was right. I was suffering an id1iot error. LOL. Thank you very much, fixed the problem right away.
Hi, me again :)
Is there a way to filter a table and present only a subset of the records? Something like when you type something into the search field?
Like this:
[table id=5 / filter:fieldname="search criteria"]Thanks in advance!
Hi,
just to let everybody know: I’m working on a custom solution for Paulo (and two other nice people from the WP Support Forums).
Results will probably be published soon here.
Regards,
Tobias
I am having trouble getting my table to render when clicking into links within my WP site.
Any help would be much appropriated.
Thanks!
Hi Brendan,
thanks for your comment.
Unfortunately, I don’t really understand what you are having trouble with. I just took a look at your website and everything appears to be fine.
Could you please describe a little bit more detailed, what the problem is?
Thanks!
Tobias
Tobias,
I am wondering if you have a solution for this: http://wordpress.org/support/topic/365554
The question is to show a search query filled by default when a table is loaded on a page, within the Shortcode. Please let me know, or let me know how I can have this added, thank you.
Hi Peter,
thanks for your question. Indeed, I have found a (custom programmed) solution for the problem in that forums thread.
However, from your comment, it sounds as if you are looking for something slightly different.
The solution from above will filter unwanted rows before the data is sent to the browser, i.e. the user will never actually see it. Also the dynamic “Search” function is not affected by this.
From what I understand from your comment, you want to fill the “Search” textfield with an initial value, so that the table will initially search for that. But if the search word is removed, you want the complete table to show. Is that correct? (If not, please describe your needs again :-) )
Thanks!
Tobias
Hello Tobias!
This is simply one of the best and most complete plugins, I’ve ever seen! I do have a question, which may even serve as a request for your plugin:
Is it possible to add a form with a filtering list, so the users select which table they want to see?
I’m developing a website for a school, and there will be a page for class schedules. I’d like users to select their class, and then the subject, and then press the submit button, which will take them to the table with the selected course’s schedule. Here’s a little basic and pretty ugly example I set up: http://www.uesma.edu.ec/example.html
Then I’d like to add this list to my sidebar or to some page.
Is it possible? Is it easy to implement? Thanks a lot and keep up the good work!
Hi,
thanks for your question and the comment!
Your desired behavior is not natively possible with my plugin. The reason is that it actually is unrelated to the plugin. However, it is not hard to implement it. With your form, you actually have a pretty good starting point. Now all you need to do is use it in a PHP script (i.e. as a customly coded WordPress plugin). That plugin basically only needs to transform the selection from the user into the corresponding table ID (you’ll only need a list for that). Then your script will only need to call the provided WP-Table Reloaded template tag function
wp_table_reloaded_print_table( "id={$id}" ). And that’s basically it :-)Best wishes,
Tobias
Hi Tobias,
Again a question from me.
I know that TableTools is just an add-in for you, but still it has great potential. In WP-Table Reloaded, some features are selectable. I really need a range filtering functionality on a specific column. Seeing examples in TableTools at API for this. Can you tell me, if it is easy to incorporate this function into WP-Table Reloaded? I saw that Custom Commands are possible over there.
Any help possible from you?
Kind regards,
Ton
Hi Ton,
usually it is possible to add such custom code to WP-Table Reloaded by using the filter hooks in an Extension.
If you can tell me the exact URL of the example you mentioned, I can tell you where to add the code.
Best wishes,
Tobias
Hi Tobias,
Thanks for your quick reply.
This is the url: http://www.hoogebergschejeugd.nl/?page_id=713 as an example.
In this table, I want to filter on “groep”.
Kind regards,
Ton
Hi,
can you clearify what you mean by “filter on ‘groep’”? Do you mean: If someone enters something into “Zoek:” only the “groep” table shall be searched?
And where did you see examples for this in the TableTools API?
Regards,
Tobias
Hi Tobias,
I mean that I want e.g. filter on “groep” = 1 and see only the rows of that group.
In this case I can make one big table instead of 10 subtables as I now have on different pages.
I did see this http://www.datatables.net/examples/plug-ins/range_filtering.html
Regards,
Ton
Hi Ton,
ok, now I understand everything :-)
This actually looks like you want the filtering to be done before the table is shown on the page.
That’s what I’ll release an Extension for in the next days.
Best wishes,
Tobias
Hi Tobias,
Again many, many thanks.
I added your filter extension to the real site and it is working perfectly. Also works with the extra added text editor.
All the best,
Ton
Hello Tobias, thanks for your plugin. Great work!
It worked fine until I installed the latest version of WP (WordPress 2.9.2). Now it works fine, but the button in the toolbar is not there anymore and the tablesorters don’t work either.
Anyway, is just a little trouble. Best regards!
Hi Diego,
thanks for your comment. However, I was not able to reproduce these problems. Both of the two features work fine on all my WP 2.9.2 installation and so far you are the only one who has reported this problem.
Is there maybe another plugin breaking the features? Could you check by disabling your plugins?
Thanks!
Best wishes,
Tobias
Exactly. I found the plugin that was breaking the features of http://www.wp-eventscalendar.com/
It’s a very useful plugin, that I need too, so, maybe I just need to put your tables with [ ] and no more toolbar option.
Thank you for your concern.
Hi Diego,
thanks for your comment. However I still can not reproduce the problem. All my sites with WP 2.9.2 are working fine (including this one as you can see).
I also do not see any changes in the code of WP that could make the plugin break when updating from 2.9.1 to 2.9.2.
Can you test again with all other plugins disabled?
Also, please provide the URL of the site with the table that is not working.
Best wishes,
Tobias
Dear Tobias,
As I told you, the problem was with that other plugin and yours (Events calendar).
When you wrote: “I still can not reproduce the problem”, did you mean that you installed “Events calendar” on your blog? I tested with all the plugins disabled and it works fine. Just with Events Calendar, it crashes. It’s a pitty.
Sorry my english. And I forgot to say thank you and best regards. You are very nice person responding the people questions, many newbies as me.
Thanks
Hi Diego,
no, I did not install Events calendar on my site (I just don’t have the time). I did however take a short peak into the code and can see various places that might eventually lead to problems.
One such place is in the way the plugin embeds it’s JavaScript into the page. Therefore, I strongly believe that the error you are experiencing is caused by Events calender. However, I can not fix the bugs in that plugin. Instead, I ask you to contact its developer who knows his code better and might be able to fix the problem.
Best wishes,
Tobias
Tobias,
Great plugin, which I will certainly use.
I have another question. How did you get the toggle effect of the paragraphs on the plugins page? Is there a WP plugin for this?
Han
Hi Han,
thanks for the question.
That’s not a plugin, but I wrote a blog post about that feature a while ago: http://tobias.baethge.com/2009/07/expandhide-accordion-feature-explained/
You should find an explanation there.
Best wishes,
Tobias
Great plugin! I want to create a table which lists information along with an image. Easy enough to do individually, but what if I have a thousand “records”?
Is it possible to load images into the table via CSV, without going to the media library and loading them individually?
I can duplicate and import the same code from my CSV file, which WordPress generates to place the image into the table when it is done individually, but just adding the matching code doesn’t seem to work.
I assume there is some background function which links the image to the table which allows it to work.
I can even get image placeholders to appear via HTML in the CSV but there seems to be a path issue.
I am new to WordPress, so forgive me if this is a dumb question.
Thanks!
Hi Cecil,
thanks for your question.
It is definitely possible to load images into the table via CSV, if you load them as their corresponding HTML code. There is no “background function” as you call it that links tables and images. In fact, the plugin doesn’t even know that you have an image in the table. The plugin only sees text that happens to be HTML for showing an image.
You say that you can duplicate and import the code find and also see the image placeholders in the page. That really sounds as if you the URLs to the images are wrong (or at least don’t match to the actual image URLs, because they are relative URLs and not absolute URLs).
And don’t worry, there are no dumb questions :-)
To further assist, it would be good, if you could provide the URL to the table that is not working and if you could describe what you did to insert the images (i.e. how does the code and the CSV file look like).
Best wishes,
Tobias
Tobias,
I love your plugin. I was wondering, if there is a way to change the font to “Helvetica” (for someone who does not know PPP or HTML. Thanks in advance.
Hi Alexa,
thanks for your question. Changing the font to a different one is easily possible with CSS. Please have a look at the question “How can I change the font, font size and font color of a table?” in the FAQ, where you will find the solution.
Best wishes,
Tobias
Hi Tobias,
Thanks for the great plugin. One question though: Could be quite a lame one, but how can I change the font-type or make strong just one row (a #colspan# one), e.g.: column 1, row 5?
Thanks Again
Hi Bobby,
that could be achieved with Custom CSS like this:
Just change the table ID and the row number accordingly, then paste the code into the “Custom CSS” textarea on the “Plugin Options” screen. As you have a colspanned row, there’s no need for the column number, as it doesn’t really matter.
You might also wanto totake a look at some of the questions in the FAQ, which could show you how the styling works.
Best wishes,
Tobias
Told you, I am a noob :p. Thanks again!
Hello Tobias,
Thanks for the good work you are doing, man you are great.
Well, I want to know, if there is a way to disable the search box and the small arrows from appearing… And I also want the table to show in full…
Thanks and hope to hear from you soon.
Hi,
thanks for your comment.
All of this is easily possible. The easy solution for you would be to uncheck the “Use JavaScript library” checkbox in the “Table Styling Options” on the “Edit” screen of your table. If you want a more fine grained control, you can check/uncheck checkboxes for various features in the “DataTables JavaScript Features” section (right below the first mentioned one, and initially hidden, so just click “Expand”).
Hope this helps.
Best wishes,
Tobias
Wow, man it worked. And thanks for the early reply! What about bolding and adding color to the text in first rows…?
Hi,
good to hear that!
There are a few examples regarding styling (bold font, color, …) on the FAQ page. That should get you started. All relevant code has then be entered into the “Custom CSS” textarea on the “Plugin Options” screen.
Best wishes,
Tobias
Hey Tobias,
Awesome plugin. I was spending quite a bit of time designing this myself, and then decided–I should see if there is a plugin for that.
Sure enough, there is yours, and it does everything.
I, too, would like filter functionality, so I have two questions:
1. What can I do to be alerted when that solution is available?
2. Is there anything I can to do to help (beta test, donate, etc?)
Hi Thomas,
thanks for your comment! Nice to hear that you like the plugin!
Regarding your questions:
1. Actually I published the filtering extension today :-) You can have a look at it here.
2. Of course feedback to it is always welcome. I’m also always happy about donations, as they allow me to spend more time working on the plugin and on Extensions, and giving support.
Best wishes,
Tobias
Hi, I’m trying to use your plugin. Sounds great, but to operate with another one, Shrink The Web Thumbnails, I have a problem.
Who is blocking it? Is it yours or is it them or is it WP?
I’d like to put a Thumbnail in a cell.
When using their shortcut in a table, the shortcut is not parsed. I just can read the shortcut.
Regards,
Cedric
Hi Cedric,
I have taken a look at that plugin and the problem is, that they are not using the integrated WordPress Shortcode API, but some custom method to find Shortcodes in posts or on pages. Therefore their Shortcode is not recognized within tables.
However, fixing it is easy. Just put this line of code in your theme’s functions.php (or create a WP-Table Reloaded Extension for it):
I’m having problems with the table.
In column 1, I have a 95×95-image, I set it as 98 or 100 and it’s just all over the place… Seems like they’re set then I change another one and another one goes crazy on me.
I’ve added this
"bAutoWidth": falseto the Custom Commands, not sure what I’m doing wrong.Hi,
thanks for your comment.
The code looks fine, so it is hard to say, why it’s not working, without seeing the actual page.
Can you provide the URL to the page with the table?
Also, please try adding this to the CSS:
Best wishes,
Tobias
Here is the CSS code, I put in:
Is this right? It doesn’t seem to be working at all.
Hi Shane,
I don’t know what you are trying to achieve, and unfortunately you also didn’t provide a URL of the page with your table. So, it’s hard to say if the code works or not.
Anyway, There are at least two mistakes in your code:
The first selector
.wp-table-reloaded.centerwill never match, and doesn’t really make sense. Are you trying to center the table on the page?Also, in the second CSS section, there’s a little typo: You forgot a “;” after the
font-weight: bold. If you add that, that part of the code should work.Best wishes,
Tobias
I figured, I was doing something wrong, I’m really new at this CSS business!
Anyways, I’m trying to center my table on the page. What’s the code that I need to put in to achieve that?
Hi Shane,
don’t worry, we’ll find a solution :-)
Have you taken a look at the question “How do I center a table on the page?” in the plugin FAQ?
That should get you started.
Also, your previous code is not “wrong”, it just has those tiny mistakes in it. If you remove the “.center” from the first selector and add that missing semicolon as mentioned in my previous comment, you should see first results.
Also, please provide the URL of the page with the table that you are trying to center on the page. That way, I can help you much better, because I can see if there are actually any conflicts in the CSS coming up, i.e. between the plugin’s and your theme’s CSS.
Best wishes,
Tobias
My table is right on the front page of http://www.texasholdemkings.com that I’m currently developing. I just want to be able to center it on the page.
also -
How do you manipulate the top row where the column titles are listed? I’d just like this to stand out more – I want to recolor the boxes and the text.
Hi Shane,
I checked out your site: That table looks centered to my, as it spans the whole width of the content area. So everything seems to be ok there.
You can re-style the column heads, too. Please have a look at the question “How can I change the background color of the table head?” from the plugin FAQ, which explains how to change the background color. You can then also add further CSS into those selectors, i.e. for a different text color or font, just like you are already doing with the regular table cells.
Best wishes,
Tobias
Hello Tobias,
Trying out your great plugin, my application requires a few thousand rows of data daily. I noticed issues when trying to pull in a table of more than about 1000 rows. Am I asking too much, pulling in this much data daily? It would also be nice to merge tables into a single archive table as they age… Thanks!
Hi Drew,
thanks for your question. Unfortunately, I don’t yet really know why that happens. There is no limit within the plugin itself that limits the number of rows. So, I believe that it is a server related issue. Either your memory or script time is not sufficient, or your server has the Suhosin PHP extension installed, which is known to make problems (see here).
Also, I’d like to know how exactly you are “pulling” your data. Are you using the import? If yes, which method and which source? And how exactly do you have issues?
Regarding the merging: This doesn’t really seem necessary to me. Why don’t you just put both Shortcodes on the page where the tables shall be shown? I also doubt that this will be useful to a lot of people, so I’m not yet convinced on it. There might also be issues coming from that, e.g. if the table’s don’t match in size and stuff like that.
Best wishes,
Tobias
Appreciate the quick response Tobias… I will look deeper into the server-side resources available, the site’s on a shared-server (perhaps in a VM), but I also notice less issues using IE than Firefox (current versions), FWIW.
At about >1000 rows, the browser will hang when viewing the table, or updating the Table Options (such as “Display description above table”). IE will eventually timeout, where FF will be a hung process that needs manual termination. There are 3GB of RAM in the client PC.
Currently I’m manually importing data nightly via CSV files, broken into smaller chunks, as not to trigger limitation issues. Eventually I would like to automate/script this as much as possible.
As to the archive, the goal is to have search results return matches from all tables (historical data). The columns/types of data will remain consistent over time.
Current growth is +3 tables a day. Output is currently done with 1 post per table. This method works but makes searches cumbersome.
If I use a page for all tables, I get too much data loading on the page, before the tables are shrunk down to 10 lines. This concern would also apply if an “archive table” needed to be posted, as opposed to merely search-able…
Hi Drew,
ok, now I understand better. This doesn’t really sound like the Suhosin problem anymore. It sounds more like bad luck. Most browsers seem to get into trouble when there are many textfields on a page. I don’t really know why (3 GB of RAM should be totally enough), but this issue also happens to me and other people – if I want to deal with tables larger than 1000 rows.
Unfortunately there’s nothing I can do about this really. I might add some sort of pagination to the “Edit” page, but don’t know yet, when I’ll be able to add that feature.
Anyway, after reading your other requirements/ideas, you might probably be better of with a custom solution, that uses its own database table instead. You should not have problems with the textfields then and you gain more possibilities for the automated import (as you can use SQL queries). This would also “fix” that issue with the archive tables. However, you would need custom programming to pull the data from the database, obviously.
Best wishes,
Tobias
Hi, here is the Simple Chinese webpage for this plugin. It’s not been completed yet. But I don’t know how to make a hide-expand-effect in the page like yours. Could you give me some tips, please?
http://cnzhx.net/wp/wordpress-plugins/wp-table-reloaded/
Hi,
very cool! Thanks!
The hide-expand-effect is described in this blog post: http://tobias.baethge.com/2009/07/expandhide-accordion-feature-explained/
Best wishes,
Tobias
Thank you!
Your instant reply gave me such a surprise.
Hi Tobias,
We kinda got stuck with not being able to size the column widths. Frustration led to giving up on that table.
We did exactly as outlined in the FAQ section – pasted the CSS code and associated it with the proper table, added the specified code to the DataTables JS library. But no matter what we do, the column width does not change in any browser or any computer.
Any suggestions? What could we be doing wrong?
Thanks Tobias. Please help if you can.
Reuben
Hi Reuben,
I’ll be happy to help of course!
I had a look at your site, and the first thing I noted (by using the W3 HTML Validator) is, that you have put the table (and the text above it) inside a
<h2>heading element. This might be one reason that the CSS is not working. Please have a look at the heading “PARTICIPATING PARTNERS” and fix the HTML around it. (This is best done with the “HTML editor” in WordPress.)Then you might also try adding this CSS code to the one you are already trying. That will tell the table to not span the entire page, and that may lead the browser to actually obey your column widths:
Best wishes,
Tobias
Okay. I got it to work. I ended up using the CSS code you gave above, but I changed it from “auto” to the exact px value of the table, then I made the column widths add up to the table width.
Thanks Tobias. Donation coming in a few minutes.
Hi Tobias! I have another question for you:
Alright here is my code for now, after I made the fixes:
This is what I want to happen, and I’m not sure enough about CSS to make sure this is how to make the code, so you’ll know better than me:
- I want my table to be centered on the page and all the text to be centered.
- My table headers to be a dark blue color and the text in the headers to be white.
- everything in column D to have a dark blue background and red text.
All my tables will probably be the same, so I’m not worried about the table IDs.
Did I do this right? Thanks again for all your help.
Hi,
you had it almost right again.
This time, the issues were: The color attribute is just called “color” and not “font-color”. Also, the selector for the column is not “column-D”, but “column-4″ (they are indexed with numbers, just as the rows are).
I adjusted your CSS code in your comment. Can you try that code again? I can’t spot further errors in it and it should work this time.
Best wishes,
Tobias
Thanks!
I just checked things over, everything looks good except the background on what would now be column 5 (I added another column). I want this to show up as a dark blue background. Did I do this right in the CSS code?
Hi Shane,
you did everything right. There’s on tiny thing again however, and that’s the priority of which CSS is used in case of a conflict. Currently the browser will use the background color defined for the rows, as it values it higher than that of the column, as you want it.
That can be easily changed, by adding the
!importantto the CSS however. Just replace the current CSS for the column background color with this:Everything should then work as you want it :-)
Best wishes,
Tobias
Thanks a lot for the nice plugin!
Is it possible to hide/filter rows with a checkbox?
I would like to show/hide table rows with multiple checkboxes.
Thanks a lot!
Marnix
Hi,
thanks for your comment.
Unfortunately I don’t really know yet where you want that functionality. You can hide certain rows on the “Edit” screen already. Is that what you want?
Otherwise, please explain a little more what you are trying to do.
Thanks!
Tobias
Hi,
I would like to use checkboxes on my website and use them for filtering rows.
Example: http://www.picnet.com.au/resources/tablefilter/demo.htm
You can use checkboxes at the top of the example.
Thanks again,
Marnix
Hi Marnix,
thanks for the link, that looks like a pretty cool script!
From the view of WP-Table Reloaded, there’s nothing that speaks against such a feature, however it is not integrated by default. It should (taking the examples, especially Example 2) on that page, be easy though, to add that kind of filtering to a table that was generated by the plugin. All you need to do is include the scripts, the checkboxes and a custom call to the JavaScript function.
WP-Table Reloaded provides plugin hooks to integrate the calls seemlessly.
By the way: The included DataTables library (http://www.datatables.net) offers something similar maybe: It has a fnFilter API function that will do the filtering. You also would only need to add the checkboxes and some code to make the clicks on the checkbox trigger the filtering.
Best wishes,
Tobias
Hi Tobias,
On the Demo site you have a table with a search function. Can you tell me how you install this for the table?
Many thanks
Peter
Hi Peter,
thanks for your question.
That functionality is actually integrated with the plugin and should be enabled by default (depends on when you installed the plugin). In case it is not turned, you can easily do so, by selected (and activating) the “DataTables JavaScript Library” on the “Plugin Options” screen.
Then, you’ll need to enable it for the table(s) in question on their respective “Edit” screen.
Also (depending on your theme), it might be necessary to add a call to
wp_footer();the the footer.php of your theme.Hope this helps. If not, please provide a link to the page with the table in question, so that I can take a look at it.
Best wishes,
Tobias