Skip to Content
This question has been flagged
importcsvencoding
2 Respostes
39018 Vistes
Avatar
Tomas Parnarauskas

is it possible to somehow convert csv data that has iso-8859-13 encoding to utf-8?

Old system, does not have utf-8 encoding, it uses only iso-8859-13. And OpenERP, does not have iso-8859-13, but have both utf8 and utf-16. If i try to open csv file with other encoding than iso-8859-13, then some symbols are not recognized. And if I try to import such file into OpenERP it gives error that I have wrong encoding. I can only import it using windows-1252, but then it will import with unrecognized symbols. What can I do to convert it to normal encoding such as utf-8?

Avatar
Descartar
Avatar
Stefan Reisich
Best Answer

Hello,

with a simple text editor you can convert your file to utf:

http://notepad-plus-plus.org/

image description

OR for Linux look here:

http://superuser.com/questions/16672/how-can-i-convert-multiple-files-to-utf-8-encoding-using-nix-command-line-tools

Avatar
Descartar
Tomas Parnarauskas
Autor

Do you mean set encoding or convert? because where is an option to convert encoding? Also I use Linux, so what equivalent could do in linux as in gedit I don't see a way to convert encoding from one to another.

Stefan Reisich

With notepad++ you can encode and convert. see updated image. But it is Windows application. I'm sorry... There must be something equivalent for linux too...

Stefan Reisich

I found a Linux way. See my updated answer. I hope it works, I cannot try it...

Tomas Parnarauskas
Autor

I was able to convert encoding simply creating new csv file with utf-8 encoding, then copying everything there. I previously tried something similar with libreoffice, but that didn't work.

Avatar
Clod
Best Answer

I prefer to use Codelobster editor

Avatar
Descartar
Related Posts Respostes Vistes Activitat
Disable automatic follow when importing res.partner csv
import csv
Avatar
Avatar
Avatar
3
de juny 20
5046
Enable/disable import rights?
import csv
Avatar
Avatar
1
de nov. 18
10514
'utf8' codec can't decode byte error when importing a list of products as a CSV file Solved
import csv
Avatar
Avatar
Avatar
Avatar
Avatar
11
de febr. 17
65164
Import contacts through CSV Solved
import csv
Avatar
Avatar
2
de març 15
12284
Import csv file with related field other than id, external id, name
import csv importing data from excel file
Avatar
Avatar
Avatar
Avatar
4
de nov. 24
13052