plainblack.com
Username Password
search
Bookmark and Share

GDWGraph: Create graphs in WebGUI

Current version: 0.00.05/2005-01-17
NOTE FOR USERS

THIS MODULE IS STILL IN VERSION ALPHA. UNTIL THE RELEASE OF FIRST DEFINITIVE VERSION (01.00.00) THIS COMPONENT MAY SUFFER OF HEAVY MODIFICATIONS. NO SCRIPT WILL BE RELEASED  FOR UPGRADING FROM ONE VERSION ALPHA TO ANOTHER. OBVIOUSLY THIS COMPONENT  MUST NOT BE USED IN PRODUCTION ENVIRONMENT.

YOU ARE INVITES TO INSTALL IT AND TO ASK FOR ADDITIONAL FUNCTIONALITIES THROUGH THE RELATIVE FORUM.

Introduction

This module was born when a my colleague let me see the ZGDChart module, a module for Zope, to interface to GD library for the creation of varied type of charts.

When I saw it, I have thought: "WebGUI must have an analogous module too!"

What GDWGraph is?

GDWGraph is a W(eb)object for WebGUI (http://www.plainblack.com/webgui) one of the most popular open source content management systems (CMS). Currently supports WebGUI release 5.5, 6.0, 6.1 and 6.2 under Linux with Apache and under Windows with IIS.

With this component, you can build graphs with data available from external sources like:

  • SQL query
  • external script (perl, shell, python,...)

Here are some samples generated by this component.

Requirements

To use this module you must have already installed:

How to install it.

Take reference to docs/GDWGraph/install.txt file for relative details to the installation.

How to use GDWGraph.

The data for the graphs generation can come from various sources.

SQL Query.

You can directly insert the SQL statements , in the relative field that will explode the possible macros inserted. The first returned field will be used for the X axis, the other fields will be used for the several series of values for the Y axis.

External script

A whichever script written in a whichever supported language can be used. The script will have to be executable on the server by the process under which the web server runs. The script will have to print on standard output (STDOUT) the plotting data, one line for every data. These data on every line will have to be separate by a tabulation character. The first element of every line will be used for the X axis, the other elements will be used for the several series of values for the Y axis.

Layout configuration of the graph

It's possible to configure various layout elements of the graph. To have an idea, these are the screenshots of the WebGUI configuration for this object

Changelog

Version 00.00.05 (2005-01-17)
=============================
- In order to follow changes in WebGUI 6.2.x related to wobject ids, now all ids in GDWGraph are stored in a varchar(22) fields. Use upgrades/upgrade_00.00.04_00.00.05.sql to upgrade from previous version.
- Implemented duplicate and purge code so you can now copy/cut and paste GDWGraph wobjects.
- Tested under Windows 2000 and add installation notes for this operating system to install GD library with ActiveState ActivePerl.
- Add notes for upgrading and uninstalling module.

Version 00.00.04 (2004-07-31)
=============================
- To support large SQL statements, sqlQuery field has been modified to be MEDIUMTEXT.
- Add i18n directory with internalizations for WebGUI 6.1.x
- Add code to maintain compatibility between old and new API for function isInGroup
- Modify mimetype setting to follow WebGUI 6.1 API changes.
- Split create.sql in two script, the first to run always, the second only in WebGUI < 6.1.x

Version 00.00.03 (2004-07-07)
=============================
- Correct a bug that cause incorrect height and width attribute in IMG tag that it prints graph.

Version 00.00.02 (2004-06-05)
=============================
- Add some properties to scale the graph. If you need to print little graphs, this can be a better solution. (it doesn't works well with transpanparent graphs).
- Add the possibility to change graph colors (labels, axes, dataset,...).
- Add some other graph properties to configure axes and ticks.

Version 00.00.01 (2004-06-02)
=============================
- First public release.

To do.

  • Complete the interface between GD::Graph and component
  • Documentation

Make a donation

This free software has been developed during my spare time, and therefore, during some nights lost to develop this for you instead sleeping. If you found this product useful, feel free to send me a donation. You will be remember in my prayers and you will help my soul to feel less alone during long the long nights of coding. Of course, if you make a donation and have a feature request, I'll try to place your feature with a high priority.

You can fast and free donate using a credit card, bank account, or existing Paypal balance.  After you push the button, you'll be taken to Paypal's secure website, where you'll supply a username and password (if you already have a Paypal account) or you'll sign up for an account (it's easy). You get to choose the amount you'd like to donate.  Once you've authorized the transaction, you're done. Paypal does take a cut of what you send (so if you send me $20, I get $19.12; if you send $5, I actually get $4.55; if you send me $3, I get $2.61).

System RequirementsPlease be advised: this contribution was tested with something older than WebGUI 7.5. When this contribution was uploaded there was no field for the author to fill out regarding it's requirements.
Comments
3Ehab: "
WOw

Excellent

Words can not tell you how nice this is really.

 

Keep up the good work.
"
4andreasG: "
Emiliano is the man!!

thanx for your great job!! (and your sqledit too!)

WebGUI worldwide Germany
http://www.webgui-cms.de

"
4rxm8028: "This has got to be the most useful third-party wobject I have seen! Thanks for creating it. I really hope that JT will consider incorporating its functionality into future standard releases of WebGUI.

By the way - This is also one of the most functional 'Alpha' releases of any software I have ever"
4rxm8028: "One little thing I had to change: the field in you table to hold the SQL query just wasn't large enough...I modified mine to be a 'mediumtext' data type, in order to get in the queries I"
DownloadGDWGraph-00.00.05.tar.gz GDWGraph-00.00.05.tar.gz
LinksNo Support Offered
Statistics Downloads: 378
Views: 10984
Rating: 4
Updated: 8/12/2005
Keywords Assets
NavigationBack to the Bazaar
© 2018 Plain Black Corporation | All Rights Reserved