Translations: Difference between revisions

From nuBuilderForte
Jump to navigation Jump to search
Line 22: Line 22:
/* Translation Stats */
/* Translation Stats */
SELECT trl_language
SELECT trl_language
    , COUNT(*) AS translated_strings
  , COUNT(*) AS translated_strings
    , (SELECT COUNT(DISTINCT trl_english) FROM `zzzzsys_translate` a)-COUNT(*) AS ToTranslate  
  , (SELECT COUNT(DISTINCT trl_english) FROM `zzzzsys_translate` a)-COUNT(*) AS ToTranslate  
FROM `zzzzsys_translate` GROUP BY trl_language ORDER BY translated_strings DESC;
FROM `zzzzsys_translate` GROUP BY trl_language ORDER BY translated_strings DESC;


/* Missing Strings */
/* Missing and Duplicate Strings */
SET @lang:='German'; -- choose your language here
SET @lang:='German'; -- choose your language here
-- Missing Strings
SELECT a.trl_english
SELECT a.trl_english
FROM `zzzzsys_translate` a LEFT JOIN  
FROM `zzzzsys_translate` a LEFT JOIN  
Line 34: Line 36:
WHERE lang.trl_english IS NULL
WHERE lang.trl_english IS NULL
GROUP BY a.trl_english;
GROUP BY a.trl_english;
-- Duplicate Strings
SELECT trl_english, COUNT(*) AS records FROM zzzzsys_translate
WHERE trl_language = @lang GROUP BY trl_english HAVING records > 1;
</pre>
</pre>



Revision as of 10:15, 11 January 2021

This allows you to make alternative phrases in other languages that can be used instead of nuBuilder Forte's English (Australian) phrases.

The translated phrases for all supported languages are stored in the zzzzsys_translate table.

Language

The User's language.

Dialects

Any changes to the English Translation (Australian) for other dialects like UK, US, Indian, etc can be treated as another language (UKEnglish, USEnglish, INEnglish) having the override strings alone with the parent English as fallback for strings not present in these modded dialects.

This method cannot be used directly for dialects of non-English languages where UPDATE statements can be used with base language INSERTs.

English

A translatable phrase used in nuBuilder Forte.

Translation

The translated phrase used in the selected language. Can safely delete unused language translations in the zzzzsys_translate table.

Supported Languages

Translation Stats

/* Translation Stats */
SELECT trl_language
  , COUNT(*) AS translated_strings
  , (SELECT COUNT(DISTINCT trl_english) FROM `zzzzsys_translate` a)-COUNT(*) AS ToTranslate 
FROM `zzzzsys_translate` GROUP BY trl_language ORDER BY translated_strings DESC;

/* Missing and Duplicate Strings */
SET @lang:='German'; -- choose your language here

-- Missing Strings
SELECT a.trl_english
FROM `zzzzsys_translate` a LEFT JOIN 
(SELECT b.trl_english FROM zzzzsys_translate b WHERE b.trl_language = @lang) lang
USING (trl_english)
WHERE lang.trl_english IS NULL
GROUP BY a.trl_english;

-- Duplicate Strings
SELECT trl_english, COUNT(*) AS records FROM zzzzsys_translate 
WHERE trl_language = @lang GROUP BY trl_english HAVING records > 1;

Stable Updated Version

Bold indicates 100% Translation of 211 strings available

  • Arabic
  • Armenian
  • Chinese
  • Czech
  • French
  • German
  • Greek
  • Hindi
  • Italian
  • Malay
  • Russian
  • Spanish
  • Tamil
  • Vietnamese