Posted on by

Clearing the Participants Database Table

If you want to start with a clean slate on Participants Database, you need to reset the main database table. One way to do this is to use phpMyAdmin, an application for managing databases. This application is usually available in your hosting control panel: Open the application, select your WordPress database, then select the Participants… (read)

Posted on by

Generating Unique Member IDs for New Registrations

Update 1/16/19: this plugin had to be rewritten to work with versions of Participants Database later than 1.8.0. I often get questions about how to set up member IDs in Participants Database. It is possible to use the built in “id” or “private_id” fields, but in most cases, you’ll want to be able to generate… (read)

Posted on by

Copying a Participants Database Setup to Another Site

While Participants Database does not have a settings export feature, it is possible and not too hard to export the settings from an existing install and copy them to an install on another site. To do this, you’ll need to access a database management tool, such as phpMyAdmin, which is typically provided in your hosting… (read)

Posted on by

Getting Correct Search Results with Non-English Characters

Participants Database is set up to be compatible with non-English installs using the normal localization setup provided by WordPress: download the language pack, choose your language in the settings, and you’re set. Participants Database will follow along, as long as it has a translation file that matches the chosen language. This is discussed in more… (read)

Posted on by

Showing a Record Edit Form Based on a Value in the Record

When using Participants Database to represent two or more classes of people or things, you sometimes need to customize the frontend edit form so that is only shows the fields that are relevant to the type of record that is getting edited. We can easily do this with a custom template. If you’re not familiar… (read)

Posted on by

How to Copy Participants Database to Another Site

Sometimes, you want to duplicate a configured installation of Participants Database to another site or server. It can be done, it’s a bit complicated, and you’ll need to be familiar with database tools such as phpMyAdmin. Start by installing the plugin in the new location. Activate it to set up the initial database entries, then… (read)

Posted on by

Migrating an Existing Database into Participants Database

If you have a database already and want to adapt it for use in the Participants Database plugin, you’ll have to set up the plugin to interface with that data and then import the data itself into the plugin’s main database table. Here’s how you get that done. Start with the User Interface Participants Database… (read)

Posted on by

“Multiple Databases” with Participants Database

One of the most frequent support requests I receive for the plugin is: can it do multiple databases? Can multiple instances of the plugin be installed? To both questions, the answer is no, it’s not designed for that, but you can do a lot with this plugin and in most cases it’s not really necessary… (read)