CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • Documentation for Multiple Languages Support functionality
Pages: [1]

Author Topic: Documentation for Multiple Languages Support functionality  (Read 2799 times)

Michał Mach

  • Moderator
  • Ask me questions
  • *****
  • Posts: 748
  • Karma: 59
    • CiviCRM site
  • CiviCRM version: latest
  • CMS version: Drupal and Joomla latest
  • MySQL version: numerous
  • PHP version: 5.3 and 5.2
Documentation for Multiple Languages Support functionality
December 14, 2009, 10:59:32 am
Based on IRC conversation, I'm starting this thread to coordinate the effort to create some (at least) basic documentation for Multiple Languages Support functionality, which allows storing and exposing data in many languages in the same time. More to come. :-)
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

My absolute favourite: Wordpress Integration!.

Donate Now!

mathieu

  • Administrator
  • Ask me questions
  • *****
  • Posts: 620
  • Karma: 36
    • Work
  • CiviCRM version: 4.7
  • CMS version: Drupal
  • MySQL version: MariaDB 10
  • PHP version: 7
Re: Documentation for Multiple Languages Support functionality
December 14, 2009, 11:32:55 am
Thanks Michał :)

Here is how to activate multi-lingual support:

- Backup your database. The schema of your database will be modified.
- Make sure your hosting provider provides either the MySQL "trigger" privilege or the "super" privilege. ("grant super on *.* to mysqluser@'%' " or "grant trigger on *.* to mysqluser@'%' ")
- Download the "l10n" package for CiviCRM, uncompress and upload to your web host. You should have files such as civicrm/l10n/fr_FR/[...].
- Go to CiviCRM > Admin > Global configurations > Localization
- Enable multi-lingual support
- Add the language (ex: French) from the Localization page.
- In Drupal: Enable the "CiviCRM Language Switcher" block

Here is how to create a multi-lingual profile:

- Switch to a language using the CiviCRM Language Switcher (it seems to be necessary to do it at least once, so that the multi-lingualism interface activates)
- Create a new profile (or edit an existing one)
- Add a field if necessary
- Edit the field again, you will see a "multi-lingual" icon (green square) next to the field label. Click on the icon to translate the field label into other languages.

Viewing the profile in a different language:

- Since your users will probably not see the CiviCRM Language switcher (as it may conflict with Drupal's language switcher), you can link directly to a profile by adding "&lcMessages=en_US" at the end of the URL (where en_US is the language code for your language).

matt (bgm on #civicrm)
CiviCamp Montréal, 29 septembre 2017 | Co-founder / consultant / turn-key CiviCRM hosting for Quebec/Canada @ SymbioTIC.coop

mathieu

  • Administrator
  • Ask me questions
  • *****
  • Posts: 620
  • Karma: 36
    • Work
  • CiviCRM version: 4.7
  • CMS version: Drupal
  • MySQL version: MariaDB 10
  • PHP version: 7
Re: Documentation for Multiple Languages Support functionality
December 14, 2009, 11:38:33 am
It seems that once you have added the new language, you may revoke the "super" rights (revoke super on *.* from mysqluser@'%' ). Do this at your own risk.  Make sure you backup your database regularly.

If you add new languages, you will have to grant the super rights again. If you don't, CiviCRM will crash during the operationg and may leave your database in a unusable state.

Of course, running on MySQL 5.1 is the best solution. :-)
CiviCamp Montréal, 29 septembre 2017 | Co-founder / consultant / turn-key CiviCRM hosting for Quebec/Canada @ SymbioTIC.coop

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • Documentation for Multiple Languages Support functionality

This forum was archived on 2017-11-26.