In-Portal Issue Tracker

Welcome to the In-Portal Open Source CMS Issue Tracker! This is a central management / tracking tool for all types of tasks / issues / bugs for the In-Portal Project. Before reporting any issues, please make sure to read the Guide into Issue Tracker and How to Properly Test and Report Bugs!
Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories
  

Viewing Issue Simple Details [ Jump to Notes ] [ Wiki ]  [ Related Changesets ] [ View Advanced ] [ Issue History ] [ Print ]
ID Category Type Reproducibility Date Submitted Last Update
0000279 [In-Portal CMS] Optimization feature request N/A 2009-09-09 07:01 2010-07-22 15:06
Reporter alex View Status public Project Name In-Portal CMS
Assigned To alex Developer
Priority normal Resolution fixed Fixed in Version 5.1.0-B1
Status closed Product Version Target Version 5.1.0
Time EstimateNo estimate
Summary 0000279: Phrases of state and country names
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.
Additional Information 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.
Tags No tags attached.
Reference
Change Log Message Refactoring Countries and States functionality and adding management options
Estimate Points 0
Attached Files patch file icon country_state_refactoring_core.patch [^] (148,485 bytes) 2010-04-11 08:34 [Show Content]
patch file icon country_state_refactoring_core_addon1.patch [^] (14,980 bytes) 2010-04-11 08:35 [Show Content]
patch file icon country_state_refactoring_modules.patch [^] (144,694 bytes) 2010-04-11 08:35 [Show Content]
patch file icon country_state_refactoring_themes.patch [^] (20,008 bytes) 2010-04-11 08:35 [Show Content]
patch file icon country_state_refactoring_core_v2_(including_addon1).patch [^] (163,836 bytes) 2010-04-27 07:26 [Show Content]
patch file icon country_state_refactoring_core_v3.patch [^] (164,567 bytes) 2010-04-27 14:24 [Show Content]
patch file icon country_state_refactoring_modules_v2.patch [^] (145,690 bytes) 2010-04-27 14:24 [Show Content]