The site currently uses version 2.0.2 and the purchase code has expired so looking to see if it is worth renewing to get the following functionality.
The user would like to make changes to the data on an excel spreadsheet locally and then upload this to the server REPLACING the data held in the current associated wp data table thereby automatically update the data displayed on the website. In effect synchronising the excel spreadsheet with the wp data table.
As far as I can make out it seems that it is not currently possible to upload replacing a table, it's only possible to upload creating a NEW table.
Am I correct?...
please can you suggest a recommended method, the current method of editing on the website is undesirable especially with the proposed implementation of a new table which will have around 40,000 rows.
One option if it cannot be done through wp data tables might be to find a plugin that can upload csv format directly into the relevant mySQL table perhaps.
In order to use a file this big, you would need to import it, and once it's imported, wpDataTables reads the source file and creates a database table that can be edited. However, it cannot be updated by uploading (replacing) the source file since the file was read only at the moment the table was created - it is no longer being used to display the data of the table.
You're correct that you'd need to create a new table by uploading the modified file in order to see changes. I am not aware of any plugins that would allow you to upload a file and overwrite/add data to the corresponding database table, though.
Hi, I have been asked to investigate ways of simplifying and speeding up the process of adding and updating data held in wp data tables for display on the http://www.ww1bradford.org/ website e.g table: http://www.ww1bradford.org/those-who-served-and-died/ .
The site currently uses version 2.0.2 and the purchase code has expired so looking to see if it is worth renewing to get the following functionality.
The user would like to make changes to the data on an excel spreadsheet locally and then upload this to the server REPLACING the data held in the current associated wp data table thereby automatically update the data displayed on the website. In effect synchronising the excel spreadsheet with the wp data table.
As far as I can make out it seems that it is not currently possible to upload replacing a table, it's only possible to upload creating a NEW table.
Am I correct?...
please can you suggest a recommended method, the current method of editing on the website is undesirable especially with the proposed implementation of a new table which will have around 40,000 rows.
One option if it cannot be done through wp data tables might be to find a plugin that can upload csv format directly into the relevant mySQL table perhaps.
Thanks
Pete
Hello Pete
Thank you for reaching out to us.
In order to use a file this big, you would need to import it, and once it's imported, wpDataTables reads the source file and creates a database table that can be edited. However, it cannot be updated by uploading (replacing) the source file since the file was read only at the moment the table was created - it is no longer being used to display the data of the table.
You're correct that you'd need to create a new table by uploading the modified file in order to see changes. I am not aware of any plugins that would allow you to upload a file and overwrite/add data to the corresponding database table, though.
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