Skip to Content
Menu
This question has been flagged
2 Replies
36519 Views

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
Discard
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
Discard
Author

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.

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...

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

Author

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.

Best Answer

I prefer to use Codelobster editor

Avatar
Discard
Related Posts Replies Views Activity
3
Jun 20
2789
1
Nov 18
8248
11
Feb 17
62007
2
Mar 15
9866
4
Nov 24
9761