django-tables2-reports 0.0.9

With django-tables2-reports you can get a report (CSV, XLS) of any django-tables2 with minimal changes to your project

Contents

• django-tables2-reports

  • Requeriments

  • Installation

  • Changes in your project

  • Usage

  • Test project

  • Releases

    • 0.0.9 (2013-11-30)

    • 0.0.8 (2013-11-14)

    • 0.0.7 (2013-08-29)

    • 0.0.6 (2013-08-22)

    • 0.0.5 (2013-07-03)

    • 0.0.4 (2013-05-17)

    • 0.0.3 (2012-07-19)

    • 0.0.2 (2012-07-18)

    • 0.0.1 (2012-07-17)

django-tables2-reports

With django-tables2-reports you can get a report (CSV, XLS) of any table with minimal changes to your project

Requeriments

• django (>=1.3)

• django-tables2 (>=0.11.0, tested with 0.14.0)

• xlwt (>=0.7.5), openpyxl (>=1.6.2) or pyExcelerator (>=0.6.4.1) (These are optionals, to export to xls. Default to xlwt if available)

If you use python3, and you want export to xls use this version of the xlwt (fork) (0.8.0) if this pull request is not merged still , or use openpyxl

Installation

• In your settings:

INSTALLED_APPS = (

    'django_tables2_reports',
)


TEMPLATE_CONTEXT_PROCESSORS = (

    'django.core.context_processors.static',

)


# This is optional

EXCEL_SUPPORT = 'xlwt' # or 'openpyxl' or 'pyexcelerator'

Changes in your project

1. Now your table should extend of ‘TableReport’

############### Before ###################

import django_tables2 as tables


class MyTable(tables.Table):

    ...

############### Now ######################

from django_tables2_reports.tables import TableReport


class MyTable(TableReport):

    ...

2.a. If you use a traditional views, now you should use other RequestConfig and change a little your view:

############### Before ###################

from django_tables2 import RequestConfig


def my_view(request):
    objs = ....
    table = MyTable(objs)
    RequestConfig(request).configure(table)
    return render_to_response('app1/my_view.html',
                              {'table': table},
                              context_instance=RequestContext(request))

############### Now ######################

from django_tables2_reports.config import RequestConfigReport as RequestConfig
from django_tables2_reports.utils import create_report_http_response

def my_view(request):
    objs = ....
    table = MyTable(objs)
    table_to_report = RequestConfig(request).configure(table)
    if table_to_report:
        return create_report_http_response(table_to_report, request)
    return render_to_response('app1/my_view.html',
                              {'table': table},
                              context_instance=RequestContext(request))

If you have a lot of tables in your project, you can activate the middleware, and you do not have to change your views, only the RequestConfig import

# In your settings

MIDDLEWARE_CLASSES = (

    'django_tables2_reports.middleware.TableReportMiddleware',
)

############### Now (with middleware) ######################

from django_tables2_reports.config import RequestConfigReport as RequestConfig

def my_view(request):
    objs = ....
    table = MyTable(objs)
    RequestConfig(request).configure(table)
    return render_to_response('app1/my_view.html',
                              {'table': table},
                              context_instance=RequestContext(request))

2.b. If you use a Class-based views:

############### Before ###################

from django_tables2.views import SingleTableView


class PhaseChangeView(SingleTableView):
    table_class = MyTable
    model = MyModel


############### Now ######################

from django_tables2_reports.views import ReportTableView


class PhaseChangeView(ReportTableView):
    table_class = MyTable
    model = MyModel

Usage

Under the table appear a CSV icon (and XLS icon if you have xlwt, openpyxl or pyExcelerator in your python path), if you click in this icon, you get a CSV report (or xls report) with every item of the table (without pagination). The ordering works!

Test project

In the source tree, you will find a directory called ‘test_project’. It contains a readily setup project that uses django-tables2-reports. You can run it as usual:

python manage.py runserver

Releases

0.0.9 (2013-11-30)

• Compatible with the future version of Django (>=1.7)

• Update the tests

• Refactor the code

• Fix a bug when the title of the sheet is longer than 31

• Thanks to:

  • Pavel Zaytsev

0.0.8 (2013-11-14)

• Refactor the csv_to_excel module. In the next release this package will be a pypi egg.

• Support for openpyxl

• Integration with travis and coveralls

• Fix an error if you use the theme paleblue

• Fix test with python 3

• Fix some details

• Test project

• Thanks to:

  • Michał Pasternak

  • Mark Jones

0.0.7 (2013-08-29)

• Russian translations

• Thanks to:

  • Armicron

0.0.6 (2013-08-22)

• Python3 support

• Polish translation

• Thanks to:

  • Michał Pasternak

0.0.5 (2013-07-03)

• Improvements in the README

• Exportable to XLS with xlwt

• Thanks to:

  • Crashy23

  • Gamesbook

  • And spatially to Austin Phillips

0.0.4 (2013-05-17)

• Escape csv data correctly during output

• The fields with commas now are not split into multiple columns

• Thanks to:

  • Austin Phillips

0.0.3 (2012-07-19)

• Fix a little error, when a column has line breaks. Now these are changed to espaces

• Details

0.0.2 (2012-07-18)

• Add a default view (https://docs.djangoproject.com/en/dev/topics/class-based-views/)

• Exportable to XLS

• Update the README

0.0.1 (2012-07-17)

• Initial release