CiviCRM Community Forums (archive)

bump

I've found a similar post that mentions UK states.  2 questions
1.  does anyone have a USA macro?
2.  anyone have an update on this, since the post was old?

old post: http://forum.civicrm.org/index.php?topic=1350.0

Resurrecting this question .... because, well, it seems important. In general, the abbreviations for state/province make much less sense than the full names; e.g. for Paris, the abbr is 75 , which appears to also be a part of the postal code.

I hacked core to do this, with one very small change to CRM/Contact/BAO/Query.php around line 627 (in 4.1.5 for D6; a little earlier for 4.2.6 D7).
              if ($name == 'state_province') {
                $this->_select[$name] = "civicrm_state_province.abbreviation as `$name`, civicrm_state_province.name as state_province_name";
                $this->_element['state_province_name'] = 1;
              }

to


              if ($name == 'state_province') {
                $this->_select[$name] = "civicrm_state_province.name as `$name`, civicrm_state_province.name as state_province_name";
                $this->_element['state_province_name'] = 1;
              }

I think this is a great workaround, but terrible fix. What did I break, elsewhere? I am assuming this is used in many, many other places. Tokens and address labels would seem to be the most likely.

I have picked all through CRM/Export/BAO/Export.php looking for a better way to do this, but it appears that the abbreviation is what is returned from the query selectClause function mentioned above.

If anyone has a better suggestion on how to accomplish this, I am game to try. But I can't currently make heads or tails of what the 'right;' way to do this would be.