CiviCRM Community Forums (archive)

Hi Guys and Gals,

I'm trying to transform country strings (like "US", "FR", "BR", etc) to civicrm country_id's via the v3 API but I can't seem to get any traction.

I've been doing:

CRM_Core_PseudoConstant::country($value);

To accomplish the inverse lookup (country_id to country) but I can't seem to find the right tool for this job.

All I can find in import/contact.php is what looks to be code that validates the country against the allowed list...

Any ideas?

Hi Eileen,

I'll try that once I get go back to my address import inc and clean it up, adding that to the spec would be great!

Posterity Post:

This is what ended up working for me:  I passed country and province strings in the id fields, then used prepare() to lookup and replace.

public function prepare(&$entity, &$row) {
    civicrm_initialize();
   $countryIsoCodes=civicrm_api("Constant","get", array ('version' =>'3', 'name' =>'countryIsoCode'));
   $stateProvinces=civicrm_api("Constant","get", array ('version' =>'3', 'name' =>'stateProvince'));
   $stateProvinceAbbreviations=civicrm_api("Constant","get", array ('version' =>'3', 'name' =>'stateProvinceAbbreviation'));       

    $entity->country_id = array_search($entity->country_id, $countryIsoCodes['values']);

    $entity->state_province_id= array_search($entity->state_province_id, $stateProvinceAbbreviations['values']);

if( !isset($entity->state_province_id) ) {
$entity->state_province_id= array_search($entity->state_province_id, $stateProvinces['values']);
}


Not quite elegant, I'm sure, but it did the trick.