Hey everyone!

With the holiday season upon us, we want to share our upcoming working hours:

After that, we’ll return to our regular schedule and assist you as quickly as possible.

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.

Thanks a bunch for your understanding and support!

Warm regards and happy holidays!

TMS

Okay
  Public Ticket #2109877
Upload Excel file to be used in SQL Query
Closed

Comments

  • Ian started the conversation

    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

    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 siteFront-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: FAQFacebookTwitterFront-end and back-end demoDocs

    Amelia: FAQFacebookTwitter |  Amelia demo sites | Docs

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

    Powerful FiltersGravity Forms Integration for wpDataTablesFormidable Forms Integration for wpDataTables