CiviCRM Community Forums (archive)

Hey all,

This is going to sound like a silly use for CiviCRM. I am a member of a Star Trek fan club. We have 3800+ members internationally, with over 200 chapters. The memberships can be individual or family. The membership is broken down into regions and chapters. There will be multiple roles (ACLs should work well here). Here's a breakdown of what I need.

So my basic unit is the contact. Joe Member.

That contact is part of a chapter, the USS Lollipop. (She's a good ship!). Her Chapter President is Dave.

That chapter is part of Region Two, whose coordinator is Jack.

RC Jack oversees 32 chapters in his Region. Each chapter has a minimum of 10 members. Some as many as 40.

Can the chapter president (Dave) have access rights to ONLY his members, while the RC Jack has access to all of the members of all 32 chapters in his region?

Also, how do households fit in? Can I use a household to track our family memberships? There are cases (odd) where one member of a family is a member of one chapter and other members are part of other chapters. Can members of a household belong to multiple groups?

As far as adding the needed specialized fields, that all looks do-able in CiviCRM. I just need to know if the access control schemes will work in the model I am outlining.

Advice?

need to do the setup directly in the DB tables rather than trying do use the Admin UI. So, to some extent you will "boldly go where no wo/man has gone before." (Actually I think a few of our political campaign users have done implemented some of this - and I'm hoping they'll chime in.)

I want to use as much of the built in functionality that I can to save work. You guys have developed a wonderful tool. Our organization has already rolled out Joomla as our website/CMS, so this was the next logical progression.

What I am not sure of is how to list the chapters. As Groups? As Organizations? As both?

RE: households and memberships, you can create membership type(s) where the member is a household and membership is automagically extended to any household members. (Use the "Relationship Type" field when setting up the Membership Type.)

I did not see any way to make an individual a member of a household. I assume that is done through Relationships?

Thanks, Dave, for your help!