User import (with csv files) : utf8 and Ansi

[tanchon]

Current behavior / Resultado actual / Résultat actuel

If I work from the "example" file downloaded from the Chamilo Platform, I have a problem.
When I try to import users it works fine except that : firstnames or lastnames with special characters are only partially imported => "Stéphane" is imported as "St" ; "Agnès" is imported as "Agn"...

It seems that this "example" file is encoded in "ANSI". I tried to convert it in "utf8" but Chamilo doesn't accept to import it (I have a green message that indicates the file has been imported : but in fact none of the users listed in the file are imported).

If I export a csv file with my current users, it is coded in "utf8" (why is it different form "example" file ?) : if i open this file with notepad, everything seems ok, even special characters (which are not correctly displayed in Excel).
But if I modify the file (in notepad), adding a new user with special character, Chamilo doesn't accept to import it (I have a green message that indicates the file has been imported : but in fact none of the users listed in the file are imported).

Chamilo Version / Versión de Chamilo / Version de Chamilo

1.11.2 and 1.11.4

[jmontoyaa]

Can you provide the example file here? It should work with a csv utf8 file.

[tanchon]

The first file is the example file downloaded from my platform (I just modified some names) : Chamilo accept to import it, but with problem (names partially imported).

The second file has been converted in utf8 : but Chamilo doesn't accept to import it (I have a green message that indicates the file has been imported : but in fact none of the users listed in the file are imported).

Thanks for your help !

examples files.zip

[ywarnier]

Maybe linked to Aix and the possibility to import directly in XLSX

[jmontoyaa]

The import was fixed because of some changes for Aix, now it should work.

[NicoDucou]

The example file 2 example converted in utf8.csv indicated by @tanchon works fine now, but @jmontoyaa for Aix it is the glossary example file that has been converted to utf8 but not the user_import.csv example file.

As we can see the example file here https://11.chamilo.org/main/admin/example.csv is like this :

file example.csv 
example.csv: ASCII text

It should be in utf8 no ? So that it will already be in the correct format.

[jmontoyaa]

yes, you're right it should be utf8. I converted the files using notepadqq (ubuntu)

[ywarnier]

Please check this is working in 2.0

[Coursenligne]

Well it's a very old issue that accuentuated names would be troncated. I think the first time I saw it was at the begining of the project (back to 1.8.6 version).
Thanks to emails, most of the accentuated names are transformed to non-accent letters.
If you manage to make it working, all the Jérôme of the world will thank you!
Courage dev. gang :)

[tanchon]

Hi @Coursenligne
In the short term, i "purified" all the firstnames and lastnames of the list i want to import, eliminating all accented characters. But sometimes i forget the issue, and some users send me mails :-)

I tried to define the charset in my .htaccess file : AddDefaultCharset UTF-8
But it had no effect....

May be the issue is related to another ? : it is impossible to modifiy this setting in chamilo (i know there is an issue about that, but i can't find it).