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 Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Unicode names not imported from CSV
Pages: [1]

Author Topic: Unicode names not imported from CSV  (Read 1140 times)

yositsitsu

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 2
  • CiviCRM version: 4.0.4
  • CMS version: joomla 1.6.3
  • MySQL version: 5.5.8-log
  • PHP version: 5.3.5
Unicode names not imported from CSV
July 21, 2011, 06:57:17 am
Hi,
I tried the import on my windows local machine with CiviCRM 4.0.4 on Joomla 1.6.3 and the import worked fine.

However, on my linux server with  CiviCRM 4.0.4 on Joomla 1.6.4, the import does not extract the hebrew names.

The same hapens on the Drupla Demo Site:
http://drupal.demo.civicrm.org

I've attached a 2 line demo CSV with hebrew in it.

Does anyone have any clues?

Thanks!
Yosi

yositsitsu

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 2
  • CiviCRM version: 4.0.4
  • CMS version: joomla 1.6.3
  • MySQL version: 5.5.8-log
  • PHP version: 5.3.5
Re: Unicode names not imported from CSV
July 26, 2011, 04:54:19 am
Guys,

I really need help - I donated and will donate more.

Just give me a sing that someone cares - please.

The component does not work properly, not only on my installation, but also on the demo site -

Is it a known issue? Is it of secondary importance?

Support will be much appreciated.

Yosi.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Unicode names not imported from CSV
July 26, 2011, 06:14:40 am
Hi Yosi. Try surrounding each field with commas like the attached. This works for me on a Linux server.

בהצלחה
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

yositsitsu

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 2
  • CiviCRM version: 4.0.4
  • CMS version: joomla 1.6.3
  • MySQL version: 5.5.8-log
  • PHP version: 5.3.5
Re: Unicode names not imported from CSV
July 27, 2011, 12:44:24 am
Hey thanks a lot Hershel - that did it for me too!

Is it a bug in CiviCRM or a Linux "feature"?

As long as I know, no software exports CSV values with quotes around values - in fact this is a huge pain in the neck as I have to import hundreds of rows, 20 columns each with hebrew values all around.

Is there a chance to get true support for non-latin/unicode symbols without surrounding with quotes?

Thansk for help! :)
Yosi

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Unicode names not imported from CSV
July 27, 2011, 02:12:54 am
> Is it a bug in CiviCRM or a Linux "feature"?

I do not know.

> As long as I know, no software exports CSV values with quotes around values

Try OpenOffice, available in Hebrew http://openoffice.org.il/ and English http://www.openoffice.org/ as it will do that for you.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

yositsitsu

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 2
  • CiviCRM version: 4.0.4
  • CMS version: joomla 1.6.3
  • MySQL version: 5.5.8-log
  • PHP version: 5.3.5
Re: Unicode names not imported from CSV
July 27, 2011, 04:28:33 am
Quote from: Hershel on July 27, 2011, 02:12:54 am
> Is it a bug in CiviCRM or a Linux "feature"?

I do not know.

> As long as I know, no software exports CSV values with quotes around values

Try OpenOffice, available in Hebrew http://openoffice.org.il/ and English http://www.openoffice.org/ as it will do that for you.

Thanks for your reply.

It was too general to say "no software exports CSV values with quotes" - in fact I do know several, thinking back.
It would more precise to say that we use google docs in our organization and the google excel exports CSV without quotes.

I will see if open office can help me if used as a link the export chain :)

Thanks a lot mate!

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Unicode names not imported from CSV
July 27, 2011, 06:06:53 am
My pleasure.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

yositsitsu

  • I post occasionally
  • **
  • Posts: 30
  • Karma: 2
  • CiviCRM version: 4.0.4
  • CMS version: joomla 1.6.3
  • MySQL version: 5.5.8-log
  • PHP version: 5.3.5
Re: Unicode names not imported from CSV
July 27, 2011, 12:48:08 pm
You are the man!

This is what I did as a workaround to quoteless google CSV:
  • Opened the google CSV with OpenOffice
  • Saved as OpenOffice CSV

Now I can easily import the Unicode CSV into CiviCRM :)

Thanks again mate ;)

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Unicode names not imported from CSV
July 28, 2011, 02:47:26 am
Happy to help. :)
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

xavier

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4453
  • Karma: 161
    • Tech To The People
  • CiviCRM version: yes probably
  • CMS version: drupal
Re: Unicode names not imported from CSV
July 29, 2011, 07:20:21 am
Hi,

Csv is a nice solution in theory. Unfortunately, some major software company decided to generate the csv in latin1 (or the local charset), and NOT offer the option to export it as unicode utf8.

I'm working on a excel import, mostly working, but as most of the "whenever you have the time" projects, it's put aside...

X+
-Hackathon and data journalism about the European parliament 24-26 jan. Watch out the result
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Unicode names not imported from CSV

This forum was archived on 2017-11-26.