Skip to main content
Share Your Experience: Take the 2024 Developer Survey
7 votes
Accepted

Show full county name rather than the abbreviated form

In Administer > Localization > Address Settings, you can change the mailing label format to use {contact.state_province_name} instead of {contact.state_province}. It is not currently ready, but the ...
bgm's user avatar
  • 3,431
5 votes
Accepted

Is it possible to not have a default country?

CiviCRM allows you to over-ride the settings through php. You can over-ride default value for Contact Country. Add the below snippet in your sites civicrm.settings.php file global $civicrm_setting; ...
Pradeep Nayak's user avatar
5 votes

Mass deletion of bad addresses

If you completly want to delete the addresses, you could also delete them from the database with a query like DELETE FROM civicrm_address WHERE location_type_id = xx AND contact_id IN (SELECT ...
Jaap Jansma - CiviCooP's user avatar
4 votes

API for update an address

@Zeno when you have create option you don't have to look for replace please use create key word to create new or to update the record if record exist $result = civicrm_api3('Address', 'create', ...
Ramesh - ARTECH Consultancy's user avatar
4 votes
Accepted

Shortlisting contacts with complete address

You can use the search builder to search for empty fields, e.g. Steet-Address or ZIP Code. From the result, you could create a (smart) group and then exclude contacts in that group from the mailing.
Fabian's user avatar
  • 3,597
4 votes

Need historical address information

This is only possible if you have "detailed logging" enabled. If not, you'll need to restore a backup copy of your database (to a test server!) and do a comparison. You can check to see if you have ...
Jon G - Megaphone Tech's user avatar
4 votes

How does CiviCRM handle international mailing addresses with unusual formats?

You can control the address format in Administer menu » Localization » Address Settings, so your mailing labels generate how you'd like. What CiviCRM does not currently do is print different mailing ...
Jon G - Megaphone Tech's user avatar
4 votes

Remove Prefix from Addressee

You might try the display_name short code (assuming it exists as I do not use WP mysqlf)? You can control the way the display name is built in Administer>Customize Data and Screens>Display Preferences....
ErikH - CiviCooP's user avatar
4 votes

How to create latitude and longitude automatically for civirm contact

You need to enable Mapping and Geocoding from civicrm/admin/setting/mapping?reset=1 Enter your API Key or Application ID. An API Key is required for the Google Maps API. Refer to developers.google....
jitendra - fuzion's user avatar
3 votes
Accepted

Comparing Duplicate address

The most reliable way to do this is to not import addresses that are known matches. I regularly use Pentaho Kettle to create import files for me. I'll separate addresses into their own CSV, then use ...
Jon G - Megaphone Tech's user avatar
3 votes
Accepted

new feature? - all addresses needs to be searchable

In the advanced search under the "Address Fields" you can choose "Address Location" which defaults to primary only. By selecting all of them you can search by any address type. answer taken from this ...
Parthibaraj Rajasekar's user avatar
3 votes
Accepted

Supplemental address should be searchable

It does sound like a reasonable feature request, and the good news is that it's already been implemented. The pull request was merged in March, so any version of CiviCRM from 4.7.18 upwards should ...
mickadoo's user avatar
  • 341
3 votes

How to link one contact's address to be the address of all contacts in a specific group via SQL?

This is how you set the address of all people in a certain group (group id = 13), to be the address of a specific, different contact (address id 15432) SET @InGroup:=13; SET @MasterAddress:=15432; ...
Elad's user avatar
  • 621
3 votes

Get actual value instead of ID in Address API for Country and State/Province

This is possible in the "trunk" version of CiviCRM, and will be available in CiviCRM 4.7.15, releasing January 4, 2017. Earlier versions of CiviCRM don't have a StateProvince API. Using the "Join" ...
Jon G - Megaphone Tech's user avatar
3 votes

Want to auto populate city and state from an entered U.S. zip code, WordPress

I only now stumbled on this question, so will copy-paste my response from the forum: I am the developer of civicrm-region-lookup. I use it on CiviCRM 4.6, and it would require a small fix for CiviCRM ...
bgm's user avatar
  • 3,431
3 votes

State/Province display for a contact shows a number instead of the name for Vietnam contacts

Actually I don't think it is the ID, rather it is the 'abbreviation' which in the case of Viet Nam have all been entered in to table civicrm_state_province as numbers. SELECT * from `...
petednz - fuzion's user avatar
  • 28.3k
3 votes

State dropdown empty on form with Drupal webform integration

Usually when a javascript element fails to work on your page, it's caused by a general javascript failure on your website. This can be caused by incompatible plugins or themes, etc. So the problem may ...
Coleman's user avatar
  • 18.7k
3 votes

How to connect your household address to its members in civicrm api v3?

You need to provide same set of values to create address for members of the household with additional parameter master_id as Address foreign key id of household contact. $addressParams = [ '...
Pradeep Nayak's user avatar
3 votes

Counties - US ones but based in UK

I tend to avoid using the drop down field for counties in the UK since - unlike States in the USA, or Departments in France, for example - there is no one true definition for them (is it London, ...
michaelmcandrew's user avatar
3 votes

Mass deletion of bad addresses

See the docs section on profiles and then using batch update from the search results actions dropdown, i.e. search for your tag and then choose batch update via profile, and choose a profile that has ...
Demerit's user avatar
  • 23.1k
3 votes

Exporting primary addresses exports non-primary addresses for some contacts

It turns out that the "Search Primary Details Only" setting causes this problem (found under Administer-> Customize Data and Screens-> Search Preferences). It seems that if this setting is off, the ...
Lars SG's user avatar
  • 4,073
3 votes

Ability to add International Addresses

You have to set the available countries in Administer>Localization>Language and Currency.
ErikH - CiviCooP's user avatar
2 votes
Accepted

Multiple Mailing Addresses Based on Time of Year

You could also add the two adresses as to different adress types. One is set as primary, and then you need some help on changing what adress is primary, based on time. I do think CiviRules could help ...
Flying's user avatar
  • 2,271
2 votes

How to make home address default?

You can set default Location Types From this menu: Administer>Customize Data and Screens>Dropdown Options>Location Types
KilakwaBT's user avatar
  • 2,351
2 votes
Accepted

How do I change the address on system workflow messages?

As far as I know: Your default organization address can be found in Administer/Communication/Organization Address and Contact Info. That should be your $domain.address. You can also update the sytem ...
ErikH - CiviCooP's user avatar
2 votes
Accepted

Problem exporting due to multiple addresses of one location type (e.g. two 'home' addresses)

I would fix this either partially or wholly with SQL. The general approach I'd use is: Change the location_type_id on one of the two addresses for each contact to an unused location type (creating a ...
Jon G - Megaphone Tech's user avatar
2 votes

Need historical address information

We sometimes use a custom location type "Old address", so when we add a new address we set the previous as "Old address" and the new one as the "Home" + primary. Administer > Customize Data and ...
freeform.steph's user avatar
2 votes

Need historical address information

I think this extension will help you for the future record. https://lab.civicrm.org/extensions/formercommunicationdata
Tapash's user avatar
  • 3,004
2 votes

Effect of address change on current employer

@AlainB I totally agree that this should not happen for all location types. Do I understand correctly that: I change the address of John Doe I tick the 'use another contact's address' I then select ...
ErikH - CiviCooP's user avatar
2 votes

Effect of address change on current employer

It looks like a relic from an earlier era and an opportunity to simplify one tiny corner of the codebase. Maybe we could just document a CiviRules recipe to re-implement the current behaviour and ...
Aidan's user avatar
  • 13.5k

Only top scored, non community-wiki answers of a minimum length are eligible