|
Description |
Currently phrases and email event translations are stored for each language separately, so adding new language creates twice more records to Phrase and EmailMessage tables. Also after that same phrase/email event translation have different id for different languages and this enlarges amount of cached data.
I propose to make Translation column (in Phrase table) and Template/Subject columns (in EmailMessage table) multilingual. This way record count in Phrase and EmailMessage tables will be equals to actual phrase and email event count in system.
There also side benefit of that: in cases, when phrase is not translated in given language, then we still could show it's translation from primary language. This is better, then show "!LU_MISSING_PHRASE!" on Front-End at least.
After proposed refactoring is made, then "Configuration -> Website -> Regional" section can no longer exist, because each record in Phrase/EmailMessage table will represent all languages at once. This should lead to making "phrases" and "emailmessages" prefixes no subitems of "lang" prefix, but self sufficient entities with their own grid/edit templates.
There are "Website & Content -> Phrases & Labels" and "Website & Content -> Email Messages" separate grids for that purpose. They will be transformed to show translations from all languages in one record. |
related to 
child of 
duplicate of