We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
I can't seem to find anything in the docs about re-importing data once I have a table set up. I used sample data first for testing and I now want to import a much larger data set into the same table. Do I need to use an add-on plugin or is there a way to re-import the bigger, live data set through the WPDataTables dashboard.
Thanks!
- Duane Bentzen
Hello Duane
As per my knowledge once a table is set up, data sets cannot be re-imported through WPDataTables dashboard, but I have been doing it through phpMyAdmin using a CSV file.
Before importing
1. If the first row of the CSV contains column names, then it has to be deleted.
2. In the CSV add an empty column in the very beginning so that it becomes the first column. This will be the wdt_ID column (for entry IDs).
3. In phpMyAdmin go to the dB table and under the Import tab, select CSV as the Format.
4. Under 'Format-specific options', select the 'Do not abort on INSERT error' checkbox.
5. Hit the 'Go' button to import the data.
Hope this helps.
Regards
Srinath
Srinath, thank you for your assistance here!
Duane, what Srinath said is basically true, depending on what you're using to create a table.
If you're creating a table linked to an existing data source (Excel, CSV), you can modify the file in ../wp-content/uploads/YEAR/MONTH folder, and in that way, you can replace the source file.
Our developers did work on this in the past few updates, but we cannot guarantee that the table will work correctly if the structure of the file is different. This means that the new file needs to have the same column headers and the same order. So, if you have columns A, B, D, C, G, the new file needs to consist of the same columns, in the same order
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