Hi - I've created a new table (MySQL) and imported the initial 5K rows of data. Each day I will need to add new data to this table (~200 rows). I see how I can manually edit/add rows in the backend, but how would I import the daily new rows via csv or excel to add to the new table I've created? I've searched 'import' and 'add' on the FAQ and public tickets but was unable to locate any clear method.
Thanks for reaching out to us, and sorry about the delayed answer.
-
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 using a database management tool, such as PhpMyAdmin,
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.
-
Let me know if you have any further questions. Thank you.
Hi - I've created a new table (MySQL) and imported the initial 5K rows of data. Each day I will need to add new data to this table (~200 rows). I see how I can manually edit/add rows in the backend, but how would I import the daily new rows via csv or excel to add to the new table I've created? I've searched 'import' and 'add' on the FAQ and public tickets but was unable to locate any clear method.
Hi, Jason
Thanks for reaching out to us, and sorry about the delayed answer.
-
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 using a database management tool, such as PhpMyAdmin,
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.
-
Let me know if you have any further questions. Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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