Contact manager: I'd love some advice

Events happening in the community are now at Drupal community events on www.drupal.org.
Screenack's picture

One of my favorite clients are looking to migrate their contact information (address, email, etc) database from an MS Access database (a jet-based database with the Access-based GUI, bless their hearts) to something more robust. They also wish to move a Drupal 5-based contact information (who called whom, when, where and the results of the contact) database and merge the two models into one solution, as we current have two address databases. Sounds like low-hanging fruit, given what a disaster the jet database is. BUT, this is a golden opportunity to rework the business model to incorporate standard best practices into what is essentially a Customer Relationship Management problem and solution.

I'm aware of CiviCRM and SugarCRM. In my rather quick reading, SugarCRM is more robust, configurable and thus has a steeper implementation curve and my deliver far more than we need (we don't need to track calls to sales revenue and other commercially-driven CRM requirements) whereas CiviCRM sounds to be right balance of feature set and implementation. Of course, simply going to a non-drupal standalone web application is also a possibility. All things do not need to be Drupal-based.

I would deeply appreciate any thoughts. Thanks in advance.

Comments

Have you thought about

pcave's picture

Have you thought about Salesforce.com? And if you haven't worked with Salesforce, don't let the name mislead you. While it started out as an online sales pipeline management application, it is now a full featured CRM hosted in the cloud. The built-in apps are completely customizable, and if they don't meet your needs, Salesforce even comes with a full featured development framework (just like Drupal). You can build simple apps by pointing-and-clicking, but for more robust tasks you can use their DeveloperForce framework which includes its own programming language called Apex.

Oh, and if your client happens to be a non-profit, Salesforce is free.

Service, CMS, anything but bespoke code

afreeman's picture

IMHO going with a service like Salesforce or basing your implementation on an existing CMS makes a heck of a lot more sense than coding a bespoke app from scratch. Too many wheels require reinventing when you're writing the whole app from scratch. There's also lifecycle maintenance, documentation and training to consider.

What are you going to do with that, kid?

tarvid's picture

My grandfather always asked me that question when I would show up with a new gadget.

Tried SugarCRM - much too heavy.

Built my own on Drupal - a camel or perhaps an elephant.

Hammered contacts into MySQL and hung a set of queries on an internal website. Useful but ugly and always requires more "plumbing". MySQL is a hammer for which every application looks like a nail

The LCD of all such efforts is the vCard. I haven't quite adopted it yet but http://microformats.org/wiki/hcard has charm. vcard is compatible with both Gmail and Skype - my main means of communication.

@pcave: SF; really? I just

Screenack's picture

@pcave: SF; really? I just contacted them — and it's true, 10 donated licenses. That's fantastic, thanks for the referral! I'm digging deeper on that front now.

@alan: thanks, I always prefer to stand on the shoulders of giants. I was limiting my search to existing solutions.

I would also love to hear raves or horror stories on CiviCRM or SugarCRM, too.

Thanks!

CiviCRM

labrown's picture

CiviCRM is huge, extremely flexible, and I sometimes think it has a nearly vertical learning curve requiring a pole vault to get over.

I'm a big fan of CiviCRM

hallman's picture

I'm a big fan of CiviCRM!!! I've been learning Drupal with the idea of providing multi-site hosting of CiviCRM for local nonprofits.

My learning curve problem has been learning Drupal. There are now good materials online for learning CiviCRM. I'd start by skimming through http://en.flossmanuals.net/civicrm to get an idea of what CiviCRM will do -- "The Book" reads well. Then take a look at the forum -- http://forum.civicrm.org/ -- for example, Pre-installation Questions. The support for CiviCRM is excellent. Responses to questions are quick, complete, helpful, and polite. Check out http://wiki.civicrm.org/confluence/display/CRMDOC/Case+Studies -- where folks have described how they are using CiviCRM. After you've installed it and before you start configuring it, skim through http://wiki.civicrm.org/confluence/display/CRMDOC/Administrator%27s+Guide to get an idea of how you'll want to approach developing the site as an administrator. http://wiki.civicrm.org/confluence/display/CRMDOC/Using+CiviCRM provides instructions for the staff who will be using it. The documentation has improved tremendously since I first started looking at it. They now have documentation online for different versions of the software.

With regard to other CRMs, look at http://nten.org/blog/2007/12/11/2007-crm-satisfaction-survey
If you're an NTEN member, you can download it free. If not, send me email and I'll forward to you my copy.
"CiviCRM was the most commonly used by small organizations."
"Which of the following CRM Products would you be willing to
recommend to others?" -- CiviCRM was highest -- 91.3%

I have an NCTech4Good friend who is a BIG fan of Salesforce. I'm sure she'd be glad to talk with you. See her offer to help folks with Salesforce at http://nccommunities.org/node/119 Trish gave a great presentation at an NCTech4Good meetup last year.

I organize an affinity group meeting for CiviCRm each year at the NTEN conference. We get a good crowd. Last year the room overflowed into the hall. One person came up to me at the conference and said she'd been to our meeting and was going to use CiviCRM -- I think because of the ability to add on features. A lot of the improvements to the software come from users -- sometimes they write code and contribute it, sometimes they fund development.

I have CiviCRM 3.0 running on http://test.nccommunities.org with the sample data that comes with CiviCRM and some suggestions for exploring CiviCRM at http://wiki.civicrm.org/confluence/display/CRMDOC/Exploring+Sample+Data -- I have NOT checked it out since the upgrade but plan to do so very soon. I'd also be willing to give you admin access on the test site.

So now I should say... I'm not using it for a real organization yet. And I should also say that multi-site hosting is not as easy as I thought it would be. BUT I think I'll be using CiviEvent for a conference coming up in June, CiviMember experimentally for RTPnet's members, and custom data for NCTech4Good attendees. Internationalist Books & Community Center in Chapel Hill is using CiviCRM -- see http://www.internationalistbooks.org/index.php?q=civicrm/contribute/tran...

Finally, I've been thinking about starting a local CiviCRM meetup group, but I can't commit to monthly meetings for it. If there's interest, I'd be glad to start a group.

Judy Hallman

Deep appreciation

Screenack's picture

Thanks all; I greatly appreciate all of your generous input.

I'm leaning very heavily towards the Salesforce solution. I love not having to spin up another Drupal instance and let someone else do the backend work for a change.

Best regards,
Kyle

Standalone CiviCRM

hallman's picture

I meant to reply sooner...

There's a standalone version of CiviCRM now, so you don't have to install Drupal just to run CiviCRM. One advantage of using it would be to allow the site to grow to use Drupal later.

http://en.flossmanuals.net/CiviCRM/AdditionalConsiderations says:

Standalone vs CMS

If you are not interested in or ready to consider using a CMS then you might choose to use CiviCRM's Standalone mode. The trade-off here is you won't be able to take advantage of all the CMS's great integrated online features. Alternatively you might install CiviCRM as part of a CMS but not explore the CMS's features until later.

Some examples of organizations using CiviCRM in standalone mode include those that:

* have a CMS other than Drupal and Joomla. These organizations have to create a very customized system that integrates with CiviCRM.
* just need CiviCRM for one specific thing like basic contact or event management and don't need website integration.
* don't intend to use a CMS but want to start using CiviCRM anyway. 

Judy Hallman

Membership database

mariaprel's picture

Hi Kyle,
I have a client (a non profit) that is also looking to migrate from access to a web based CRM system. Have you been using any of the solutions listed above? I would like to know what your experience has been. I foresee that I will have to a fair amount of customization.

Thanks,
Maria Prel

Yes

Screenack's picture

We've settled on SalesForce and are busy implementing it now and we're doing something similar by merging a mix of access database and a Drupal tracker. Contact me if you'd like to know more, since I'm still in the design phase I don't want to say too much just yet; but so far I'm pleased with SF for non-profits.

Thanks so much

mariaprel's picture

can you provide some information about what you mean by "merging a mix of access database and a Drupal tracker'' ?
Thanks,
Maria

Sure

Screenack's picture

Well, I'd rather not go into it, as neither solution served their purposes and hence the redesign. Both were somewhat denormalized custom solutions that didn't interexchange data and thus were prone to error.

Thanks

mariaprel's picture

Hi Kyle,
thanks for your candor, and all the best
Maria

The offer stands

Screenack's picture

Please feel free to contact me off this board (you can do so using my profile here) and I can give you more details. I'd rather not go into details here just yet.

triDUG

Group organizers

Group notifications

This group offers an RSS feed. Or subscribe to these personalized, sitewide feeds: