Special Characters in Exports

[JMM]

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]

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

[JMM]

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]

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