CiviCRM Community Forums (archive)

So after more digging I have learned that this bug has been around for *years* without a fix.

There is an official issue that was created back in April 2010, but it looks like the bug has actually been around since August 2009 (http://forum.civicrm.org/index.php/topic,9501.0.html)

Anyway, according to the issue details (http://issues.civicrm.org/jira/browse/CRM-6082) this isn't going to get fixed until the 4.2 release and its priority is "minor". I'm a bit surprised that it's been assigned such a low priority considering it makes it impossible to create a decent directory unless you have really basic contact records (only 1 address, 1 phone number, 1 email address, 1 website, etc.). So maybe it isn't a show-stopper, but it's definitely a major issue if you're trying to create a professional-looking online directory.

Unfortunately I'm not a programmer so I can't just "jump in" and build a patch. Is there an official way to bump this up in priority or have it addressed sooner than the 4.2 release?

Try limiting your addresses to "is primary", "work" or "home" with Views Filters.  this will show only one address per member, and it will show the primary address.  Otherwise you may get 3 results for 1 contact if that contact has 3 addresses.

I know this is over a year old, but it's still a valid problem.  I'm running v4.2.2, and the issue you referenced (CRM-6082) is currently set to "won't fix" status.  It was closed simply because it hadn't been worked on in 18 months and they wanted to clean up the issue queue.

This might *really* help someone.

In CiviCRM 4.2.x onwards on Drupal 7 it seems like my CiviCRM fields in Views that are related to addresses have CiviCRM location settings, where I can choose to only show the primary city, state, zip, etc. as well as use filters to limit the selections. Maybe I missed this before, but it solved my problem. 

Good point zkrebs, this issue is mostly resolved due to the addition of:

"Show CiviCRM Location Display Options" within the View Field (D7 + C 4.2) which allows you to add nuance to your views and avoid duplication.  For instance, you could choose to display

Address (Work)
Address (Other) ... in the same view, without duplication

Hey guys,

Just a follow up to this, I'm having the exact same problem as the OP however, the location display options mentioned above seem to be available for all fields except the Website URL field - and this is the field giving me duplicates

In my view, I'm pulling drupal fields as well as various civicrm fields (including some from the 'contact' group and some from custom fields) - all are showing correctly except the users with multiple website URLs.

I was originally looking for a way to limit the URL field to just 1 entry, rather than * but couldn't seem to get that.

My CiviCRM phone number fields are showing up the CIVICRM LOCATION DISPLAY OPTIONS correctly - and work perfectly, but the Website URLs aren't.

My only guess here is this might be because the Website URL fields aren't sub-categorised. They're simply all "Website URL"; where as the different phone numbers are "Phone Number (Home)" or "Phone Number (Secondary)" with the bit in the brackets being the sup categorisation.

EDIT: on further inspection, it looks like they are sub categorised, but are all the same. So they're all "Website" primary category and "Home" sub-category. They mostly appear to be duplicates within a record - such as if the user has entered their website twice. Is there a way to find & merge fields within a contact field (rather than across contact fields)?
Ideally I could set the website field on the contact profile to just accept 1 value only (regardless of sub-category)

EDIT2: in the end, I enabled the distinct checkbox in the SQL advanced query settings which has resulted in the output that i wanted (not really a good solution, but an interim solution)