Install Translations

From OpenEMR Project Wiki


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. (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)

Development Translation Releases

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

Official Translation Releases

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


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':
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
  • 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).