[SOLVED] Greek characters on import

[AlexFL]

Hello,

i was trying to import products to my shop and i have a problem with greek characters, but its not your classic problem that can be fixed by encode the csv file. The problem here is that it can't see any field that begins with a greek character (i guess it happens with any utf-8 characters, i saw a thread with the same problem with turkish characters and another one with a european language i can't remember which one exactly).

I'm gonna try to explain exactly the cases:

 

1st case

containing only greek characters (ΥΠΟΛΟΓΙΣΤΗΣ) == blank data on the import.

 

2nd case

First word in greek second in english (ΥΠΟΛΟΓΙΣΤΗΣ COMPUTER)== only the word Computer (COMPUTER)

 

3rd case

First word english second word greek (COMPUTER ΥΠΟΛΟΓΙΣΤΗΣ) == worked great it read the whole field (COMPUTER ΥΠΟΛΟΓΙΣΤΗΣ)

 

4th case

greek word + any punctuation mark (! . , etc.) + greek word == we get only punctuation mark + second greek word(s) the first its gone.

 

 

I'm using PS 1.5.6 but i think that i had the same problem on previous 1.5.x version of prestashop.

Thanks to anybody who would take time to check this out.

Edited November 13, 2013 by AlexFL (see edit history)

[parsifal]

I really hope it's not some new bug introduced in last versions. AFAIK, up to 1.5.4.1 the CSV import feature didn't have any significant problems with non-Latin characters.

 

AlexFL, in the next days I'll try to setup a test eshop with 1.5.6.0 and check CSV import with Greek characters. Other forum members have reported the same issue in the Greek PrestaShop subforum and I have a bad feeling about this...

Edited November 14, 2013 by parsifal (see edit history)

[PascalVG]

Can you try to save your strings with quotation marks around it? That might help... (and of course encode and read as utf-8, but you said you did already). So like:

"ΥΠΟΛΟΓΙΣΤΗΣ", "μεγάλη σοφία" etc

 

Also, maybe have a look here, there are some other suggestions:

http://stackoverflow.com/questions/2238971/fgetcsv-ignores-special-characters-when-they-are-at-the-beginning-of-line

 

 

My 2 cents,

pascal

[AlexFL]

THANK YOU PASCAL!!!

The quotation trick, worked fine. 

But i think thats a half measure, they have to fix this on the upcoming version (1.6 i think) its a major flaw for presta, we are not talking just about the greek language, any language with special characters is affected by this.

 

PS. i just test it on a small csv (1 product) i'm gonna check it tomorrow on a bigger scale csv, although i'm sure it will work fine. 

Edited November 14, 2013 by AlexFL (see edit history)

[PascalVG]

It's a problem/limitation with the standard php function: fgetcsv

 

To really fix it, they should write their own function using fgets() and then parse csv self or so...

 

Glad it worked with the quotes!

 

I'll mark the topic as solved,

pascal