Skip to Content
Меню
Вам необхідно зареєструватися, щоб взаємодіяти зі спільнотою.
Це запитання позначене
4 Відповіді
5340 Переглядів

Hi, i have a question about export to csv file from OE system. my OS is windows 7. the character set of OS is GBK . now, i export to CSV file from OE system , the CSV file is UTF-8 encoding, it's different from OS's encoding, so appear garbled.

I want to change current OS encoding(GBK) to OE's file encoding(UTF-8), so achieve my purpose, but this implementation is difficult.

any good idea for me.

thank you!

Аватар
Відмінити
Автор Найкраща відповідь

Thank for antanas's infos I want to solve this issue once and for all. I want to not convert every time, when i export and import file I know change system encoding is better, but i don't know how to change it.

Аватар
Відмінити
Найкраща відповідь

Your problem most likely lies in what you are using to open the files.

You should be using a 'plain text editor' in the first instance. However I appreciate that excel may present a CSV in a more readable format.

Normally when you open the file you will likely be presented with a dialogue asking how to handle the file, in this you will have the option of setting the field separators, and encoding.

Your problem is going to arise in saving the file back to CSV, microsoft with try and second guess you, and will attempt to adjust the encoding, and field separators to something more modern (read wrong for Odoo).

In the first instance of using Odoo I was rather surprised that they used UTF-8, I'm more used to seeing one of the IS0-8859-X forms, but that is probably just me.

Your best bet may be to get a version of libre office or Open Office, the spreadsheets in them are more friendly to saving the file to the format that you started with.

I don't know if it exists in windows, but on Linux you can often set a specific encoding for specific file types.

 

David

Аватар
Відмінити
Найкраща відповідь

Try to use notepad++, it's a really powerfull text editor and can be a minimal IDE for your favorite programming language.

For you problem, it has nice Encoding converter and you can see what encoding of current loaded file in the status bar.
 

Аватар
Відмінити
Найкраща відповідь

Imho, changing system encoding could prove to be a better idea than changing OpenERPs'.

Or maybe changing encoding of the editor you use to view exported csv files would be enough?

Аватар
Відмінити
Автор

Thank for antanas's infos, I want to solve this issue once and for all. I want to not convert every time, when i export and import file. I know change system encoding is better, but i don't know how to change it.