copy wombat text domain to other

SET @domain="wombat";

CREATE TABLE nlstmp LIKE wbnlsmsg;
INSERT INTO nlstmp SELECT * FROM palas.wbnlsmsg WHERE domain="@domain";

SELECT w.mid FROM wbnlsmsg w JOIN nlstmp USING (md5);



Translate Wombat and derived projects
=====================================

1) Setup Environment
====================

1.1) locale-gen
Generate calendar setting and stuff for used locales.

 $ sudo vim /etc/locale.gen
  de_DE.UTF-8 UTF-8
 $ sudo locale-gen

Don't forget the proper charset in /etc/locale.gen!

1.2) Message folders
For each language create folder LC_MESSAGES:

  var/lang/de/LC_MESSAGES


2) patForms
===========

Craeate MO file and copy to right location

 $ msgfmt -c -v inlcude/patForms/data/gettext/patForms/de.po -o var/lang/de/LC_MESSAGES/patForms.mo

3) Wombat
=========

3.1) PHP files

Extract messages from PHP files

$ find include -name \*.php | xgettext -f - -o resource/gettext/wombat.pot

3.2) XML Config Files

3.3) Wombat patTemplate Templates



4) The POT-file has changed and a merge with existing PO files is required.
===========================================================================

To merge POT files with PO files, use "msgmerge"

$ msgmerge -U resource/gettext/wombat/de.po resource/gettext/wombat.pot


5) Make binary files
====================

To translate portable objects to machine objects use msgfmt

$ msgfmt -c -v resource/gettext/wombat/de.po -o var/lang/de/LC_MESSAGES/wombat.mo


6) How can I add another language
=================================

If you want to add another language - lets say Greek. Just copy the the POT to
gr.po and start translating it!

$ cp resource/gettext/wombat.pot resource/gettext/wombat/gr.po
$ vim resource/gettext/wombat/gr.po

9) Are there some tools to edit PO files?
=========================================

As said, PO files are just text files. Therefore you can always use your
favourite text-editor such as VIM. Still there are some tools that make it a
lot easier

 PO-Edit for windows
 KBabel for Linux