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) »
  • Special Characters in Exports
Pages: [1]

Author Topic: Special Characters in Exports  (Read 590 times)

JMM

  • I post occasionally
  • **
  • Posts: 67
  • Karma: 0
  • CiviCRM version: 4.5.5
  • CMS version: Drupal 7.34
  • MySQL version: 5.5.40
  • PHP version: 5.4.33
Special Characters in Exports
February 02, 2015, 06:50:25 am
Hi,

I use CiviCRM in french
When I export contacts, special characters (like è or é) are not correctly exported
e.g. :
Destinataire   Home-Courriel
Mme Michèle Moranne   m.moranne@gmail.com   (Michèle instead of Michèle)
Père Bruno L'Hirondel   brulhir@gmail.com          (Père  instead of Père)

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: Special Characters in Exports
February 02, 2015, 07:07:48 am
Hi/Salut,

Are you importing in Libre/Open Office, or MS Office?

When you open the file in the other source, you must make sure to specify that the character encoding is Unicode UTF-8 (not iso-8859-x, latin1, etc). See attached screenshot for Libre Office.

For what it's worth, Libre Office has a much better CSV import feature than MS Office. In MS Office, you have to create a new spreadsheet, then use the "data import wizard" (my users hate it).

You might also like to try this extension:
https://github.com/mlutfy/ca.bidon.civiexportexcel

However, it has limitations for very large exports (it can cause a white screen/timeout).

Mathieu
CiviCamp Montréal, 29 septembre 2017 | Co-founder / consultant / turn-key CiviCRM hosting for Quebec/Canada @ SymbioTIC.coop

JMM

  • I post occasionally
  • **
  • Posts: 67
  • Karma: 0
  • CiviCRM version: 4.5.5
  • CMS version: Drupal 7.34
  • MySQL version: 5.5.40
  • PHP version: 5.4.33
Re: Special Characters in Exports
February 03, 2015, 05:39:04 am
Hi/Merci

I want to import those in a different emailing system (called www.activetrail.com), which reads csv files (which can contain accentuated characters).

But it won't read accentuated characters if those have been replaced in the csv CiviCRM Export.

My problem in an Export problem, not an Import one

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: Special Characters in Exports
February 03, 2015, 05:59:53 am
Hi,

Can you ask the operators of the other system (activetrail) what their import default character encoding is, and convert the file if necessary? Other than that, there are no known bugs with CiviCRM exports of accentuated characters in CSV.

Mathieu
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) »
  • Special Characters in Exports

This forum was archived on 2017-11-26.