Hi, I initially bought a license for wpDataTables for a specific reason but could never could get it to work. I am now giving it another go but still cannot find a way to do what I want.
I created a new database table by importing data from a CSV file. I assumed that because the table is editable, I will be able to upload and import new sets of CSV data to be inserted into the table when necessary. However I can only see a way to add new data manually, row by row. This is quite a time consuming process if I have to add lots of data.
Is there not a way to import new data (from CSV for example) and insert it to a table already created via wpDataTables, instead of having to create a new separate table for each set, even though the data structure is exactly the same? It seems that the functionality is technically already there in the code but there is no way to do this via the interface.
I hope you understand what I mean!
Your advice in this regard would be much appreciated.
Uploading files to existing tables, to update the data in that way is, unfortunately, not possible.
You have two options:
1. Edit the table in Excel-like editor, where you can select a range of cells from an Excel file (you can open the CSV file in Excel, and select only the new data you want to add), copy them and paste them in the last row of the Excel-Like editor, and that will paste all selected cells in the table.
2. Save the new data you want to add (without headers) as a separate CSV file, go to the database and find the database table. Access it, and go to "Import" tab, where you can import that new CSV file, and update the database table in this way.
Our developers will be working on this in the future, but I have no ETA as to when it will be implemented in the plugin
Hi, I initially bought a license for wpDataTables for a specific reason but could never could get it to work. I am now giving it another go but still cannot find a way to do what I want.
I created a new database table by importing data from a CSV file. I assumed that because the table is editable, I will be able to upload and import new sets of CSV data to be inserted into the table when necessary. However I can only see a way to add new data manually, row by row. This is quite a time consuming process if I have to add lots of data.
Is there not a way to import new data (from CSV for example) and insert it to a table already created via wpDataTables, instead of having to create a new separate table for each set, even though the data structure is exactly the same? It seems that the functionality is technically already there in the code but there is no way to do this via the interface.
I hope you understand what I mean!
Your advice in this regard would be much appreciated.
Regards,
Marie
Hello Marie
Thank you for your purchase.
Uploading files to existing tables, to update the data in that way is, unfortunately, not possible.
You have two options:
1. Edit the table in Excel-like editor, where you can select a range of cells from an Excel file (you can open the CSV file in Excel, and select only the new data you want to add), copy them and paste them in the last row of the Excel-Like editor, and that will paste all selected cells in the table.
2. Save the new data you want to add (without headers) as a separate CSV file, go to the database and find the database table. Access it, and go to "Import" tab, where you can import that new CSV file, and update the database table in this way.
Our developers will be working on this in the future, but I have no ETA as to when it will be implemented in the plugin
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
Thank you.
Regarding Option 1: would I only be able to copy/paste a single row at a time or would this work for multiple rows with one copy/paste action?
Hi again Marie
You can select a range of cells, and paste them all at once.
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