Difference between revisions of "Install Translations"

From OpenEMR Project Wiki
 
(28 intermediate revisions by the same user not shown)
Line 5: Line 5:
These are instructions to upgrade to the most recent language translation tables published for OpenEMR. This is very simple to do.
These are instructions to upgrade to the most recent language translation tables published for OpenEMR. This is very simple to do.


:<span style="color:red;">'''Note that this will delete all of your current local OpenEMR language translation tables.'''</span> (unless you are using the lang_custom table to hold your local customizations - this is described in the OpenEMR 3.2 patch and will be included in OpenEMR 4.0)
:<span style="color:red;">Note that this will delete all of your current local OpenEMR language translation tables if you are using a OpenEMR version less than 4.0.</span> (Since version 4.0, there is a lang_custom mysql table that holds your local customizations, and instructions to synchronize your custom local translations with the standard translation tables are described at the end of the tutorial below.)




== Development Translation Releases ==
== Development Translation Release ==
:* [http://github.com/openemr/translations_development_openemr/raw/master/languageTranslations_utf8.sql Daily Development Release]: This is automatically built daily (17:00 Pacific Standard Time) from the google docs translation spreadsheet; note it could be buggy.
:* [http://translations.openemr.io/languageTranslations_utf8.sql Daily Development Release]: This is automatically built daily (8:10 AM Pacific Standard Time) from the google docs translation spreadsheet; note it could be buggy.


 
== Most Recent Official Translation Release ==
== Official Translation Releases ==
:* [https://raw.githubusercontent.com/openemr/openemr/v6_0_0/contrib/util/language_translations/currentLanguage_utf8.sql OpenEMR 6.0.0 Release]: This was released with OpenEMR 6.0.0
:* [http://openemr.cvs.sourceforge.net/viewvc/*checkout*/openemr/openemr/contrib/util/language_translations/currentLanguage_utf8.sql?revision=1.11.2.6 08/20/2009 Release]: This was released with OpenEMR 3.1.0 and included only selected languages (English, English(Indian), Swedish,Spanish,Dutch,Chinese,Greek).
:* [http://openemr.cvs.sourceforge.net/viewvc/*checkout*/openemr/openemr/contrib/util/language_translations/currentLanguage_utf8.sql?revision=1.16 10/24/2009 Release]: Includes all languages.
:* [http://openemr.cvs.sourceforge.net/viewvc/*checkout*/openemr/openemr/contrib/util/language_translations/currentLanguage_utf8.sql?revision=1.18 12/11/2009 Release]: Includes all languages.
:* [http://openemr.cvs.sourceforge.net/viewvc/*checkout*/openemr/openemr/contrib/util/language_translations/currentLanguage_utf8.sql?revision=1.19 12/19/2009 Release]: Includes all languages.
:* [http://openemr.cvs.sourceforge.net/viewvc/*checkout*/openemr/openemr/contrib/util/language_translations/currentLanguage_utf8.sql?revision=1.20 01/23/2010 Release]: Includes all languages.
:* [http://openemr.cvs.sourceforge.net/viewvc/*checkout*/openemr/openemr/contrib/util/language_translations/currentLanguage_utf8.sql?revision=1.21 01/30/2010 Release]: Includes all languages.
:* [http://openemr.cvs.sourceforge.net/viewvc/*checkout*/openemr/openemr/contrib/util/language_translations/currentLanguage_utf8.sql?revision=1.19.2.3 02/12/2010 Release]: This was released with OpenEMR 3.2.0 and includes only selected languages (English, English(Indian), Dutch, Greek, Portuguese (Brazilian), Portuguese (European), Spanish, and Swedish).
:* [http://openemr.cvs.sourceforge.net/viewvc/*checkout*/openemr/openemr/contrib/util/language_translations/currentLanguage_utf8.sql?revision=1.22 03/20/2010 Release]: Includes all languages.
:* [http://openemr.cvs.sourceforge.net/viewvc/*checkout*/openemr/openemr/contrib/util/language_translations/currentLanguage_utf8.sql?revision=1.23 04/24/2010 Release]: Includes all languages.
:* [http://openemr.cvs.sourceforge.net/viewvc/*checkout*/openemr/openemr/contrib/util/language_translations/currentLanguage_utf8.sql?revision=1.24 07/21/2010 Release]: Includes all languages.
:* [http://openemr.cvs.sourceforge.net/viewvc/*checkout*/openemr/openemr/contrib/util/language_translations/currentLanguage_utf8.sql?revision=1.25 08/23/2010 Release]: Includes all languages.
:* [http://openemr.cvs.sourceforge.net/viewvc/*checkout*/openemr/openemr/contrib/util/language_translations/currentLanguage_utf8.sql?revision=1.26 09/06/2010 Release]: Includes all languages.
:* [http://openemr.git.sourceforge.net/git/gitweb.cgi?p=openemr/openemr;a=blob_plain;f=contrib/util/language_translations/currentLanguage_utf8.sql;h=6743429b3a4e6df13bf8a127dca9db1f633c66f5;hb=dc47d28 03/05/2011 Release]: Includes all languages.
:* [http://openemr.git.sourceforge.net/git/gitweb.cgi?p=openemr/openemr;a=blob_plain;f=contrib/util/language_translations/currentLanguage_utf8.sql;h=e3791186c031dea337a21fec5b5e75be9ac718fb;hb=bbbac7f816daf9d39663b552db9c786c5d06c818 03/12/2011 Release]: Includes all languages.
:* [http://openemr.git.sourceforge.net/git/gitweb.cgi?p=openemr/openemr;a=blob_plain;f=contrib/util/language_translations/currentLanguage_utf8.sql;hb=5bb4c7beab1fe274147df9ccf3b989adcb0ae04b 03/20/2011 Release]: This was released with OpenEMR 4.0.0 and includes only selected languages (English, English(Indian), Dutch, Greek, Portuguese (Brazilian), Portuguese (European), Spanish, and Turkish). <span style="color:green">(new)</span>


== Installation instructions ==
== Installation instructions ==
Line 67: Line 52:




:'''The last thing to do is to synchronize your custom translations. (Note that all translations and constants that you have added (since OpenEMR version 4.0) via the Administration->Language editor are saved in a sql table entitled lang_custom; this allows you then to add these back after importing the standard set of tables above). To do this, go to Administration->Other->Language, click 'Manage Translations' at the top, and then click the 'Synchronize' button.'''


'''ALL DONE'''
== How The Translation Releases Are Built==
*This is how I build the above official translation tables from the google docs spreadsheet. These instructions can be used by others to create their own translation tables from the most current google docs spreadsheet.
*To create a new set of translation tables from the most current google docs spreadsheet, then follow these instructions, which are specific for linux commandline and are run in a temporary directory entitled 'translations':
<pre>
cd (to your openemr directory)
cd ../
mkdir translations
cd translations
wget --no-check-certificate -O spreadsheet.tsv "https://spreadsheets.google.com/ccc?key=0AtTW60zHo6HzcGg0UE9JMGJHM1NsSWpuYkh0Snl4Q0E&output=txt"
wget -O buildLanguageDatabase.pl "http://openemr.git.sourceforge.net/git/gitweb.cgi?p=openemr/openemr;a=blob_plain;f=contrib/util/language_translations/buildLanguageDatabase.pl;hb=HEAD"
chmod +x buildLanguageDatabase.pl
wget -O log_buildLanguageDatabase.txt "http://openemr.git.sourceforge.net/git/gitweb.cgi?p=openemr/openemr;a=blob_plain;f=contrib/util/language_translations/log_buildLanguageDatabase.txt;hb=HEAD"
wget -O currentConstants.txt "http://openemr.git.sourceforge.net/git/gitweb.cgi?p=openemr/openemr;a=blob_plain;f=contrib/util/language_translations/currentConstants.txt;hb=HEAD"
./buildLanguageDatabase.pl spreadsheet.tsv currentConstants.txt
rm languageTranslations_latin1.sql
(SANITY CHECK) diff log_buildLanguageDatabase.txt log.txt
</pre>
*The SANITY CHECK is very important and should not contain any ERRORS. (Errors are almost always secondary to translators mistakenly putting tab or carriage return characters in their translations and requires manual repair in the google doc spreadsheet).
*[http://gist.github.com/867634 A bash script that runs above commands is also available].


*<b>The languageTranslations_utf8.sql file is the new sql table which can be [[Install_Translations#Installation_instructions|imported into OpenEMR via above instructions]].</b>
[[Category:Internationalization]]

Latest revision as of 07:49, 18 January 2021


Overview

These are instructions to upgrade to the most recent language translation tables published for OpenEMR. This is very simple to do.

Note that this will delete all of your current local OpenEMR language translation tables if you are using a OpenEMR version less than 4.0. (Since version 4.0, there is a lang_custom mysql table that holds your local customizations, and instructions to synchronize your custom local translations with the standard translation tables are described at the end of the tutorial below.)


Development Translation Release

  • Daily Development Release: This is automatically built daily (8:10 AM Pacific Standard Time) from the google docs translation spreadsheet; note it could be buggy.

Most Recent Official Translation Release

Installation instructions

1. Download the translation (choose a link above) release to desktop (via 'File'->'Save Page as'):


2. Login to OpenEMR:

Login. (screenshot below)

Translations-Install-1.jpg


Click 'Administration'->'Other'->'Database' from left tree menu. (screenshot below)

Translations-Install-2.jpg


Click 'openemr' database link near top left (highlighted by arrow). (screenshot below)

Translations-Install-3.jpg


Click 'Import' near top right (highlighted by arrow). (screenshot below)

Translations-Install-4.jpg


Click 'Browse' (highlighted by arrow). (screenshot below)

Translations-Install-5.jpg


Select the 'currentLanguage_utf8.sql' (or languageTranslations_utf8.sql) file that you downloaded in above first step, and click 'Open'. (screenshot below)

Translations-Install-6.jpg


Click 'Go' at bottom right (highlighted by arrow). After click, the import can take up to a minute or so. (screenshot below)

Translations-Install-7.jpg


After import is done, you should see the yellow banner stating the import has been successfully finished. (screenshot below)

Translations-Install-8.jpg


The last thing to do is to synchronize your custom translations. (Note that all translations and constants that you have added (since OpenEMR version 4.0) via the Administration->Language editor are saved in a sql table entitled lang_custom; this allows you then to add these back after importing the standard set of tables above). To do this, go to Administration->Other->Language, click 'Manage Translations' at the top, and then click the 'Synchronize' button.