wiki:ChartReportGeneratorPlugin

Chart Report Generator

Notice: This plugin is deprecated.

Description

Generate reports with chart using Google Chart API. First developed in shell script and now in python. I'm a new python programmer, so, any improvement to my code is welcome. I was discovering the language while coding this report.

It's not a plugin yet, but will be. Any help is welcome. I'll try to improve the code, making the reports more flexible and easy to use. The template is very simple and could be improved a lot. Maybe using another python library.

Bugs/Feature Requests

Existing bugs and feature requests for ChartReportGeneratorPlugin are here.

If you have any issues, create a new ticket.

Download

Download the zipped source from here.

Source

You can check out ChartReportGeneratorPlugin from here using Subversion, or browse the source with Trac.

Example

Copy the files to any directory and configure the script editing config.py. The config.py have some suggestions!

First Mode

Uses independent queries. The query must have only two columns: the first is the labels and the second is the data.

{
  'title': 'section title',
  'description': 'section description (optional)',
  'queries': [
    {
      'title': 'chart title',
      'type': 'chart type', (available types are in Google Chart API)
      'filename': 'chart filename (don't use extension)',
      'sql': 'query to chart'
    },
    {
      'title': 'chart title',
      'type': 'chart type',
      'filename': 'chart filename (don't use extension)',
      'sql': 'query to chart'
    }
  ]
}

Second Mode

Uses dependent queries. The main query must have only one column, and the query to chart must have only two columns: the first is the labels and the second if is the data. The tag ${item} is replaced by current item in the main query.

{
  'title': 'section title',
  'description': 'section description (optional)',
  'sql': 'main query'
  'queries': [
    {
      'title': 'chart title (can use ${item})',
      'type': 'chart type', (available types are in Google Chart API)
      'filename': 'chart filename (don't use extension and ${item})',
      'sql': 'query to chart'
    },
    {
      'title': 'chart title',
      'type': 'chart type',
      'filename': 'chart filename',
      'sql': 'query to chart'
    }
  ]
}

Recent Changes

[3094] by msbrogli on 2008-01-18 13:18:46
[3093] by msbrogli on 2008-01-18 13:03:56
[3076] by msbrogli on 2008-01-17 14:05:23
New hack ChartReportGeneratorPlugin, created by msbrogli

Author/Contributors

Author: msbrogli
Maintainer: msbrogli
Contributors:

Last modified 5 weeks ago Last modified on Aug 17, 2014 7:29:20 PM

Attachments (2)

Download all attachments as: .zip