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) »
  • Exporting Participants Causing duplicate entries
Pages: [1]

Author Topic: Exporting Participants Causing duplicate entries  (Read 1942 times)

dominion

  • Guest
Exporting Participants Causing duplicate entries
June 22, 2009, 04:31:29 pm
Whenever I export a list of participants, there are often several duplicates.  They are not consistent.  I can export the same list 5 times, and have 5 different duplicates.  Sometimes it'll export the same field in triplicate or quadruple entries instead of just a duplicate.

This is causing some angst for our registrar, and I need to find a way to resolve it.  

I checked the issue tracker, and this is the closest issue I can find.  

http://issues.civicrm.org/jira/browse/CRM-4488

If there are debug steps that I can take, please let me know so that I may take them in order to fix this, and help the community in addition to myself.

EDIT:

After further inspection upon exporting a listing, and comparing to what is in the system....
It appears to be making duplicate entries when there is a secondary e-mail address or secondary phone number on file for a contact record. 
Is this expected behaviour?  Shouldn't the system only export the primary contact phone number and primary e-mail address when exporting, unless otherwise specified?
« Last Edit: June 22, 2009, 04:50:06 pm by dominion »

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: Exporting Participants Causing duplicate entries
June 22, 2009, 11:57:04 pm

can u check if the email / phone also have the is_primary flag set in the db. i think export will behave that way if it has multiple is_primary db records. Not sure how you got multiple is_primary records, that is a bug :(. If you can reproduce that would be great

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

sonicthoughts

  • Ask me questions
  • ****
  • Posts: 498
  • Karma: 10
Re: Exporting Participants Causing duplicate entries
November 19, 2009, 10:56:15 pm
sorry - just saw this.  i have a similar issue.  I can reproduce without a secondary phone / email.

sonicthoughts

  • Ask me questions
  • ****
  • Posts: 498
  • Karma: 10
Re: Exporting Participants Causing duplicate entries
November 20, 2009, 08:23:02 am
I can reproduce using views.  I found a single contact, participating in a current event but there are two rows with the following code:
SELECT civicrm_participant.id AS id,
   civicrm_contact.display_name AS civicrm_contact_display_name,
   civicrm_contact.id AS civicrm_contact_id,
   civicrm_email.email AS civicrm_email_email,
   civicrm_contribution.contribution_type_id AS civicrm_contribution_contribution_type_id,
   civicrm_contribution.receive_date AS civicrm_contribution_receive_date,
   civicrm_participant.fee_amount AS civicrm_participant_fee_amount,
   civicrm_event.title AS civicrm_event_title,
   civicrm_event.id AS civicrm_event_id
 FROM jicny_crm3.civicrm_participant civicrm_participant
 LEFT JOIN jicny_crm3.civicrm_participant civicrm_participant_civicrm_participant ON civicrm_participant.registered_by_id = civicrm_participant_civicrm_participant.id
 LEFT JOIN jicny_crm3.civicrm_contact civicrm_contact ON civicrm_participant.contact_id = civicrm_contact.id
 LEFT JOIN jicny_crm3.civicrm_email civicrm_email ON civicrm_contact.id = civicrm_email.contact_id
 LEFT JOIN jicny_crm3.civicrm_participant_payment civicrm_participant_payment ON civicrm_participant.id = civicrm_participant_payment.participant_id
 LEFT JOIN jicny_crm3.civicrm_contribution civicrm_contribution ON civicrm_participant_payment.contribution_id = civicrm_contribution.id
 LEFT JOIN jicny_crm3.civicrm_event civicrm_event ON civicrm_participant.event_id = civicrm_event.id
 WHERE civicrm_participant.register_date >= '2009-11-19 01:32:09' AND civicrm_participant.contact_id =1371

Kiran Jagtap

  • Ask me questions
  • ****
  • Posts: 533
  • Karma: 51
Re: Exporting Participants Causing duplicate entries
November 22, 2009, 10:48:15 pm
I suspect given contact has two registrations.
( w/ same or different events )

can u run this query :
Quote
SELECT id, event_id, contact_id from jicny_crm3.civicrm_participant where contact_id = 1371;

kiran
You Are Designed To Choose... Defined By Choice.

sonicthoughts

  • Ask me questions
  • ****
  • Posts: 498
  • Karma: 10
Re: Exporting Participants Causing duplicate entries
January 31, 2010, 09:53:35 pm
FYI - this is still not resolved - only has one entry.  still not resolved.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviEvent (Moderator: Yashodha Chaku) »
  • Exporting Participants Causing duplicate entries

This forum was archived on 2017-11-26.