Skip to main content
This is a pre-production deployment of Warehouse. Changes made here affect the production instance of PyPI (pypi.python.org).
Help us improve Python packaging - Donate today!

Module to export django querysets as csv files

Project Description

Queryset CSV is a simple module to allow Django Querysets to be exported as CSV files.

Installation

pip install intouch-queryset-csv

Then add the app to your installed apps

intouch.queryset_csv

Usage

There are several ways to use the Queryset csv exporter.

Render to response

The most basic usage is to call the function

queryset_as_csv_response

This function accepts a queryset as a parameter, along with a filename and whether the file is to be streamed. It returns an HTTPResponse object, so should be called at the end of a view function to offer the download to the client.

Admin Action

An action is provided for the Django admin site. There are 3 ways of including it:

  1. The function export_model_as_csv can be added to your custom admin class’s actions
  2. The CsvExporterAdmin class can be inherited to provide the action
  3. Setting CSV_EXPORT_ADMIN_ACTION_AVAILABLE=True in your django settings module will make the action available to all registered admin classes.

The action will simply export all objects of the selected model to csv (as a stream)

Why create this code rather than use an existing CSV export project?

  1. Licensing - Other CSV export packages encountered are Licensed under the GNU GPL. The GPL is incompatible with the desired usage, so a this was written from scratch.
  2. Functionality - Existing CSV packages are not designed to handle very large querysets, the option to steam querysets is essential for models with thousands of entries.
  3. Simplicity - This package has no dependencies other than django itself, and the requirements are to be kept to a minimum in future versions (preferably solely django). It is also designed to require as little effort as possible to use.
  4. Currency - The package is written and tested using the latest versions of Python and Django. While it may work with older versions, no special effort will be expended to force compatibility with old versions.

Settings

  1. CSV_EXPORT_ADMIN_ACTION_AVAILABLE - If True, adds the CSV Export action to all admin pages by default
  2. QUERYSET_CSV_DATE_FORMAT - Set the format to use when outputting datetime.datetime objects, defaults to "%d-%m-%Y %H:%M:%S"

Tested Versions

Django versions 1.7-1.10 should be supported, Python 3 versions supported as per the Django releases.

Release History

Release History

This version
History Node

0.2.1

History Node

0.2.0

History Node

0.1.3

History Node

0.1.2

History Node

0.1.1

History Node

0.1.0

Download Files

Download Files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

File Name & Checksum SHA256 Checksum Help Version File Type Upload Date
intouch_queryset_csv-0.2.1-py3-none-any.whl (7.1 kB) Copy SHA256 Checksum SHA256 3.4 Wheel Jan 17, 2017
intouch_queryset_csv-0.2.1.win-amd64.zip (16.1 kB) Copy SHA256 Checksum SHA256 any Dumb Binary Jan 17, 2017
intouch_queryset_csv-0.2.1.zip (10.9 kB) Copy SHA256 Checksum SHA256 Source Jan 17, 2017

Supported By

WebFaction WebFaction Technical Writing Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Heroku Heroku PaaS Kabu Creative Kabu Creative UX & Design Fastly Fastly CDN DigiCert DigiCert EV Certificate Rackspace Rackspace Cloud Servers DreamHost DreamHost Log Hosting