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.
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.
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
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