Answers.Body: <p>I managed to install CiviCRM in Joomla with the database translated strings, but I had to replace the <code>civicrm_data.mysql</code> file with the content of the <code>civicrm_data.fr_CA.mysql</code> file.</p>
  
  <p>Here is what I did, step by step, in case someone else is trying to accomplish the same thing:</p>
  
  <ol>
  <li>Uncompressed both <code>civicrm-4.7.2-joomla.zip</code> and <code>civicrm-4.7.2-l10n.tar.gz</code> in <code>/tmp</code></li>
  <li>Unzipped <code>/tmp/com_civicrm/admin/civicrm.zip</code> and deleted the zip file.</li>
  <li>Copied <code>/tmp/civicrm/l10n/fr_CA/LC_MESSAGES/civicrm.mo</code> into a newly created <code>/tmp/com_civicrm/admin/civicrm/l10n/fr_CA/LC_MESSAGES/</code> directory.</li>
  <li>Copied <code>/tmp/civicrm/sql/civicrm_data.fr_CA.mysql</code> as <code>/tmp/com_civicrm/admin/civicrm/sql/civicrm_data.mysql</code> (overwriting the original file)</li>
  <li>Zipped directory <code>/tmp/com_civicrm/admin/civicrm</code> as <code>/tmp/com_civicrm/admin/civicrm.zip</code> and deleted the directory.</li>
  <li>Pointed Joomla to install from the <code>/tmp/com_civicrm</code> directory.</li>
  <li>Once installed, from Joomla's control panel, went to <strong>CiviCRM - Administer - Localization - Languages</strong> and changed the <strong>default language</strong> to <strong>français (Canada)</strong>.</li>
  </ol>
  
  <p>That's it!  CiviCRM en français !  I don't know if there is an easier way, but that's the only solution I found working.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-25T03:05:33.813Z
Answers.LastActivityDate: 2016-02-25T03:05:33.813Z
Answers.UserDisplayName: Mathieu
Answers.Body: <p>Indeed, the text that is created in the database needs to be set in the proper language at installation.</p>
  
  <p>Once you have installed, you need to do it via the UI, one by one... painful</p>
  
  <p>If you install the i18n folder *before" the installation, you have the option to choose the language you want and it will choose the correct mysql sql for that language behind the scene</p>
  
  <p>How long have you used your civi? might be easier to re-install and import your contacts if you just started</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-24T12:15:18.190Z
Answers.Text: I have only been tinkering in our dev environment, so I can easily re-install. In the civicrm.l10n.tar.gz file, there are two folders: l10n and sql.  Where in the directory structure should I copy them?
Answers.UserDisplayName: Mathieu
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-24T14:13:18.030Z
Answers.Text: just untar it in the root of your civi and it will install both
Answers.UserDisplayName: Xavier
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-24T21:13:22.600Z
Answers.Text: After untaring the civicrm-l10n.tar.gz file, I copied the resulting civicrm directory under com_civicrm from the install package. In Joomla, I typed in the install directory name and then clicked "Install".  After a minute, it comes back with "CiviCRM component files and database tables have been INSTALLED successfully" but I am never prompted for a language selection and the tables are created with English strings.  I also tried copying the civicrm language directory under com_civicrm/admin and that didn't work either.  Is it possible this only works on Drupal?
Answers.UserDisplayName: Mathieu
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-24T21:25:08.850Z
Answers.Text: Looking at the `configure.php` from the Joomla installation zip, it seems to only be calling `civicrm_source($sqlPath . DIRECTORY_SEPARATOR . 'civicrm_data.mysql');`, never looking for a language version of this file.  I guess it couldn't because it never prompts for a language while installing.
Answers.UserDisplayName: Mathieu
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-02-24T10:06:04.043Z
Answers.LastActivityDate: 2016-02-24T10:06:04.043Z
Answers.UserDisplayName: Xavier
Body: <p>Allô!</p>
  
  <p>I have installed CiviCRM 4.7.2 on Joomla and then copied the French language file (<code>l10n/fr_CA/LC_MESSAGES/civicrm.mo</code>). This allowed me to change the default language to fr_CA and most of CiviCRM is now French.</p>
  
  <p>Now I'm looking to install the French language database data file (<code>civicrm_data.fr_CA.mysql</code>) to have the countries, activities and many more strings in French, but it seems this can't be done once the install is complete? Is that right?</p>
  
  <p>The only way I can think of to install this database file is to reinstall CiviCRM but by first replacing the original (English) <code>civicrm_data.mysql</code> file with the content of the <code>civicrm_data.fr_CA.mysql</code> file in the install package. Is this the only way?  It feels like a strange hack and the <a href="https://wiki.civicrm.org/confluence/display/CRMDOC/i18n+Administrator&#39;s+Guide%3A+Using+CiviCRM+in+your+own+language" rel="nofollow">i18n install guide</a> does not mention this database file. </p>
  
  <p>Thanks!</p>
  
Tags: <joomla><i18n>
Title: How to install translated database strings?
ThreadText: # How to install translated database strings?
  
  (Asked by: username_0 on 2016-02-24)
  
  Allô!
  
  I have installed CiviCRM 4.7.2 on Joomla and then copied the French language file (`l10n/fr_CA/LC_MESSAGES/civicrm.mo`). This allowed me to change the default language to fr\_CA and most of CiviCRM is now French.
  
  Now I'm looking to install the French language database data file (`civicrm_data.fr_CA.mysql`) to have the countries, activities and many more strings in French, but it seems this can't be done once the install is complete? Is that right?
  
  The only way I can think of to install this database file is to reinstall CiviCRM but by first replacing the original (English) `civicrm_data.mysql` file with the content of the `civicrm_data.fr_CA.mysql` file in the install package. Is this the only way? It feels like a strange hack and the [i18n install guide](https://wiki.civicrm.org/confluence/display/CRMDOC/i18n+Administrator's+Guide%3A+Using+CiviCRM+in+your+own+language) does not mention this database file.
  
  Thanks!
  
  **Tags:** joomla, i18n
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_0 on 2016-02-25. Score: 1
  
  I managed to install CiviCRM in Joomla with the database translated strings, but I had to replace the `civicrm_data.mysql` file with the content of the `civicrm_data.fr_CA.mysql` file.
  
  Here is what I did, step by step, in case someone else is trying to accomplish the same thing:
  
  1. Uncompressed both `civicrm-4.7.2-joomla.zip` and `civicrm-4.7.2-l10n.tar.gz` in `/tmp`
  2. Unzipped `/tmp/com_civicrm/admin/civicrm.zip` and deleted the zip file.
  3. Copied `/tmp/civicrm/l10n/fr_CA/LC_MESSAGES/civicrm.mo` into a newly created `/tmp/com_civicrm/admin/civicrm/l10n/fr_CA/LC_MESSAGES/` directory.
  4. Copied `/tmp/civicrm/sql/civicrm_data.fr_CA.mysql` as `/tmp/com_civicrm/admin/civicrm/sql/civicrm_data.mysql` (overwriting the original file)
  5. Zipped directory `/tmp/com_civicrm/admin/civicrm` as `/tmp/com_civicrm/admin/civicrm.zip` and deleted the directory.
  6. Pointed Joomla to install from the `/tmp/com_civicrm` directory.
  7. Once installed, from Joomla's control panel, went to **CiviCRM - Administer - Localization - Languages** and changed the **default language** to **français (Canada)**.
  
  That's it! CiviCRM en français ! I don't know if there is an easier way, but that's the only solution I found working.
  
  
  ---
  
  ### Answer by username_1 on 2016-02-24. Score: 0
  
  Indeed, the text that is created in the database needs to be set in the proper language at installation.
  
  Once you have installed, you need to do it via the UI, one by one... painful
  
  If you install the i18n folder \*before" the installation, you have the option to choose the language you want and it will choose the correct mysql sql for that language behind the scene
  
  How long have you used your civi? might be easier to re-install and import your contacts if you just started
  
  > **Comments:**
  > **username_0**: I have only been tinkering in our dev environment, so I can easily re-install. In the civicrm.l10n.tar.gz file, there are two folders: l10n and sql.  Where in the directory structure should I copy them?  
  > **username_1**: just untar it in the root of your civi and it will install both  
  > **username_0**: After untaring the civicrm-l10n.tar.gz file, I copied the resulting civicrm directory under com_civicrm from the install package. In Joomla, I typed in the install directory name and then clicked "Install".  After a minute, it comes back with "CiviCRM component files and database tables have been INSTALLED successfully" but I am never prompted for a language selection and the tables are created with English strings.  I also tried copying the civicrm language directory under com_civicrm/admin and that didn't work either.  Is it possible this only works on Drupal?  
  > **username_0**: Looking at the `configure.php` from the Joomla installation zip, it seems to only be calling `civicrm_source($sqlPath . DIRECTORY_SEPARATOR . 'civicrm_data.mysql');`, never looking for a language version of this file.  I guess it couldn't because it never prompts for a language while installing.  
  
  ---
  
  