Java Script library problem

Hi,

thanks for your post, and sorry for the trouble.

The reason for this is that something on your site (either a plugin or the theme) is loading a second (and totally outdated) copy of the jQuery JS library from the Google CDN.
You will need to find the plugin/theme that does this, maybe with the help of https://tablepress.org/faq/js-functions-not-working/ or by deactivating the other plugins one by one and checking again each time.

Regards,
Tobias

Hi,
Still trying to find the problem.
Also noticed that importing a file adds a blank row at the top, where the headings should be. I edit it out, but of course auto update overwrites this and puts a blank row back in again.
I assume the extensions won’t work if there is a blank header row?
Happy Days!
John

Hi John,

when I visit the link that you posted above, the JS functions work fine for me. Looks like you found the source of that extra jQuery library?

Regarding the import: Can I see the imported file? If there is an empty row at the top, TablePress will of course import that, as it can’t know that you don’t want it.

Regards,
Tobias

Tobias,
Our Web hosted found the offending plugin – slider! Now I can get on with some serious tables!

The imported file is from google drive:

https://docs.google.com/spreadsheet/pub?key=0AsK-nbmoTnoVdEtNdGUwbTM1SmpIOWl4Y0NaR0VoV0E&single=true&gid=11&range=B3%3AG10&output=html

The range B3:g10 is defined, row 3 is the headers but after import, there is an additional blank row above. I get the same problem importing as CSV or HTML.
Let me know what you think,
Regards,
John

PS should I try the 1.5 beta?

Hi John,

ah, that’s great! If you rely on that Slider plugin, I suggest to ask its developer to remove that jQuery dependency and instead use the version that ships with WordPress.

Regarding the import: When I view the table in the link, it has an empty second row, and that’s what TablePress sees and imports. If you don’t want that empty row, you’ll have to remove it in the original spreadsheet.
An easier way would be to simply hide it in TablePress, i.e. click the checkbox on the left of the row and use the “Selected rows: Hide” button. The row will then still be visible on the “Edit” screen, with a red background to indicate that its hidden, but it will be hidden from the user when the table is shown in a post/page.

Regards,
Tobias

Tobias,
The empty row in row 4 after the header is not the problem. when I import the link, it adds a row above my data in row A which should be the header.
As I want to use auto update to keep the table current, this needs to be fixed.
By the way, with auto update, will the table get updated each time it is loaded or only on the 15 min intervals?
Regards,
John

Hi John,

I’m confused now. When I look at the table at https://docs.google.com/spreadsheet/pub?key=0AsK-nbmoTnoVdEtNdGUwbTM1SmpIOWl4Y0NaR0VoV0E&single=true&gid=11&range=B3%3AG10&output=html
that table has 8 rows: One header row, then one empty row, and then six rows with data.
This is exactly what TablePress will import and it’s exactly what I see at https://www.donnington-grove.com/members-home/seniors-area/seniors-events/seniors-winter-matches/tryme/
The empty row after the header row is not coming from TablePress, but from the original spreadsheet. If you can’t hide it from there, the hiding method that I described should work as a workaround, as it will hide the empty row from the user.

The auto update will run the import approximately every 15 minutes (depending on how many users your site has), if you choose that interval.
(This usually creates a new revision of the table in the database, which could therefore grow quickly. If you keep that 15 minutes interval, it’s therefore a good idea to set the maximum number of stored revisions to e.g. 10, with the help of https://codex.www.ads-software.com/Editing_wp-config.php#Specify_the_Number_of_Post_Revisions )

Regards,
Tobias

Tobias,
Maybe I truncated the URL I sent you. It is
https://docs.google.com/spreadsheet/pub?key=0AsK-nbmoTnoVdEtNdGUwbTM1SmpIOWl4Y0NaR0VoV0E&single=true&gid=11&range=B3%3AG10&output=html
which defines the range of cells to import – B3:G10, where row 3 is my header row. Perhaps your import does nor recognise the range element in the URL?
In this table I could just shift it all up one row, but in other cases I want to import part of a table using the cell range.
Does that make sense?

I understand your comment on revisions.

Regards,
John

Tobias,
Import seems to work better as CSV which can be selected on google drive and the auto updates work too.
Now I have nice tables I need to solve a new problem – fixed top and left header with horizontal scrolling – is there a fix for this?
Kind regards,
John

Hi John,

ah, yes, that’s different URL with the range parameter (interesting feature, by the way).
TablePress will not treat that parameter differently however, it will import exactly what it sees there. Now, CSV might indeed work better, as it’s more reliable. So if that works better, I suggest to keep using that.

Regarding those fixed top and left headers: You cold maybe take a look these TablePress Extensions for that:
https://tablepress.org/extensions/datatables-fixedcolumns/
https://tablepress.org/extensions/datatables-fixedheader/

Regards,
Tobias

Tobias,
With the fixed headers set top and left i get an error message – won’t work with scrolling.
Any ideas?
John

Hi John,

I think that the JS code of the Extension requires to turn off the “Horizontal Scrolling” checkbox, as it basically adds it’s own scrolling.

Regards,
Tobias

Tobias,
That Kinda works but sometimes it seems the table goes beyond the page limit – I’ll keep trying.

Now for something different – I have tried adding links to some cells which work fine, but when auto update reloads the data, the link gets deleted – any way round this?

My new page with tables looks quite nice now:

https://www.donnington-grove.com/members-home/seniors-area/seniors-events/seniors-winter-matches/winter-golf/

Regards,
John

Hi John,

well the auto update replaces the existing table with the version from the import source. And therefore it will also replace those added links, obviously.
The only way around this is to already add the HTML code for the links in the source table. Sorry.

Regards,
Tobias

Tobias,
I thought that might be the case.
Google does allow a hyperlink to be added and that works, but sadly when imported as a csv into table press, it displays the literal hyperlink instead of the link text. I’ll try an html import but as you recall, this seems to put in an extra top row.
I’ll keep trying,
John