Hi,
thanks for your post, and sorry for the trouble.
Unfortunately, I’ll have to disappoint you here. Something like this is not possible with TablePress. It can only manage and show its own tables, but not tables from external source like a database tables.
For that, you could take a look at the commercial wpDataTables from http://wpdatatables.com/ (I have no affiliation or connection to this, and I have never used this, I just thought, I’d mention it).
Also, you could develop custom PHP code that creates the HTML code for your table from a DB query and then manually load the DataTables JS library from http://www.datatables.net for the sorting, etc.
Regards,
Tobias
Try Advanced Custom Fields nad repeater field. You will have use of it in the future. You need to make manual template, either with div/classes or table/tr/td.
Hi,
that’s a good suggestion, that could also work. Thanks for sharing it!
Regards,
Tobias
Thanks to both of you for getting back to me. I am not skilled enough to do what stagger lee is suggesting.
I am already using wpdatatables, however using it with a MySQL database does not allow the download confirmation box to work with the s2member plugin when users download files from the links in the table. I have only recently discovered that using a csv wpdatatable fixes this problem, however the table is too big for csv.
Example here: http://shiphydros.com/test-tables/
The top table, using MySQL database, does not show a confirmation box when downloading. The bottom table, using csv, does show a confirmation box.
If anyone can fix this using tablepress or wpdatatables I will pay. You will need level 1 membership or greater to download files. Let me know if you want me to set up a subscriber and admin account.
Hi,
I’m not really sure what you mean here. In both of the tables on that page, when I click a link in the first column, I get redirected to “Subscribe” page, asking me to sign up for a membership. Isn’t that what you are expecting?
Regards,
Tobias
I am confused too. What is “confirmation box”. It is just setting in the browser.
I see now. It has nothing to do with mysql or files folder. Both tables are the same from visitiors view. (xls file)
So either your plugin cannot handle two instances per page, or you did something wrong in tables/suscription plugin setup.
Please log in for an example-
user: test Password: 64233289
Click a link in the bottom table first. It shows you a download confirmation box. It is a small table using information from a csv file.
Click a link in the top table. It does not show you a confirmation box. It is using MySQL database for the information, with over 5200 rows. This is what I would like to use but want it to work with the confirmation box. CSV is too slow with a table this big.
The links in both tables are exactly the same (other than the files names).
Hi,
ah, now I can also see what you mean.
I’m not sure why the confirmation dialog is not showing in the top table, but this is something that you should ask the developer of that s2member plugin where this function is coming from. It’s not related or cauesd by wpDataTables, from what I can see, it’s simply the s2member plugin not registering its JS calls for all cases.
Regards,
Tobias
Thanks Tobias. Your responsiveness to questions is much better than other plugin developers who I have paid.
Hi,
thanks for those kind words, I really appreciate it!
Best wishes,
Tobias
P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!
