Django Shell to CSV Dump

django_shell_to_csv.py

import csv

def get_field(instance, field):
    field_path = field.split('.')
    attr = instance
    for elem in field_path:
        try:
            attr = getattr(attr, elem)
        except AttributeError:
            return None
    return attr

# Object to dump to csv
usrs = User.objects.all()

# List of fields to export to csv.
field_list = ['first_name', 'last_name', 'email', 'depatement.name']
headers = ['First Name', 'Last Name', 'Email', 'Department']

writer = csv.writer(open('new_data.csv', 'w'))

# Add CSV header if required
writer.writerow(headers)

# Write data content
for user in usrs:
    row = []
    for field in field_list:
        val = get_field(user, field)
        row.append(val)
    writer.writerow(row)