Author Topic: Can't Import State and Country 'cause Already in Numeric Code (Read 1675 times)

farmrchrys · February 05, 2009, 04:09:38 pm

I'm attempting to try and import some contact data using the SQL Query method from another (civicrm 2.0) database where the state and country fields are already in numeric form and it looks like CiviCRM expects these values to be in the ISO 3166-1-alpha-2 code form so it can convert them on import.

.

Piotr Szotkowski · February 10, 2009, 01:39:18 am

Quote from: farmrchrys on February 05, 2009, 04:09:38 pm

I'm attempting to try and import some contact data using the SQL Query method from another (civicrm 2.0) database where the state and country fields are already in numeric form and it looks like CiviCRM expects these values to be in the ISO 3166-1-alpha-2 code form so it can convert them on import. .

Currently CiviCRM doesn’t support country_id as an import field. That said, you can create a simple query that will add the country name based on the country_id you have – simply JOIN civicrm_country ON (country_id = civicrm_country.id) and add civicrm_country.name to the SELECT part.

CiviCRM Community Forums (archive)

News:

Author Topic: Can't Import State and Country 'cause Already in Numeric Code (Read 1675 times)

farmrchrys

Can't Import State and Country 'cause Already in Numeric Code

Piotr Szotkowski

Re: Can't Import State and Country 'cause Already in Numeric Code