I have purchased the plugin and am very happy except for one thing. After creating a table from an XL file, , I will need to periodically import new data via an XL or .csv file and append it to the current data. I can't see anywhere that will allow me to set up this option. Can you help?
When you create a table using the first option (Create a table linked to an existing data source), wpDataTables is used only to display the values from an external source (Excel, CSV, Google Spreadsheet) and it cannot be edited. If you make changes in the source file - it will be shown in the table. However, please note that this file is being stored in the Media Library of your WordPress site, so if you upload a file from your desktop - changing something in that file wouldn't affect the contents of the table created by our plugin. Instead, you need to access the file in ../wp-content/uploads/YEAR/MONTH/your_file.xlsx and then the changes will be visible.
Please note: Once you create a table from an Excel file, changes in this file, like:
Changing the column’s name,
Changing the column’s order,
Deleting the column, and
Adding a new column.
are highly not recommended, because the table in the wpDataTable plugin will not work, at the moment. If you make any of these changes, please recreate the table again.
Hi
I have purchased the plugin and am very happy except for one thing. After creating a table from an XL file, , I will need to periodically import new data via an XL or .csv file and append it to the current data. I can't see anywhere that will allow me to set up this option. Can you help?
Regards
Georg
Hello Georg.
Thank you for your purchase.
When you create a table using the first option (Create a table linked to an existing data source), wpDataTables is used only to display the values from an external source (Excel, CSV, Google Spreadsheet) and it cannot be edited. If you make changes in the source file - it will be shown in the table. However, please note that this file is being stored in the Media Library of your WordPress site, so if you upload a file from your desktop - changing something in that file wouldn't affect the contents of the table created by our plugin. Instead, you need to access the file in ../wp-content/uploads/YEAR/MONTH/your_file.xlsx and then the changes will be visible.
Please note: Once you create a table from an Excel file, changes in this file, like:
are highly not recommended, because the table in the wpDataTable plugin will not work, at the moment. If you make any of these changes, please recreate the table again.
I hope this helps.
Best regards.
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