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 CiviMail (Moderator: Piotr Szotkowski) »
  • CiviMail duplicate email check
Pages: [1]

Author Topic: CiviMail duplicate email check  (Read 2933 times)

apotropaic

  • I post occasionally
  • **
  • Posts: 34
  • Karma: 1
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress 1.8
  • MySQL version: 5.5.32
  • PHP version: 5.3.10
CiviMail duplicate email check
March 09, 2011, 12:12:53 am
Does CiviMail check for duplicate emails in its queue? So if I have 2 contacts with test@test.org in my mailing group, will the system only send one to that email or 2? Thanks!

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: CiviMail duplicate email check
March 09, 2011, 12:18:55 am
If they are two different contacts, then I would expect it to send to each of them, eg if you use first.name token, one will say, 'hi fred' the other will say 'hi maybelline'
If they are the same contact coming in from two different groups then i would expect only one email to go out.
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

apotropaic

  • I post occasionally
  • **
  • Posts: 34
  • Karma: 1
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress 1.8
  • MySQL version: 5.5.32
  • PHP version: 5.3.10
Re: CiviMail duplicate email check
March 09, 2011, 12:36:38 am
So, deduping prior to an email would be the best to ensure that a contact doesn't the same email twice? Thanks for the reply!

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: CiviMail duplicate email check
March 09, 2011, 01:14:48 am
Deduping would find if you have two contacts with the same email - subtle difference - but yes i think you are on the right track - unless you have couples or families where more than one contact uses the same email - it happens
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

xcf33

  • I post frequently
  • ***
  • Posts: 181
  • Karma: 7
  • CiviCRM version: 3.3.2
  • CMS version: Drupal 6.19/6.20
  • MySQL version: 5.x
  • PHP version: 5.2.6
Re: CiviMail duplicate email check
March 22, 2011, 08:29:10 am
I'm actually wondering if it would make sense to just restrict the query to send only to DISTINCT email addresses when building the mailing queue.

I think the issue that we often run into is that in large Civi installs (with more than 250 K contacts), run dedupe before every send is not a practical approach since CiviCRM deduping process is still not able to handle large dataset very well.

Another point is that I don't see any use cases (maybe someone can point it out to me) of sending a bulk email to 2 or more of the same email addresses. (Even for household contacts) So that by constructing the mailing queue query differently and restrict to distinct email addresses.


Let me know if any of this makes any sense?



Cheers!

penguintrax

  • I post frequently
  • ***
  • Posts: 230
  • Karma: 2
  • CiviCRM version: 3.3x and 4.x depending on site
  • CMS version: Joomla 1.5 or 1.7 depending on site
  • MySQL version: 5.0.92-community
  • PHP version: 5.2.17
Re: CiviMail duplicate email check
April 06, 2011, 01:43:39 pm
It makes sense to me re: distinct email address check. One of our clients registers entire families for their events, with each contact record using the same email address as head of household. Having CiviMail send to only distinct addresses would be a big improvement for them.

Alternately, is there a way to use Search Builder to pull only 1 (out of several identical) email addresses for a smart group?

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: CiviMail duplicate email check
April 06, 2011, 02:14:47 pm
Just to speak in favour of keeping things as they are. We have several clients where John and Judy share an email address - they want to be able to email them via CiviMail - and the system works well by using Tokens so John won't think that the Dear Judy email is for him and v.v.
So if there is a push to make distinct work for civimail it needs to be optional IMO.
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

apotropaic

  • I post occasionally
  • **
  • Posts: 34
  • Karma: 1
  • CiviCRM version: 4.4.4
  • CMS version: Wordpress 1.8
  • MySQL version: 5.5.32
  • PHP version: 5.3.10
Re: CiviMail duplicate email check
April 17, 2011, 01:54:33 am
Speaking strictly on bulk/mass emails, if John and Judy are sharing an email whats the difference, they are both going to see Dear John AND Dear Judy emails, assuming they are both checking the email. In most cases, one of the 2 people never checks email, thus they share with a person. Thats my opinion, there is no logic in emailing the exact same email to the same email address multiple times. But, I also understand clients :), so yea +1 lets make it optional!

jeff porter

  • I post occasionally
  • **
  • Posts: 72
  • Karma: 2
Re: CiviMail duplicate email check
October 24, 2011, 07:31:27 am
I agree that there needs to be a setting for this.  We have people complaining to us that they are getting multiple copies of the same email (from different contact records). While I could never imagine sharing an email account with my spouse, people do - and more than I thought do it I suppose. 

Jeff
Jeff Porter
Foundation for Prader-Willi Research (www.fpwr.org)

robinhood

  • I post frequently
  • ***
  • Posts: 153
  • Karma: 6
  • CiviCRM version: 4.5.5
  • CMS version: Drupal 7.34
  • MySQL version: 5.1.56
  • PHP version: 5.3.5
Re: CiviMail duplicate email check
October 24, 2011, 03:27:55 pm
There is a request for this feature that has been pending for a while at http://issues.civicrm.org/jira/browse/CRM-3975
It is scheduled for the 4.2 version.

It references a patch contributed in the forums, originally authored by me and then updated by Piotr, that still seems to work.  I apply that patch to every CiviCRM install I touch.  The patch makes the change for all Civimail output, so it is non-optional, and does not apply to any other Civi email.  See http://forum.civicrm.org/index.php/topic,6070.15.html

Hope that helps.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • CiviMail duplicate email check

This forum was archived on 2017-11-26.