Hello, my main use case is to display data from linked Google Sheets. In your UI, it says "Data will be read from the source every time the page loads."
Is there a way to avoid this?
Instead of getting the data from Google Sheets every time a visitor hits a page, we should have the option to set table refresh intervals. In this case, there would be a local copy of the table that is updated at a specified interval. This would avoid constantly repeating the slow, external data pull.
TablePress has this option, which is called Auto Refresh. You can specify the update interval. By displaying cached local data to users, the tables load dramatically faster than yours.
However, I need your charts and other features. Is there some alternative to reading the source every time? Or some workaround?
Auto Refresh is available only for server-side tables (Manual, Imported, and MySQL query-based tables). So, if you have a way of loading the Google Sheet into your database with some custom procedure, you can create a table linked to the database table, and include an auto-refresh which will automatically refresh the table after XX seconds that you defined in the Auto-Refresh section above the table.
This, however, reloads the table without reloading the page, but the data still needs to be pulled from the database, so I don't know if this is what you're looking for to achieve.
Thank you for adding this to our feature suggestion page, and I hope our developers will see it as useful and include it in the plugin soon.
Also, have you checked out the Google Sheets API method, which is a lot faster than the regular method?
Thanks. I did just set up the Sheets API. Probably a better practice anyway.
It does seem somewhat faster, but it would still be nice to avoid the call on every page request--the same tables in TablePress still load much faster (practically instantly since they're storing the data locally).
Hopefully the "periodic import" feature request makes it into wpDataTables eventually.
I forwarded the ticket to our developers, so hopefully they'll see it as a beneficial addition as well, and I hope it will be included in one of our future updates.
At the moment, with the built-in features of the plugin it's not possible.
Just a small update from our developers - this is planned for all non-server-side tables, along with an option for caching the data - so it's not read every time from the source, but that it's read from the cache, and updated within a certain period of time, per your liking.
We don't have an exact ETA yet, but please feel free to add this to our feature suggestion page.
Hello, my main use case is to display data from linked Google Sheets. In your UI, it says "Data will be read from the source every time the page loads."
Is there a way to avoid this?
Instead of getting the data from Google Sheets every time a visitor hits a page, we should have the option to set table refresh intervals. In this case, there would be a local copy of the table that is updated at a specified interval. This would avoid constantly repeating the slow, external data pull.
TablePress has this option, which is called Auto Refresh. You can specify the update interval. By displaying cached local data to users, the tables load dramatically faster than yours.
However, I need your charts and other features. Is there some alternative to reading the source every time? Or some workaround?
Thank you for the help.
PS - I did submit this as a feature request.
Hello Justin
Auto Refresh is available only for server-side tables (Manual, Imported, and MySQL query-based tables). So, if you have a way of loading the Google Sheet into your database with some custom procedure, you can create a table linked to the database table, and include an auto-refresh which will automatically refresh the table after XX seconds that you defined in the Auto-Refresh section above the table.
This, however, reloads the table without reloading the page, but the data still needs to be pulled from the database, so I don't know if this is what you're looking for to achieve.
Thank you for adding this to our feature suggestion page, and I hope our developers will see it as useful and include it in the plugin soon.
Also, have you checked out the Google Sheets API method, which is a lot faster than the regular method?
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thanks. I did just set up the Sheets API. Probably a better practice anyway.
It does seem somewhat faster, but it would still be nice to avoid the call on every page request--the same tables in TablePress still load much faster (practically instantly since they're storing the data locally).
Hopefully the "periodic import" feature request makes it into wpDataTables eventually.
Hey Justin.
I forwarded the ticket to our developers, so hopefully they'll see it as a beneficial addition as well, and I hope it will be included in one of our future updates.
At the moment, with the built-in features of the plugin it's not possible.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi again Justin.
Just a small update from our developers - this is planned for all non-server-side tables, along with an option for caching the data - so it's not read every time from the source, but that it's read from the cache, and updated within a certain period of time, per your liking.
We don't have an exact ETA yet, but please feel free to add this to our feature suggestion page.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Fantastic news. Thanks for the update.
You're welcome, Justin
Glad I could help.
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables