[wellylug] Membership database

[Jethro Carr]

On Thu, 2009-04-02 at 15:04 +1300, Xav Paice wrote:
> Hi all,
> 
> Just wondering if anyone has used or knows of a browser based
> membership database I might be able to adapt to use to control
> membership of a non-profit music organisation I'm involved with - it's
> a paid annual subscription, and involves students and teachers so the
> needs are reasonably simple - I need to track the usual personal
> details like name and address, plus branch, teacher(s), instrument(s),
> registration status and probably things like teacher registration
> status for the teachers.  As such, the ability to customise is king,
> but simplicity for a non developer like myself is very important as
> well.
> 
> I've suggested that we link that to an online sign up form and
> potentially Paypal payments - but the most important thing is that
> it's able to be shared and we can use a query to pull out things like
> "give me all the members in Wellington".
> 
> Suggestions very gratefully received!

Naturally I'll plug my own program. ;-)


For your accounting requirements, the Amberdms Billing System would be
ideal.

It has sample code included for creating a Paypal page as well as a SOAP
API to make it easy to link to any kind of website you decide to create.

It's also designed for regular service billing which will make member
subscription invoicing easy.



Unfortunately, the Amberdms Billing System isn't really designed for a
membership system - it can certainly track customers, and basic address
information but it's not flexible enough to allow you add your own
fields.

However, having said that:

1. There is a journal for each customer where you can attach notes and
files with extra information. No limits what you can add in here, but
you can't generate reports or do queries against it.

2. If you can supply me with a lot sugar + caffine to allow me to pull
an all-nighter, I can work on adding in support for custom fields to
meet your requirements. ;-)


regards,
jethro


-- 
Jethro Carr
www.jethrocarr.com/index.php?cms=blog
www.amberdms.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: This is a digitally signed message part
Url : http://lists.wellylug.org.nz/pipermail/wellylug/attachments/20090402/1737ce77/attachment.pgp