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) »
  • Import of contacts : System has no character sign "Ö"
Pages: [1]

Author Topic: Import of contacts : System has no character sign "Ö"  (Read 1214 times)

Markus Hapke

  • I’m new here
  • *
  • Posts: 14
  • Karma: 0
  • CiviCRM version: 4.3.0
  • CMS version: Drupal
  • MySQL version: MySQL 5.1
  • PHP version: PHP 5.3
Import of contacts : System has no character sign "Ö"
November 06, 2013, 01:47:50 am
Hello

When importing a csv - contact sheet, the country is "Österreich"  in the file.
But when importing it, allways the "Ö" isn't visible. System complains about incorrect country
Language / country settings are ok, there 'Österreich" is a specified country.

What to do?
UTF-8 seem not to work correct ?

best regards,
M. Hapke

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Import of contacts : System has no character sign "Ö"
November 06, 2013, 08:35:00 am
Are you sure your csv is utf-8? if you used microsoft, it likely isn't.

you can replace the long name by the iso code (at) and it shouldn't have any problem
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

Markus Hapke

  • I’m new here
  • *
  • Posts: 14
  • Karma: 0
  • CiviCRM version: 4.3.0
  • CMS version: Drupal
  • MySQL version: MySQL 5.1
  • PHP version: PHP 5.3
Re: Import of contacts : System has no character sign "Ö"
November 07, 2013, 04:56:28 am
Hello!
Yes import possible w.o. problems when using Coutnry code AT instad of Österreich.

( UTF-8 file was created from out of MAC - Textedit- when saving it is possible to specify the
text - coding )

Thanks !
Markus

Jens-Erik

  • I post occasionally
  • **
  • Posts: 60
  • Karma: 0
  • CiviCRM version: 4.4
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.4
Re: Import of contacts : System has no character sign "Ö"
November 07, 2013, 07:41:00 am
You create a CSV on a Mac and want to import contacts in CiviCRM, right? When dealing with CSVs I highly recommend you to use LibreOffice or OpenOffice, it's much more convenient than Textedit or TextWrangler (btw. Xavier, TextEdit is made by Apple not MS). But if you have set TextEdit to use UTF-8 for writing (and best also for importing) simple texts, then it does use UTF-8, and I recommend to stay with UTF-8 as a standard encoding where ever possible, it saves you from a lot of trouble.

I didn't know you can use the country codes for importing contacts, good to know. Anyway, i think the country import should be more tolerant. Why not accept UK, USA, United States of America instead of United Kingdom and United States only?
« Last Edit: December 06, 2013, 02:29:12 am by Jens-Erik »

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Import of contacts : System has no character sign "Ö"
November 08, 2013, 02:03:48 am
Quote from: Jens-Erik on November 07, 2013, 07:41:00 am
Why not accept UK, USA, United States off America instead of United Kingdom and United States only?

Good idea, it would be super useful indeed! patch welcome if you work on it.
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

Markus Hapke

  • I’m new here
  • *
  • Posts: 14
  • Karma: 0
  • CiviCRM version: 4.3.0
  • CMS version: Drupal
  • MySQL version: MySQL 5.1
  • PHP version: PHP 5.3
Re: Import of contacts : System has no character sign "Ö"
November 09, 2013, 02:05:33 pm
OK, for the moment done.
But it works only wit "AT" instead of "Österreich"  . UTF-8 -encoding seems not to bo sufficcient to CiviCRM 4.4  .

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Import of contacts : System has no character sign "Ö"
November 10, 2013, 02:42:18 am
Can you try importing some sample on the demo site? Never had any problem importing utf8
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result

Jens-Erik

  • I post occasionally
  • **
  • Posts: 60
  • Karma: 0
  • CiviCRM version: 4.4
  • CMS version: Drupal 7
  • MySQL version: 5.5
  • PHP version: 5.4
Re: Import of contacts : System has no character sign "Ö"
December 06, 2013, 02:33:33 am
Quote from: xavier on November 08, 2013, 02:03:48 am
Good idea, it would be super useful indeed! patch welcome if you work on it.

Okay, I hope I can understand the structure of the code soon, then I'm willing to contribute.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • Import of contacts : System has no character sign "Ö"

This forum was archived on 2017-11-26.