Country Codes

[rrj17]

Is it possible to change how Country Codes are displayed? For example, while creating a new Location, when we click on 'l' in Country Code field, we get a list of 3-character codes. From that, for eg, FRA can be selected. I need FRA to be displayed as FR-France. This can be done by creating a new Country Code, but if new Country Code is created, it will not be associated with a time zone. My need is that it should be associated with the time zone as well.

[AlejandroBarba]

Re: Country Codes

Rajashree,

Are you entering the respective Country Zone ID when you create the new Country Code that you mentioned?

Hope this helps,

Alejandro B.

[laxman]

Re: Country Codes

I face a similar situation.

I key in "FR" in country_code field and it list "FRA". But I would like it to list only "FR". Are there any property file where I can set it as two digit country code?

Can anyone help me out?

Laxman

[rrj17]

Re: Country Codes

Hi

Are you also getting FR in the list along with FRA? I don't think there are any properties like that because you can only add new countries. However, if it is okay for you, you can delete the 3 char countries and create 2 char countries. Then you can turn autocomplete.start=2 in glog.ui properties.

Hope it helps.
Rajashree

[rrj17]

Re: Country Codes

Hi Alejandro

I found the answer to that one. We need to associate the newly created country with a timezone in Time zone locale. This is in Power data of Transportation Planning and Execution.

Thanks
Rajashree

[laxman]

Re: Country Codes

Hi,

Thank you for your reply.

I do not want to create a new country code.

In "country_code" table in the back end you can find two column "COUNTRY_CODE3_GID" and "COUNTRY_CODE2".

COUNTRY_CODE3_GID is three character country code
COUNTRY_CODE2 is two character country code.

How to associate with two character country code.


Eg. I want two list only "FR" when I type "FR". I do not want the three digit code to be listed.

I have set the autocommit property already so that when I type "FR" its listing as only "FRA". I want it to list only "FR".

I hope clearly stated my requirement?

Laxman

[laxman]

Re: Country Codes

Any input on my last post?

[AntonyC]

Re: Country Codes

Hi Laxman,
I don't know of any property or setting that allows you to change from 3 to 2 digits.

The only way i've seen this done before at another client was they updated all the 3 digit country codes in the country_code table with the 2 digit equivalant (as DBA.ADMIN). To associate the country codes with a time zone you will also need to update the country_code3_gid in the time_zone_locale table.

Word of caution though, the scripts to do this will have to form part of your post upgrade process as any upgrade to the db will overwrite the changes.

Rgrds,
Antony

[rrj17]

Re: Country Codes

Hi

It could be because the field calls the CountryCodeQuery, which fetches the country code3 gid (glog.server.query.servprov.CountryCodeQuery). How you want it would be a query which calls all the country code2. I am not sure how that can be done unless there is a query for that. Does OTM allow creation of custom queries? I am not sure.

The other way it could possibly be done is to customize the manager layout and change the field to a drop down with the custom countries.

Hope this helps
Rajashree

[neoandr]

Re: Country Codes

Hi ,
All locations are mapped with 3 letter country codes. So if you want it to be displayed in 2 characters then either u need to create new country codes with 2 letters or ...u can modify the 'Picklist' template to drop down in XSL (JSPx) and using 'options' you can display it as 2 letters which is actually mapped with 3 letter codes.

<options>
<option name='FR' value='FRA'>FR</option>
<option name='US' value='FRA'>US</option>
</options>

you can customise ur XSL with above code.