Bill Powell Is Alive [The Den]
{ Three Acres and a Penguin }

CiviCRM is an amazing open-source web-based program that non-profits can use to communicate with their constituents.

I'll have more to say soon, but for now, here are a few first stops in the wealth of documentation.

A few quick PDFs for an overview

• Short Introduction, showing key features
• Examples of sites using CiviCRM, such as Wikipedia
• Printable brochure with main features

Screencasts (videos)

Here's a long list of short tutorial videos. These videos seem to favor the Drupal integration of CiviCRM, but the tasks will work the same way within Joomla.

Live demo sites

• Joomla demo. Use "demo" and "demo" to log in to the demo administrator site, which is where most of the fun is.
• Drupal demo. You'll notice that the Drupal demo is running the latest release, with the latest features. The CiviCRM community seems to prefer Drupal over Joomla, but they're committed to fully supporting both.
• Standalone demo. You can run CiviCRM outside either CMS, but users will need an OpenID.

More documentation

• Current documentation
• A team also recently wrote a free CiviCRM manual, which you can also read as a PDF

Features to note

A growing list. :)

Access keys

Most screens have a small question mark icon at the bottom right labeled Access keys. Click on it to see special hotkeys for that screen.

Import anything you like

You can import a CSV file almost (every?) time you can enter data. You don't need to sort the CSV columns beforehand; a sophisticated screen will help you match up each column in the CSV file to the exact CiviCRM field you choose.

One gotcha: you will need to sort your CSV files beforehand by whether each constituent (donor, contact, whatever you want to call it) is an individual, organization, or household. CiviCRM can only import one of these kinds of constituent at a time, presumably because the field list is so different.

Export

Don't look for an export button those data screens. Exporting is done via reports. When you select CiviReport, you will get a list of reports you can run and tweak. You'll see the results on the screen, but you can also export them to a PDF or a CSV file.

Or use back-door SQL magic

Of course, since CiviCRM stores the data in a MySQL database, you can export anything you want, if you're willing to learn SQL. (You could also import data with SQL, but this is usually best left to a program's frontend. Especially one so sophisticated as CiviCRM.)

Combining with a payment processor.

The one thing you probably don't want CiviCRM to do is actually process your credit card or other payments. Unless you're set up to process these transactions directly with Visa, Mastercard, et. al., you'll want to tie CiviCRM to a payment processor. Many people may think of PayPal, but in fact you have other options.

Authorize.net and batch processing.

For instance, how could you connect CiviCRM to authorize.net? CiviCRM works with authorize.net out-of-the-box; getting donation pages to send donors to authorize.net to actually enter their sensitive info is easy.

But what about batch processing? What if you have a print appeal, and get back a stack of checks and credit card donations to process?

One approach: put it in a spreadsheet first.

One option is to put this data into a spreadsheet first. Then, you can log in to authorize.net and use their tools for a batch upload.

Tools on the top menu, then Upload Transactions on the left menu, then Upload New Transaction File on the main area of the screen.

How you would you then get this into CiviCRM. Well, you could remove the sensitive financial data from the spreadsheet (easy enough to delete those columns). But this might split the workflow -- what if some of these donations don't go through? So you might instead use authorize.net to manage the transactions, and after the transactions clear, use the authorize.net export features to get a CSV file of donations to import into CiviCRM.

About this personal site of Bill Powell (me)

Hi. I write, and I'm alive. Wherever I go, whoever I meet, I often find we have at least one of those in common.

Although I have a few pages here about my professional work, most of this site is my den, which is kind of like a personal wiki that no one else can edit. My typesetting and web development work is over at Wineskin Media.

My mnemonic work, or studies in how to remember anything you want, even entire books, is not yet online. The current wisdom is to launch a complete site with many, many articles, rather than start a blog site with one or two or twenty posts. So you can expect to see this, along with my new book, in Winter 2009.

Why Bill Powell Is Alive? For years I've let this email address amuse and bewilder hapless data entry folk, but it's time I explained that the site name is a reference, perhaps oblique, to Chesterton's Manalive, which is one of my favorite books. In fact, maybe you should just go read it right now, or at least my sample typeset chapter. Or find out how I made it into a game.

What's here? You can read about my adventures in land hunting, organic farming, and permaculture under quest. Oh, and then there's that home birth or two (or three) under family.

If you prefer not to think about chickens as cannibals or what it's like to actually use your pocketknife, fear not, fellow sedentary friend. I haven't done much homesteading in the last couple of years.

For instance, I've been rather occupied with GNU/Linux. You wouldn't guess it from the volume of posts, but that's because it's more fun to play with Linux.

I've also posted a fair bit of my fiction and humor writing here (especially at the portfolio), but most of my current (and better) stuff is still offline while I send it to market. In fact, I originally conceived of this as my work/personal site, but that little slash turns out to cover rather an abyss. If you're interested in professional typesetting, layout, graphic design, and web development services, please consider Wineskin Media for your next click.

And if you don't find enough around here on distributism and other social justice topics, you might enjoy this (now retired) ezine:

Lately, I've been writing instead for the Distributist Review.

And if you're tired of the Internet's collective posturing at veracity, perhaps you'd enjoy a bit of open satire:

Wherever you go next (here!), I hope you have a lovely day.

And if you have any questions, comments, or uproarious tales of derring-do, please let me know.