How to import french/spanish alphabets/characters?

Hello,

2 checks

1. Import file should be UTF-8 encoded

2. Import properties(View Import File Properties) should have UTF-8 encoding selected (File Encoding)

Let me know if that works.

Hello Hash,

     Thanks for the reply. May i know, how can we save file to .csv format with UTF-8 encoding selected? Or how can we check whether the imported file is in UTF-8 encoded format?

Hello,

Open the .csv file in Notepad++

Encoding > Convert to UTF-8 > Save

And try importing again.

Hello Hash,
     Thanks for the reply. It worked, but not a good option for us. Can you tell how we can achieve the same without using any tool other than Microsoft Excel?

Hello,

I too first wanted to avoid this step but event Microsoft's forum's thread is suggesting the same

How can I save a csv with utf-8 encoding using Excel 2013? - Microsoft Community

Hello Hash,

     Nevermind, i found the solution. I just added some code in sugarcrm core file. But it's not a upgrade safe, nor it is verified and tested for a long run. After added this, no need to take care of encoding. But need to check whether it will affect other functionality as I don't have much time now to go through code and check it. Still, thank you.

Hi Sohan,

Can you share your solution, and maybe it can help us point you to an upgrade safe method