I have a table which was created by a csv import. Is there a way to have that table automatically refresh from the csv file on a schedule?
Reading from csv is so slow. I do have caching on but it did not seem to make a difference. Im hoping to automatically/on a schedule "replace rows with source data"
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
2. The only alternative method i can think of, for this kind of use-case,
and this only works if you don't have "too many rows"/ too large of a data set ( approximately less than 6 thousand rows);
and activate our Cache and Auto-Update Cache option, which helps with performance for non-server-side tables like that;
Then with a cron job you can set up the time interval in which our plugin is going to pull any editing you do on the source file.
But the limitations here are :
1. As mentioned, the data set can't become too large, depending on the server performance, and the PHP limits that are set on it, approximately if it gets over 6 thousand rows, the page could become very slow or unresponsive
2. Or, if you change the data structure on the source file;
Changing the column’s name,
Changing the column’s order,
Deleting the column, and
Adding a new column.
then the connected table would break and you would have to make a new linked table.
-
Those are the current possibilities with our plugin's capabilities.
I have a table which was created by a csv import. Is there a way to have that table automatically refresh from the csv file on a schedule?
Reading from csv is so slow. I do have caching on but it did not seem to make a difference. Im hoping to automatically/on a schedule "replace rows with source data"
Attached files: 2023-03-16 10_24_09-Window.jpg
Hi ,Stephen.
1. When it comes to updating existing Manual Tables by uploading an updated CSV file to 'replace rows with source data',
at the moment, we don't have any automated way to schedule the upload of the file,
this process can only be done manually by user action.
It is an interesting idea for a future option, though.
Please feel free to search on our suggestions page,
to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
2. The only alternative method i can think of, for this kind of use-case,
and this only works if you don't have "too many rows"/ too large of a data set ( approximately less than 6 thousand rows);
you could try to link the source CSV file to a table in our plugin,
and activate our Cache and Auto-Update Cache option, which helps with performance for non-server-side tables like that;
Then with a cron job you can set up the time interval in which our plugin is going to pull any editing you do on the source file.
But the limitations here are :
1. As mentioned, the data set can't become too large, depending on the server performance, and the PHP limits that are set on it, approximately if it gets over 6 thousand rows, the page could become very slow or unresponsive
2. Or, if you change the data structure on the source file;
then the connected table would break and you would have to make a new linked table.
-
Those are the current possibilities with our plugin's capabilities.
Let me know if you have any questions.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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