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 #2109877
Upload Excel file to be used in SQL Query
Closed

Comments

  • Ian started the conversation
    August 8, 2019 at 8:09pm

    Hello,

    I am wondering if it is possible to upload an excel table and then reference this table in an SQL query with your plugin?

    I.e.

    Upload Table A with 2 Fields, ID, Name

    Join this to a wordpress table

    Is this something that can be accomplished with your plugin

    Thank you

  •  472
    Isidora replied
    August 9, 2019 at 9:05am

    Hi Ian,
    Thank you for your purchase.

    If I understand you right, yes that is possible. You can use your Excel file and use third option in table wizard from which will be created table in database. 

    You can read more about this on this link. This table then you can use in your custom SQL queries.

    You can find name of the table in option MySQL table name for editing on Editing table in table settings.(attachment)

    You can try all of this on our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin premium features.

    All useful information about all wpdatatables features that are explained (video and text) you can find in our DOCUMENTATION.

    If this is not what you look for then please explain me in little more details on what you mean exactly and I will gave you my suggestion.

    Best regards.

    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter |  Amelia demo sites | Docs

    You can try our wpDataTables add-ons before purchase on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables