Author Topic: Export Full State Names not Abbreviations (Read 1125 times)

Aahar · May 16, 2013, 03:31:19 am

"Export Full State Names not Abbreviations" has come up occasionally in the forum
For instance: http://forum.civicrm.org/index.php?action=post;topic=21897.0;last_msg=113602

I cannot contribute code but can consider sponsoring this.

Donald Lobo · May 16, 2013, 10:10:30 am

I think there is already a token for this. If not adding it as a token and also including it in the primary export is definitely a good project for 4.4

I suspect its a 20 hour project. Contact us on IRC / offline if your org can sponsor this

lobo

vakeesan26 · September 01, 2014, 02:46:20 am

in CRM/Contact/BAO/Query.php (4.5 beata 8 )
line 5520
is this patch workable ?

Code: [Select]

     elseif ($value['pseudoField'] == 'state_province_abbreviation') {
          $country_id = CRM_Core_PseudoConstant::countryIDForStateID($val);
          $result = civicrm_api3('Country', 'get', array(
          		'sequential' => 1,
          		'id' => $country_id,
          ));
          if($result['values'][0]['is_province_abbreviated'] == 1){
          	$dao->$key = CRM_Core_PseudoConstant::stateProvinceAbbreviation($val);
          }else{
          	$states = CRM_Core_PseudoConstant::stateProvinceForCountry($country_id);
          	if (array_key_exists($val, $states)) {
          		$dao->$key = $states[$val];
          	}
          }
        }

CiviCRM Community Forums (archive)

News:

Author Topic: Export Full State Names not Abbreviations (Read 1125 times)

Aahar

Export Full State Names not Abbreviations

Donald Lobo

Re: Export Full State Names not Abbreviations

vakeesan26

Re: Export Full State Names not Abbreviations