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 #2294548
Connection to MySQL database
Closed

Comments

  • Mark Beasley started the conversation

    I have a name index for past issues of our Journal, with over 350K names. Currently, I work from an MS Access database to generate name-grouped pdf indexes.

    I created a table in our database. It does not have the standard Wordpress wp- prefix.

    Question:  Can I connect directly to this table and only this table to create a searchable index on the website?

    Question: Does the table need to have the wp prefix in the table name?


    Thanks,

    Mark

  •  2,576
    Aleksandar replied

    Hello Mark

    Thank you for your interest in wpDataTables.

    If this is the same database where WordPress resides, all of them would have the same prefix, so you could create a table simply querying it:

    SELECT * FROM yourCustomPrefix_table

    However, if this is a table located on another database, you would first need to connect that database through wpDataTables settings, as a Separate DB Connection. Then, when creating a table, you would choose that separate DB connection from the dropdown, and use the query box normally to create a table.

    You do need to have a prefix in front of the table name, but you don't need to pass the database name?

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

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

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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

  • Mark Beasley replied

    Hi, Aleksandar

    Thank you for your quick response.

    After going back and looking at it, the table is in the same DB as Wordpress, and I did give it a wp prefix:  wp_journal_index_names - so this shouldn't be an issue.

    It has almost 400,000 records in it now, and several thousand more when I update it with the last two years worth of Journals.

    So a few more quick questions:

    Will this size of table pose any issues with wpDataTables? Would it require any special configuration?

    Assuming the plugin can handle this, I intend to purchase the plugin for the non-profit organization I'm building this for. So the final question is, can I install this on my dev site to work it out and then install it on my live site under the same license? 

    Thanks,

    Mark

  •   Aleksandar replied privately
  •   Mark Beasley replied privately
  •   Aleksandar replied privately
  •   Mark Beasley replied privately
  •   Aleksandar replied privately
  •   Mark Beasley replied privately
  •   Aleksandar replied privately