Active TopicsActive Topics  Display List of Forum MembersMemberlist  CalendarCalendar  Search The ForumSearch  HelpHelp
  RegisterRegister  LoginLogin
Running Your Theater
 Community Theater Green Room Discussion Board :Theater Administration :Running Your Theater
Message Icon Topic: Membership Database(Topic Closed Topic Closed) Post Reply Post New Topic
Page  of 2 Next >>
Author Message
tonyboling
Star
Star
Avatar

Joined: 3/15/08
Location: United States
Online Status: Offline
Posts: 55
bullet 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 IP Logged
skoehler
Lead
Lead
Avatar

Joined: 5/19/08
Location: United States
Online Status: Offline
Posts: 37
bullet 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 IP Logged
tonyboling
Star
Star
Avatar

Joined: 3/15/08
Location: United States
Online Status: Offline
Posts: 55
bullet 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 IP Logged
Stageref
Player
Player
Avatar

Joined: 7/30/08
Location: United States
Online Status: Offline
Posts: 13
bullet 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 IP Logged
ticketjunior
Walk-On
Walk-On
Avatar

Joined: 6/23/07
Location: United States
Online Status: Offline
Posts: 0
bullet 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 IP Logged
LEHCo
Walk-On
Walk-On
Avatar

Joined: 9/03/07
Location: United States
Online Status: Offline
Posts: 7
bullet 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 IP Logged
Tallsor
Star
Star
Avatar

Joined: 2/24/04
Online Status: Offline
Posts: 63
bullet 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 IP Logged
ziggy1122
Walk-On
Walk-On


Joined: 10/26/08
Online Status: Offline
Posts: 6
bullet 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 IP Logged
trutter
Star
Star
Avatar

Joined: 11/13/06
Location: United States
Online Status: Offline
Posts: 81
bullet 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 IP Logged
imamember
Celebrity
Celebrity
Avatar

Joined: 8/18/08
Location: United States
Online Status: Offline
Posts: 121
bullet Posted: 2/07/09 at 8:31am
tell me more trutter, tell me more!
IP IP Logged
Page  of 2 Next >>
Post Reply Post New Topic
Printable version Printable version

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

Bulletin Board Software by Web Wiz Forums version 8.05
Copyright ©2001-2006 Web Wiz Guide
buy generic cialis are in line cialis canada outcome for yourself viagra sales cost saving benefit viagra uk convert your buy phentermine online pay phentermine cod payment Lenders Everything xanax online your existing xanax overnight absolute must free incest stories online The value gay incest advance The key free dog sex pics cash flow dog sex the reduced noise free gay college guys of the period gay guys