I have a table linked to a csv. When the CSV updates, the data doesn't update. Is it being cached? Why would it be displaying the old data? I submitted a ticket for this 2 days ago and still haven't heard a response. This is a time sensitive project!
thank you for reaching out to usFirstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
I have forwarded your inquiry to our senior agent, and he will contact you back as soon as possible.
If you created a table linked to the file, you must overwrite the file located in ..wp-content/uploads/YEAR/MONTH/ folder, and the table will be updated when you do that, but you need to keep in mind that you can't change the structure of the source file, so renaming, deleting, adding or reordering columns in the source file will cause the table to break.
To update the table by importing the CSV file again, you'd need to remove the headers and existing rows, and include only new rows. Then, in the database, find the wp_wpdatatable_# that was created, and then import that new CSV file in there.
Another option would be to view the table in Excel-like mode in the back-end, and then bulk select; copy and paste the data from Excel. There's no way of updating the existing table by just updating the original CSV file.
I have a table linked to a csv. When the CSV updates, the data doesn't update. Is it being cached? Why would it be displaying the old data? I submitted a ticket for this 2 days ago and still haven't heard a response. This is a time sensitive project!
Hi Katie,
thank you for reaching out to us
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
I have forwarded your inquiry to our senior agent, and he will contact you back as soon as possible.
Hi Katie!
Just a small update I am in touch with developers regarding this (I will also send them a reminder tomorrow).
I hope you're having a good weekend.
Hi Katie
Thank you for your patience.
Could you please tell us how did you update the CSV file?
Did you create a table linked to a CSV file or by Importing a CSV file?
If you created a table linked to the file, you must overwrite the file located in ..wp-content/uploads/YEAR/MONTH/ folder, and the table will be updated when you do that, but you need to keep in mind that you can't change the structure of the source file, so renaming, deleting, adding or reordering columns in the source file will cause the table to break.
To update the table by importing the CSV file again, you'd need to remove the headers and existing rows, and include only new rows. Then, in the database, find the wp_wpdatatable_# that was created, and then import that new CSV file in there.
Another option would be to view the table in Excel-like mode in the back-end, and then bulk select; copy and paste the data from Excel. There's no way of updating the existing table by just updating the original CSV file.