Page 1 of 1
Multi Language
Posted: Tue Apr 26, 2011 2:58 am
by 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
Re: Multi Language
Posted: Wed Apr 27, 2011 4:11 am
by 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
Re: Multi Language
Posted: Wed Apr 27, 2011 3:14 pm
by 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
Re: Multi Language
Posted: Wed Apr 27, 2011 10:56 pm
by 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
Re: Multi Language
Posted: Thu Apr 28, 2011 2:42 pm
by alvin