Active Topics Memberlist Calendar Search Help | |
Register Login |
Running Your Theater | |
Community Theater Green Room Discussion Board :Theater Administration :Running Your Theater |
Topic: Membership Database( Topic Closed) | |
Page of 2 Next >> |
Author | Message |
tonyboling
Star Joined: 3/15/08 Location: United States Online Status: Offline Posts: 55 |
Topic: Membership Database Posted: 9/28/08 at 4:52pm |
Wat do the rest of you use for membership databases? I don't knowSQL or anything, but was thinking of trying to learn MS Access.
Any recommendations? |
|
IP Logged | |
skoehler
Lead Joined: 5/19/08 Location: United States Online Status: Offline Posts: 37 |
Posted: 9/28/08 at 7:24pm |
We use MS Access, it is horribly limiting and frustrating to use in many ways, but it works, and the majority of our volunteers, not to mention my office manager, fell comfortable with it.
|
|
Steven Koehler
Managing Director Civic Theatre of Greater Lafayette www.lafayettecivic.org |
|
IP Logged | |
tonyboling
Star Joined: 3/15/08 Location: United States Online Status: Offline Posts: 55 |
Posted: 9/28/08 at 11:43pm |
Yeah, I'm not much for programming or databases so I'm currently learning Access as well. I figure if it works for what we need then it's okay. Plus if we ever get someone on the board that really knows databases, it's fairly easy to export an Access database to MS SQL or MySQL and then they can build new queries, forms and reports.
|
|
IP Logged | |
Stageref
Player Joined: 7/30/08 Location: United States Online Status: Offline Posts: 13 |
Posted: 10/08/08 at 11:12am |
It's not a member database per se but stageref.com can give you a professional looking web presence to your productions.
|
|
Stageref.com
The new, free, on-line social experience of community theater productions and people |
|
IP Logged | |
ticketjunior
Walk-On Joined: 6/23/07 Location: United States Online Status: Offline Posts: 0 |
Posted: 11/19/08 at 12:01pm |
Tony, Not sure if its helpful or not but as part of the Ticketjunior system we help you maintain your customer database. Our solution is web based and therefore you've always got access to your member database and can export the list at any time to excel. With our system you could kill 2 birds with one stone. We could help you sell tickets to your event and help you keep a current and accurate list of your customers / patrons.
|
|
-James P. Walters
Phone: 404-272-4778 www.ticketjunior.com "We're the little guy in the ticketing business." |
|
IP Logged | |
LEHCo
Walk-On Joined: 9/03/07 Location: United States Online Status: Offline Posts: 7 |
Posted: 1/10/09 at 6:59pm |
I started an Excel spreadsheet and put all of the information in. I can sort it and expand to maintain any kind of data. For example, I put in whether a member wants to act, sing, dance, set construction, etc, and then I sort on whatever trait a person requests. It makes it easier to find people to work on productions. Hope that helps!
|
|
Thanks!
LEHCo |
|
IP Logged | |
Tallsor
Star Joined: 2/24/04 Online Status: Offline Posts: 63 |
Posted: 1/11/09 at 5:48pm |
It all depends on what you're trying to accomplish with your information. If you're just tracking mailing lists, then Excel is fine. Access comes in handy if you want to separate out your lists (i.e., actors, directors, audience members) and there are some people on just one list and some people on multiple lists. For my personal database, which stemmed out of me working with a number of different nonprofits who sometimes had similar people working or interacting with it (such as media) but sometimes had vastly different people.
There are also online options such as eTapestry Wild Apricot, which might be your best bet and what I'd do if I was running a theatre right now, as most of then can then track your various campaigns in much greater detail than you can program in Access as well as use it to send e-mails and other communications. Idealware has a great article on choosing donor management systems ( http://www.idealware.org/articles/fgt_donormgt.php ).
But some of these cost different dependent on whether your organization is a non-profit and what your mailing list is like. Of course, if you're a non-profit, you can get some of the fancier database software for cheap through TechSoup.
Angie
|
|
IP Logged | |
ziggy1122
Walk-On Joined: 10/26/08 Online Status: Offline Posts: 6 |
Posted: 1/26/09 at 4:26pm |
I actually stumbled upon CiviCRM (www.civicrm.org). It has both Joomla and Drupal integrations as well as a standalone version. It's a web type application, not an installed software thing. It can handle contributions, pledges, membership signups, membership renewals, etc... Looks pretty snazzy so far, but I've only scratched the surface and done initial prodding and poking-style testing.
|
|
IP Logged | |
trutter
Star Joined: 11/13/06 Location: United States Online Status: Offline Posts: 81 |
Posted: 2/06/09 at 11:51pm |
We were using a custom made access database, then I got a grant for Fundraiser Professional and it has surpassed all my dreams. :)
|
|
------
Troy A. Rutter Author, "Kids in the Biz: A Hollywood Handbook for Parents" http://www.kidsinthebiz.com/ A Heinemann Drama Publication |
|
IP Logged | |
imamember
Celebrity Joined: 8/18/08 Location: United States Online Status: Offline Posts: 121 |
Posted: 2/07/09 at 8:31am |
tell me more trutter, tell me more!
|
|
IP Logged | |
Page of 2 Next >> |
Forum Jump |
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |