I keep getting the same error over and over when trying to add new data into an existing table. I have counted the number of columns, including wdt_ID and the column names, and all seems fine.
If I understood, you are basically updating an existing Manual table by file upload, when that error comes up?
Can you tell me, are you including the wdt_ID Column in your source Excel?
If you are updating an existing Manual Table and if you try to include any of these 'premade columns' like wdt_ID, or wdt_created_by, wdt_created_at, wdt_last_edited_by and wdt_last_edited_at;
in that case, it will fail to import.
So please check and ensure that you only use your custom Columns in the source Excel file which is used for importing of the 'replace rows with source data' and exclude any of these 'premade manual columns' because they will auto-populate with auto-assigned wdt_ID and auto-asigned data for the user who uploaded the file and the time, when it was uploaded, etc.
Hi guys,
I keep getting the same error over and over when trying to add new data into an existing table. I have counted the number of columns, including wdt_ID and the column names, and all seems fine.
Except I get the error:
------------------------------------------------------------------------------------------------
There was an error while trying to save the table!parsererror
The number of columns in your file does not match the number of columns in the existing table. Please check your source file and try again.
------------------------------------------------------------------------------------------------
I have followed the instructions in your document and support videos, but to no avail.
Much obliged for any help ASAP on this matter.
Best regards
Michael
Hi Michael,
If I understood, you are basically updating an existing Manual table by file upload, when that error comes up?
Can you tell me, are you including the wdt_ID Column in your source Excel?
If you are updating an existing Manual Table and if you try to include any of these 'premade columns' like wdt_ID, or wdt_created_by, wdt_created_at, wdt_last_edited_by and wdt_last_edited_at;
in that case, it will fail to import.
So please check and ensure that you only use your custom Columns in the source Excel file which is used for importing of the 'replace rows with source data' and exclude any of these 'premade manual columns' because they will auto-populate with auto-assigned wdt_ID and auto-asigned data for the user who uploaded the file and the time, when it was uploaded, etc.
Let me know if that helped.
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