Ok, i figured out what i did wrong! I didn’t put the styling in the main “plugin options” area, but on the table’s editing page instead. Now that it’s in the plugin options, it works!
Ok, wait..sorry…actually the color is not being applied. Hmmm
Hi,
yes, exactly, code needs to go into the field on the “Plugin Options” screen. And you should remove it again from the “Edit” screen, as you still have it added there.
For the color code, please try with this:
.wp-table-reloaded-id .odd td {
background-color: #e9e9e9!important;
}
That raises the importance of that specific code. That’s needed because your theme also contains code to change the color of table cells.
Regards,
Tobias
Thanks so much. I eventually figured out that I needed to add the !important to make it work.
I have a long-winded, totally un-related to CSS couple of other questions, too…
As you can see, I am using this table to list restaurants. I want the website visitor to be able to sort the restaurants by category. For istance, if they’re looking for a pizza restaurant, I want them to be able to click on a link that takes them only to the pizza restaurant page.
Also, I need to mass import images/icons that will represent whether the restaurant is a “local favorite”, “kid friendly”, and also images for whether the restaurant is $,$$, or $$$ in cost. Additionally, I’d like them to beable to sort the restaurants by price . What is the easiest way to do that?
Hi,
for that “sorting by category”, you could use the Filtering Extension from my website: http://tobias.baethge.com/2010/03/extension-6-showing-only-rows-that-match-a-filter/
For those icons: I suggest that you do it with some HTML <span> elements, which get a background image based on a CSS class (which contains information on the rating or similar). See for example the rating of a plugin on the right side (like here).
That way could work with the sorting for price as well, as you could extend the DataTables JavaScript library to sort for the contained values.
Unfortunately, this is beyond the scope of support that I can provide for the plugin, so I’ll not be able to help with this much.
Regards,
Tobias
Thanks so much for providing the link for the filtering extension. What I did was set up a column called “Cuisine” and just typed in each cell the kind of cuisine it was. I then sorted it by putting, for instance, [table id=2 cellspacing=”0″ filter=”Buffet”/] if it is a buffet restaurant. However, every buffet was also in another category. So, for instance, in the cell it says: Asian Buffet . It now seems as though any restaurant that has two categories listed does not show up on the results. Also, I don’t know if this is related to the problem, but I have hidden the column “Cuisine”, as there is no reason to say what cuisine it is if the page is specifically for Buffet anyways.
Last question for now…and this is not as important…more of just curious…I also implemented your automatic change to links extension and it added “http://” to the listed link. I already have so much information listed that it would be nice to remove the “http://” from showing up in the results and just have the “www” instead of http://www.link.com. Is this possible?
I’m sorry to be a pain with all these questions!
Hi,
the search in the Extensino only works with exact matches, so filtering for “Buffet” will really only find table rows where a cell exactly matches “Buffet”. It will not find cell which just have “Buffet” as part of the content, like in “Asian Buffet”.
Hiding the column is totally fine, that does not influence the search.
Just as a note (as it is important): Please uncheck the “Cache Table Output” checkbox for that table, as it could otherwise interfere with the filtering.
For the automatic links extension: Unfortunately, this can not be changed easily, as the WordPress function that is used for this automatically prepends the http:// to the link text as well. You would need a custom make_clickable() PHP function to change that. Creating each link manually through the “Insert link” button gives you more flexibility here.
Best wishes,
Tobias
Thank you so much for taking all this time to answer all my questions. I REALLY appreciate it! I ended up making additional columns so that I could apply multiple cuisine categories to each restaurant, if needed.
I’m assuming this is not possible, but I figured I would throw this out there: Is there a way to make all the letters located in a certain column become all CAPS and also bold? (I’d like to make the restaurant names CAPS and bold)
Other question: Is there a way to make the table be presented alphabetically? I find it a little odd that it looks like the only choices are ascending and descending order…or maybe I am missing something?
Again, thank you sooooo much!
Hi,
yes, using several columns for the different categories is definitely a nice idea!
For the styling in CAPs and bold: You can use some “Custom CSS” code for that. Please try to add this:
.wp-table-reloaded-id-2 tbody .column-1 {
text-transform: uppercase;
font-weight: bold!important;
}
For the sorting: But isn’t “alphabetically” the same as order ascending?
Regards,
Tobias
Thanks so much for the help for the CAPS and bold thing. That worked beautifully!
For the sorting: Alphabetically means it would list in alphabetical order (A,B,C,D,E,F,G, etc) and ascending is putting it in the order I entered the rows into the table. For instance, “Jamestown Pie Company” is the last restaurant I entered into the table (the last row), so it is always showing as the last result. Z is the last letter of the alphabet, so “Zpizza” should be the last entry when shown on the website. They should all be grouped together in alphabetical order (for my use) with all the A’s being together, B’s being together, etc. Is this possible?
Hi,
but when you click the table head to sort, you will sort ascending, which is alphabetically?!
But I guess that you want this to be the initial state, without needing to activily envoke the sorting.
Now, for that, you can simply sort the table on the “Edit” screen.
There’s a “Sort” button below the text input fields, where you can choose a column, on which the sorting shall be based. This will then sort your table on the “Edit” screen, which then resembles the initial state when the table is viewed.
Regards,
Tobias
Ahh…I’m kinda embarrassed that I didn’t see that I had to click “Sort” to make that happen. Sorry about that.
I was nearly done with making edits to my table and just moved one column to the very end. After doing this, all my settings on the table got erased (no alternating color, no hidden columns, etc). Also, I had 280 entries. After I moved the column it removed all entries after 129. Do you know why this happened and how I can repair this? I’d hate to have to redo all my work.
Hi,
ouch, that’s not good. This problem sounds like the “Suhosin” problem, a PHP extension on your server that prohibits saving large tables.
Please see the following threads for more, including ideas to fix it:
http://ww.wp.xz.cn/support/topic/plugin-wp-table-reloaded-cannot-save-changes-for-big-table
http://ww.wp.xz.cn/support/topic/plugin-wp-table-reloaded-import-file-size-uploading-limit
http://ww.wp.xz.cn/support/topic/plugin-wp-table-reloaded-unable-to-edit-table-data
http://ww.wp.xz.cn/support/topic/wp-table-reloaded-row-limit
Now, unfortunately, this means that your data is likely lost – if you don’t have a backup in form a mySQL dump or an exported file. Sorry about that, but I don’t know how to fix this problem (as it is server related).
However, I’m kind of confused that this happened now, when you actually had created and worked with the large table. Usually, that problem shows much earlier already…
Tobias
Tobias, thanks for the help files. I’ll take a look at those. Fortunately, I had exported a copy last night before I spent about 2 hours working on it. Those were very productive 2 hours, so it pains me to lose that, but I do have all data, minus those 2 hours last night. I’m just grateful I did that! I’m guessing it just got overloaded because I had added a bunch of images to the columns. I guess I will just have to re-do the work from last night and then export often to make sure I don’t lose it again.
Hi,
yes, exporting the table often is always a good idea, as it is a good backup.
I don’t think that this was caused by adding the images, because the plugin does not know that you added images. It only sees the HTML code, but that’s treated just like regular text.
Instead of the Suhosin problem it might also be that (for whatever reason) that transmission/HTTP request of the data was somehow disturbed, so that the table got corrupted. This could e.g. happen if the server is busy with other stuff when the request happens.
But there’s nothing really that one can do against that either…
Regards,
Tobias
