How to make an update to existing table that was imported via CSV, I need to update current lines or be able to export the whole table to change info/add some lines and import it back (or export, empty current table if update is not possible) but without creating and configuring new one, so I need to stay with old shortcode and old settings.
If you used the third option to create the table (Create a table by importing data from data source), that table would be editable in wpDataTables, but those changes wouldn't reflect in the source file.
If, however, you used the first option to create the table (Create a table linked to an existing data source), that table will not be editable through wpDataTables, and it is only showing the data from the source file.
You can change the contents of the source file and those changes will be seen in wpDataTables, but once you create the table, the plugin stores a copy of the source file in ../wp-content/uploads/YEAR/MONTH and that's the file you need to modify in order for wpDataTables to display the change.
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.
Sorry for late reply, thanks for your answer. As I have big tables created with option 3, the best way to go is to export, make changes, import as a new table and change shortcode to new one.
Will be happy if sometime you'll make an "update/add lines by csv" functionality like ninja tables has. If there is any similar requests, +1 from me :)
Thank you for your suggestion. We carefully follow customers requirements and try to implement most of them if they appear in requests from time to time, so we will add to our idea list and look into some possible solutions on plugin side in the future.
Maybe you can consider going for large MySQL query based tables. You can add CSV files to the database using PHPMyAdmin, and tables created linked to an existing file source would update automatically for SQL query based tables.
Hello!
How to make an update to existing table that was imported via CSV, I need to update current lines or be able to export the whole table to change info/add some lines and import it back (or export, empty current table if update is not possible) but without creating and configuring new one, so I need to stay with old shortcode and old settings.
Hello Kostya.
Thank you for your purchase.
If you used the third option to create the table (Create a table by importing data from data source), that table would be editable in wpDataTables, but those changes wouldn't reflect in the source file.
If, however, you used the first option to create the table (Create a table linked to an existing data source), that table will not be editable through wpDataTables, and it is only showing the data from the source file.
You can change the contents of the source file and those changes will be seen in wpDataTables, but once you create the table, the plugin stores a copy of the source file in ../wp-content/uploads/YEAR/MONTH and that's the file you need to modify in order for wpDataTables to display the change.
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.
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
Sorry for late reply, thanks for your answer. As I have big tables created with option 3, the best way to go is to export, make changes, import as a new table and change shortcode to new one.
Will be happy if sometime you'll make an "update/add lines by csv" functionality like ninja tables has. If there is any similar requests, +1 from me :)
I see, Kostya.
Thank you for your suggestion. We carefully follow customers requirements and try to implement most of them if they appear in requests from time to time, so we will add to our idea list and look into some possible solutions on plugin side in the future.
Maybe you can consider going for large MySQL query based tables. You can add CSV files to the database using PHPMyAdmin, and tables created linked to an existing file source would update automatically for SQL query based tables.
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
May be it's the way to go, I'll have a look, thank you!