CiviCRM Community Forums (archive)

Working with custom fields for imported records I have assigned to a group - 13,075 records in total.

I perform a search for records including a particular value in a field; in this case, Party Enrollment = DEM.

System returns 17,523 results, with each found record repeated six (6) times.

Summary: Search Builder returns multiple repeated contacts instead of single contact instance.

Severity: High - Search is not usable as is.

Any ideas? Hope this helps!

Unfortunately, I was not able to reproduce this on the sandbox using a subset of 500 records. Grrr...

In looking at the repeated records on my site, though, I see something of a pattern in the search results: e.g., only one of the repeated results will show the country (United States, which is default and not a field in the imported data), one will show the address and not the state, another will show address and state, without the country, etc.)

So a temporary workaround may be to include fields in the search builder that one would normally think unnecessary. In my case, this seems to do the trick.

This is a tough one insofar as it takes so much time to do the import. If you have any ideas why Search Builder might output multiple values and where I ought to look, perhaps I can poke around while I have the data living on the site - the objective is to ultimately have over 300,000 records, so I won't be going further here until I can figure out what's going on. (Or am I crazy to try?)

Import progress status is definitely broken, as per this post -  http://forum.civicrm.org/index.php/topic,11621.0.html - but that's another issue.

Thanks much for the response - I hope this is helpful!

Perhaps it's related to another issue that I noticed today after installing a new test site. When setting up the new site, I selected India as the country, but it did not auto fill the "state" fields with anything. That pull down remained empty. This is a regression from beta 4, which did work.

This suggests that there's something broken about the country <-> state relationship or processing?