How to create a MySQL database and table

Today’s tutorial is not so much about Church Community Builder (CCB) in great detail, but it is about preparing your data for migration to or from CCB.

One of the things I’ve learned from migrating Fellowship One data to CCB is that it pays in spades to have your data in a database.

Unfortunately, I was given our church’s data in multiple excel files from Fellowship One.  Nevertheless, I was happy to have data in its rawest form to massage and manipulate for migration into a MySQL database and table, and then into CCB.

I won’t cover migration of your CCB data in this video tutorial, but will teach you to simply setup a MySQL database and table.  I’ll cover migration and how to use your MySQL database and table as an external backup source in a series of tutorials in the coming weeks. Continue reading

How to insert online gifts

This tutorial is definitely one of my favorites and will save a tremendous amount of time for any church looking to migrate to Church Community Builder.

Most churches have two main concerns about moving from one Church Management Software system to another: How hard is it to migrate personal profiles and giving information?

We’ve covered the first part of the question in our tutorial on How to Create a CCB Profile.  It was a simple tutorial, but with a little elbow grease, you can transform the codebase into automatically creating CCB profiles.

If you’re still in the dark on how to programmatically go about creating or inserting multiple CCB profiles, then no worries, I’ll soon provide a paid written or video tutorial walking you through how to automate the process.  Sit tight for now.

However, today’s tutorial will cover in detail how to go about inserting online gifts into CCB.  Let me be clear that this tutorial IS NOT about processing payments for online giving.  This tutorial is primarily for churches migrating to CCB, and needing a sound method for transferring their online giving history into CCB. So lets’ get started with today’s tutorial. Continue reading

Creating a reusable function for CCB API calls

Okay, so I’ve taken you to grandmas house two different ways in Part I and Part II of how to search for individuals.

Today, we will continue to build upon both tutorials.  You’re going to love today’s assignment because it is going to help you save a lot of time moving forward with your CCB API projects and solutions.

Are you ready to start cutting your CCB API development time in half creating reusable codebase?  Let’s get started. Continue reading

How To Search For Individuals – Part II

Back for another CCB Tutorial.  Today’s tutorial will be a quick follow up to Part I of How To Search For Individuals.

If you recall at the every end of Part I’s Tutorial, I let you in on a secret that we had taken the long way to grandma’s house learning to write a PHP user-defined function.

Simply put, its my goal that you always learn multiple ways to send and receive data as well as just learn to think differently about how you solve technical problems.  Remember, there’s always more than one way to solve a problem, and each way or method will have its pros and cons.

Nevertheless, let’s get down to business with Part II.  Today, I’ll show you how to reduce lines of code, and how to use a new PHP function (shell_exec()).  Ready to get started? Continue reading

How To Search For Individuals

We’ve learned how to create individual profiles and how to parse CCB API XML response in our latest tutorials.

Next, we’ll learn how to search for individuals using the CCB CPI.  Of course, coming from someone who has master this tutorial, searching for individuals via the CCB API is quite simple.

We’ll build upon the lessons and takeaways you’ve learned up until now.  This tutorial will guide and instruct you as I show you how to build a reusable PHP/CURL function for sending (POST) and receiving (GET) data.  We’ll cover the function a bit later.

But if you’re ready to get started, then so am I!  Let’s start… Continue reading