9 votes
Accepted

What are best practices for bad postal addresses?

I think a location type of something like "Rejected" will give you great flexibility. If you want to get a bit more elaborate, combine the location type with a custom field that tracks the reason for ...
user avatar
  • 2,808
8 votes

Change address location type for all contacts?

I'd use SQL. Take a backup first, of course, and test on a non-production server. Then run: UPDATE civicrm_address ca JOIN civicrm_contact cc ON ca.contact_id = cc.id SET location_type_id = 3 ...
user avatar
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 ...
user avatar
  • 3,161
6 votes
Accepted

Using contacts as event locations

It would require a change to the core function CRM_Event_BAO_Event::getLocationEvent(). Right now, it only pulls addresses that are tied to existing events. Theoretically, the schema supports ...
user avatar
  • 7,357
6 votes

How can I change the order of address field columns on screens and reports?

Have you tried making adjustments under Administer > Localisation > Address Settings?
user avatar
6 votes
Accepted

Change address location type for all contacts?

I solved this using the Drupal modules CiviCRM Entity and Views Bulk Operations. This gave me a very powerful way to search, filter, and mass-modify the addresses in our database. Create a new ...
user avatar
  • 1,604
6 votes
Accepted

Notification of address change (for external accounting software)

Use a combination of smart groups, tags, CiviRules, and CiviReports. A. Create a Smart Group Use Search Builder to search for Contact :: Envelope # :: Not Empty OR Not Null OR > 0 From search ...
user avatar
5 votes

What are best practices for bad postal addresses?

I would second Erik's suggestion of adding an "on hold" or "bad address" property to postal mail addresses, similar to what civicrm has for email address. The "invalid postal address" scenario is ...
user avatar
  • 3,803
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 ...
user avatar
4 votes
Accepted

How to show only the relevant County/State of multiple countries in a profile?

If you have a state/province field on its own, it will have all options for the countries' states you enable on your site. If you have a country field alongside a state/province field of the same ...
user avatar
  • 7,357
4 votes

Using contacts as event locations

It would be a simple extension to write, and would likely make a small group of users quite happy. Just fyi, it's currently possible to add a custom field to addresses, so you could create a contact ...
user avatar
  • 6,671
4 votes

How to setup Civicrm for using FPO addresses

The list of states isn't editable by the end user, so it will require filing a bug to get APO, FPO (and whatever the third one is) added as state. In the meantime, I recommend using APO as the city, ...
user avatar
  • 2,808
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', ...
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.
user avatar
  • 3,357
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 ...
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 ...
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....
user avatar
4 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; ...
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....
user avatar
3 votes
Accepted

API call setvalue for is_primary does not make other values 'not primary'

There are lots of problems with the setvalue api. This is a good example of why everyone should stop using it. The plan is to deprecate setvalue soon and remove it in a future version. See https://...
user avatar
  • 16.2k
3 votes
Accepted

Disable certain address location types depending on Contact type?

The cheapest solution would be to combine "Home" and "Main" into one option that can be used for both individuals and organizations. Just have to come up with a word that has both meanings...
user avatar
  • 16.2k
3 votes
Accepted

Importing Household Address if Already Exists

If the households and individuals exist in the database but individuals do not have a shared address with the household, you can run the following sql to create a csv that you can import. On the ...
user avatar
  • 2,913
3 votes

Importing Household Address if Already Exists

A workaround is to import the address along with the Master Address ID. So import like you are importing a new address but also include the Master Address ID, mapped to the "Master Address Belongs To" ...
user avatar
  • 2,913
3 votes

What are best practices for bad postal addresses?

I guess I would add an 'on hold' custom field to the Address entity?
user avatar
3 votes

How can I lookup US county from latitude/longitude?

I've never done it, but I think Tyrell's SmartyStreets extension provides it. One thing to point out, however, for anyone who does it another way: county names repeat a lot, and the ID numbers of ...
user avatar
  • 7,357
3 votes

How do I set the print order for address labels?

It is complicated to add a sort order on address labels. I think it is possible to add a sort order to your search and that sort order is used in printing labels. However, in a recent project, we ...
user avatar
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 ...
user avatar
  • 7,357
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 ...
user avatar
  • 7,357
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 ...
user avatar
  • 3,161
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 `...
user avatar
  • 27.2k

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