Author Topic: should you import country name or abbreviation with contacts? (Read 3072 times)

webguy2 · August 20, 2009, 01:03:55 pm

I have been importing the country name along with contacts' address and have had a rash or random errors. Should I import a country code or abbreviation? If so, where do I get the correct codes?

Donald Lobo · August 20, 2009, 04:41:32 pm

I would use country code

check the database table civicrm_country to get a valid list of country abbreviations that CiviCRM recognizes

lobo

Kiran Jagtap · August 21, 2009, 05:44:22 am

To import country and state w/ contact -

lets take a example of county = "united states" and state = "California"

supportable value formats are :
country = "US" or "United States" ( ie both "iso code" as well as "name" )
state = "CA" or "California" ( ie both "abbreviation" as well as "name" )

but civicrm does not support data like county = "1228" and state = "1004"
(these are 'civicrm_country' and "civicrm_state_province" tables id, corresponding to "United States" and "California" respectively )

Also make sure state and country should be enabled.
( go to Administer CiviCRM -> Global Settings -> Localization -> check "Available Countries" and "Available States and Provinces"
http://drupal.demo.civicrm.org/civicrm/admin/setting/localization?reset=1 )

hope this help

kiran

CiviCRM Community Forums (archive)

News:

Author Topic: should you import country name or abbreviation with contacts? (Read 3072 times)

webguy2

should you import country name or abbreviation with contacts?

Donald Lobo

Re: should you import country name or abbreviation with contacts?

Kiran Jagtap

Re: should you import country name or abbreviation with contacts?