django read dynamic csv file error

Question

I wrote Django python csv reader but it's not working properly. I can see the file is uploaded to the system, but I can't read it and I'm getting the error below:

Exception Type: AttributeError 
Exception Value:     'str' object has no attribute 'read'
data = csv.reader(open('tmp/tmp.csv'), delimiter=";")

When I am using as per above statically ,it's working but I need the dynamic one that I am receiving via file upload. I need your help because I am out of options to solve this. I know that decoded_file, io_string and data variables are not working correctly but can't fix them.

def upload_csv(request):
    if request.method == 'POST' and request.FILES['csv_file']:
        myfile = request.FILES['csv_file']
        fs = FileSystemStorage()
        filename = fs.save(myfile.name, myfile)

        decoded_file = filename.read().decode('utf-8')
        io_string = io.StringIO(decoded_file)
        data = csv.reader(io_string, delimiter=';', quotechar='|')
        for row in data:
            if row[0] != 'FP_Item':
               post = FP()
               post.FP_Item = row[0]
               post.save()

CSV File: Not much because still import trials, only 2 lines.There was ; at the end but I deleted and retried still the same

5.Item try
Try

blacker · Accepted Answer · 2018-04-03 21:25:45Z

2

You try to read a string in csv.reader. you change your code in upload_csv:

def upload_csv(request):
    if request.method == 'POST' and request.FILES['csv_file']:
        myfile = request.FILES['csv_file']
        fs = FileSystemStorage()
        filename = fs.save(myfile.name, myfile)
        print "filename",filename
        data = csv.reader(fs.open(filename, mode='r'), delimiter=str(u';').encode('utf-8'), quotechar=str(u'"').encode('utf-8'))
        for row in data:
            print "row: ",row

edited Apr 3, 2018 at 21:25

answered Apr 3, 2018 at 18:53

blacker

7981 gold badge10 silver badges13 bronze badges

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

11 Comments

İlkem Çetinkaya Over a year ago

I am still getting the same error Exception Type: AttributeError Exception Value: 'str' object has no attribute 'read'

İlkem Çetinkaya Over a year ago

I am getting this error at this line: decoded_file = filename.read() It's not accepting to read filename variable.What can cause this ?

blacker Over a year ago

i edit this line: decoded_file = fs.open(filename) . try and tell me if works

blacker Over a year ago

filename is the name of the file that it is save. And you need open the file with the name of filename in fs. You change this line in your code: decoded_file = filename.read().decode('utf-8') with this line decoded_file = fs.open(filename).read().decode('utf-8')

İlkem Çetinkaya Over a year ago

Yes now it works.:) Thank you very much for your interest.

|

Collectives™ on Stack Overflow

django read dynamic csv file error

1 Answer 1

11 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

11 Comments

Your Answer

Sign up or log in

Post as a guest

Related