Translate initial database values

[ebernier]

Hello,

We currently working on a project to improve the French translation of OTRS. At the installation, an SQL script is run to insert values into database. Is there a way to translate these value at the installation? We need those values in French.

Thanks

[jojo]

just enhance the script

[ebernier]

The sql script that insert value in database is run at step 2 of the OTRS installation. We select the language at step 3.

The quick solution is to create an sql file that update the initial values in database. This file should be run after the language selection in the installation process. Then, the user should have the initial values in his language. If there is no sql update file for the selected language, no update will be run.

Does this modification can be accepted by the community?

Thanks

[jojo]

the only things in database which should be in local language in database are the agent notifications. As these are independent from a choosen language (for all languages are own notifications available) the can be in the database script.

Never change generic values like group names, priorities and states. They will be translated in the frontend if needed

[ebernier]

Why I can't change the group name per example? It is possible to change it in the backend after installation. I think that all stuff that can be modified in backend after installation should be translatable automatically during the installation. I think that my solution should be good for all other languages that english. After the installation, my customers have to change it manually... That's not funny.

Thanks

[jojo]

not everything should be changed, like

- group names
- state type names
- state names (will be translated in frontend per default)
- Names of config values etc.

Only descriptions will be translated. The only additional thing which is needed is the declaration of language depended notification textes