ganaxi

Hi,

I am trying to fix the same issue. However, my “wp-ui.js” file in the “js” folder of the “wp-ui” directory in “plugins” does not have the lines that need to be changed above.

In fact, my wp-ui.js file looks like this:

[That’s too much code to post here]

Thank you, Tobias.

I will mark this as resolved.

Hi Tobias,

Thanks for the response.

I wasn’t meaning for auto-import to pick a single column, but rather the whole table, for all 132 tables. So, let me clarify.

So, in the example table linked above, there is a column on fund holding, that relies on the price of the underlying stock. What changes everyday (for simplification) is really just the price, as the no. of shares held would be updated end-of-quarter.

My idea was to have an equation for each cell in that ‘fund holding ($)’ column, as in,

No. of shares (from another col. in same table) * Price (from the daily updated table).

So, the idea, was that when the TablePress did the auto-import on all 132 tables once a day, it would import new values for that column based on the latest price info, based on the equation in that column.

If that makes sense, would you still say that it is a fatal flaw?

Thanks,

Ganaxi

Thanks, Tobias.

I am not sure I fully understand the results from that test. However, from what I can tell, I loaded successive pages (all identical in terms of other elements, except for #rows in the Table). The pages as a whole increased incrementally almost from 3 sec for tables with <100 entries to the 8-10sec for 1000 entries to 12-15sec for 2000-2500 entries and then the 25-30sec I mentioned in the largest 4000+ entries Table.

The tests above are a bit tricky, for they tell me a different bottleneck everytime I remove something, and finally when all that is left on the page is the 4000+ entries table, it still shows up in the 25sec download time range.

While I am no expert at this, logically it leads me to think that the load times are related to TablePress, and the way it displays data in the browser.

That being said, I understand that this is probably not a common use for 4000+ rows by 10 columns of data, and I still will say TablePress is by far the best solution for most uses. For now, I am going to have to live with this limitation, but it affects probably only 5%-10% of the almost 800-1000 tables I have on my site.

Thanks, again, for a great plugin.

Ganaxi

Just to add,

although I have a lot of CSS, just to be sure, I also tried deleting all of the custom CSS and re-ran, but I came about only 1+ sec less than the above times.

Will do. Thanks for the reminder.

Thanks Tobias,

That worked wonderfully!

Hi, Tobias:

Thanks for your response.

Based on the instructions, I added

“aoColumnDefs”: [ { “sType”: “formatted-num”, “aTargets”: [ 3, 4, 5, 6 ] } ]

in the Custom Commands section of the DataTables JavaScript Features panel. However, that did not change anything. The table still sorts that columnn as a text string (FYI – the # have both $ and , i.e., like $500,500, and in other cases just the comma).

Did I interpret the instructions properly? Or perhaps is there another code to be added given that these are not TablePress, but WP-Tables tables? Previously, per your instructions, I have added the WP-Tables Reloaded Extensions plugin, so that the CSS and other things for WP-Tables are based on TablePress (since I am using both plugins due to memory issues).

Thanks,

Ganaxi

Hi, Tobias:

If you remember, a while ago, you helped me implement numeric sorting so that numbers with commas get sorted as #s and not as text strings, and you helped have that implemented in WP-Tables as well (since I have a large # of Tables, and I had to break them down between the two due to memory limitations).

I seem to have recently run into a snag, and I am not able to figure out why, but some tables are sorting correctly, as I had mentioned to you when we corresponded about that, but some others (both in WP-Tables) are not (i.e., they are sorting #s with commas as text strings).

E.g,
https://www.gurufundpicks.com/13f-4q2-abg?s2-ssl=yes
is sorting it as a text string
and
https://www.gurufundpicks.com/new-trial-page
is sorting it correctly

Both are in TablePress, and have almost idential coding.

If you don’t mind, though, I am not able to unprotect the pages, and you will have to ‘register for free’ to access both pages.

Thanks,

Ganaxi

Hi, Thanks Tobias.

The solution to the first point worked, and you were right on the 2nd. I had forgotten to check the hover highlighting on the WP-Tables.

Ganaxi

Sorry, the second one link is
https://www.gurufundpicks.com/13f-4q2-spr

Hi, Tobias,

Similar to the queries above, this one I think also relates to the
custom plugin that loads the TablePress DataTables JS file for the WP-Table Reloaded tables. As you may see from the following 2 links,

the first below was created using TablePress
https://www.gurufundpicks.com/13f-4q2-vng

and it looks good!

However, the second one below was created using WP-Tables, and a number of functionalities haven’t quite transferred with that custom plugin, the two noticeable ones being:
1> the sorting arrow in the header row is not visible on this one
2> the hovering of the rows does not highlight them

Any ways to fix this?

Thanks,

Ganaxi

Hi, Tobias:

Excellent! That worked.

Sie sind ein Genie!

Thanks again,

Ganaxi

Hi Tobias,

Sorry about that – that page was protected for registered users only. I have disabled that now, so that you can view it. Try sorting the fifth column, as the others are too narrow right now so you can’t see very well that the numeric sorting of strings is working well with the Extension plugin.

On #2, thanks for the clarification. I will try that and see.

Thanks,

Ganaxi

Hi Tobias,

I think the extension plugin solved the string problem, as you will see in the table below, that was generated using TablePress
https://www.gurufundpicks.com/13f-4q2-vng

I believe whatever the extensions did to treat the string as numbers, is somehow not being applied to WP-Tables, with the custom coding that you had provided me earlier.

Regarding point#2, my columns have px width, so I will try making them wider and see if that helps.

Thanks,

Ganaxi