Multi Language

[alvin]

Is there a plan to build a translator module?
Or some other way to build a Multi language system?

Please let me know,

Thanks

AM

[admin]

alvin,

Sorry about taking so long to get back (we had a 5 day long weekend).

The best solution I can offer is to get a list of all the titles used in zzsys_object and zzsys_form and do a replacement for each phrase into the language you want.

You can get this list by

1-Creating a temp table...

Code: Select all

CREATE TABLE nubuilder_phrases SELECT `sob_all_title` as english_phrase, lpad('',250,' ') as other_phrase  
FROM `zzsys_object` 
GROUP BY `sob_all_title`

UNION 

SELECT `sfo_title` as english_phrase, lpad('',250, ' ') as other_phrase 
FROM `zzsys_form` 
GROUP BY `sfo_title`

2-Then updating the other_phrase field to what is needed.
3-Then creating a Procedure Activity with this code

Code: Select all

$t = nuRunQuery("SELECT * FROM nubuilder_phrases");

while($r = db_fetch_object($t)){
   $o = "UPDATE zzsys_object SET sob_all_title = '$r->other_phrase' WHERE sob_all_title = '$r->english_phrase'";
   $f = "UPDATE zzsys_form SET sfo_title = '$r->other_phrase' WHERE sfo_title = '$r->english_phrase'";
   nuRunQuery($o);
   nuRunQuery($f);
}

4-And Running it.

Hope this helps

Steven

[alvin]

Thanks Steven,

But in the end I will need to have a way that a user can switch between languages, a button, or maybe pick your language at login.

The system will have users in multi location with multi language.

What do you think?

AM

[admin]

Sounds like a big job.

If you need someone to do it for you, you can get commercial support for nuBuilder here http://www.nusoftware.com.au/home.html

Steven

[alvin]

I am going to look into this more, later... But for now I am just going to post a few links to some info.

http://en.wikipedia.org/wiki/GNU_gettext
http://www.gnu.org/software/hello/manua ... Files.html
http://fplanque.net/Blog/devblog/2003/0 ... d_po_files
http://www.poedit.net/index.php