Participants Database 1.5 WordPress Plugin

Call for Beta Testers!

Release of version 1.6 is coming, with new features & many code improvements.

I need beta testers, so if you have an install of Participants Database in a non-critical application and want to run it through it’s paces for me, email me.

what’s new in 1.5

There’s lots of improvements under the hood, and a list of new and better user features too:

Plugin Overview

This WordPress plugin is for the purpose of creating a database for use in a WordPress site. It is primarily intended as a way to manage information pertaining to people such as the members of a club or team, volunteers, students, anything like that. It gives you the ability to allow people to create and edit their own record while additional information can be managed by administrators or managers. The plugin may also be used as the basis for an index, directory or catalog.

>> Quick Setup Guide

The database is made up of fields, and each field may be one of several types that are uniquely suited to store a particular kind of information. These fields can also be divided into groups to help organize the information. Fields can also be provided with help text to assist users in providing the information.

Please read the documentation fully, as this is a complex plugin that can be used in a lot of different ways.

I have created a page that gives a step-by-step method for setting up a typical application of the plugin. I suggest you begin with that, it will help you understand how the plugin works and also give you a working baseline so you know the plugin works on your site. You can make your modifications to the plugin functionality from there.

[email protected]

Next… Using The Participants Database Plugin

2,644 comments

Hi, installed the PDB couple of days ago and implemented it to my so far experimental website and tested it abit. Looks great, was easy to understand and it was just the thing I was looking for.

However, I wish I could upload a CSV-file with more than 8 coloumns. Is it possible to do with some tweaks? I know it said that you have to follow the setup in upload menu.

by Mike on May 27, 2015 at 2:45 am. Reply #

Hi again. I have been thinking about this awhile now as I am designing a briefing page for a virtual airline. I have let`s say New York is one field and Boston is another. Now, I have a flight plan route field for example between these citites (a field on its own).

But I am out of coloumns in the CSV for the upload! :) So for New York – Washington route I need to manually put in the route for this. OR as I thought of now, use the Percistence. Let`s say I manually edit all the input field (and make them persistence) and THEN upload the CSV for the NEW York – Washongton flights. Persistence will put in manual labour I did in the first one I guess.

I hope I made sense and I will try this now to see if it works.

by Mike on May 27, 2015 at 3:13 am. Reply #

Ok! I found out that I just needed to mark the field with CVS (blahrgh)…

Now I have as many coloumns I could wish for! So thank you again for a great plugin :)

by Mike on May 27, 2015 at 3:28 am. Reply #

OK, Glad you got it working…but just to make it clear, the CSV setting is only for exports, you can upload any number of columns as ling as they match defined columns in the plugin.

by Roland on May 27, 2015 at 6:57 am. Reply #

You can upload as many columns as you want. What specifically is happening when you try to upload your CSV?

by Roland on May 27, 2015 at 6:55 am. Reply #

Great plugin. Is there a way for registered participants to delete their own profile and removed themselves from the system?

by Ken on May 25, 2015 at 11:36 am. Reply #

Hi Ken,

No, they can’t delete a record, but you can create a checkbox for them to use to deactivate it. Then, you just need to filter those records out of your displays. If you want to delete them, you can do that as an admin, list all the ones marked fro deletion, then delete them all.

by Roland on May 25, 2015 at 12:31 pm. Reply #

I’ve used this approach to let users delete their records. Just remember to add some way to prevent that record from being shown on the single record page.

(I solved it by adding some logic to the template I’m using, pdb-single-default.php.)

by Adrian B on May 25, 2015 at 12:38 pm. Reply #

It is possible to set the width of the columns? where can I do that?
thanks!

by Monica on May 19, 2015 at 6:59 am. Reply #

Formatting column widths can be tricky because tables attempt to expand to contain everything in the cells. So you can set the width of a column, but the results won’t always be what you want. You’re much more likely to get a column to be narrower than wider because of this.

The set the width of a table column, you just need to use a CSS rule that changes the width of the cell in the top row. The plugin’s tables have classes on the top row that you can use to set your widths.

There is no plugin setting for this, you have to do it with CSS. There is a place in the plugin setting where your custom CSS can go.

by Roland on May 19, 2015 at 7:36 am. Reply #

Since this issue was a WordPress/database issue, I’ve deactivated all my plugins, then started reactivating them. I think the problem was that I had set up the pages which include the database, member profile, etc. as password protected pages. The conflicting plugin was probably BAW Login/Logout Menu by Juliobox. I’ve deactivated that and removed password protection from the pages that were associated with the database. I would like the database to be restricted to registered site users but not sure if that is possible.

by Joan Oefner on May 18, 2015 at 11:15 pm. Reply #

Yes it’s possible to place the plugin shortcodes on restricted-access pages, I have lots of users doing this and I’ve doe it for several clients. The problem you described happened in the admin, so it’s likely unrelated to a restricted access page on the frontend. Is the plugin working OK now?

by Roland on May 19, 2015 at 7:31 am. Reply #

Our database was working great but now you can’t add any records, you get this error “Are you sure you want to do this?

Please try again.”

Could it be the upgrade to latest WP?
Previously I had password protected the database, it had worked previously even with the passwords, but not I’ve removed all passwords and it still isn’t working. Hope you can help me.

by Joan Oefner on May 18, 2015 at 7:25 pm. Reply #

Try clearing out all browser cookies from your site domain and log in again. That will probably do it.

by Roland on May 18, 2015 at 10:27 pm. Reply #

This an awesome plugin – I think what would be useful is for the ‘update’ email being returned to the administrator to advise what fields have been updated.
Adam

by Adam on May 18, 2015 at 1:37 pm. Reply #

Hello, great plugin. Is possible to get an email when a record is accessed?
Thanks!
Jose

by Miori on May 18, 2015 at 1:02 am. Reply #

If they save it, yes. Check under the “Record Form” tab in the settings.

by Roland on May 18, 2015 at 8:45 am. Reply #

Thanks Roland. I was able to do this but I need to get an email when someone actually click on the form and later when they save. Would you consider it as a feature down the road? for now I can search the list daily.
Thanks!

by Miori on May 18, 2015 at 9:32 am. Reply #

Probably not a feature I’d add, most people only want to know if the record is updated.

If you’ve got some coding skills, it wouldn’t be that hard to build this function into a custom plugin template for the record form.

by Roland on May 18, 2015 at 9:36 am. #

When I download a CVS file. The text (have tried rich text and text fields) are downloading with html formatting code around it and other characters – see below. I am I to expect this with the download?

………………(quantitative–qualitative), we evaluated the effectiveness of FSS program.As such, the Food Safety Supervisor (FSS) certification was THIS IS THE END OF THE TEXT.

Thanks
Adam

by Adam on May 11, 2015 at 5:04 pm. Reply #

I’ve been succesfully using PDB for several years on my kayak race web page. Great plug-in, thanks! Now, yesterday I upgraded to the latest WP version, and now there are some problems with PDB. The only visible item on the sign up page is the sign up button – there are no sign up fields visible any longer. Furthermore – the participants list is just showing some code info that I don’t understand: “Warning: current() expects parameter 1 to be array, null given in …/wp-content/plugins/participants-database/classes/PDb_Shortcode.class.php on line 494 Warning: key() expects parameter 1 to be array, null given in …/wp-content/plugins/participants-database/classes/PDb_Shortcode.class.php on line 500″ …. etc
Please have a look here: http://www.paddelrace.se/anmalan/
Any ideas of what could be wrong??
Thank you!
/Jörgen

by Jorgen on May 11, 2015 at 11:13 am. Reply #

I would guess that your database got corrupted or deleted somehow, those errors indicate the plugin was unable to find the data it needs to display form and lists and such.

There aren’t any known incompatibilities with the latest WordPress (4.2.2) I’ve got it running on several sites.

by Roland on May 11, 2015 at 12:06 pm. Reply #

Yes, it’s most definitely corrupted in some way. But where and how? I haven’t got a clue… Since I’m not the hacker type, I figure the easiest way for me is to simply delete the PDB plug in, and re-install it. I’ve managed to export all the current participants, so that I can add them manually when the new installation is done. Wish me luck!

by Jorgen on May 16, 2015 at 12:51 pm. Reply #

Is it possible to download the database (or filtered section) into a csv file from the front end rather than the WP dashboard – this would be useful?
Thanks Adam

by Adam on May 10, 2015 at 10:12 pm. Reply #

The plugin doesn’t have this ability as it is, sorry.

by Roland on May 11, 2015 at 6:46 am. Reply #

why I cant show the clickable link. I put this in the record
SRC_01191_12.pdf

by Spartan on May 6, 2015 at 9:37 pm. Reply #

Make sure it is fully configured: you must set up a page with the [pdb_record] shortcode on it, the select that page in the “Participant Record Page” setting under the “record form” tab in the plugin settings.

by Roland on May 6, 2015 at 10:33 pm. Reply #

How come I don’t receive a signup notification email and recipient do not receive signup response email?

by Khaw on May 6, 2015 at 7:26 pm. Reply #

Take a look at my Email Troubleshooter, it will help you solve your problem.

by Roland on May 6, 2015 at 10:32 pm. Reply #

is there a way to display a subset of members, ie all the real estate members?

by Barbara Davis on May 6, 2015 at 1:29 pm. Reply #

Yes, take a look at the “Other Notes” page, under “Filtering which Records Get Shown with the List Shortcode”

by Roland on May 6, 2015 at 10:31 pm. Reply #

Thanks again I will research that and find out what to do. Great service

by Tommy on April 29, 2015 at 8:36 am. Reply #

Thanks for your fast response.
From the box size, text-area seemed way to big.
I just wanted to double the existing area/field so one does not have to scroll to see the entry

by Tommy on April 29, 2015 at 7:41 am. Reply #

Are we talking about the size of the box or the number of characters that can be stored? If it’s the visible size of the box you want to change, you need to add a CSS rule to modify how your theme is formatting the text input box. If you need more characters, but the text-area box is too big, you can also set the to what you want it to be by using a CSS rule.

by Roland on April 29, 2015 at 7:57 am. Reply #

New at this, but is there a way to make the text-line boxes longer. 255 characters is a little short my my application. Thank you. Learning but great so far

by Tommy on April 29, 2015 at 3:44 am. Reply #

Have you tried using a text-area instead of a text-line?

by Roland on April 29, 2015 at 7:04 am. Reply #

Hi Roland,

When will it be possible to search within the list for a specific Record ID via ‘show only records with’? This would be extremely helpful for us.

Many thanks,
Daphne

by Daphne on April 17, 2015 at 12:10 am. Reply #

Not in the current version, the update has this ability…it will be out in a couple of weeks.

by Roland on April 17, 2015 at 6:56 am. Reply #

Leave your comment

Please note: comments are moderated by someone who is usually pretty busy and may not appear for several hours.

Required.

Required. Not published.

If you have one.



css.php