CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Any Way to See Multiple Registration Correlation?
Pages: [1]

Author Topic: Any Way to See Multiple Registration Correlation?  (Read 737 times)

nessnzoe

  • I post occasionally
  • **
  • Posts: 84
  • Karma: 2
    • GingerFeet LLC
  • CiviCRM version: 3.4.8
  • CMS version: Drupal 6.22
  • MySQL version: 5.1.14
  • PHP version: 5.3.6
Any Way to See Multiple Registration Correlation?
January 24, 2011, 05:16:40 pm
Hi all,

We've got a client who is using Register multiple participants? - which is working fine - except that there's no correlation after-the-fact to see who, the one registering, has registered...is that correct? I.e., John Doe register himself and two friends, Milo Bloom and Elmer Fudd. If I search on contributions I can see that he did multiple registrations, but I don't know who's associated with his registration/payment.

Or am I missing something?

Any thoughts would be most appreciated.
Cheers!
Vanessa

nessnzoe

  • I post occasionally
  • **
  • Posts: 84
  • Karma: 2
    • GingerFeet LLC
  • CiviCRM version: 3.4.8
  • CMS version: Drupal 6.22
  • MySQL version: 5.1.14
  • PHP version: 5.3.6
Re: Any Way to See Multiple Registration Correlation?
February 08, 2011, 09:41:57 am
Well darn...now the client has noticed this issue and is asking how CiviCRM connects the person who registers multiple participants with the folks they register. They are holding 1) a golf tournament and the participants are all team members, so they need to know who connects to whom; and 2) they are having a fund-raising ball where a registrant can register up to 10 people and buy out a table - so they all need to be connected so that the administrators know where to place people.

Is there any way to do this?  ???

Or at the very least, can the list of the multiple participants be included the notification email?

Thanks,
Vanessa

rjb

  • I post occasionally
  • **
  • Posts: 63
  • Karma: 2
  • CiviCRM version: 3.3.5
  • CMS version: Drupal 6
  • MySQL version: 5.1.44
  • PHP version: 5.3.1
Re: Any Way to See Multiple Registration Correlation?
February 09, 2011, 06:19:31 am
Fear not, Vanessa - this is all do-able.

Just go to Events>Manage Events>[Your Event]>Participants>Registered, Atended, Etc

Select All [however many you have] Records and choose 'Export Participants' from the 'Actions' dropdown.

On the next page, choose 'Select fields for export' (you can save this for future reports), then continue.

It's up to you which other fields you want to export (names, emails and phone numbers from the Individual list seem wise) but the one you're after is: Record type = Participant  ---+--- Registered By ID.

Export this spreadsheet and you'll see a column which gives you the Registered By ID for every participant. NOTE: this isn't their contact ID but the Participant ID, so you'll have to cross-reference the contents of this column with the Participant ID column (which will be in the spreadsheet whether or not you selected it - it's a default).

Regarding the notification email, that's do-able, too.

Just go to Events>Manage Events>[Your Event]>Configure>Online Regsitration

At the bottom of the form, you'll see a BCC field where you can enter the email address of someone at your organisation. They'll receive the same confirmation email the registrant gets - including the details of ALL the people registered.

I hope this helps,

RJB

nessnzoe

  • I post occasionally
  • **
  • Posts: 84
  • Karma: 2
    • GingerFeet LLC
  • CiviCRM version: 3.4.8
  • CMS version: Drupal 6.22
  • MySQL version: 5.1.14
  • PHP version: 5.3.6
Re: Any Way to See Multiple Registration Correlation?
February 09, 2011, 06:11:51 pm
RJB,

We developed a work-around using a custom data field called "Team name" that is filled in for each participant. The the admin can search for participants that are in a given team, but if the export is easier for them that would be much easier.

And WAY groovy about all the details being emailed!!!!

You rock!

Thanks!,
Vanessa

rjb

  • I post occasionally
  • **
  • Posts: 63
  • Karma: 2
  • CiviCRM version: 3.3.5
  • CMS version: Drupal 6
  • MySQL version: 5.1.44
  • PHP version: 5.3.1
Re: Any Way to See Multiple Registration Correlation?
February 10, 2011, 02:32:21 am
You're very welcome - nice to help!

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Any Way to See Multiple Registration Correlation?

This forum was archived on 2017-11-26.