Sorry to answer a question - but - What do you want your data to do once its moved? Does it need to integrate with other services? Do you need local access, cloud or both? How much in house expertise does your museum have? How much do you want to spend? Who's records are being managed? Curatorial? Development? Public Programs? Admissions? Some combination? Do you use auction or event management software too? Do you need QuickBooks integration?
I ask these questions, unfortunately, from experience. In my last position as a museum director of a small history museum I inherited two decisions from a previous staff who moved the museum to DonorPerfect and AuctionPay. The contract bookkeeper had already moved the museum to QuickBooks. The problem was none of them talked to each other! We had donor data in three different databases! And not always the same data for the same person. Each decision was made in isolation without stepping back and reviewing the overall institutional needs.
So first off - do a needs assessment. What office needs to share data with other offices. What platforms are you standardized on.
Second - thoroughly research the interoperability of the candidate software packages with software used by or needed by other departments.
Third - is there an open source solution? Google provides Google Apps for Education free to nonprofits and museums. I have used for the last 6 years with great success. And guess what? There are bookkeeping, crm and inventory third-party apps that are built on this free platform! (And if you need help let me know - I have been researching these for a while) (see
https://www.google.com/enterprise/marketplace/?pli=1 ) and look at (www.zoho.com)
How small are your needs? PastPerfect integrates collections management and donor/development management tools in one program. (
http://www.museumsoftware.com/ )
Are there other choices - SalesForce.com provides free accounts to nonprofits and their is a great online community of users. Look for their Foundation as the gateway in (see
http://www.salesforcefoundation.org/nonprofit/ )
I also HIGHLY recommend checking out NTEN - the Nonprofit Technology Network (www.nten.org ) and their magazine NTEN: Change (A Quarterly Journal for Nonprift Leaders). They work in all sectors of civil society and study the impact of technology on nonprofits and what helps advance mission.
If anyone wants more help let me know.
-------------------------------------------
Samuel Shogren, MPA
In Transition - Currently Seeking New Opportunities
Beaverton OR
-------------------------------------------
Original Message:
Sent: 10-07-2014 05:12 PM
From: Rachel Smith
Subject: Tell me about your database/CRMs
A question I wanted to pose to the group was about databases and CRMs. We currently use a Filemaker database and are looking for a more robust system. I'm particularly interested in hearing from small organizations. While museums with bigger staffs (and budgets) may be able to work on several databases (i.e. a collection mgmt database, a separate donor mgmt database, and another one for ecommerce), we're looking for a more integrated solution. Anyone had luck with a system that does it all or in building a custom CRM to their specifications?
Thanks!
-------------------------------------------
Ray Smith PhD
Corita Art Center
Los Angeles CA
-------------------------------------------