2

Most of my contacts have Vietnamese addresses. When I enter the name (organization or individual), I see the correct name for the Vietnamese provinces in the list and choose one. When I view the contact details, the name of the province displays as a number (the id, I presume) instead of the name.

I have reported this several times on the old forum but never got a solution to the problem.

2 Answers 2

3

Actually I don't think it is the ID, rather it is the 'abbreviation' which in the case of Viet Nam have all been entered in to table civicrm_state_province as numbers.

SELECT * from `civicrm_state_province`
WHERE country_id = 1233

whereas eg US ones are of type WV (West Virginia) etc

I don't know how bad it would be to suggest you copy the 'name' field and paste in to the 'abbreviation' field as a really bad hack.

I know I also raised this on the forum in the past with the hope of a solution so that there was a setting you could nominate to use either the Abbreviation or the Name on the Contacts Summary screen

5
  • Hi Peter...sorry it took so long to come back to this but ran into the same problem again today. I wonder where these numbers they are using for abbreviations came from. I don't know if VN has official abbreviations but I am sure they are not numbers. It would be nice if someone from civicrm.org would get involved in this after several years of bringing it up.
    – Vietyank
    Dec 19, 2017 at 4:09
  • I just looked at en.wikipedia.org/wiki/ISO_3166-2:VN and see what the source of the numbers is. It is the code column in the ISO 3166-2 table but without the preceding "VN". I also noticed that in the CiviCRM table, the names have been anglicized so that a province like Đắk Lắk is spelled Dac Lac in the CiviCRM table.
    – Vietyank
    Dec 19, 2017 at 4:23
  • Correct - they are the ISO number
    – petednz - fuzion
    Dec 19, 2017 at 5:33
  • This is still an issue. I don't mind fixing the table but I'm afraid it would be lost in an update.
    – Vietyank
    Jul 24, 2019 at 1:39
  • What I'd like to be able to do is use a token for the fully spelled out province name instead of fiddlling with the table. Right now, the only token available is the abbreviation, which is just a number. Same for Cambodia.
    – Vietyank
    Jul 24, 2019 at 1:52
0

Same problem here in Ireland. Export full state name - not abbreviation The solution is needed for most countries apart from USA and Canada. The exports need to include civicrm_state_province name as well as civicrm_state_province abbreviation.

3
  • is this an Answer or a Comment?
    – petednz - fuzion
    Nov 25, 2021 at 19:12
  • This does not really answer the question. If you have a different question, you can ask it by clicking Ask Question. To get notified when this question gets new answers, you can follow this question. Once you have enough reputation, you can also add a bounty to draw more attention to this question. - From Review Nov 27, 2021 at 1:39
  • Including civicrm_state_province name as well as civicrm_state_province abbreviation in the exports would answer the problem.
    – jamesleahy
    Dec 14, 2021 at 11:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.