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) »
  • Problem with non-latin words not showing up
Pages: [1]

Author Topic: Problem with non-latin words not showing up  (Read 3220 times)

condor21

  • Guest
Problem with non-latin words not showing up
November 04, 2009, 07:48:21 am
Hello

I'm trying to use csv file that contains non-latin characters (in cyrillic) (See attached).
Step 2 of import. I can see only fields that start from a number or a latin charachter. (See attached)

Futher Steps generate error.

The same situation with a Contact Import.
Your demo site has the same problem.
I tried to play with encoding, no result.

Any idea?

Many thanks
Serguei

condor21

  • Guest
Please, help!
November 06, 2009, 04:53:42 am
I really need this functionality. What can be the problem? At least which php file to look in?

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Problem with non-latin words not showing up
November 06, 2009, 05:54:19 am

is your import file in UTF-8 encoding?

the code is in CRM/Import/Form/*

if you'd like to investigate

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

condor21

  • Guest
Re: Problem with non-latin words not showing up
November 09, 2009, 05:06:31 am
Yes, UTF-8.

condor21

  • Guest
Re: Problem with non-latin words not showing up
November 11, 2009, 01:53:41 am
I found that it writes empty values for these values into jos_session table. Something like
Code: [Select]
{i:0;s:13:"JДрыгин";i:1;s:0:"";i:2;s:63:"1 Место Группа А, категория Мужчины";i:3;s:2:"13";i:4;s:0:"";i:5;s:0:"";} It writes array value properly if the first symbol (of the value) is a latin character or a number.

I'm lost a bit in a variety of CRM files as it's hard to me to dig with no understanding of the overall solution architecture...

Please, help where the bug can be? Parser error?

condor21

  • Guest
Re: Problem with non-latin words not showing up
November 11, 2009, 03:00:47 am
The problem is solved. Using "" or '' for each field.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Problem with non-latin words not showing up
November 11, 2009, 06:14:13 am

do u mean in the column header field?, i.e. the first row?

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

condor21

  • Guest
Re: Problem with non-latin words not showing up
November 11, 2009, 07:24:58 am
"" for each non-latin field (value) in csv.
Example of a csv row:
Code: [Select]
38;25;9;0;20;"Участник";"Посетил";6

Piotr Szotkowski

  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: Problem with non-latin words not showing up
November 12, 2009, 05:37:18 am
(For reference, the relevant issue in our issue tracker is CRM-345.)
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • Problem with non-latin words not showing up

This forum was archived on 2017-11-26.