In my table I have selected first option that says "Create a table linked to an existing data source."
Whenever I update my Excel file I have to upload that every time for the updates to get reflected on my table, this increases old copies of excel file on my WP database which I have to separately delete from galary. Am I doing something wrong here Or not doing smart work or there is no other option than this?
When you select a file to be used as an external data source, that file is being stored in ../wp-content/uploads/YEAR/MONTH.
For example, if you select a file "test.xlsx" from your desktop - making any changes in that file won't affect the table created from it. You need to modify the "test.xlsx" file located in ../wp-content/uploads/2019/03 (that's a folder where files uploaded in March, 2019. are being stored).
Please note: Once you create a table from an external data source, 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,
In my table I have selected first option that says "Create a table linked to an existing data source."
Whenever I update my Excel file I have to upload that every time for the updates to get reflected on my table, this increases old copies of excel file on my WP database which I have to separately delete from galary. Am I doing something wrong here Or not doing smart work or there is no other option than this?
Thanks.
Hi rakesh.
When you select a file to be used as an external data source, that file is being stored in ../wp-content/uploads/YEAR/MONTH.
For example, if you select a file "test.xlsx" from your desktop - making any changes in that file won't affect the table created from it. You need to modify the "test.xlsx" file located in ../wp-content/uploads/2019/03 (that's a folder where files uploaded in March, 2019. are being stored).
Please note: Once you create a table from an external data source, 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.
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