ChurchInfo

  • PHP
  • MySQL
  • MariaDB
  • ChurchInfo
Please feel free to contact us

About

An AWS product ChurchInfo Open source church database powered by Miri Infotech. ChurchInfo is a free church database program to help churches track members, families, groups, pledges and payments. Our feature set is comparable to expensive church management software packages. Our users are supported by an open-source community of people who volunteer their time and energy to make this technology available to all churches.

We are launching a product which will configure and publish ChurchInfo, an open source CRM software solution which is embedded pre-configured tool with LAMP and ready-to-launch AMI on Amazon EC2 that contains ChurchInfo, Apache, MySQL, Linux, PHP (LAMP).
Features:

Naturally Networked:

ChurchInfo runs on any server that supports PHP and mySQL. The server may be in-house or at an ISP anywhere on the Internet. Any number of people may access the database simultaneously.

Family:

A family is a group of people who are treated as a unit. The obvious example would be a married couple and perhaps their children. The family members do not need to have the same last name, but they should live at the same address to receive newsletters and financial statements. Pledges and payments are tracked by family. Some churches call a Family a “Pledging Unit”.

Person:

A person is an individual associated with the church. A Person can be a member of a Family, and a person can also be a member of one or more Groups. A Person has individual contact information, such as a cell phone number and an email address. A Person also has a relationship with the church as “Member”, or “Guest”.

Group:

A group is a collection of people, such as the choir or the stewardship committee. Groups have many uses. Here are a few ideas: committees, church school classes, covenant groups, baby sitters. The possibilities are endless. ChurchInfo makes it easy to contact all the members of a group by letter or email.

Pledges and Payments:

Pledges and Payments are tracked for each fiscal year, with automated support for reminder letters. There is also automated support for generating donation acknowledgement letters for tax purposes based on the calendar year. The entry of payments is highly automated, with support for check and credit card scanners, automated deposit slip printing and electronic submission of credit card and EFT payments.

Volunteer Tracking:

ChurchInfo allows you to create “Volunteer Opportunities” like baking, lawn-mowing, babysitting, letter-stuffing, etc. These opportunities may be assigned to people, making it easy to locate them when the need arises.

Permissions:

Access to financial data may be restricted to one or just a few individual users as appropriate. Most users just need access to the Person, Group and Family information to look up phone numbers, generate address labels and send email.

Mapping:

The latitude/longitude coordinates of each Family may be used to plot the congregation on a map, or to find the nearest neighbors in the congregation for a particular family.

Canvass Automation:

ChurchInfo provides support for conducting an every-member canvass, and capturing the results in the database. The canvassers receive briefing sheets with information about each family to be contacted. During or after the contact the canvasser enters comments in the database.

Sunday School Support:

Classes may be defined as Groups with roles “Teacher”, “Student”, “Liaison”, and then special Sunday School reports may be used to generate class lists and attendance sheets.

Church Info Reports have following Features:
  • Group Membership
  • Contact Lists
  • Reports on Groups and Roles
  • Members Directory: Printable directory of all members, grouped by family where assigned
  • Letters and Mailing Labels
  • Birthdays: Members with birthdays in a particular month
  • Family Member Count: Returns each family and the total number of people assigned to them.
  • Membership anniversaries: Members who joined in a particular month
  • Person by Age: Returns any person records with ages between two given ages.
  • Person by properties: Returns person records which are assigned the given property.
  • Person by Role and Gender: Selects person records with the family role and gender specified.
  • Person Count
  • Recent friends: Friends who signed up in previous months
  • Select all members: People who are members
  • Select database users: People who are registered as database users
  • Total By Gender: Total of records matching a given gender.
  • Volunteers: Find volunteers for a particular opportunity
  • Volunteers: Find volunteers for who match two specific opportunity codes
  • Advanced Search: Search by any part of Name, City, State, Zip, or Home Phone.
  • Families to canvass: People in families that are ok to canvass.
  • Finance Reports
  • Financial Reports: Pledges and Payments
  • Canvass Automation: support for conducting an every-member canvass.
  • Pledge comparison: Compare pledges between two fiscal years

Usage / Deployment Instruction

Open the URL: http://<instance ip address>

Step 1: Login to the system with “admin” username and <instance ip address> as the password

Step 2: Create a new password after login by providing the <instance ip address> in the old password.

IP address of the running EC2 instance.

Now you can use the system.

Database Information

Host Name : localhost

Database Name : mirichurchinfodb

Database User : mirichurchinfo

Database Password : <instanceID>

SSH using root user is disabled. ec2-user is the sudo user with root privileges with access using the key pair created during launching the instance.

MYSQL can be accessed only with SSH

MYSQL User : root

Password : <instanceID>

Note : You are not supposed to change it.

Submit Your Request

First Name:*
Last Name:*
Company/Organisation:*
Email Address:*
Phone Number:*
Message:*

You can subscribe to ChurchInfo, an AWS Marketplace product and launch an instance from the ChurchInfo product's AMI using the Amazon EC2 launch wizard.

To launch an instance from the AWS Marketplace using the launch wizard
  • Open the Amazon EC2 console at https://console.aws.amazon.com/ec2/
  • From the Amazon EC2 dashboard, choose Launch Instance.
    On the Choose an Amazon Machine Image (AMI) page, choose the AWS Marketplace category on the left. Find a suitable AMI by browsing the categories, or using the search functionality. Click Select to choose your product.
  • A dialog displays an overview of the product you've selected. You can view the pricing information, as well as any other information that the vendor has provided. When you're ready, choose Continue.
  • On the Choose an Instance Type page, select the hardware configuration and size of the instance to launch. When you're done, choose Next: Configure Instance Details.
  • On the next pages of the wizard, you can configure your instance, add storage, and add tags. For more information about the different options you can configure, see Launching an Instance. Choose Next until you reach the Configure Security Group page.
  • The wizard creates a new security group according to the vendor's specifications for the product. The security group may include rules that allow all IP addresses (0.0.0.0/0) access on SSH (port 22) on Linux or RDP (port 3389) on Windows. We recommend that you adjust these rules to allow only a specific address or range of addresses to access your instance over those ports.
  • When you are ready, choose Review and Launch.
  • On the Review Instance Launch page, check the details of the AMI from which you're about to launch the instance, as well as the other configuration details you set up in the wizard. When you're ready, choose Launch to select or create a key pair, and launch your instance.
  • Depending on the product you've subscribed to, the instance may take a few minutes or more to launch. You are first subscribed to the product before your instance can launch. If there are any problems with your credit card details, you will be asked to update your account details when the launch confirmation page displays
  • 1What can developers now do that they could not before?

    Until now, small developers did not have the capital to acquire massive compute resources and ensure they had the capacity they needed to handle unexpected spikes in load. Amazon EC2 enables any developer to leverage Amazon’s own benefits of massive scale with no up-front investment or performance compromises. Developers are now free to innovate knowing that no matter how successful their businesses become, it will be inexpensive and simple to ensure they have the compute capacity they need to meet their business requirements.

    The “Elastic” nature of the service allows developers to instantly scale to meet spikes in traffic or demand. When computing requirements unexpectedly change (up or down), Amazon EC2 can instantly respond, meaning that developers have the ability to control how many resources are in use at any given point in time. In contrast, traditional hosting services generally provide a fixed number of resources for a fixed amount of time, meaning that users have a limited ability to easily respond when their usage is rapidly changing, unpredictable, or is known to experience large peaks at various intervals.

     

  • 2Do I need one Elastic IP address for every instance that I have running?

    No. You do not need an Elastic IP address for all your instances. By default, every instance comes with a private IP address and an internet routable public IP address. The private address is associated exclusively with the instance and is only returned to Amazon EC2 when the instance is stopped or terminated. The public address is associated exclusively with the instance until it is stopped, terminated or replaced with an Elastic IP address. These IP addresses should be adequate for many applications where you do not need a long lived internet routable end point. Compute clusters, web crawling, and backend services are all examples of applications that typically do not require Elastic IP addresses.

     

  • 3How do I prevent other people from viewing my systems?

    You have complete control over the visibility of your systems. The Amazon EC2 security systems allow you to place your running instances into arbitrary groups of your choice. Using the web services interface, you can then specify which groups may communicate with which other groups, and also which IP subnets on the Internet may talk to which groups. This allows you to control access to your instances in our highly dynamic environment. Of course, you should also secure your instance as you would any other server.

     

  • 4Does Amazon S3 support data access auditing?

    Yes, customers can optionally configure an Amazon S3 bucket to create access log records for all requests made against it. Alternatively, customers who need to capture IAM/user identity information in their logs can configure AWS CloudTrail Data Events.

    These access log records can be used for audit purposes and contain details about the request, such as the request type, the resources specified in the request, and the time and date the request was processed.

     

  • 5How secure is my data in Amazon S3?

    Amazon S3 is secure by default. Upon creation, only the resource owners have access to Amazon S3 resources they create. Amazon S3 supports user authentication to control access to data. You can use access control mechanisms such as bucket policies and Access Control Lists (ACLs) to selectively grant permissions to users and groups of users. The Amazon S3 console highlights your publicly accessible buckets, indicates the source of public accessibility, and also warns you if changes to your bucket policies or bucket ACLs would make your bucket publicly accessible.

    You can securely upload/download your data to Amazon S3 via SSL endpoints using the HTTPS protocol. If you need extra security you can use the Server-Side Encryption (SSE) option to encrypt data stored at rest. You can configure your Amazon S3 buckets to automatically encrypt objects before storing them if the incoming storage requests do not have any encryption information. Alternatively, you can use your own encryption libraries to encrypt data before storing it in Amazon S3.

  • 6Benefits of using a CMS?

    Taking control of your site with a content management system also has great advantages as far as your search engine rankings are concerned. All search engines like to see that websites are updated regularly and favor sites that alter their content on a regular basis. Our CMS platform provides search engine friendly web pages and also allows you to create your own page titles and meta tags used by the Search Engines for page rankings.

     

  • 7May I use either a PC or Mac?

    The CMS is browser-based and will work on both PC and Mac platforms using either Internet Explorer and Firefox. Keyboard shortcuts may vary between the two systems.

  • 8I linked to an existing CMS page, but the link appears to be broken. Help?

    1) Reattach the link. If the page was renamed, the link might have been affected.

    2) Confirm that the folder and content block do not contain special characters (such as ‘ “ # % & + / : ; < > ) in the title.

    When in doubt, avoid using non-numerical or -alphabetical characters.

     

  • 9How to decide which CMS?

    Requirements gathering is crucial, to make sure you buy on what you need, not on the shiny features that look good in the demonstration.

     

  • 10Once I have settled on a CMS, that’s all my content problems solved then?

    Another important factor is how easy the system is to use – most likely, the people you’d like to update the site won’t be that technically comfortable, so the best solution is one that has solid usability.

    no. That is the biggest myth of CMSs. Most of the time, the real issues in content creation are around people and processes, not the technology. You need to manage your content creation like any other project – with a clear workflow and timetable, and enough people—with the right skills—to handle what you need to create. The CMS will help you get the content on to the site, but the much more difficult challenge is creating it. And computers don’t write very well.

     

  • 11How does a CMS work?

    The Web CMS does not require any special software or any technical knowledge to use. It is a web-based platform and can be accessed wherever you have an Internet connection and a web browser. The interface is very similar to Microsoft Word and does all of the HTML coding for you. You can concentrate on the content and not worry about how it will affect the page layout. It also automatically optimizes your site’s content for search, so that when someone searches for information on your site it is more likely to be found.

  • 12How does a CMS work?

    The Web CMS does not require any special software or any technical knowledge to use. It is a web-based platform and can be accessed wherever you have an Internet connection and a web browser. The interface is very similar to Microsoft Word and does all of the HTML coding for you. You can concentrate on the content and not worry about how it will affect the page layout. It also automatically optimizes your site’s content for search, so that when someone searches for information on your site it is more likely to be found.

Highlights

  • It is Naturally Networked, and tracks Family, Person, Group, Pledges and Payments
  • It provides Volunteer Tracking, Permissions, Mapping, Canvass Automation and Sunday School
  • Helps you maintain group membership, contact lists, Members Directory, Birthdays, Family Member Count, Membership anniversaries

Application Installed