Posted by: Joel Larkin
on Mar 12, 2009
Over the last year i've been using an Open Source Church Database called ChurchDB or ChurchInfo. This database allows non-profits(specifically targeted at churches now) to track members, create directories, track donations & pledges, and other perform membership functions. Unfort this application doesn't have some basic functions.
I've released a version (in downloads) of this that allows for table prefix's and the ability to un-publish certain fields from the directory (Phone Numbers & Emails). I'm currently working on an installation front-end that would enable the table prefixes (right now you have to edit the SQL file to put your own prefix in) and the modifications to the front-end to control unpublishing certain fields.
Posted by: Joel Larkin
on Jan 7, 2009
Our Church uses a Church Member database system called ChurchInfo. In our Church we track members and regular attenders separately however we do similar things for each group (like track birthdays). The system out of the box only allows us to report members birthdays. This is kind of annoying and requires running a "free-text" query to get around.
Recently I got a request from the church secretary (my wife) to change this behavior. They wanted to have a drop down box selecting the month and a select box with the Classifications (Member, Regular Attender, etc) on the Query screen so they could easily see what they were doing.
I was able to modify the system pretty easily and wrote up how I did it. Here is what I did. It involved modifying a file (QueryView.php) and a few rows within the sytem.
