Translation of country names using Locale::CLDR #205

bschmalhofer · 2020-07-13T12:31:46Z

Most Country names are not translated. This means that when adding a customer in a non-english frontend, the country names are still mostly English.

TODO:

maybe show two versions, like in Personal Settings, but what about multiligual countries ?
maybe add missing Translations

My guess is that these translations can be taken from a publicly available resource.

StefanRother-OTOBO · 2020-07-15T05:59:33Z

If you look at the country names in the OTOBO -> Personal settings, you can see how it is supposed to be. First the name is displayed in the language of the country (so that the user who speaks the language can recognize it. Behind the minus is then the translation in the currently active language.

Edit: this seems to be about language names, not the country names

bschmalhofer · 2022-02-04T13:16:48Z

The relevant resources for countries in multiple languages seem to be https://cldr.unicode.org/, https://icu.unicode.org/, and https://metacpan.org/pod/Locale::Country::Multilingual.

bschmalhofer · 2023-11-11T13:16:02Z

As far as I see in rel-11_0 the only place where a country list is used is the AdminCustomerCompany frontend. There there is either a selection of English country names from Locale::Country or from the SysConfig setting ReferenceData::OwnCountryList. The country code isn't used anywhere. However there might be OTOBO packages that enhance the handling of countries.

bschmalhofer · 2023-11-11T13:47:34Z

Finally found the module that has the information from the latest release of CLDR: Locale::CLDR. Looks like it also has everything than anybody ever wanted for localisation.

Indirect object syntax is just mentioned in the documentation. But the regular constructor syntax works just as well.

the list should be stable because Locale::Codes is Kernel/cpan-lib Testing for the exact result also reduces the number of test cases. It will also be easier to detect future changes.

bschmalhofer · 2023-11-12T12:14:36Z

I verified with OTOBO 10.0.x that the SysConfig setting ReferenceData::OwnCountryList has indeed a strange behavior. The keys of the mapping are simply ignored. Only the values are shown in the GUI and stored in the database.

For the sake of this issue I propose the following:

Add new SysConfig setting like ReferenceData::TranslatedCountryNames
the new option will be implemented with Locale::CLDR
Locale::CLDR will be added to Kernel/cpan-lib
The CLDR country code will be stored in the database
The country names in AdminCustomerCompany will be in the language of the current user
Additionally the Flag, or the Language Code, will be showh
In the customer information widgets, the country will be in the language of the current user
There is no such concept as selection in the language of the country, because Belgium

bschmalhofer · 2023-11-18T12:03:50Z

Decided against added Locale::CLDR to Kernel/cpan-lib. This is because then the new dependencies of Locale::CLDR would also have to be added to Kernel/cpan-lib. And these modules might interfere with already installed versions of thess modules.

So I declared Locale::CLDR as an optional dependency in the feature div:cldr.
It happens that Locale::CLDR is not available in Linux distro packages. So it has to be installed from CPAN. For convenience div:cldr will be included in the Docker image. This means that the availability of Locale::CLDR has to be checked at runtime. Maybe fall back to Locale::Country.

bschmalhofer · 2023-11-25T17:06:12Z

Worked on the implementation. Found that for each supported language the needed language pack must be installed.

bschmalhofer · 2023-11-25T17:14:46Z

During test I set my language to french. After reloading the page I had in the language selection entries like "Nederlandse - Dutch". The first part is fine, that is Dutch in Dutch. But the second part should be néerlandais, that is Dutch in French. Looks like a translation is missing.

I propose to use Locale::CLDR for the complete matrix.

bschmalhofer · 2023-12-01T17:07:44Z

Implemented the translation of country names using Locale::CLDR. But my confidence that this is a good solution is waning a bit, as there are some problems:

Loading of the customer information widget is slow
Trying to get the Norwegian Bokmal translation of BV (Bouvet Island) causes a deep recursion, see Deep recursion when creating objects for specific regions ThePilgrim/perlcldr#41
Country names for Serbian latin are shown in cyrillic, but that is fine as transliteration is a special case

Indirect object syntax is just mentioned in the documentation. But the regular constructor syntax works just as well.

the list should be stable because Locale::Codes is Kernel/cpan-lib Testing for the exact result also reduces the number of test cases. It will also be easier to detect future changes.

Include it in the Docker image

Also show the flag in the country selection. Load language packs for the most popular languages

in the customer information widget of the ticket zoom page

Thats is, check whether the Locale::CLDR object can be created. Add code comment about problem with Bouvet Island.

Indirect object syntax is just mentioned in the documentation. But the regular constructor syntax works just as well.

the list should be stable because Locale::Codes is Kernel/cpan-lib Testing for the exact result also reduces the number of test cases. It will also be easier to detect future changes.

Include it in the Docker image

Also show the flag in the country selection. Load language packs for the most popular languages

in the customer information widget of the ticket zoom page

Thats is, check whether the Locale::CLDR object can be created. Add code comment about problem with Bouvet Island.

Indirect object syntax is just mentioned in the documentation. But the regular constructor syntax works just as well.

the list should be stable because Locale::Codes is Kernel/cpan-lib Testing for the exact result also reduces the number of test cases. It will also be easier to detect future changes.

Include it in the Docker image

Activated with the SysConfig setting ReferenceData::TranslatedCountryNames. Also show the flag in the country selection. Load language packs for the most popular languages.

in the customer information widget of the ticket zoom page

Thats is, check whether the Locale::CLDR object can be created. Add code comment about problem with Bouvet Island.

This version fixed a bug that caused infinite recursion.

Issue #205 country names take2

bschmalhofer · 2023-12-09T12:11:48Z

Translations work fine with Locale::CLDR 0.34.4. PR is merged. Closing this issue.

bschmalhofer · 2023-12-25T15:07:11Z

Some missing pieces were encountered:

previous country names should still be available, even if they are full country names instead of the two letter codes
The special region names Pseudo-Accents and Pseudo-Bidi should not be in the selection
The AdminCustomerUser frontend should also show the selection list

Issue #205 cldr customeruser

bschmalhofer · 2023-12-25T15:25:06Z

Closing again after the fixes.

bschmalhofer added the enhancement New feature or request label Jul 13, 2020

bschmalhofer added this to the OTOBO 10.1 milestone Jul 13, 2020

bschmalhofer mentioned this issue Dec 23, 2020

Update Country List #674

Closed

bschmalhofer modified the milestones: OTOBO 10.1, OTOBO 11.0 Feb 23, 2023

bschmalhofer added a commit that referenced this issue Nov 11, 2023

Issue #205: no need to use Lingua::Traslit with indirect object syntax

35d4706

Indirect object syntax is just mentioned in the documentation. But the regular constructor syntax works just as well.

bschmalhofer mentioned this issue Nov 25, 2023

Use Locale::CLDR for the translation of language names #2707

Closed

bschmalhofer changed the title ~~Translation of country names~~ Translation of country names using Locale::CLDR Nov 28, 2023

bschmalhofer added a commit that referenced this issue Dec 2, 2023

Issue #205: no need to use Lingua::Traslit with indirect object syntax

1cca74e

Indirect object syntax is just mentioned in the documentation. But the regular constructor syntax works just as well.

bschmalhofer added a commit that referenced this issue Dec 2, 2023

Issue #205: add Locale::CLDR is an optional dependency

822f24f

Include it in the Docker image

bschmalhofer added a commit that referenced this issue Dec 2, 2023

Issue #205: Add support for translated country names

ab56d5f

Also show the flag in the country selection. Load language packs for the most popular languages

bschmalhofer added a commit that referenced this issue Dec 2, 2023

Issue #205: fix a code comment: required => readonly

9b4d5db

bschmalhofer added a commit that referenced this issue Dec 2, 2023

Issue #205: translate the country code

8521247

in the customer information widget of the ticket zoom page

bschmalhofer added a commit that referenced this issue Dec 2, 2023

Issue #205: add fallback to 'en' and finally Locale::Country

81a9ab2

Thats is, check whether the Locale::CLDR object can be created. Add code comment about problem with Bouvet Island.

bschmalhofer added a commit that referenced this issue Dec 2, 2023

Issue #205: no need to use Lingua::Traslit with indirect object syntax

81849a2

Indirect object syntax is just mentioned in the documentation. But the regular constructor syntax works just as well.

bschmalhofer added a commit that referenced this issue Dec 2, 2023

Issue #205: add Locale::CLDR is an optional dependency

79e0f2a

Include it in the Docker image

bschmalhofer added a commit that referenced this issue Dec 2, 2023

Issue #205: Add support for translated country names

a656c35

Also show the flag in the country selection. Load language packs for the most popular languages

bschmalhofer added a commit that referenced this issue Dec 2, 2023

Issue #205: fix a code comment: required => readonly

4688909

bschmalhofer added a commit that referenced this issue Dec 2, 2023

Issue #205: translate the country code

16edb28

in the customer information widget of the ticket zoom page

bschmalhofer added a commit that referenced this issue Dec 2, 2023

Issue #205: add fallback to 'en' and finally Locale::Country

5c52811

Thats is, check whether the Locale::CLDR object can be created. Add code comment about problem with Bouvet Island.

bschmalhofer mentioned this issue Dec 4, 2023

Issue #205 country names #2668

Closed

bschmalhofer added a commit that referenced this issue Dec 9, 2023

Issue #205: no need to use Lingua::Traslit with indirect object syntax

93761e7

Indirect object syntax is just mentioned in the documentation. But the regular constructor syntax works just as well.

bschmalhofer added a commit that referenced this issue Dec 9, 2023

Issue #205: add Locale::CLDR as an optional dependency

16d44fe

Include it in the Docker image

bschmalhofer added a commit that referenced this issue Dec 9, 2023

Issue #205: fix a code comment: required => readonly

a81e49f

bschmalhofer added a commit that referenced this issue Dec 9, 2023

Issue #205: translate the country code

d9f9a31

in the customer information widget of the ticket zoom page

bschmalhofer added a commit that referenced this issue Dec 9, 2023

Issue #205: add fallback to 'en' and finally Locale::Country

bc2fc46

Thats is, check whether the Locale::CLDR object can be created. Add code comment about problem with Bouvet Island.

bschmalhofer added a commit that referenced this issue Dec 9, 2023

Issue #205: require version 0.34.4 of Locale::CLDR

8796448

This version fixed a bug that caused infinite recursion.

bschmalhofer added a commit that referenced this issue Dec 9, 2023

Merge pull request #2762 from RotherOSS/issue-#205-country_names_take2

8fcf6b7

Issue #205 country names take2

bschmalhofer closed this as completed Dec 9, 2023

bschmalhofer reopened this Dec 25, 2023

bschmalhofer added a commit that referenced this issue Dec 25, 2023

Issue #205: remove special codes XA and XB from the selection

4db83cd

bschmalhofer added a commit that referenced this issue Dec 25, 2023

Issue #205: add prev. country to the selection list

513c84f

bschmalhofer added a commit that referenced this issue Dec 25, 2023

Issue #205: show CLDR country list also in AdminCustomerUser

eb86938

bschmalhofer added a commit that referenced this issue Dec 25, 2023

Merge pull request #2786 from RotherOSS/issue-#205-cldr_customeruser

a755e4d

Issue #205 cldr customeruser

bschmalhofer closed this as completed Dec 25, 2023

bschmalhofer self-assigned this Jan 7, 2024

bschmalhofer mentioned this issue Jan 7, 2024

Upgrade Locale::CLDR to 0.40.0 #2802

Closed

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Translation of country names using Locale::CLDR #205

Translation of country names using Locale::CLDR #205

bschmalhofer commented Jul 13, 2020 •

edited

Loading

StefanRother-OTOBO commented Jul 15, 2020 •

edited by bschmalhofer

Loading

bschmalhofer commented Feb 4, 2022

bschmalhofer commented Nov 11, 2023

bschmalhofer commented Nov 11, 2023

bschmalhofer commented Nov 12, 2023 •

edited

Loading

bschmalhofer commented Nov 18, 2023

bschmalhofer commented Nov 25, 2023

bschmalhofer commented Nov 25, 2023

bschmalhofer commented Dec 1, 2023 •

edited

Loading

bschmalhofer commented Dec 9, 2023

bschmalhofer commented Dec 25, 2023

bschmalhofer commented Dec 25, 2023

Translation of country names using Locale::CLDR #205

Translation of country names using Locale::CLDR #205

Comments

bschmalhofer commented Jul 13, 2020 • edited Loading

StefanRother-OTOBO commented Jul 15, 2020 • edited by bschmalhofer Loading

bschmalhofer commented Feb 4, 2022

bschmalhofer commented Nov 11, 2023

bschmalhofer commented Nov 11, 2023

bschmalhofer commented Nov 12, 2023 • edited Loading

bschmalhofer commented Nov 18, 2023

bschmalhofer commented Nov 25, 2023

bschmalhofer commented Nov 25, 2023

bschmalhofer commented Dec 1, 2023 • edited Loading

bschmalhofer commented Dec 9, 2023

bschmalhofer commented Dec 25, 2023

bschmalhofer commented Dec 25, 2023

bschmalhofer commented Jul 13, 2020 •

edited

Loading

StefanRother-OTOBO commented Jul 15, 2020 •

edited by bschmalhofer

Loading

bschmalhofer commented Nov 12, 2023 •

edited

Loading

bschmalhofer commented Dec 1, 2023 •

edited

Loading