CiviCRM Community Forums (archive)

I've got some legacy data which needs importing into CiviCRM, and it includes CiviCase components so it seems I can't use the GUI import process. Instead, I thought I could write a script to use the API to load the contacts, their relationships and create the case details all in one process. However, I can't see how to import the stateProvince using the the API - is there a method for looking up the text string of an address and converting it into the stateProvince id so that it can be inserted into the address table entry?

Hi Eileen,

Thanks, but that's not my experience with the API explorer.

I went with:


              $stateProvinces=civicrm_api("Constant","get", array ('version' =>'3', 'name' =>'stateProvince'));             
              $county = array_search($graphic2_import_array['15'], $stateProvinces['values']);


... and then insert the $county variable into the address,create API call.

Seems to work. But it feels a bit clunky.