I've been playing around with software for assisting myself and the president,
and perhaps the web master for the ham club I'm in. As is, it allows you to
input the information for all the club members, including when their license
expires. I also have another database setup for the events the club will be
participating in. (later, I plan to also add a seperate table for the upcoming
contest and special events the members might be interested in that the club
itself is not necessarily participating in.) I then setup various reports to
print out, or make a pdf file, or view on screen the information either the
entire table, or only the data for the current month. I can add other features
and reports later on if you have any ideas. I'd like to make a generic
news letter type pdf print out. Just now I was thinking I may make a table for
the meeting notes and information. Grab all the info from the meeting notes,
combine with information on upcoming events and call signs whose licenses are
needing to be renewed soon, make a pdf in a news letter format that can be
e-mailed to all club members. Since I have the e-mail addresses of most of the
club members, I may be able to e-mail the newsletter automatically from inside
the program! It was my goal that other clubs may be able to use this software,
so I planned on contacting various other clubs and asking if they'd be
interested in using it. I honestly feel that the software is getting closer
and closer to what I'd consider a release state for other clubs. If you'd like
to look at what I have so far, check out
http://www.johngsigns.com/w5wq/w5wq7.zip
At this time, the only catch I have to warn you about is for the date fields to
work with everything, you MUST enter the dates as yyyy-mm-dd hh:mm:ss format,
you must use dashes and not slashes, you must put it in that format. (later,
I'l put checking to ensure it's in the right format). Eventually, I'm going to
input all dates in Zulu time, because there's a nice nifty feature that allows
me to convert to local time, and most ham events are in zulu time anyway.
The database routines use Sqlite3, you can edit the databases directly from DOS
with sqlite3.exe. You can also use firefox with SQL Manager plugin.
---
■ Synchronet ■ Roach Guts -- kingcoder.net
|
