Tobias says:

Hi Paul,

I would suggest the HTML tags “abbr” or “acronym” for this. They will show a tooltip when hovering over the text.

Best wishes,
Tobias

Tobias says:

Hi Tim,

unfortunately there is no such way, that I’m aware of. The problem is that Excel does not know that you want the hyperlinks to be HTML, so it doesn’t export them that way. And my plugin can’t know that the text is a URL that shall be shown as a link.

One possible way could be to open the CSV file with a text editor and add the HTML around the URLs by using the editor’s search and replace functions.

In the upcoming release 1.5 you will also be able to filter the output and (basically by writing a small WordPress plugin) replace URLs with links. Until then, you’ll need to make the links by hand, sorry.

Best wishes,
Tobias

Tobias says:

Hi,

thanks for your question.

This is possible with CSS. Please find more on this in the documenation. For the column widths, you could also use a shortcode parameter, which is also described in the docs.

Best wishes,
Tobias

Tobias says:

Hi Evan,

thanks for your question. This is not easily possible at the moment.
I could imagine a possible way though: You could insert the shortcode for displaying a table into that cell, adding shortcode parameters that will lead to only a certain cell being shown. For your example: In cell A1 of table 1 you would insert a shortcode like [table id=3 hide_columns="..." hide_rows="..." /] where the “…” would need to be adjusted so that only cell C3 remains for the output. This would work in concept, but has some drawbacks: It would also include a complete table (with just one row and column) instead of just the value. But it would be possible with this. You can find more on the mentioned shortcode parameters in the documentation.

Best wishes,
Tobias

Tobias says:

Hi Kyle,

thanks for your request! I can understand the need for such an export feature. I’ll try to find a solution for one of the next, but can’t promise anything right now.

Best wishes,
Tobias

Tobias says:

Hi,

I’ve not heard of such an issue before. This sounds like a corrupted database to me though.

The tables are stored as so-called “options” in the “wp_options” mySQL table of WordPress. There is one entry for each table and one entry with information on where the plugin finds the single tables.
I can only assume that some of the entries for the tables got lost. You could check for those with names like “wp_table_reloaded_data_”. There should be one for each table.
If some are really missing and there is no database backup, I don’t see a good chance of getting the data back.

Best wishes,
Tobias

Tobias says:

Hi Jason,

thank you very much! A very nice review!

Best wishes,
Tobias

Tobias says:

Hi Jed,

thanks for your comment and your tweet!

You can format the width of table columns with CSS (this is not HTML, it’s more a language to style HTML code on the visual end of the browser).

You will need to add code to the CSS textarea on the “Plugin Options” screen of WP-Table Reloaded.
Here’s an example:

.wp-table-reloaded-id-123 .column-3 {
width:100px!important;
}

If you add that, column 3 of table 123 should be 100px wide. Of course you can adjust those values/the ID/the column in the code and copy it as many times as needed.
There’s more on this CSS stuff in the documentation.

Hope this helps!
Tobias

Tobias says:

Hi Steve,

thanks for this feature request.

Unfortunately I have to disappoint you at this time. I would really love to add support for “rowspan” and “colspan”, but the current structure of how the tables are stored in WP’s database does not make this possible. I have yet to find a way to store the information on linked cells and then I will also need a good way to make this feature accessible on the “Edit table” screen, to make it easy to link cells.

I hope the plugin is useful to you besides this drawback.

Regards,
Tobias

Tobias says:

Hi Sebastien,

thanks for your question.

Querying single cells is not directly possible, in terms of just returning the cell content. One possibility might be the usage of the “show_columns” (and their related) parameter(s). That way you could hide all columns and rows and then only show a certain row/column (which is a cell). The resulting shortcode would be rather long though and the output would still be a table (but with only one row and column basically).
So, it is possible but a little bit ugly.

You might want to check out the “Custom Data Field” feature though. Each table can have them, and they are edited and used just like tables with a shortcode. You can find the feature at the bottom of the “Edit table” screen of every table. After creating a field, you will get a shortcode to access that data from anywhere on your blog (you can also use a template tag function for places without shortcode support). Using this method, you would only have to edit the data once, but can show it in many places. The drawback is, that it is not shown in table form, but you could also add the shortcode for the field to a table to get that. So, depending on the number of such queries you want, I would recommend this solution.

Hope this helps!
Tobias

Tobias says:

Hi Claire,

this is because WordPress needs more memory than your server/installation gives it.
The fix can be as easy as one line added to your wp-config.php file.

Please refer to these links for instructions:
http://codex.wordpress.org/Editing_wp-config.php#Increasing_memory_allocated_to_PHP
http://www.clickonf5.org/wordpress/allowed-memory-size-exhausted-wordpress/3636

You will probably have to add the line
define('WP_MEMORY_LIMIT', '64M');
to your wp-config.php file.

Best wishes,
Tobias

Tobias says:

Hi Wolfgang,

thanks for your comment and the feature requests!

I have some remarks though:
- For columns with <th>: Do you have an example where this might be useful? I see the problem that the tablesorting JavaScript won’t work with this…
- This seems a good idea. But: Do you want *another* input field on the “Edit table” screen for a second description? Or do you actually want to dictate the position of the description? (If the second is the case, there is a workaround by using the [table-info /] shortcode.)
- In the upcoming version 1.5 it will be possible to move the “WP-Table Reloaded” menu item to another menu in the WP admin menu (without splitting off the “Plugin Options” though, because that would somehow be confusing I believe.)

Regarding your last question:
I don’t really understand what you need here. Horizontal scrolling? You would probably need to wrap the shortcode/table in a <div> that has scrolling enabled (with CSS), but I can’t help with that, because it depends heavily on your theme. Sorry.

Best wishes,
Tobias

Tobias says:

Hi,

character encoding in CSV importing is a very difficult topic. I’m currently using a third-party library that handles this. Unfortunately it seems that this library is no longer maintained by its developer. Therefore it is hard to make changes or to get additional features in. I personally don’t have any real knowledge on character encodings and how to deal with them. Thus, I can’t tell you what’s wrong here. I have tried different things with different encodings, but couldn’t get any reliable results. Sometimes I couldn’t even get an UTF-8 encoded file to import correctly. It looks like this also depends heavily on server config stuff (PHP version, user OS, …), so it’s really difficult.

The only idea I have right now is, to convert any files into one encoding that seems to import correctly. This probably is UTF-8, but I can’t guarantee.
If you have more insights or ideas on this, please let me know!

Best wishes,
Tobias

Tobias says:

Hi Isaac,

thanks for your comment!

Pagination will be available in the next version 1.5 (which is currently in a public beta test). It can then be added by using the “DataTables” JavaScript library, which also has other features like sorting or filtering.
So, you can either test the beta, or wait about a week or so for the final release of 1.5.

Best wishes,
Tobias