8

I'm using D7, with CiviCRM 4.4.6. I had use civicrm to create a profile, for user to enter and edit their billing address in their account.

The country, displaying well as "Malaysia", but the state field is displaying as digit, "07".

Is there any way that I can display the state name, just like the selected name in drop down when editing state field?

4
  • Go to: Administer => Localization => Langauge, Currency, Locations (civicrm/admin/setting/localization?reset=1) and check to make sure that Malaysia is included in the State/Province settings.
    – Shai
    Nov 10, 2014 at 4:45
  • Yes, I had added in, but it is still displaying as digit. Is there any method I can display the name instead of abbreviation?
    – vences
    Nov 10, 2014 at 4:57
  • @vences please add your vote to the CiviCRM SE site petition so we can have a dedicated space for these questions.
    – Coleman
    Nov 11, 2014 at 3:52
  • If you haven't already done so, it would be great to see you supporting the proposal for a new CiviCRM StackExchange site: area51.stackexchange.com/proposals/77367/…
    – Graham
    Feb 27, 2015 at 14:03

3 Answers 3

4

Check the table:

civicrm_state_province

specifically the column abbreviation for malaysia. If i had to guess, all the abbreviations are numeric and hence u r seeing numbers.

You can use PHPMyAdmin to find the relevant rows for malaysia. Your short term fix will be to populate the right values. Would be even better for you to submit a PR against civi-core so that changes get incorporated into future versions

2

'Administer > Localization > Address Settings' provide display format in terms of token, that we see on Contact Summary page's Address Section, not for profile usage.

Profile is being composed of fields, so when we view/edit a profile those field(s) got displayed in freezed or desired HTML element format respectively.

As in your case it seems like there is a js break involved, because last time I encountered such problem for a drop-down where name(label) is being replaced by integer(value).

Do you have firebug installed to see if there is any error report on console, which might help us to dig further!

1
1

I have found that by default CiviCRM displays a code or an abbreviation for state/province rather than the full name.

You can change this by going to Administer > Localization > Address Settings (siteroot/civicrm/admin/setting/preferences/address?reset=1)

Here you can see the tokens that are used for mailing labels and for address display. Edit the token that reads "{contact.state_province}", changing it to "{contact.state_province_name}". Then the addresses should display using the full name of the state/province as stored in the database.

2
  • I tried it, but it shows empty field...
    – vences
    Nov 11, 2014 at 8:54
  • It did shows the name, but in contact summary page, not in my account page profile part
    – vences
    Nov 12, 2014 at 1:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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