Three Important Facts about Exporting Data from One Church Database Program to Another

By Mike at July 12, 2010 02:00
Filed Under: Church Management, Church Technology, General

FACT ONE: Most CMS programs will allow you to Export your data which can be imported into another CMS.

It’s now easier than ever to make a switch to a new church data base program. Most Church Membership Programs (CMS’s) now have a data export option which will allow you to save your data to an Excel or Data Base file. While the feature was intended to allow churches the opportunity to export data for mail merges or custom reports by using their Word or Excel processing programs, the opportunity also exist to export their data for import into a new CMS program.
As a partner in a CMS online service we knew that offering the export in our own program could make it easy for clients to switch but we were willing to forgo the negative due to the greater benefit that this feature provides for our clients.

FACT TWO: A Data Import Can Save You Valuable Time and Records

First let me explain what you need to understand about exporting data from one CMS and then importing it into another CMS.
Data Base programs in general use fields or cells to store data. Data is placed in a field or a cell in a column that has a name at the top of the column defining the type of data listed in the column. See below:

First Name Last Name
Mike Smith
Don Lewis
Stan Jones
Sue David

 

When a Data Export is performed the information you entered into your CMS is exported into a viewable document (most likely Excel). This document is also known as a spreadsheet. The information can be used in a number of ways: like mail merge letters or reports.
As mentioned before, you can use this exported data to switch over to another program if that program has a Data Import service or feature.
Your exported data is then matched up with like fields in your new CMS and then uploaded. This transfer or data import allows you to get up and running much faster than re-entering the data again for each person. Thus, saving you time in re entering the data.

FACT THREE: A Service Import Provides Better Data Import Results

We at Church Office Online use a “Service Import ” as opposed to a “Program Feature Import”. Simply defined: A Service Import is “we do it”, as opposed to a Program Feature Import where “you do it”.

The reason we chose providing it as a “Service Import” is twofold;

  1. We are experienced in Data Export and Import and can accomplish the service with ease and accuracy.

    A program feature places the task on the client who is not as informed about data export and import.
  2. As a service, we make sure the exported data in NOT corrupted and will cause no conflicts or errors when it is imported into your CMS and stored on our secure servers.

    A program feature export/import can and does corrupt CMS fields. It also puts at risk not only your data stored on the servers but the data of other clients as well.

Finally I would encourage you to consider the cost of the Import Service. The service can range from the low $40’s and on into the hundreds. However, because it is a one-time-fee you won’t be seeing it each month.

Mike Smith, CMO Ministry Support
Church Office Online

Free Microsoft Office For Churches

By Aaron at July 04, 2010 07:58
Filed Under: Church Management, Church Technology, General

We have some exciting news for churches, Microsoft now has a free Office Suite available online!

Microsoft has created online versions of its most popular Office applications, including Microsoft Word online, Microsoft Excel online, Microsoft Powerpoint online and Microsoft OneNote online; all for FREE! Although the licensed versions of the software have a few more features, the basic Microsoft Office functionality is available for free. This also gives you the ability to edit existing Word, Excel and Powerpoint documents for free!

Free Microsoft Office Can Save Your Church Big Money

Microsoft Office is an essential application for getting work done. However, up until now using Microsoft Office has been a huge expense for churches. Now, with access to Microsoft Office Online for free, churches can save thousands of dollars in licensing!

How To Use Microsoft Office Online

  1. Go to http://office.live.com
  2. Sign in with your Windows Live ID account. (if you don't have one, can sign up for free).

Tell Other Churches

Please send a link to this page to pastors and church volunteers you know to spread the word, this is a huge cost savings for churches!

Thanks!
The Church Office Online Team

Great Ideas On How To Take Church Attendance

By Mike at May 24, 2010 21:01
Filed Under: Church Management, Church Technology, General

Having served as a pastor for 27 years in young and old churches, large and small, I understand the importance of taking attendance and the difficulty that goes with it. I can offer you several suggestions some will be easier to implement based on your attendance others on the age of your church. I have also included attachments of support materials, i.e. cards, list and links which you may use free with our permission.

1. CARD PEW ATTENDANCE

Place cards in the pews that both visitors and attendees are instructed to place in the offering. Visitors fill out their contact information; Members fill out names of those in the household attending only or check a box for household attendance. (See Attachment Card 1)

2. GROUP ATTENDANCE

Divide up your congregation into groups (5-10 families per group). Have individuals or couples designated with the task of seeking out those individuals/families each service and record their attendance on a service attendance sheet. This method works great because it strengthens the church community.

3. DROP CARD TREE

For your members, have cards (heavy card stock) made up for each family that list their names and address. Have them available in three or more areas in the foyer (punch-card holder racks work great). They simply pick up their card and place it in the attendance box in the foyer or place in the offering. This is very green as you are using the cards over and over.

4. NAME BADGE TREE

They simply pick up their name badge and at the end of the service they drop it in the badge return box at the door. They are picked up and marked off in CMO attendance and then placed back on the Badge Tree.

5. PEW LIST ATTENDANCE

Have a clip board in each pew that has a copy of your member’s names which they can check off and pass down their isle. Limit the list to one isle if at all possible as more isles will create a disruption. A designated person/s will collect the clip boards and record them online.
(See Attachment 2)

Hi-Tech Attendance Solutions

6. COMPUTER ENTRY ATTENDANCE

Some churches have placed laptops at various places in the foyer using the check box attendance in our program. This can be done by an attendant or not. Visitor cards would be recommended as it reduces both traffic and confusion. Some systems allow for touch screen entry.
(See Attachment CMO Check List)

7. iPad Attendance

With our program we recommend the Apple iPad as an inexpensive device which has a great touch screen and finger scroll for attendance using our attendance program. See an example picture of using an iPad to take attendance below.

8. BAR CODE ATTENDANCE

Today’s technology also makes available bar code readers. It has been billed as fast and simple. A check-in station, computer connection, scanner, would be required. An attendant is usually required and there are options other than bar-coding: i.e. magnetic strip cards, fingerprint scan, and face recognition : )

NOTE: As in most things that are new for a church there will be a learning curve. Don't expect whatever method you use to instantly work. Churches no matter how old they are can put into practice a good attendance program (I have served in churches that were over 100 years old).

It doesn't take a Rocket Saint to know the advantages. People in general feel followed up, connected, and missed. Leadership will better be able to care for their people and see growth.

I hope this has been helpful. If you have another way to take Individual attendance please let me know. I would love to hear from you.

Mike Smith, CMO Ministry Support
Church Office Online


Keeping Church Records Current Just Got Easier

 Did you know that you have a new program to help keep your church records current?

It’s called Me.Churchmembershiponline.com (or Me.Church…).

In the high tech Internet world it is referred to as “Individual Member Access”.

 

Once logged into Me.Church… individuals can securely view or edit their contact information, i.e. name, address, email, phone, and household contact information. Changes will instantly update their records in Church Membership Online. They can also view their contributions and print a giving report for taxes and personal records.

 

Me.Church… is designed to be a no load to load reducing feature.

Administrators will not have to create the individual login and passwords as the program will do it for you. A tutorial can be viewed on the link below.

 

Visit your new program at: https://me.churchmembershiponline.com

 

*me.churchofficeonline.com is a feature of Church Membership Online, a service program of Church Office Online and provided free to all subscribers.

The Technology Side Of Church Management

By Aaron at May 05, 2008 03:43
Filed Under: Church Management, Church Technology, General

Church Technology Overview


One of the most often overlooked and least understood aspects of Church Management is the technology used in churches. Relatively inexpensive costs have allowed many of today's churches to have broadband internet access, email, a church web site, PDAs to keep track of meetings and church management software to help them keep track of their ever growing and changing flock. Ministry positions are often created to administer the church computers, network, website & email and a good size budget set aside for this effort each year. The problem most church leaders face is what / how to implement technologies that will be effective for building The Kingdom and also good stewardship of the resources they have been provided with.

Matthew 25-21
“His master replied, ‘Well done, good and faithful servant! You have been faithful with a few things; I will put you in charge of many things. Come and share your master’s happiness!’ ”

Church technology can become overwhelming & expensive very quickly. The real question is what technologies will make your church management more effective? Without a solid understanding of what you need and what is out there to meet your needs, it is easy to spend an exorbitant amount of your budget on technology and not get what you need.

What Today's Churches Need


If you are here reading this blog, you probably don't need to be convinced that technology can be extremely useful in church management. The following is a list of computer related technologies that will help your church stay relevant and connected in today's technology age.

Workstation PCs
- Windows (XP/Vista) or Mac OSX based computer (purchased within the past 4 years)
- At least 2GB of RAM memory
- Backup drive

 

Internet Access & Network
- Broadband Internet Access
- Router with built in switch

Software
- Anti-Virus (AVG Free Edition)
- Office Application Suite (OpenOffice)
- Church Management Software (Church Membership Online)
- Internet Browser (Internet Explorer 7 or Firefox)

Internet Presence
- Website
- Email

I have provided some quick links for some of the items above. For everything else, check back in the future as I will be posting more about specific inexpensive & easy to implement solutions for each of these technology needs. In the meantime, please check out the collection of free internet resources we have compiled.
http://www.churchofficeonline.com/FreeResources/FreeResources.aspx

- Aaron
Church Office Online
http://www.churchofficeonline.com/


How To Save Your Church BIG $$$ On Software

By Aaron at March 03, 2008 23:42
Filed Under: Church Technology

Software can be really expensive and add up quickly. If you want to be legal and licensed (and you do, you are a church after all :) the different licenses & upgrades can add up quickly and become a multi-thousand dollar per year expenditure for even small churches. There is a lot of free software available that can cut down on your software costs by thousands of dollars per year while at the same time providing the same ease of use as their expensive counterparts.

Average Software & Expenses


Below is a list of software that seems to be standard in most churches today.
  • Microsoft Office Professional (Word, Excel, Powerpoint) ~$300
  • Microsoft Outlook (Email, included in Microsoft Office Pro)
  • Norton Security Suite (Anti-Virus, Firewall, Anti-Spyware) ~$100
  • Bible reference program ~$100 

Total Expenses Per Computer: ~$500

 

Alternative Software & Expenses


How here is a list of alternative software that will do the exact same thing as the above mentioned applications.

Total Expenses Per Computer: $0

List of free software resources for churches: http://www.churchofficeonline.com/FreeResources/FreeResources.aspx

If you use the free alternatives listed above it will save your church hundreds of dollars per computer in your church!

Please post comments of any other free software that your church uses on a regular basis. We would love to share it with other churches.


Aaron
Church Office Online
http://www.churchofficeonline.com