Hi, Brian

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

To be fully honest with you, i have not seen a setup like this before, it is not my area of expertise.

First, i will give you the general information about using Excel with our plugin, and i will check with my senior colleagues from the 2nd level Team, if they can confirm the answer to your main question, if our plugin is capable of doing something exactly as you need it.

-

You can use Excel files in two ways to create wpDataTables:

1. Create a table linked to an existing Excel file, in which case you get to select the file (upload it) that'll be used to pull the data. 

This file will be stored in ../wp-content/uploads/YEAR/MONTH/ folder. The file on that location can be changed, but the structure can't. 

So, if you have the file with the same title, the same number of columns, same headers, and the same order of columns - you'd be able to replace the original file with the new file, and wpDataTables would pick that up.

2. Create a table by importing the Excel file. In this case, the source file is read, and a manual table is created. So, the generated table reads the source only once, and after that, there are no relations between it and the wpDataTable. You would be able to edit the table, but the changes wouldn't be seen in the source file. In this case, you'd be able to save new rows in a separate Excel file (without column headers) and export it as CSV.

 Then, access the table and in the Editing tab above the table see what the "MySQL table name for editing" is. Access your database and access that table. In the "Import" tab select the new CSV file and import it. 

That will update the table. Another option would be to switch to Excel-like view, select a range of new cells from your Excel file and paste them below the last row in wpDataTables.

-

I will get back to you as quick as i can, once i confirm if we can create a data flow as you need it / as shown on the example, but i am hoping that this information was at least useful for a start.

Thank you.

Hi, Brian

Sorry for all the waiting time that it took to test and confirm this.

Unfortunately, this is not possible to create using any plugin's built-in functionalities.

We will try to add a solution for this in the future, but i can't say an ETA on it.

Maybe it can be done with a high level of custom work, but I am not sure, to be honest.
Our developers are very busy at the moment, working on some priority tasks and fixing bugs and issues with our plugins, so they won't be having the time for custom work in the near future.

We can recommend reaching out to someone who does custom solutions, such as WP Kraken,
but we can't advise on their pricing.