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 Import (Moderator: Yashodha Chaku) »
  • Importing via csv creating duplicate phone end email fields
Pages: [1]

Author Topic: Importing via csv creating duplicate phone end email fields  (Read 474 times)

riswana123

  • I’m new here
  • *
  • Posts: 5
  • Karma: 0
  • CiviCRM version: 3.4.6
  • CMS version: Drupal 6
  • MySQL version: 5.3
  • PHP version: 5.5
Importing via csv creating duplicate phone end email fields
April 03, 2015, 12:38:57 am
Hi,

  If i am updating the contacts via csv and mapping the work details(address,phone,email) with work and home details(address,phone,email) with home and selecting these two options for duplicate contacts its creating multiple phone and email fields.
1. UPDATE
2. NO DUPLICATE CHECKING
Can anyone please clarify?
 

CiviTeacher.com

  • I live on this forum
  • *****
  • Posts: 1282
  • Karma: 118
    • CiviTeacher
  • CiviCRM version: 3.4 - 4.5
  • CMS version: Drupal 6&7, Wordpress
  • MySQL version: 5.1 - 5.5
  • PHP version: 5.2 - 5.4
Re: Importing via csv creating duplicate phone end email fields
April 03, 2015, 12:28:00 pm
Quote from: riswana123 on April 03, 2015, 12:38:57 am

2. NO DUPLICATE CHECKING


That is your problem.    Read the documentation on import settings.  What this setting means is that you are telling CiviCRM not to check for a matching contact and thus it always creates a duplicate as you have instructed.

A better setting would be to match on: email + name, or external ID number (from your legacy database) and update the matching contact.   You can choose the dedupe rule you wish to use.

Try CiviTeacher: the online video tutorial CiviCRM learning library.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Importing via csv creating duplicate phone end email fields

This forum was archived on 2017-11-26.