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
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
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?
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
@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
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
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
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
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:
Judy Hallman
Membership database
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
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
can you provide some information about what you mean by "merging a mix of access database and a Drupal tracker'' ?
Thanks,
Maria
Sure
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
Hi Kyle,
thanks for your candor, and all the best
Maria
The offer stands
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.