The problem of the Arabic language in export and import

I exported my clients to Excel 2007. I tried importing them to another hosting account, but the client name didn’t appear despite the process being complete. The client name field is empty,

while the mobile number appears normally.

The language used is Arabic.

When I open the Excel file, the name appears correctly.

The problem occurs in Dolibar when importing the file.

Thank you for your support

sounds like the mapping wasn’t working correctly but you can give it another try just with some key field and the company name.

1 Like

It’s probably a language encoding problem… but I don’t know the solution.!

can you enter the companies name manually?

Hello,

Did you try importing with XLSX or CSV file ?

1 Like

You must set the language encoding type of your import file to “UTF8 with Product Recipe”. This will prevent charset corruption and whitespace generation.

2 Likes

I tried all the formats available in the program.

After exporting the file, how do I convert it to UTF8 encoding?

if on Linux, try using iconv? @xshop

1 Like

The products were successfully translated and imported into Arabic. The problem is with customer names; they are rejected or appear blank.

if you create a company in dolibarr, export it, delete that company, and the re-imports it - does the name then work or not?

I don’t know the answer; I haven’t tried doing that.