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!

Okay
  Public Ticket #3704580
wrong number of columns when appending or replacing rown
Closed

Comments

  •  1
    Michael started the conversation
    August 13, 2024 at 7:07pm

    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

       

  •  1,895
    Miloš replied
    August 15, 2024 at 6:38pm

    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?

    3091569499.png

    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.

    5195819183.png
    6654926734.png

    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