Hi, Samantha

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.

-

There are two ways in using wpDataTables with CSV:

1. If you wish to create a table that will be linked/synchronized with the source CSV file,

you could update/edit the values from the source CSV file, and the output table would immidiately update with it, as soon as the page refreshes.

It will not be editable from WP-Admin/or front-end;

and  please note these limitations of this method,

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, you will have to recreate the table again.

-

2. 

the second option is to import the data during table creation, which will not synchronize the source CSV and the output table,

but the table will become editable in WP-Admin and it can be editable on front-end as well.

- A table would be created in the WP database.

If you wish to update it by importing an updated CSV with updated values, you will not be able to delete/add new columns, or change header name of columns.

The only way to import CSV into existing table like that,

would be to only leave the new rows in the updated CSV file, 

delete "old existing rows", and delete headers( first row),

and for example, you could use phpMyAdmin to import the data from CSV containing only the new rows.

-

Our developers will work on improving that functionality in the future, but i can't say an ETA on it.

Let me know if anything was not clear, and if you have further questions. Thank you.

Hi, Samantha

I just forgot to add, regarding charts,

even if you would be able to add new columns to existing wpDataTables via CSV import,

the charts would not be able to automatically pick them up,

because during the chart creation, you have to pick a table and also pick the columns for the chart.

If you then add a new column, you would have to manually edit the chart, and add a new column into it,

so, unfortunately, there is no automation in that regard, as well.

- 

Our developers are always working to improve the plugin, so, if they find a way to add this functionality in the future, they will do it,

but for the time being there is no way to achieve it, sadly.