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 ...
- 3,441
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;
...
- 34.5k
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 ...
- 3,641
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.
- 3,627
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 ...
- 39.4k
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....
- 11.9k
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 ...
- 39.4k
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....
- 7,191
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 ...
- 19.1k
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 ...
- 39.4k
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 ...
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 ...
- 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;
...
- 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" ...
- 39.4k
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 = [
'...
- 34.5k
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, ...
- 2,515
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 ...
- 24.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 ...
- 4,083
3
votes
Ability to add International Addresses
You have to set the available countries in Administer>Localization>Language and Currency.
- 11.9k
3
votes
Accepted
Is World Region accessible for a search using Searchkit?
You need to join to Countries and then world region is a field in there. If you've joined to Addresses then you can get it by joining Address to Address Countries.
- 24.1k
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 ...
- 2,343
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
- 2,381
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 ...
- 11.9k
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 ...
- 39.4k
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 ...
- 13.6k
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 ...
- 11.9k
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 ...
- 388
2
votes
Need historical address information
I think this extension will help you for the future record.
https://lab.civicrm.org/extensions/formercommunicationdata
- 3,014
2
votes
How to create latitude and longitude automatically for civirm contact
Welcome to Stackexchange. Take a look at the docs about geocoding and mapping. If you're using Google then you need an API key for geo coding requests. To get Google API key you can find information ...
- 34.5k
2
votes
Accepted
Membership sign ups
If you are using Drupal then you can use Webform + Webform Conditional modules to hide show certain fields.
Else you can add JS to CiviCRM Membership form through extension to hide/show postal code ...
- 34.5k
Only top scored, non community-wiki answers of a minimum length are eligible