Import Windows to Linux - with accents

[ysh]

Hi

I'm attempting to import data into a newly installed linux server : Sugar CE 5.2c running on OpenSuse 11.1 with latest Apache2, PHP, MySQL (+ Synolia French language pack).

The data, in french, originates from Excel 2003 running on Windows Vista
I saved the file using OpenOffice Calc in CSV (UTF-8) format (all columns are in TEXT, delimited using ").

As a matter of fact the Sugar database tables are all in UTF-8 format in MySQ, and the following settings have been checked and validated :

config.php
'default_charset' => 'UTF-8',

include\language\en_us.lang.php
'LBL_CHARSET' => 'UTF-8',

include\phpmailer\class.phpmailer.php
Var $CharSet = "utf-8;


When I view the header row and first record, of a purposefully created test file, in the import screen (Accounts or Contacts) under Sugar the accents (international characters) appear properly. I have tried several other file formats, but without success (CP 1252, Unicode, ...)

Once the import is over though I realize that the fields containing accentuated characters have simply been ignored i.e. not imported.

With over 15000 records to import, and a good third of them with fields containing these international characters, and two days spent solely on this issue, I feel like I'm in a rut.

Unfortunately I can't convince our customer to give up on these linguistic stress symbols.
Ah non Monsieur !

I don't particularly want to implement Sugar on a Windows box, but if I can't resolve this issue, I don't think that I'll be at liberty to choose my flavour.

Today I will import the data unto a Windows Sugar installation, backup the MySQL databases, and then attempt to restore them onto the original Linux box to see if that works any better.

Any ideas, or experience you might have on these matters will be greatly appreciated.

Thanks

ysh

[kbrill]

Can you post an example or two from your import file? It looks like you have all the settings right, I would also look at admin->locale settings and make sure that they are all reflected there as well.

[ysh]

Thanks for your reply

Imported CSV file into Windows Sugar platform and then Backed-up databases via phpMyAdmin
Restored MySQL dump into Linux box : accents were properly retained. Cool.

I did attempt a few other direct imports from the Linux box and I finally got it to work : 'save as' from OpenOffice Calc of CSV in [Western Europe ISO-8859-1] or [Western Europe ISO-1252/WinLatin1] formats.
Bingo !

Happy

ysh