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 #2731573
unable to Create a data table by importing data from a data source
Closed

Comments

  • Wasike Paul started the conversation
    March 25, 2021 at 10:38am

    I am getting an error while Create a data table by importing data from a data source. In my case the data source is an excel file.

    The error i am receiving is;

    There was an error while trying to generate the table! Internal Server Error
    There has been a critical error on this website.

    Learn more about troubleshooting WordPress.

    Kindly help me fix this error please.


  • [deleted] replied
    March 25, 2021 at 10:47am

    Hi Wasike

    Thank you for reaching out to us.

    Could you kindly send us the file so we can try and recreate the issue on our end and find the best solution?


  • Wasike Paul replied
    March 25, 2021 at 10:53am

    Dear Blaženka,

    Thanks a lot for your swift response.

    Kindly let me know which file i should send to you please.

    Do you mean the zipped wpdatatable plugin is the one i should send you, or which one.

    Let me know please.

    Thank You

  • [deleted] replied
    March 25, 2021 at 10:56am

    I apologize I should have been more clear.

    If you could send us the Excel file you are trying to import that would be greatsmile.png 

    Thank you

  • Wasike Paul replied
    March 25, 2021 at 11:03am

    Alright.

    I got you now.

    Kindly find the excel file am trying to import below.

    Thank You.

  • [deleted] replied
    March 25, 2021 at 12:18pm

    Thank you.

    The file you are trying to import is not formatted correctly so the plugin is unable to read the values properly and it results with an error.

    Please note there are some limitation when trying to import Excel files.

    Formulas and merged cells are not supported.

    Formatting applied in the original file (font families, color, size, fill color, etc.) will not be copied over to the wpDataTable, but you can make whatever adjustment you may need in WpDataTables.

    Please try reformatting the file and refrain from using any customization in the Excel file and let us know if it works.

  • Wasike Paul replied
    March 25, 2021 at 12:36pm

    Alright Blaženka, 

    Thank you so much for your valued advise,

    Let me apply suggested adjustments then get back to you.

    Thank You.

  • [deleted] replied
    March 25, 2021 at 1:30pm

    You are most welcome.

    If you create a simple Excel file you shouldn't face any issues when uploading it but we will await your response to make sure everything is in ordersmile.png