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) »
  • Weird double entries when exporting to CSV
Pages: [1]

Author Topic: Weird double entries when exporting to CSV  (Read 281 times)

tobbe

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.2.16
  • CMS version: Wordpress 3.8.1
  • MySQL version: 5.1.73
  • PHP version: PHP 5
Weird double entries when exporting to CSV
December 03, 2014, 05:13:50 am
Hi

My problem is superweird, I simply can't understand what is going on.....
When I try to export all my contacts into a CSV file, i get duplicates that are not present in Civi. Not every entry just some.
The weird part is according to my database, there are 35069 entries in Civi. in the CSV, there are 35069 entries, but some, maybe 8000 are duplicates.

If I check one of the entries that was a duplicate in the CSV file, there is only one entry in the Cviv database.
I did compare an entry that was duplicated and one entry that was not duplicated, and there is no difference in the entries (except name, email and address). There is only one primary entry for address and email.

If anyone have any insight in this, I would really apreciate your help

Tobbe

Drupal 7.3.1
CiviCRM 4.4.6
« Last Edit: December 03, 2014, 05:19:37 am by tobbe »

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: Weird double entries when exporting to CSV
December 03, 2014, 12:42:25 pm
so you are saying you checked and it is not due to multiple emails etc - and there are no other fields in the row that are not 1:1 such as relationships/employer/websites etc?
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

tobbe

  • I’m new here
  • *
  • Posts: 6
  • Karma: 0
  • CiviCRM version: 4.2.16
  • CMS version: Wordpress 3.8.1
  • MySQL version: 5.1.73
  • PHP version: PHP 5
Re: Weird double entries when exporting to CSV
December 03, 2014, 11:14:29 pm
Yeah, we only store name, address, email, and 4 custom fields.
The main purpose is to send out email blasts.

Tobbd

JonGold

  • Ask me questions
  • ****
  • Posts: 638
  • Karma: 81
    • Palante Technology
  • CiviCRM version: 4.1 to the latest
  • CMS version: Drupal 6-7, Wordpress 4.0+
  • PHP version: PHP 5.3-5.5
Re: Weird double entries when exporting to CSV
December 04, 2014, 09:07:09 am
I'm having a hard time visualizing this.  Would it be possible to post an (anonymized) example?
Sign up to StackExchange and get free expert CiviCRM advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Weird double entries when exporting to CSV

This forum was archived on 2017-11-26.