Hey there, Awesome Customers!
Just a heads up: We'll be taking a breather to celebrate International Workers' Day (May 1st and 2nd - Wednesday and Thursday) and Orthodox Easter from Good Friday (May 3rd) through Easter Monday (May 6th). So, from May 1st to May 6th, our team will be off enjoying some well-deserved downtime.
During this time, our customer support will be running on a smaller crew, but don't worry! We'll still be around to help with any urgent matters, though it might take us a bit longer than usual to get back to you.
We'll be back in action at full throttle on May 7th (Tuesday), ready to tackle your questions and requests with gusto!
In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find loads of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel). These gems might just have the answers you're looking for while we're kicking back.
Thanks a bunch for your understanding and support!
Catch you on the flip side!
Warm regards,
TMS
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
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:
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 | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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
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