duplicates on export of participants

[sonicthoughts]

In civi 2.2.7 I'm getting duplicates when exporting participants. they don't dup when i list them on the page.  anybody seen this?
thx,
Shawn

[Kurund Jalmi]

Can you try to replicate this on http://drupal.demo.civicrm.org

Kurund

[sonicthoughts]

Hi Jamli - I don't know what is triggering the duplication.  There is a single contribution and a single participant in the database.  short of giving you a copy of the database (which I'm willing to do if it will help) I don't know how to replicate.

[petednz]

Have you verified that none of these are a result of the Contact Record having multiple 'primary address' fields? that has thrown this problem in other situations

[sonicthoughts]

I don't think so.  I checked the database address table and there is nothing under "supplemental."  Is_billing and is_primary is set to 1. Also, there is one contact record, address record and participant record. I only see one contribution record and activity entry, but i noticed two entries in the change log tab but i don't think that is related.  I can't figure out what is causing it but something is definitely different about the logic in export and listing participants.  btw - i selected Primary for export.

[sonicthoughts]

Oh - i also have a problem of dups when creating views of participants....

[petednz]

the duplicate address issue can just be related to having two primary emails, rather than extra locations.

if you export the Participants with their default fields, do all fields have same info for both of the contacts participant records

[sonicthoughts]

yes, exactly the same.

[sykong]

I have this problem too. I realised that the number of times the participant is duplicated is equal to the number of activities for the event.

The issue is everytime you edit the participant, an activity is saved. I'm not sure if this is the intended behaviour...

[sykong]

Oops... looks like I posted to fast...

The duplicates still appear after I deleted the extra activity entries from the sql table

[sonicthoughts]

Does anyone have a suggestion for debugging?  This is actually a big issue for us.  Thanks, S.

[Donald Lobo]

i would do the following:

1. Enable query logging in mysql. Check the massive query generated for the export

2. Use that query in mysql shell to track why u r getting the duplicates. I suspect it is some data issue (maybe activities?)

3. if doing the above is beyond your ability, consider hiring someone from http://civicrm.org/professional/ to investigate (and potentially fix) this issue

lobo

[sykong]

sonicthoughts: Are you exporting using primary fields or selected fields? I just realised that in my situation, the duplicates appear with only if the fields are selected.

[reperry]

This has been reported as a bug here: http://issues.civicrm.org/jira/browse/CRM-5271

I'm pretty sure the duplicates are related to whether you include the Participant Note field in the fields for export (which only happens when you select the fields and isn't one of the primary fields).  The duplicates are the participants that have some value entered in the Participant Note field. 

I was also able to duplicate the problem at drupal.demo.civicrm.org.