CiviCRM Community Forums (archive)

Hi, we are observing a strange issue where doing a "Find Contributions" search returns 22 results. When I export all records, 24 records are exported, including two duplicates. Also, the export file (attached) seems to have mis-aligned columns, with long/lat info shifted into the city column on some records.

Any ideas? We're running 2.2.7 on Drupal 6

It appears both duplicated records in the export have 2 address records marked as primary. How does that happen, and what's the best way to fix it. Thanks!

We've also seen duplicates in exports where there are multiple primary addresses. I'd say the export should mirror the search results and only have one row per contact (for contact search) or per contribution (for contribution search). In contributions export, the duplicates cause an Excel sum on the amount column to give an incorrect total, which perturbs accounts staff!

Dave J

Perhaps there are two issue here:

• How is a contact getting multiple primary addresses / email / phones?
• When there are multiple primary addresses / emails / phones, how are the duplicate rows occurring in exports?

On the first issue, on one site we had this happen as a result of CRM-4737. A membership contribution on behalf of an Org was creating an address record flagged is_primary but with no location_type_id. This occurred because the location type was hard-coded as "Main" in CRM/Contribute/Form/Contribution/Confirm.php but this site had no location type "Main". A profile edit containing primary address fields then caused a second address record to be created, also flagged is_primary.

We had duplicates in exports on another site, also related to multiple locations, but haven't tracked this down yet.

On the second issue, presumably the duplicates occur because the export contains primary address/phone/email fields and the query has a join to civicrm_address etc, which will produce multiple rows if there are multiple address records.

So the question is whether it's always a bug to have multiple is_primary address/email/phone records - this comment by Lobo indicates that it is: Re: Exporting Participants Causing duplicate entries. I guess the same applies for multiple records of the same location type. If so then the task is to track down ways this can happen.

Dave J