Hi again Torsten

Did you acquire the Master-Detail add-on? It would allow your users to click on the row (or a button) in the row, and display the rows from the attached image. Those rows would actually be hidden columns, along with the image column that would show the image in the master-detail modal (or page).

160.000 rows is not that large for manual (imported) tables, so you should have no issues regarding the size. Importing new data, however, is not that easy. You wouldn't be able to create a table linked to the CSV file, because they can handle only smaller tables (up to 3.000 - 4.000 rows), so the only option is to import the table. That creates a manual table which is saved in the database.

To update the table by importing the CSV file again, you'd need to remove the headers and existing rows, and include only new rows. Then, in the database, find the wp_wpdatatable_# that was created, and then import that new CSV file in there.

Another option would be to view the table in Excel-like mode in back-end, and then bulk select; copy and paste the data from Excel.

Hi again Torsten

You need to go into wpDataTables settings, and adjust the number format so it is the same as in the CSV file.

For example, if your numbers in the CSV have a dot as the decimal separator, you need to change the number format to 15,000.00 in wpDataTables settings. Then you should have no issues adding the column as float.

There's no way of updating the existing table by just uploading the new CSV file. The plugin doesn't have those options yet, so updating it through the database, or copying a range of cells into Excel-like view is the only solution for now.

The plugin doesn't have any features that would look for existing data, and disable editing if there already exists an entry like that. You can, however edit the email field in the database, adding a unique constraint, like this:

ALTER TABLE myTableName ADD CONSTRAINT UQ_MyTable_Email UNIQUE (emailColumnName)

And it will not allow anyone to add the same email address if it already exists in the table.

That is just an example, but that's how it needs to be set in the database.

Hello again Torsten

1. Unfortunately, something like this would have to be done as a custom solution. It looks rather nice to me, though. I wouldn't change it one bit. You can use the class td.dataTables_empty if you wish to modify the size or the color.

2. The only thing you can do here is to add (required) in the filtering label, so it looks like "Serial number (required)", but that's pretty much it.

3. Not without customization. It would require a custom script that would see "ENTER" as a button click. Unfortunately it can't be done with the built-in features.

Hi again Torsten

1. You can use table tools to download the table in Excel or CSV format. Please note that the table tools can only download what they see, so if you want to export a table that has 20 rows, you will need to display all 20 rows on the page and then do the export.

2. Unfortunately, there's no way of making that happen. The wdt_ID column is an auto-increment column, which stores the row data, but it can't be automatically recalculated when the row is deleted.