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 Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Search for contacts using list of email addresses
Pages: [1]

Author Topic: Search for contacts using list of email addresses  (Read 335 times)

Joeri Theelen

  • I’m new here
  • *
  • Posts: 13
  • Karma: 0
  • It's nothing personal.
  • CiviCRM version: 4.4.5
  • CMS version: Drupal 7.28
  • MySQL version: 5.6.11
  • PHP version: 5.5.3
Search for contacts using list of email addresses
June 30, 2014, 02:02:11 am
Hi, I have a list of email addresses, and I would like to find their matching contacts in CiviCRM. I tried to concatenate them using spaces or other separators in several search fields, but it did not work. Also, I tried the search builder using the "in" operation but this also does not seem to work. The error message remains "Please enter correct Data (in valid format)." I've tried many formats:
email1 email2
'email1' 'email2'
"email1" "email2"
email1, email2
email1 OR email2
[email1, email2]
etc.

How can I do this in CiviCRM, i.e. find contacts using a list of email addresses?

Thanks,
Joeri
« Last Edit: June 30, 2014, 02:54:49 am by Joeri Theelen »

Joeri Theelen

  • I’m new here
  • *
  • Posts: 13
  • Karma: 0
  • It's nothing personal.
  • CiviCRM version: 4.4.5
  • CMS version: Drupal 7.28
  • MySQL version: 5.6.11
  • PHP version: 5.5.3
Re: Search for contacts using list of email addresses
June 30, 2014, 11:36:02 am
Ok, I found another post with the solution:
https://issues.civicrm.org/jira/browse/CRM-8548

The format is very specific: (email1,email2,...)

Cheers,
Joeri

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Search for contacts using list of email addresses

This forum was archived on 2017-11-26.