Hi, Jouke

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.

- Just as you described, it is correct, because you cut down the number of rows to 240, we are able to import the CSV without issues.

- Could you send us the full version of the CSV with all of the rows, and we will replicate the issues on our end?

If it contains any kind of sensitive data, you can check the reply as Private, so nobody can see it but us.

- Our plugin is capable of handling very large amounts of data using SQL server-side processing. 

If you'd like, you could check out this example on  our documentation with a table where  wwe used a data set of 2.560.000 rows.

On our sandbox, it might be that we did not set the upload limit high enough, we will certainly check that, too.

Hi, Jouke

Sorry for the delay.

I am glad to see that you have now successfully started with the table, and a chart, as well.

-

If the original CSV file would be uploaded to a certain file path;

and if the new CSV files would only overwrite this file, to keep the same path, and same column structure, such as header names;  and not to add or remove columns;

basically only to edit existing rows, or update new rows with values, then it can work,

if you use the method to link the CSV to wpDataTable output;

-

But if they are going to have 10 thousand rows, or more, like this one... basically anything more than 3000 rows will be extremely slow, or even break the page, unfortunately,

in that case you would have to switch to something that uses server-side processing, such as SQL based tables.

-

Alternatively, if you import the CSV to create a table in the database;

there are some workarounds, but they require a bit more work, such as :

You could create an initial imported table from CSV;

it will exist in the database;  but it won't be linked to the source CSV anymore;

If you want to update it later using CSV,

the only way is to either use something like PhPMyAdmin, to insert CSV as update;

but you would have to remove headers, and remove old rows > only to keep the new/updated rows, and import CSV like that...

-

There are also custom SQL Queries that might achieve that, to update a table via CSV automatically from certain path ; 

but both of these " custom workaround" solutions would not be covered by our support.

-

For SQL Queries, please note :

Using this plugin feature requires at least a basic knowledge of SQL. It is assumed that you can create the table in some MySQL data manager (e.g., PHPMyAdmin, MySQL Workbench), and prepare a SQL query that will return the data you need. If you do not know how to use MySQL, refer to the “Create a MySQL-query-based table by generating a query to MySQL database” section. It will explain how to create complete tables or MySQL queries without this basic knowledge. Please be advised that preparing MySQL queries for you is not included in the plugin support.

-

Sorry for such a long message, i just wish to try and advise you in the best possible way with all of the details.

Let me know how all that sounds. Thanks.