Once you create a table by importing an external data source (CSV, Excel, Google Spreadsheet), that data source is being imported and once the operation completes that's all the plugin has to do with the file. It is being stored as a "Manual" table, which you can modify only manually.
If you wish to have a dynamic table, created from an external data source, you can create it using the first option (Create a table linked to an existing data source). You wouldn't be able to edit the table from the plugin, but only modifying the source file. Also, if you use the source file located on your desktop - the plugin will make a copy of it in your media library, and will not use the file from the desktop. So, let's say you use the file from your desktop. In order to change the table in the plugin, you would have to open the file located in ../wp-content/uploads/YEAR/MONTH.
Please note: Once you create a table from a CSV file, 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, please recreate the table again.
So, you can add content to existing columns, but not anything mentioned above.
I have created a wp datatable from a .csv file. I need to import new records into the table. How can I do this?
Clicking "new entry" is not acceptable due to volume and propensity for errors.
I cannot simply delete and create a new table because the underlying table name in the database is changed.
Hello Mardeebo.
Once you create a table by importing an external data source (CSV, Excel, Google Spreadsheet), that data source is being imported and once the operation completes that's all the plugin has to do with the file. It is being stored as a "Manual" table, which you can modify only manually.
If you wish to have a dynamic table, created from an external data source, you can create it using the first option (Create a table linked to an existing data source). You wouldn't be able to edit the table from the plugin, but only modifying the source file. Also, if you use the source file located on your desktop - the plugin will make a copy of it in your media library, and will not use the file from the desktop. So, let's say you use the file from your desktop. In order to change the table in the plugin, you would have to open the file located in ../wp-content/uploads/YEAR/MONTH.
Please note: Once you create a table from a CSV file, changes in this file like:
are highly not recommended, because the table in the wpDataTable plugin will not work, at the moment. If you make any of these changes, please recreate the table again.
So, you can add content to existing columns, but not anything mentioned above.
Best regards.
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