Open the file in universal-newline mode using the CSV Django module
I am trying to access a model.filefield
in Django to parse a CSV file in Python using the csv
module. It's working on Windows, but on Mac it gave me this:
Exception Type: Error
Exception Value: new-line character seen in unquoted field - do you need to open the file in universal-newline mode?
This is the code:
myfile = customerbulk.objects.all()[0].fileup
mydata = csv.reader(myfile)
for email,mobile,name,civilid in mydata:
print email,mobile,name,civilid
I finally found the solution:
mypath = customerbulk.objects.get(pk=1).fileup.path
o = open(mypath,'rU')
mydata = csv.reader(o)