Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Phrases of state and country names

Components

Labels

Description

Currently we have around 400 phrases of for countries and states used for ex. during checkout process. Translation of such kind of phrases almost never got changed and they provide additional load to each template, because they are used for Country field for users and user object is loaded on every page and these phrase with it.

I propose to create multilingual column Translation in StdDestinations table and move all current state/country translations there. Then loading of these moved values should be done using "options_sql" option in field definition in unit config.

Later we can add separate grid, where administrators could enable/disabled unneeded countries/states and change their translation.

Context Information

None

Additional information (do not use)

Same idea with currency translations.

In total we could decrease language pack by approximately 600 phrases, that never got changed.

---------

Country and state names and currencies should stay in language pack but not under <phrases> node by now. We can create special nodes for them, and language pack format will be like:

<LANGUAGES>
<LANGUAGE PackName="English" Encoding="base64">
<PHRASES>
...
</PHRASES>
<COUNTRIES>
<COUNTRY iso="USA" translation=".....">
<STATE iso="IL">...</STATE>
...
</COUNTRY>
...
</COUNTRIES>
<CURRENCIES>
...
</CURRENCIES>
<EVENTS>
...
</EVENTS>
</LANGUAGE>
</LANGUAGES>

This way different language translation of countries/states/currencies could be still transferred in language packs, but won't be stored in Phrase table.

Attachments

13

Activity

Alex July 22, 2010 at 8:06 PM

Closing, since 5.1.0 release has been released.

Alex May 19, 2010 at 7:41 AM

Fix committed to [b]5.1.x branch/b. Commit Message:

Fixes #0000279: Phrases of state and country names

Dmitry Andrejev May 19, 2010 at 3:27 AM

Tested good, please commit.

Alex May 18, 2010 at 12:47 PM

Patch "export_country_state_only_for_core.patch" contains fix of described before problem.

Alex May 18, 2010 at 12:47 PM

Countries & states are exported always, even, when I export only In-Commerce language pack.

Fixed

Details

Priority

Assignee

Reporter

Developer

Change Log Message

Patch Instructions

Patches must be submitted through Phabricator.

External issue ID

External issue URL

http://tracker.in-portal.org/view.php?id=279

Fix versions

Created September 9, 2009 at 12:01 PM
Updated December 30, 2024 at 2:24 AM
Resolved July 22, 2010 at 8:06 PM