Creating a custom spiritual gifts assessment questionnaire – PART III

Welcome back to this week’s tutorial. We’re picking back up from where we left off last week.

As a quick recap, Part I and Part II covered the following aspects:

  • Creating a php form
  • Creating an excel/csv spreadsheet of spiritual gift questions and a CCB spiritual gifts key
  • Parsing excel/csv spreadsheet of display questions for form viewing via a web browser
  • Submitting and validating form data
  • Excluding certain question categories based on category key
  • Summing, grouping, sorting and storing results via an excel/csv spreadsheet

Today’s tutorial focuses on completing the following items:

  • Creating a page to view a list of completed spiritual gifts assessments
  • Emailing a summary to download spiritual gifts excel/csv file

Ready to get started? Let’s do this then!Read This Tutorial

Integrate CCB using PHP and Mailchimp API 3.0

As I begin this tutorial, it’s an early Saturday morning, and I mean early… like 4:12 A.M!

For whatever the reason, the good Lord saw to it that I should arise this day, and I’m grateful for that.

It’s not often that I’m up this early on a Saturday morning.

But hey, since I’m up, bright eyed and bushy tailed, I might as well crank out a tutorial, right?

Today’s tutorial is likely to make many of you quite happy. Read This Tutorial

Email a Queue overdue persons report via Excel/CSV file

The weeks fly by so fast. It seems like we just completed last week’s tutorial about emailing a queue overdue persons report.

This week’s tutorial will build and extend upon last week’s tutorial. We focus on saving the data to a Excel/CSV file, and emailing the file as an email attachment.

It goes without saying, but I won’t cover the detailed nuts and bolts of the previous tutorial.

You have to read the previous tutorials for logical explanation of the code in its entirety.

Without further ado, let’s start coding today’s tutorial.Read This Tutorial

Emailing a Queue overdue persons report

Last week, I showed you how to create a Queue overdue list of persons report.

This week, we’re going to work with the same tutorial, yet extend upon the base functionality you developed thus far.

As with any tutorial we extend upon, I’m not going to cover the nitty-gritty details of the previous tutorial. You’ll have a bit of reading and review for areas you find to be challenging.

That said, today’s tutorial focuses on having a Queue overdue persons report emailed to you using Church Community Builder’s API service.

You would right to think that you can already do such reporting by using the existing web front-end interface as provided by CCB.

But what if you wanted to access the data programmatically using a 3rd-party system?

Well, this is where last week’s and today’s tutorials come quite in handy. Let’s get started.Read This Tutorial

Custom Report: Duplicate profiles in Process and Queues

Welcome back.  Today’s tutorial picks up from where we last left off.  By now, you should be able to retrieve a list of individuals in a queue.

That’s all good, but our original request was how do we find duplicate individuals in a given process as covered in the Retrieving list of Queues for a given Process.

Today’s tutorial is not how to use the API to find duplicate individuals, but how to use CCB’s front-end interface to accomplish the same feat.  We’ll get back to API coding next week.

For now, you’ll want, rather desperately need, to understand and know how to create reports using the CCB front-end interface.  Why?  I’m glad you asked.

There is certain information available via the CCB front-end interface that cannot be accessed via the CCB API.

Today, I’ll show you how to create a custom report and have it email to yourself.

Then next week, I’ll show you how to access the same custom report using the API.  Let’s get started.Read This Tutorial