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) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • [SOLVED] import ecoding error
Pages: [1]

Author Topic: [SOLVED] import ecoding error  (Read 504 times)

TeNNoX

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
  • CiviCRM version: v4.4.x
  • CMS version: Drupal v7.x
  • MySQL version: newest
  • PHP version: PHP 5
[SOLVED] import ecoding error
September 07, 2014, 09:44:46 am
I tried to import some contacts with bin/csv/import.php, but some lines resulted in a
Code: [Select]
ERROR line 2: DB Error: unknown errorI figured out that those where the lines containing fields with special german letters in it (ü,ö,ä)

How can I fix this?
(the imported file is attached)
« Last Edit: September 09, 2014, 03:02:22 am by TeNNoX »

JonGold

  • Ask me questions
  • ****
  • Posts: 638
  • Karma: 81
    • Palante Technology
  • CiviCRM version: 4.1 to the latest
  • CMS version: Drupal 6-7, Wordpress 4.0+
  • PHP version: PHP 5.3-5.5
Re: import encoding error
September 08, 2014, 08:34:23 am
This may have to do with your system's local text encoding.  I don't know your platform, but you should a) check the default text encoding for your shell session, and b) check the MySQL text encoding for the relevant tables.

Rest assured I've imported accented characters with that tool many times!
Sign up to StackExchange and get free expert CiviCRM advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

Michael McAndrew

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1274
  • Karma: 55
    • Third Sector Design
  • CiviCRM version: various
  • CMS version: Nearly always Drupal
  • MySQL version: 5.5
  • PHP version: 5.3
Re: import encoding error
September 09, 2014, 02:36:04 am
Quote from: JonGold on September 08, 2014, 08:34:23 am
Rest assured I've imported accented characters with that tool many times!
Spoken like a true bin/csv/import.php guru :D
Service providers: Grow your business, build your reputation and support CiviCRM. Become a partner today

TeNNoX

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
  • CiviCRM version: v4.4.x
  • CMS version: Drupal v7.x
  • MySQL version: newest
  • PHP version: PHP 5
Re: import encoding error
September 09, 2014, 03:02:01 am
Quote from: JonGold on September 08, 2014, 08:34:23 am
This may have to do with your system's local text encoding.  I don't know your platform, but you should a) check the default text encoding for your shell session, and b) check the MySQL text encoding for the relevant tables.

Rest assured I've imported accented characters with that tool many times!

I saw that the encoding in MySQL was UTF-8 and the file was iso-8859-1 or something like that.

After saving the file as UTF-8 it worked!
Thanks :D
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • [SOLVED] import ecoding error

This forum was archived on 2017-11-26.