Announcement

Collapse
No announcement yet.

Country Codes

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Country Codes

    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.

  • #2
    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.

    Comment


    • #3
      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

      Comment


      • #4
        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
        Last edited by rrj17; May 27, 2008, 12:40.

        Comment


        • #5
          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

          Comment


          • #6
            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

            Comment


            • #7
              Re: Country Codes

              Any input on my last post?

              Comment


              • #8
                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
                Antony Carter
                Mavenwire

                www.MavenWire.com

                Comment


                • #9
                  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
                  Last edited by rrj17; May 29, 2008, 13:02.

                  Comment


                  • #10
                    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.
                    Cheers,
                    -Neo

                    Comment

                    Working...
                    X