Support (offered by community volunteers) > Internationalization and Localization

Export contacts wizard does not deal with non-English characters

(1/2) > >>

epg:
I am running CiviCRM 4.1.1 under Drupal6. The default language is English-US, as this is a US-based organization.    In a handful of contact custom fields, they are using Hebrew.  This is working fine, except when I try to export to a CSV file (using the search batch action of "Export Contacts" )

The resulting exported file has ? characters for each Hebrew letter.  I have reproduced this issue in the 4.1.1. civicrm.org running under Drupal 7. (The link to the 4.1.1. sandbox under Drupal 6 leads to the civicrm.org homepage.)

This same field also produces garbage when used as a mail merge token when generating a PDF letter, which may be related to my first issue.

Is there any setup steps I should check?

thomjoh:
I have the same problem with Chinese characters. I use Drupal 6, CiviCRM 4.1.1 and MySQL 5.5. It used to work fine when we were on CiviCRM 3.x.

Donald Lobo:

1. can u check and see if they are saved properly in the DB

2. Can u save to a file and see what the character is via a text editor

would be good if u can help debug and trace this issue. ping us on irc if u need help

lobo

xavier:
Hi,

For the export, are you sure it isn't on the reader side? Try open it with open/libreoffice, and choose utf8.

Excel assumes it's ascii/latin1, and doesn't offer you the option to change the charset.

The workaround involves a wax doll of Ballmer, a long pin, lots of crude words an changing the extension from .csv to .txt

For the pdf, don't recall having had the problem and we printed badges with a lot of non ascii chars. Might be there is an option somewhere to specify to use ascii

Hershel:
Definitely try OpenOffice. I have outputted Hebrew data from CiviCRM for years.

Navigation

[0] Message Index

[#] Next page