CiviCRM Community Forums (archive)

Hi all,

We seem to be having an ongoing problem with some of our contributions being duplicated when exported.
Someone will have a single contribution, but when we export the search to a file and look at it in excel, the contribution will be listed 2 times or 3 times.

We tracked some of the problem to "blank" location fields in the address.  Apparently when you merge records, it doesn't check to make sure that some required fields are filled, so we have found addresses in the system that are marked as Location "Select".

Once we change that to "home" or some other item, the search list seems to export correctly for that individual.

In some cases however, we are still receiving duplicates even after we have fixed that particular issue.  Are there any other things that we can check in our records that might cause duplication in the export?

Thanks

Mila