To make it easiest on my client, I want her to keep her data in an Excel spreadsheet. But I need to do my own wpdb query to extract the data, in order to do more advanced formatting.
Since the "Excel" type of table isn't actually in the database, I cannot query that. So I can have her import her excel data into a Manual table. When she makes updates, I want her to be able to simply re-import the whole file, allowing my code to use the same table query.
Is there a way to clear out the table, so that when she re-imports the data, it's only what's currently in the file?
Unfortunately each manual table will be needed to be imported again and there is no possible way to just upload the file and empty the already created table.
As for the Add from data source (the first option in table wizard) the changes in the file will be applied to the table after some time ( because of the caching).
Hi! Extremely awesome plugin!!!
To make it easiest on my client, I want her to keep her data in an Excel spreadsheet. But I need to do my own wpdb query to extract the data, in order to do more advanced formatting.
Since the "Excel" type of table isn't actually in the database, I cannot query that. So I can have her import her excel data into a Manual table. When she makes updates, I want her to be able to simply re-import the whole file, allowing my code to use the same table query.
Is there a way to clear out the table, so that when she re-imports the data, it's only what's currently in the file?
Thanks!!!
Hi anniengo,
Thank you for your purchase.
Unfortunately each manual table will be needed to be imported again and there is no possible way to just upload the file and empty the already created table.
As for the Add from data source (the first option in table wizard) the changes in the file will be applied to the table after some time ( because of the caching).
Best regards.
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
OK, thanks for the quick response!