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) »
  • Separate registrations with the same email address
Pages: [1] 2

Author Topic: Separate registrations with the same email address  (Read 7594 times)

mcnamedia

  • Guest
Separate registrations with the same email address
November 27, 2008, 12:02:24 pm
Good afternoon folks,

Consider the following event registration scenario. Let's say an admin assistant for a company is in charge of registering that company's staff for our event. If she registers them using her email address on separate registrations, the first registrant's details are updated each time. It is quite common for organizations with admin staff to have that person handle, say, all the senior staff info. And he/she would put that under her email address.

So.... is there a way to allow multiple uses of the same email address?

And forgive me/point me in the right direction if this is already covered in the forums. I'm looking at a couple of threads that are similar to this, but nothing final.

Thanks,
Greg

mcnamedia

  • Guest
Re: Separate registrations with the same email address
November 28, 2008, 11:47:32 am
Ok I've "maybe" sold the customer on the fact that we can't have duplicate emails in the database. So my problem now is that when people register for an event, they overwrite the data in the backend if they're using an email address that's already registered.... flow example:

  • John Smith registers and purchases a ticket for $50 using the email jsmith@hotmail.com
  • Terry Smith registers and purchases a ticket for $50 using the same email - jsmith@hotmail.com

Terry Smith isn't getting the "Oops. It looks like this participant is already registered.." so the record in the backend is changed - Terry Smith's name replaces John Smith and also adds a second $50 ticket to the purchase.

How can I configure CiviEvent to make sure once someone registers with an email address that someone else cannot register with the same email address?

Sorry for the long wind :)

Thanks,
Greg


Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Separate registrations with the same email address
November 28, 2008, 03:50:51 pm

can you reproduce this issue on demo.

We check via email address, however a few conditions need to be met:

1. both should be either test or non-test registrations

2. the status cannot be pending (we allow multiple pending registrations)

3. they should have the default event role associated with the participant record

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

mcnamedia

  • Guest
Re: Separate registrations with the same email address
December 01, 2008, 04:37:36 am
Hi again,

Ok it looks like it's because the status is pending (pay later option). Is there a way to turn this off for pending registrations? I'm worried that if someone fills out the registration multiple times for pay later, the record is updated. I suppose this would mean that once an email address is entered, even a pending registration, that they'd get the oops message. THis would prevent overwriting of the same record.

Thanks,
Greg

mcnamedia

  • Guest
Re: Separate registrations with the same email address
December 01, 2008, 05:42:54 am
I'm thinking a workaround for this might be to create a "pending2" or similar and have that be the default status when someone registers to pay later. Might that be a way of stopping the duplicate emails?

mcnamedia

  • Guest
Re: Separate registrations with the same email address
December 01, 2008, 05:56:35 am
Ok I created a "pending2" status and switched my participant to this but was still able to register. It seems only if the status is set to "registered" do I get the OOps message.

Any ideas?


Thanks again,
Greg

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Separate registrations with the same email address
December 01, 2008, 06:47:06 am

greg:

the easiest workaround is to:

select v.id, v.label, v.filter from civicrm_option_value v, civicrm_option_group g where v.option_group_id = g.id AND g.name = 'participant_status';

and then change the 'filter' column value to 1 for the "Pending" status. We use that to detect which status columns should be treated as duplicate

lobo

A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

mcnamedia

  • Guest
Re: Separate registrations with the same email address
December 01, 2008, 07:31:04 am
Thanks Lobo... Once again, I'm getting there with your help.

I found the first code in registration.php and updated it accordinly and the filter I think is line 399 on Confirm.php (previously set to 5). Does this sound like what you instructed?

So now everyone who registers, even with the pay later option, shows up as Registered. This solves the duplication problem.

Would there be a workaround that gives "pending" the same duplicate checking properties as "registered?"

Thanks,
Greg

mcnamedia

  • Guest
Re: Separate registrations with the same email address
December 01, 2008, 08:06:00 am
Interestingly, on the main page of the event in the backend, all my registrants have their status as "registered" but have their status set to pending-pay later on the View Participant Screen.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Separate registrations with the same email address
December 01, 2008, 08:27:30 am

filter is either a 1 or a 0. In this case u need to set the filter column for the "Pending" row to 1. this is a db change

I'm not sure what you did / changed in the code in Confirm.php, so cant comment on it :)

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

mcnamedia

  • Guest
Re: Separate registrations with the same email address
December 01, 2008, 09:00:46 am
Oh ok... that makes more sense. I'll check it out.

Thanks.

mcnamedia

  • Guest
Re: Separate registrations with the same email address
December 01, 2008, 09:38:58 am
Reset my changes in confirm.php and updated the db - Works like a charm!

Many Thanks!!!

mcnamedia

  • Guest
Re: Separate registrations with the same email address
December 02, 2008, 06:52:43 am
Can anyone think of a reason one user gets through the "Oops you've alreadry registered" message? That is, they don't receive it - they go straight to reg review. In testing after making Lobo's mods above, everyone who registers can only register once except for one username's email. Even when entering "a" as an email address, it gives me the Oops message if I try to submit another registration.

Somewhere that would mark this email address as an exception? I deleted the email address from Joomla users, from CiviCRM users, from the CC to email... everything I could think of. I'm hoping I missed something obvious :)

Thanks,
Greg

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Separate registrations with the same email address
December 02, 2008, 08:57:26 am

greg:

most likely u r logged in. you might want to try it as an anon user

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

mcnamedia

  • Guest
Re: Separate registrations with the same email address
December 02, 2008, 09:37:29 am
Thanks Lobo. I deleted all the accounts with the email address and searched it out in the db. It was in the civicrm_email table... didn't look like it was connected to a contact though. I changed it to something else and things are working fine now.

Thanks again.

Pages: [1] 2
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Separate registrations with the same email address

This forum was archived on 2017-11-26.