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,356
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;
...
- 30.7k
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,645
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', ...
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,472
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 ...
- 38.6k
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 ...
- 38.6k
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.8k
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....
- 6,936
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" ...
- 38.6k
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
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 `...
- 28.1k
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 ...
- 3,356
3
votes
Accepted
Why aren't State options non-default countries (outside UK) showing for billing address on the contribution page of a webform?
I had this problem too on the main Civi911.com checkout form, and then I was all the more sheepish when it turns out the issue was reported by my coworker Tyrell for one of our clients! It's a bug in ...
- 7,442
3
votes
Accepted
Is there a way to prevent USPS address standardization from making addresses all caps in PDF letters?
The problem is that the standard is to have addresses all-caps, without punctuation, and with various standard abbreviations. Some clients have asked us if we could "fix" them in bulk to be mixed ...
- 7,442
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 ...
- 38.6k
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 ...
- 17.5k
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 = [
'...
- 30.7k
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,497
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 ...
- 21.7k
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 ...
- 3,993
3
votes
Ability to add International Addresses
You have to set the available countries in Administer>Localization>Language and Currency.
- 11.8k
2
votes
Change address location type for all contacts?
The problem is, that civicrm_contact and civicrm_address cannot be accessed at the same time due to triggers involved.
I solved that issue by searching the relevant contacts on the civicrm user ...
- 578
2
votes
individual - location-type work address
Let me think a bit on how I would tackle this. I suppose that if I was only interested in the work addresses of Steven and Thomas I would simply add the work address on the Individual contact level. ...
- 11.8k
2
votes
Why is there a Location Type AND a Checkbox for billing addresses?
The location type is mainly as a "safe" way for recording a billing address that may differ from a contact's home, work, or other addresses. If you make a transaction that records a contact's billing ...
- 7,442
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,251
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,341
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.8k
Only top scored, non community-wiki answers of a minimum length are eligible