PYTHON / DJANGO - CSV Export view

gistfile1.py

def export_profile(request):
    import csv, StringIO, datetime
    
    date = datetime.datetime.now()
    # Create the HttpResponse object with the appropriate CSV header.
    response = HttpResponse(content_type='text/csv')
    response['Content-Disposition'] = 'attachment; filename="profiles-%s.csv"' % (date.strftime('%d-%m-%Y'))

    writer = csv.writer(response)

    headers = (
        ('id', 'ID'),
        ('first_name', 'First Name'),
        ('last_name', 'Last Name'),
    )

    # Write headers line
    row = []
    for field in headers:
            row.append(field[1])
    writer.writerow(row)
    
    profiles = Profile.objects.all()
    
    for p in profiles:
        row = []
        
        # Add the profile field as new CSV column
        for field in headers:
            row.append(unicode(p.__dict__[field[0]]).encode('utf-8'))
        writer.writerow(row)

    return response