In an effort to provide OpenOffice.org users with localized HSQLDB error messages (in the form shipped with OOo 2.0, all error messages are English), a call was made to the community to volunteer for translating the error messages from the HSQLDB source into other languages.
So far, we have volunteers (V) and finished translations (F) for the following languages:
(The initial list was stolen from here, feel free to add your own language/name if you want to participate.)
(V) (F) [ ] [ ] Basque [ ] [ ] Brazilian(Pt) [ ] [ ] Catalan [ ] [ ] Chinese [X] [X] Czech: Petr Kolesa [ ] [ ] Danish [ ] [ ] Finnish [X] [X] French: Jérôme Paschoud [X] [X] German: Thomas Kellerer [ ] [ ] Greek [ ] [ ] Hindi [X] [X] Hungarian: Andras Timar [ ] [ ] Japanese [X] [X] Korean: Jinwook Kim [ ] [ ] Laotian [ ] [ ] Malaysian [ ] [ ] Netherlands [ ] [ ] Norwegian [ ] [ ] Polish [ ] [ ] Portugese [ ] [ ] Romanian [ ] [ ] Russian [ ] [ ] Serbian [ ] [ ] Slovak [X] [X] Slovenian: Vito Smolej [ ] [ ] Spanish [ ] [ ] Tamil [ ] [ ] Thai [ ] [ ] Turkish
Encoding of the .properties files
The translated sql-error-messages_XX.properties files (XX stands for the language code) should be either in ISO-8859-1 or in plain ASCII with escaped unicode values. The native2ascii executable from Sun JDK can convert files to escaped unicode format. Other text editors on Windows known to handle escaped unicode: UltraEdit 11.20 (shareware), UniRed (freeware), SC Unipad (shareware)
The current JAR file with the translated error messages can be found at the DBA pages.
- download it to an arbitrary location
- in OOo, go to Tools|Options|OpenOffice.org|Java
- press the "Class Path" button
- add the JAR file you just downloaded to the class path
- close all dialogs with OK
- (re-start OpenOffice.org, if advised so)
Note that you can use prop2po.py from the translate toolkit to convert properties files to PO files. For example,
prop2po.py -P sql-error-messages.properties -o po/sql-error-messages.pot prop2po.py -t sql-error-messages.properties sql-error-messages_it.properties -o po/it.po
this yield files like this:
#: 001 msgid "08001 The database is already in use by another process" msgstr "08001 L'archivio Ã¨ in uso da un altro processo" #: 002 msgid "08003 Connection is closed" msgstr "08003 Connessione chiusa"
Samples from hsqldb 1.8 here