Problem with non-latin words not showing up

[condor21]

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]

I really need this functionality. What can be the problem? At least which php file to look in?

[Donald Lobo]

is your import file in UTF-8 encoding?

the code is in CRM/Import/Form/*

if you'd like to investigate

lobo

[condor21]

Yes, UTF-8.

[condor21]

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]

The problem is solved. Using "" or '' for each field.

[Donald Lobo]

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

lobo

[condor21]

"" for each non-latin field (value) in csv.
Example of a csv row:

Code: [Select]

38;25;9;0;20;"Участник";"Посетил";6

[Piotr Szotkowski]

(For reference, the relevant issue in our issue tracker is CRM-345.)