Hello Tim.
If you’re updating the file in wp-content/uploads/YEAR/MONTH/ folder (the original folder where the file is saved), and created a table linked to an existing data source, the table will display new data as soon as the page on which it’s on is refreshed.
If you imported the table, please note that this is a feature of the full version of the plugin, not the lite version, and we cannot provide support for it on this forum.
Commercial products are not supported in these forums, as per this comment by WordPress.org moderators.
Thank you for understanding.
Thread Starter
iscape
(@iscape)
Thanks for your response.
I am indeed using the lite version. I created the table by linking to the URL (https://domainname.com.au/wp-content/uploads/2022/05/Mirani.Station.Flow_.csv).
I then created a chart based on the table.
When i show the table or chart on a page it has the original data from the CSV and not the updated data.
When i look at the file in WP Media, it also still has the original data.
If I use file manager to view the file it has the updated data.
Tim
Hi again.
Where are you pulling the original data from? Tables linked to an existing data source need a URL to the CSV file, so if you’re uploading the file, the original file will be stored in the wp-content/uploads/2022/05/ folder. This is the file wpDataTables uses. So, if you upload a file from your desktop, it creates an exact copy of that file in the aforementioned folder. Updating the file on your desktop won’t automatically update the file in the /2022/05/ folder (because it’s a copy of the file, it’s not the same file).
You need to edit the source file (the one in the 2022/05 folder), not the file you originally used.
Thread Starter
iscape
(@iscape)
In cron:
azcopy to grab some csv data files
cp to copy them to the uploads folder
mv to rename them to match the files that are in media library
After this has executed i open the table in the wptables dashboard and see that they are empty. If i hit save changes the table populates with the new data (i dont actually change anything). The chart then has a critical error and needs to be recreated.
Any help in getting this to update with out going into save the table and corrupting the charts?
Tim
