CiviCRM Cookbook

CiviCRM Cookbook

Overview of this book

CiviCRM is a web-based, open source, Constituent Relationship Management (CRM) software geared toward meeting the needs of non-profit and other civic-sector organizations.Organizations realize their mission via CiviCRM through contact management, fundraising, event management, member management, mass e-mail marketing, peer-to-peer campaigns, case management, and much more.CiviCRM is localized in over 20 languages including: Chinese (Taiwan, China), Dutch, English (Australia, Canada, U.S., UK), French (France, Canada), German, Italian, Japanese, Russian, and Swedish.CiviCRM Cookbook will enhance your CiviCRM skills. It has recipes to help you use CiviCRM more efficiently, integrate it with CMSs, and also develop CiviCRM.This book begins with recipes that help save time and effort with CiviCRM. This is followed by recipes for organizing data more efficiently and managing profiles.Then you will learn authentication and authorization and managing communication with contacts.Then you will be guided on using the searching feature and preparing reports. We will then talk about integrating Drupal and CiviCRM. You will also be taught to manage events effectively. Finally, learn about CiviCampaign, Civimember, and developing CiviCRM.

CiviCRM Cookbook

Credits

Foreword

About the Author

About the Reviewers

www.PacktPub.com

Preface

Free Chapter

Setting Up CiviCRM

Introduction

Setting up a CiviCRM theme in Drupal

Setting up cron using cPanel

Adding items to the CiviCRM navigation menu

Refreshing the dashboard

Changing display preferences

Replacing words

Setting up geocoding

Autofiling e-mails

Creating new activities

Adding custom fields

Using Scheduled Reminders for activities

Using CiviCase to create an HR system

Installing languages and localizing CiviCRM

Organizing Data Efficiently

Introduction

Adding contact types

Adding a time-limited relationship

Using tag sets to quickly organize data

Using tags and groups to segment data

Changing option lists

Creating and updating a smart group

Using Google Refine to prepare data

Importing into CiviCRM using an import script

Using external identifier deduping rules to update contacts

Using Google Refine to create a unique ID

Importing relationship data

Exporting related data

Batch updating using profiles

Using the Power of Profiles

Introduction

Speeding up data entry

Using URLs to change profile displays

Creating a membership directory

Controlling the search result columns using profiles

Using the Profile Pages and Listings setting to improve usability

Setting up reCAPTCHA for user profiles

Controlling Permissions

Introduction

Integrating profiles into Drupal user accounts

Restricting access to custom fields

Using CRM profile permissions correctly

Creating permissions for administrators

Managing event registrations using CiviCRM Access Control Lists

Managing Communications

Introduction

Setting up a bounced e-mail account using Gmail

Creating mail templates for CiviMail

Creating mail templates for CiviMail in Drupal

Using tokens in templates

Creating custom date tokens

Scheduling CiviMail

Throttling mailings to comply with hosting restrictions

Creating newsletter subscription services using profiles

Creating newsletter subscriptions using URLs

Creating a standalone newsletter subscription form

Getting a CiviMail report

Mailing attachments in e-mails and CiviMail

Allowing users to update information without logging in

Searching and Reporting

Introduction

Creating a membership mailing list using Advanced Search

Using Search Builder to create a smart group

Adding the external identifier to full-text searching

Adding custom fields to a report

Adding an extra display field to a report template

Creating a dynamic relationship report using Drupal Views

Integrating CiviCRM with Drupal

Introduction

Enabling Drupal Views

Creating user accounts from contacts in CiviCRM

Mapping contact data

Using Webform CiviCRM to update relationship data

Creating user accounts on the fly with CiviCRM entities

Combining CiviCRM contacts with Drupal content using CiviCRM entities

Managing Events Effectively

Introduction

Using jQuery to control form elements

Using jQuery to show and hide form elements by user choices

Using CiviDiscount with CiviEvents

Collecting data for a paid event registration with Webform CiviCRM

Using a shopping cart and Drupal views for event registration

Using Campaigns, Surveys, and Petitions Effectively

Introduction

Using activities for campaign planning

Designing campaign dashboards in Drupal Views

Using surveys effectively

Recording survey results

Using get out the vote effectively

Using petitions effectively

Working with CiviMember

Introduction

Creating a membership directory using Drupal Views

Updating memberships by bulk data entry

Effective membership communications using reminders

Using price sets for complex memberships

Using CiviCase for membership induction

Developing for CiviCRM

Introduction

Setting up a local development environment

Finding developer resources

Exploring Drupal hooks

Exploring the CiviCRM API

Developing a CiviCRM Drupal module

Exploring CiviCRM extension development using Civix

Index

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Using Google Refine to create a unique ID

Having a unique ID for your data is important. When you first import your data into CiviCRM you can store this unique ID in the External Identifier field. When you subsequently update this data, you can use the external identifier as the field on which to match records. But sometimes you simply don't have a unique ID for contact data you want to import into CiviCRM.

How to do it…

Here we will use Google Refine to create our unique ID. Once we have this, we can use it to match contact data during CiviCRM import operations:

Download Google Refine from http://code.google.com/p/google-refine/wiki/Downloads?tm=2.
Import data from CSV, Excel, or a variety of other files into Google Refine to see how the import mechanism works. It may look something like this:
You can see that we cannot use Last Name values as a unique identifier as it is not unique. If we did an import using the last names, CiviCRM would only update the first matching record it found.
A combination...

CiviCRM Cookbook

CiviCRM Cookbook

Overview of this book

Related Content you might be interested in

Current Title:

CiviCRM Cookbook

Using Google Refine to create a unique ID

How to do it…