Last modified: 2013-12-15 12:18:01 UTC
From Molly: Dear Arthur, I am entering a donation from Austria and the address is not showing up properly. The state is not showing up. The address is adding the #9. Please see this record. https://civicrm.wikimedia.org/civicrm/contact/view?reset=1&cid=509214 -Molly
There is a problem with data for states in SOME countries in the Civi database. For an undetermined number of countries, state abbreviations are stored in the database as digits rather than actual abbreviations, hence the odd display of some international addresses (like those for Austria). I made a temporary fix in Civi where Civi is set to display full state names rather than abbreviations. This is kind of a lame fix because there are places in Civi where ONLY abbreviations are displayed. I'm looking into an actual solution to the problem.
Where does this state data come from? Is it supplied with Civi or did we put it in ourselves at some point?
(In reply to comment #2) > Where does this state data come from? Is it supplied with Civi or did we put it > in ourselves at some point? 18:29 < awjr> dlobo: any idea where the state information for countries originally came from? 18:29 < awjr> and btw, there are 47 affected countries 18:29 < dlobo> awjr: some iso spec 18:29 < dlobo> iso-3166 i think 18:29 < dlobo> piotr will know the exact details
47 Countries are affected: mysql> select s.country_id, c.name from civicrm_state_province s, civicrm_country c where c.id = s.country_id and s.abbreviation rlike '[0-9]' group by s.country_id; +------------+--------------------------------------+ | country_id | name | +------------+--------------------------------------+ | 1003 | Algeria | | 1014 | Austria | | 1016 | Bahrain | | 1017 | Bangladesh | | 1024 | Bhutan | | 1033 | Bulgaria | | 1035 | Myanmar | | 1037 | Cambodia | | 1045 | China | | 1051 | Congo | | 1054 | C�te d'Ivoire | | 1055 | Croatia | | 1056 | Cuba | | 1057 | Cyprus | | 1059 | Denmark | | 1062 | Dominican Republic | | 1069 | Estonia | | 1076 | France | | 1085 | Greece | | 1100 | Iceland | | 1103 | Iran, Islamic Republic of | | 1109 | Japan | | 1112 | Kenya | | 1115 | Korea, Republic of | | 1131 | Malaysia | | 1132 | Maldives | | 1133 | Mali | | 1137 | Mauritania | | 1144 | Mongolia | | 1156 | Niger | | 1161 | Norway | | 1166 | Panama | | 1168 | Paraguay | | 1173 | Portugal | | 1187 | Saudi Arabia | | 1193 | Slovenia | | 1199 | Sri Lanka | | 1200 | Sudan | | 1210 | Tanzania, United Republic of | | 1211 | Thailand | | 1218 | Tunisia | | 1219 | Turkey | | 1223 | Uganda | | 1224 | Ukraine | | 1227 | United States Minor Outlying Islands | | 1233 | Viet Nam | | 1239 | Zambia | +------------+--------------------------------------+ 47 rows in set (0.01 sec)
Tried making direct contact with Piotr (the guy who presumably handled getting country info into the db) with no luck, posted on Civi forums to get more info about how they generated the info originally and how I might go about fixing this: http://forum.civicrm.org/index.php/topic,15431.new.html
We've found an interim solution for this problem and have reported this issue to the CiviCRM community multiple times now. Since we have a workaround for this in place and we do not have the bandwidth to fix the third party product, I'm marking as wontfix. Hopefully this will be fully resolved in a future release of CiviCRM.
[Moving from "CiviCRM/General" to "Wikimedia/CiviCRM; see bug 57738]