CiviCRM Community Forums (archive)

Hi,

I really, really like what I have read about the structure of CiviCRM so I would love to use it some day in a real project. But I wonder if it suits for the preject I have at hand?

Short description
We're running a commercial and quite small and personal gym and sports center with a community feel to it. We want to bring local people together with sports, exercise and a healthy life style. There are non-members who join workshops, events, and get treatments and book a personal trainer. There are members who do that also, as well as doing workout in the gym, doing classes etc. There are instructors for the classes and for workshops and events and courses. And there are staff.

Features we're looking for

• There's the gym where members become members by buying different types of gym cards. Some cards include classes, some don't, and some cards are for 10 workouts to be used within a year (I'm thinking a one year membership) while most are for a specific period of time lasting from 1 month to a year where they can workout as much as they prefer.
• For the membership types that include classes, members should be able to book the different classes. In some classes there are 25 spots to book, in others 18 and so on.
• A special feature for the class booking is to be able to book all occurences of 1 (not more) specific class, let's say yoga 7.30pm Wednesdays.
• Buying memberships (cards) online
• Some memberships (cards) bought online means filling out a form with bank account details and approving of us making monthly withdrawals from that account, Meaning a transaction involving money won't take place at the time of the purchase, but it still results in a new or prolonged membership.
• Besides classes we also have different courses. Registration by both members and anonymous users, paying online
• We also have two rooms for different treatments (like massage), used by therapists who could inform the system of their availability so that both members and anonymous users could book a sessions, and pay for it
• If we can charge for services we will also need economical reports so that the income can be distributed to therapists, course facilitators etc.
• We would also need to bookkeep the transactions, hopefully through a standard compliant SIE4 file which could be imported into our bookkeeping system
• To get the community feeling going online as well as offline I just have ideas but not so clear cut yet. (I could use some concrete ideas that harnesh the strength of CiviCRM.) Perhaps have a blogging functionality where members can blog about their training activity, perhaps have different polls, perhaps have different groups for yoga, spinning etc, where the instructors also participate, and groups for dietary questions etc where staff, therapists and instructors also participate. What else is possible?
• Keeping track of contact with members, different offers.
• Todo-lists, with private/public flag for each item. And for wishes and complaints from members, instructors and therapists. I guess like an issue que.
• Sending emails to all or selected members, instructors, etc
• Sending SMS to selected members etc would be great!
• Having an webshop selling different products to be fetched (not sent). Good if keeping control of the amount available in stock when ordering.
• It should integrate with Drupal (which I know it already does)

All of the above doesn't necessary have to come with CiviCRM since Drupal might have modules to cover some things. For example, I know there is a Bookings API for Drupal being developed, which could be used to write a special booking module for the class booking functionality. And I could install Ubercart or e-commerce for webshop functionality.

Using more Drupal modules means more memory usage and maybe also a slower site?

I'm really excited about feedback on this project. Should I go with CiviCRM, or a combination of CiviCRM and Drupal modules, or something completely different? Please eleborate a little why you are of a certain opinion.

Thanx!