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 #1642132
Cannot create table via XML or JSON
Closed

Comments

  • Scott Thomas started the conversation
    July 14, 2018 at 11:58pm

    I am demoing your plugin on a friend's website. He LOVE's your wpDataTables and I am considering purchasing it for a project I am working on.

    However, I cannot create one single table automatically.

    First, I tried using JSON as the source and the URL: https://api.battlemetrics.com/servers?filter[game]=ark&page[size]=100

    When I click apply, I get an error "Please provide a correct format for the cell".

    So, I converted the JSON to XML and tried again to create a table using the XML option and the URL: http://www.extinctioncore.com/temp/test.xml

    SAME ERROR

    If you can help me sort this out, I will gladly purchase the plugin as this will help greatly with many projects.


    Thanks

  • [deleted] replied
    July 16, 2018 at 9:53am

    Hi Scott Thomas,
    Thank you for your inquire.

    The problem in the both of these files is the same. Basically files that you are trying to use have more levels that our plugin could understand. From our - Documentation:

    • When working with JSON format please note: Currently, wpDataTables accepts this, and only this, format of JSON (see example): a one-level array of same-structured objects where each object will be parsed as a row, and each field inside of the object as a cell. If your software does not return this format, you would need to prepare, as an example some PHP adapter to return one of the formats that wpDataTables would accept.

    So our suggestion would be to create one PHP file which will fetch data from that JSON/XML and convert it to format that our plugin understand and return in in form of serialize PHP array.

    In the format that you have our plugin could not tell if columns should be data or type, id attributes, or id, name, ip, port.... so you need to convert it to have objects with repeatable array of column names with their values like in the example on our documentation page