1

I am using the Django csv import (https://pypi.python.org/pypi/django-csvimport) to populate some models. The problem is the csv files I have are encoded in ANSI (Windows-1252) format and they have words with special characters e.g. JOSÉ, when I import to my models the word become JOSи.

Could you help me with this?

P.S.:

1 - I have fulfilled the encoding field of the csv import with many options (ansi, utf-8...) but it seems to have no effect.

2 - I have tried to convert my csv files to many differents formats (using vb.net) like utf-8, utf-32, unicode... but all of them cause some error in Django csv import.

Improve this question

1 Answer 1

Reset to default
1

After some tries I found the solution: While trying to convert my text file using vb.net I was opening it with OpenText(), which open the file with UTF8 encoding. So I opened it with something like "Using SR As StreamReader = New StreamReader(Fl.FullName, System.Text.Encoding.GetEncoding("Windows-1252"), True)", and wrote it with UTF8. This solved the problem.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

I think I had the same problem with textedit. Thanks!

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.