Adds a CSV export action to any Django model admin that inherits it.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 | from django.contrib import admin
class CSVAdmin(admin.ModelAdmin):
"""
Adds a CSV export action to an admin view.
"""
# This is the maximum number of records that will be written.
# Exporting massive numbers of records should be done asynchronously.
csv_record_limit = 1000
extra_csv_fields = ()
def get_actions(self, request):
actions = self.actions if hasattr(self, 'actions') else []
actions.append('csv_export')
actions = super(CSVAdmin, self).get_actions(request)
return actions
def get_extra_csv_fields(self, request):
return self.extra_csv_fields
def csv_export(self, request, qs=None, *args, **kwargs):
import csv
from django.http import HttpResponse
from django.template.defaultfilters import slugify
response = HttpResponse(mimetype='text/csv')
response['Content-Disposition'] = 'attachment; filename=%s.csv' \
% slugify(self.model.__name__)
headers = list(self.list_display) + list(self.get_extra_csv_fields(request))
writer = csv.DictWriter(response, headers)
# Write header.
header_data = {}
for name in headers:
if hasattr(self, name) \
and hasattr(getattr(self, name), 'short_description'):
header_data[name] = getattr(
getattr(self, name), 'short_description')
else:
field = self.model._meta.get_field_by_name(name)
if field and field[0].verbose_name:
header_data[name] = field[0].verbose_name
else:
header_data[name] = name
header_data[name] = header_data[name].title()
writer.writerow(header_data)
# Write records.
for r in qs[:self.csv_record_limit]:
data = {}
for name in headers:
if hasattr(r, name):
data[name] = getattr(r, name)
elif hasattr(self, name):
data[name] = getattr(self, name)(r)
else:
raise Exception, 'Unknown field: %s' % (name,)
if callable(data[name]):
data[name] = data[name]()
writer.writerow(data)
return response
csv_export.short_description = \
'Exported selected %(verbose_name_plural)s as CSV'
|
More like this
- Template tag - list punctuation for a list of items by shapiromatron 11 months, 2 weeks ago
- JSONRequestMiddleware adds a .json() method to your HttpRequests by cdcarter 11 months, 3 weeks ago
- Serializer factory with Django Rest Framework by julio 1 year, 6 months ago
- Image compression before saving the new model / work with JPG, PNG by Schleidens 1 year, 7 months ago
- Help text hyperlinks by sa2812 1 year, 8 months ago
Comments
Please login first before commenting.