Multi-language module - add language

[jrjespersen]

I'm using Checkbox 4.4.0.5 and have installed the multi-language module and added the languages we want to support. I have an issue with the results of entering the same language for multiple countries.

I entered the following two languages:

Name/Code
French (FR)/fr-FR
French (CA)/fr-CA

After applying the changes, everything looked fine. Then I reset IIS, and the country specification in the name is removed such that is looks like this:

Name/Code
French/fr-FR
French/fr-CA

This appears to affect drop-down selections for language, as French appears twice in the list with no country specifier. This is a problem, as text for our Canadian French users may be different than text for French, and users will not know which one to select.

A similar issue occurred with English. For en-US, Checkbox removed the (US) country specification for the name field, but it left the (CA) and (UK) specifiers for en-CA and en-GB.

In a third situation, Checkbox did not remove any country specifiers from the name field. I put Spanish (ES) and Spanish (US) for es-US and es-ES, and they were unchanged.

Can anyone explain this behavior and what I need to do to have a consistent display?

As a side note, it would be great to make the list of languages sortable in the web UI (or have the data call return a sorted list).

Thanks,
Jonathan

[ncushing]

I'll forward this issue to our development team for further inspection. In the meantime, the localized names for individual languages are stored in the database and ships with some localized names for languages such as French and English. It is possible that the data was changed in the database but was not updated in the in-memory text cache that Checkbox maintains.

Please reset IIS or recycle the application pool that Checkbox uses to force Checkbox to reload the text cache. If the localized text names are still incorrect after this, please let me know and I'll dig up information about updating the text names directly in the database.

Thank you.

[jrjespersen]

I did a little more digging and found that the web application populates the file /Configuration/GlobalizationConfiguration.xml when adding additional languages via the web UI. But that file contains only the ISO codes, not the display names used in the UI controls.

The sorting suggestion is a little less important now, because I can order the entries in that file any way I need to. Automatic ordering would be nice, but I have a suitable workaround.

As for the display names for the languages getting modified, I think my situation is different than you describe. When I first enter the languages, they appear as I entered them. This leads me to assume that they are correct in memory on the server. When I reset IIS and go back to the list of languages, they are changed. This leads me to believe that the data in the database is not exactly how I entered it.