Skip to main content
Donate to the Python Software Foundation or Purchase a PyCharm License to Benefit the PSF! Donate Now

Dump the entire database to xlsx workbook with a sheet per model

Project description

Export the entire database to an Excel workbook with a sheet per model.

https://travis-ci.org/maykinmedia/django-exportdb.svg?branch=master https://codecov.io/github/maykinmedia/django-exportdb/coverage.svg?branch=master https://coveralls.io/repos/maykinmedia/django-exportdb/badge.svg https://img.shields.io/pypi/v/django-exportdb.svg

Installation

$ pip install django-exportdb

Add exportdb to INSTALLED_APPS, and make sure that django.contrib.admin is in there as well.

Add

url(r’^admin/exportdb/’, include(‘exportdb.urls’))

to your urls.py, make sure that it comes before url(r’^admin/’, …) if you hook it into the admin.

Configuration

EXPORTDB_EXPORT_CONF

Configures what models and fields are exported. Example:

 EXPORT_CONF = {
    'models': {
        'auth.User': {
            'fields': ('username',),
            'resource_class': 'app.tests.utils.UserResource'
        },
        'auth.Group': {
            'resource_class': 'app.tests.utils.GroupResource'
        },
        'auth.Permission': {
            'fields': ('name',)
        }
    }
}
EXPORTDB_CONFIRM_FORM
Form shown to confirm the export
EXPORTDB_EXPORT_ROOT
The filesystem path where the exports are stored
EXPORTDB_PERMISSION

Who can access the export. By default only superusers have access.

To allow all staff users to use the export add the following to your settings:

EXPORTDB_PERMISSION = rules.is_staff

Project details


Download files

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

Filename, size & hash SHA256 hash help File type Python version Upload date
django-exportdb-0.4.7.tar.gz (8.6 kB) Copy SHA256 hash SHA256 Source None

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page