Tip

How to use CHADDB, a free database for non-profits and churches

When a new product is announced, the word goes out about its features. If the product sounds like a good thing, then you wonder, "What would it be like to use it?" Our new product how-to series answers that question. Each how-to starts out with the basics -- product and vendor name, price, etc. -- and then gets down to business with a short how-to. This how-to was written by Don Parris, CHADDB developer and minister at Oakdale Christian Fellowship. - Jan Stafford, editor

Product: CHADDB -- The Church Administration Database

Category: Church management database

Developer/vendor: Oakdale Christian Fellowship, Charlotte, N.C.

Availability: Java front-end was released in March, 2005. The back-end for use with OpenOffice.org has been available for months.

Purpose: Designed for churches of all sizes, this database could be used by some non-profits as well. Its focus is on managing relationships among members and auxiliaries.

Price: Free

Resources:

    Requires Free Membership to View

Screenshots of the test data on OpenOffice.org's Website

How-to:

Assuming you have OpenOffice.org, MySQL, and JDBC already set up correctly, you can use the menu Tools --> Data Sources to open the data sources dialogue box to configure the MySQL connection.

  1. Run SQL scripts to create an setup CHADDB in MySQL. We recommend creating a database called chaddb_test for testing purposes, and use the test data included with the download. (All test data offered in this example is fictional.)
  2. Complete the General Tab by entering a name for the connection in the Name box; selecting JDBC as the database type; and entering the following:

    mysql://127.0.0.1:3306/chaddb_test?useHostsInPrivileges=false

  3. Complete JDBC tab, making sure that the driver class is com.mysql.jdbc.Driver. The URL should be set to:

    mysql://127.0.0.1:3306/chaddb_test?useHostsInPrivileges=false

    Then, set your MySQL user name, and check the Password required box. You should use "auto_increment" in the Auto-Increment box.

  4. Check the Tables tab. You just need to make sure all tables have a check mark next to them.
  5. Use the Queries tab to create any queries you want. You can create a simple address book query using the "person" and "address" tables, joining them on the "psn_id" field.
  6. Open a document in OpenOffice.org, and use F4 to view the data sources.

    Select the tables or queries you want. To do this, just drag a column header into your Writer document at the insertion point to create a form letter using an address book query.


Don Parris is an ordained minister and an advanced, mostly self-taught user of Windows and Linux. He is the author of "Penguin in the pew" and this tip on migrating a non-profit organization to Linux.

This was first published in March 2005

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.