"create a table linked to an existing data source" (#2311945) / TMS-Plugins

Comments

Paschal started the conversation
February 26, 2020 at 4:55pm
Hi,
If I create a table using wpdatatables in my WordPress site, from a linked data source (Excel file) on my desktop computer, is it possible to automatically update new data inputted from my data source unto the WordPress site table?
This question is assuming i need to input data on my source file, and have internet connection issues, and would expect it to update as soon as i get connected, without having to update the site table myself again.
2,576
Aleksandar replied
February 27, 2020 at 8:40am
Hello Paschal
Thank you for your interest in our plugin.
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
Tables linked to an existing Excel file use the file (from your desktop, for example), and create a copy of it in ../wp-content/uploads/YEAR/MONTH/ folder. The file in that folder is being used to generate the table, not the original file on your desktop. So, you can edit the file on your desktop, and copy and replace that same file in the Uploads folder. That way, the table will have the same structure, and the new data will be displayed in the wpDataTable.
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