Slightly OT: Seeking (python-based) project diary tool, or framework to write one

[jkn]

Hi All
    as in the title, this is a little bit OT - but since ideally I'd like a
tool written in Python, and I know readers here have wide experience of
development/collaborative workflows etc ...

A few jobs ago the company I was with used a 'Project Diary' tool which I found
very useful. It was written in-house (in VB, I believe ;-o). I am looking for a
more widely available tool that gives similar features. 

It created and read a database which contained a series of projects. In this
context, a project was a discrete unit of development effort (eg. for a single
customer, say), and lasting from a couple of weeks to a year or more.

For each project you have a main view window which listed the 'items' in that
project. You could create a new item which was one of a large-ish number of
types. When you created a new item you were given the ability to edit a variety
of parameters, appropriate to the item type:

- info item:	freeform text/HTML
- contact item:	a form with email, telephone number fields
- datasheet item:	maybe a link to a PDF
- diary item	dated freeform
- task item	had title & fields like 'completion date', 'completion
                         percentage, etc.
- query item
- document refrence
- etc. etc.

(items could also be updated once created)

As a project develops, more and more items are added. There were sorting and
searchinf facilities to allow you to quickly find a particular item, and you
could generate custom reports based on seleted items, or date ranges,and so on.

I found this very useful and would like to find something similar, or create
something similar for my own purposes. I currently use an Excel spreadsheet
but this is a bit clunky. I am a moderately experienced Python programmer
(command line, Linux interfacing) but less experienced on the
Gui/framework/database side.

I would be interested in either pointers to something like this which might
already exists, or suggestions as to a framework that I might be able to use to
create something like this.

Other nice-to-haves for a possibly already-existing tool:

-	multiplatform
-	free, open source
-	written in Python
-	web-based probably OK.
-	extendible
-	etc. etc.

Thanks for your thoughts and any suggestions

	Jon N