CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Feature Requests and Suggestions (Moderator: Dave Greenberg) »
  • Limit the number of related memberships
Pages: [1] 2

Author Topic: Limit the number of related memberships  (Read 6033 times)

nicolas

  • I post occasionally
  • **
  • Posts: 92
  • Karma: 6
    • cividesk
  • CiviCRM version: 4.4 LTS
  • CMS version: Standalone (yep)
  • MySQL version: 5.1
  • PHP version: 5.3
Limit the number of related memberships
April 08, 2012, 09:00:53 pm
=== Please comment on this proposed improvement so I can judge community interest and prioritize accordingly ===

Very often membership privileges should be granted to only a fixed number of company representatives (ex: our Corporate members can designate 8 company representatives). Yet with CiviCRM all employees of the member organization inherit the membership if configured as such, without limits.

I am proposing to implement the following changes (end-user scenario):
  • When creating a new membership type, allow the user to specify the maximum number of related contacts that can inherit this membership by relationship.
  • Inherited memberships would be automatically created for related contacts just as they are today, but up to this specified limit only.
  • When creating or editing a membership, allow the user to manage these related members by using checkboxes to create/delete the inherited memberships. The limit placed in the membership type would not be enforced in the case of such manual assignment.

See http://issues.civicrm.org/jira/browse/CRM-10012 for a more technical description of the proposed changes.
cividesk -- CiviCRM delivered ... your way!

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Limit the number of related memberships
April 09, 2012, 08:50:33 am
Nicolas - This has come up a number of times during training sessions. Pretty much everytime we review inherited memberships folks ask about the possibility of limiting the number.
Protect your investment in CiviCRM by  becoming a Member!

nicolas

  • I post occasionally
  • **
  • Posts: 92
  • Karma: 6
    • cividesk
  • CiviCRM version: 4.4 LTS
  • CMS version: Standalone (yep)
  • MySQL version: 5.1
  • PHP version: 5.3
Re: Limit the number of related memberships
April 09, 2012, 09:13:53 am
Thanks Dave, great feedback.

Does the above use case look OK for you or would you add/change anything in terms of the user experience?
cividesk -- CiviCRM delivered ... your way!

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Limit the number of related memberships
April 09, 2012, 05:14:38 pm
I'm thinking the display of "related contacts" on the Membership Form as described in CRM-10012 needs some refining. If we do this on create, then that section needs to be added dynamically (via jQuery) only after a membership type is selected AND that membership type is inheritable AND the contact we are creating the membership for has relationships of the inheritable type. This is a bit easier on membership edit because we already know the membership type when the form is built.

Also need to think about how to handle "over the limit" self-service situations. For example, someone purchases a membership on behalf of an organization and that membership is inherited by "employees of". If that organization already has > max_related_members employees in the DB, what do we do?
Protect your investment in CiviCRM by  becoming a Member!

nicolas

  • I post occasionally
  • **
  • Posts: 92
  • Karma: 6
    • cividesk
  • CiviCRM version: 4.4 LTS
  • CMS version: Standalone (yep)
  • MySQL version: 5.1
  • PHP version: 5.3
Re: Limit the number of related memberships
April 10, 2012, 07:08:04 am
The membership form will need some AJAX for both create and edit - ie. the user can edit a membership to change it's type - if so, the section might need to be shown or hidden. We definitely need an AJAX call whenever the membership type is set or modified to:
1- assess if we need to show/hide the section
2- get the list of potentially related members to be displayed
The list of related members that the user select will need to be stored in the form so we can access these when processing it.

Your 'self-service' use case is a good one - I understand it as: employee #5 (in the CiviCRM DB) of an organization purchases a company membership online. That membership type can only have 4 designated representatives. Do only the first 4 employees in our DB get it when we do the automatic assignment (and the guy who purchased is left out)? We probably first need to check if the current user is an employee in the automatic assignment code, if so give him the inherited membership, and then assign the rest according to seats left to the other employees.
cividesk -- CiviCRM delivered ... your way!

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Limit the number of related memberships
April 11, 2012, 10:25:57 pm
Is the 'over subscription' anything like 'waitlisting' for events?
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

nicolas

  • I post occasionally
  • **
  • Posts: 92
  • Karma: 6
    • cividesk
  • CiviCRM version: 4.4 LTS
  • CMS version: Standalone (yep)
  • MySQL version: 5.1
  • PHP version: 5.3
Re: Limit the number of related memberships
April 12, 2012, 07:09:48 am
Not quite sure, but I would say no:
- when wait-listed on an event, you are not considered a participant unless there is a cancellation by another guest
- when the user manually assigns more than the 'theoretical' representatives to a membership, all these are full membership rights

There is no big deal about this 'over subsciption', it is just that when presenting the option of limiting the number of inherited memberships to my customers they all said it was a great idea, but that they wished to sometimes grant additional inherited memberships to some 'faithful' or 'involved' organizational members.
cividesk -- CiviCRM delivered ... your way!

mclyde

  • I post frequently
  • ***
  • Posts: 171
  • Karma: 3
    • International Society for Bayesian Analysis
  • CiviCRM version: 4.2.7
  • CMS version: Drupal 6.x
  • MySQL version: 5.136
  • PHP version: 5.2.16
Re: Limit the number of related memberships
April 25, 2012, 08:54:46 pm
I am interested in this functionality!

We would like to add organizational memberships (academic groups, companies) but do not want to grant membership to all employees of the organization, but rather allow up to 10 student members and 3 regular memberships under the organizational membership. 

Student memberships for an organization are transient, so we need any easy way for the organizations contact to be able to update the list and add/delete members to determine who should be granted the relationship.

I started to look at adding a custom form to add the reference field for users to build a list for an admin to add the relationships, but I'm worried about the warnings of exposing the complete member list.  Many user names are not obvious as some were imported from an email list so username is an email address.    It would be ideal if the membership could be added from the institutional membership page. We would need some form of matching lookup to avoid creating duplicate accounts.  (which I still have in any case)

What happens if the selected contact already has a regular membership?  say a student membership - would they inherit the institutional membership and have 2 memberships or would their student membership be renewed/upgraded?  Would a paid on behalf model make more sense for my use case?

Please keep me posted - if there is a MIH project in the works we may be able to help out...

best,
Merlise

Merlise Clyde

nicolas

  • I post occasionally
  • **
  • Posts: 92
  • Karma: 6
    • cividesk
  • CiviCRM version: 4.4 LTS
  • CMS version: Standalone (yep)
  • MySQL version: 5.1
  • PHP version: 5.3
Re: Limit the number of related memberships
April 25, 2012, 09:33:24 pm
Merlise,

If I understand correcty, you would have:
- an academic group membership, with allows up to 10 student members
- a company membership, which allows up to 3 employee members

This would exactly fit with what I proposed. When you would create a new academic group membership, the list of all currently registered students for this organization would show up, and you would select which student you want to grant membership to with checkboxes.

If you ever want to change the student members, you would select the organization, go to the membership tab, and edit the organization membership. The same list of students would appear and you could check/uncheck whomever you want.

If a student you select already has a student membership then he/she would have 2 memberships displayed in the membership tab: his own, and the one he inherited from the organization (on behalf of). There would be no easy way around it as these memberships are not logically equivalent and could even grant different privileges. But you could always transfer the inherited membership to another student, which would probably make the most sense.

Is this what you were looking for? Would you suggest any improvement to this scenario?

--Nicolas.
cividesk -- CiviCRM delivered ... your way!

mclyde

  • I post frequently
  • ***
  • Posts: 171
  • Karma: 3
    • International Society for Bayesian Analysis
  • CiviCRM version: 4.2.7
  • CMS version: Drupal 6.x
  • MySQL version: 5.136
  • PHP version: 5.2.16
Re: Limit the number of related memberships
April 26, 2012, 09:48:42 am
What you describe would fit our needs as I am trying to avoid setting up organizational memberships that require a lot of  (non-existent) back-office support!
Merlise Clyde

mclyde

  • I post frequently
  • ***
  • Posts: 171
  • Karma: 3
    • International Society for Bayesian Analysis
  • CiviCRM version: 4.2.7
  • CMS version: Drupal 6.x
  • MySQL version: 5.136
  • PHP version: 5.2.16
Re: Limit the number of related memberships
April 27, 2012, 09:05:40 am
The creation of a second membership would be a problem for us for targeting expired members.   

If renewal notices are sent to the organizational contact, and an individual's relationship ends, then how do they know that they need to renew?
If they have already renewed as an individual, then sending emails based on the expired organizational membership will be confusing/and or annoying.

Having inherited membership within the same organization by treated as an "upsell"  leading to a continuous membership record would be better for our settings.   

best,
Merlise
Merlise Clyde

nicolas

  • I post occasionally
  • **
  • Posts: 92
  • Karma: 6
    • cividesk
  • CiviCRM version: 4.4 LTS
  • CMS version: Standalone (yep)
  • MySQL version: 5.1
  • PHP version: 5.3
Re: Limit the number of related memberships
April 27, 2012, 03:50:14 pm
Merlise,

This is just how the 'inherited' membership work in CiviCRM: there is one membership on the organization, and one membership on the individual referencing the 'parent' membership. You are able to send the renewal notices either to the organization, the individual or both by using the advanced search. You could also design your renewal templates differently based on whether they are sent to the organization or the individual that inherited the membership. This is very flexible system that can accommodate nearly every situation.

--Nicolas.
cividesk -- CiviCRM delivered ... your way!

mclyde

  • I post frequently
  • ***
  • Posts: 171
  • Karma: 3
    • International Society for Bayesian Analysis
  • CiviCRM version: 4.2.7
  • CMS version: Drupal 6.x
  • MySQL version: 5.136
  • PHP version: 5.2.16
Re: Limit the number of related memberships
April 30, 2012, 01:15:36 pm
Sorry - my question was really about trying to avoid multiple renewals and keeping one contiguous membership record.

My scenario is the following

user 1 has an individual student membership in Organization A  expired 2011
user 1 has a student relationship with Organization B; expires in 2012
Organization B has an organization membership in Organization A that is inherited in by relationship to user 1;   

We have a smart group of all expired members, so user 1 will continue to receive the renewal notices for the individual student membership even though he/she has a current inherited membership through org B in org A.

What I would hope is that the inherited membership would be treated as an "upsell" for user 1,  so that the student membership in org A  would be renewed through the inherited membership and set to current status.  Otherwise they could potentially have two current memberships in org A - one individual and one inherited.

best,
Merlise

Merlise Clyde

tso2085

  • I post occasionally
  • **
  • Posts: 75
  • Karma: 0
  • CiviCRM version: 4.7.15
  • CMS version: Joomla 3.6.5
  • MySQL version: 5.5.37
  • PHP version: 5.5.30
Re: Limit the number of related memberships
June 28, 2012, 07:42:15 pm
If I may add to possible requirements...

I have the same functional need as described in the posts, limiting the number of allowed members for each paid membership.  However, I would also like to allow for an additional charge option to add any other members over the limit.  Some companies would legitimately need more members in their membership.  Or, the scenario where you have say 3 levels of membership, with limits (4 member limit, 15 member limit, 50 member limit).  If a company just needed 5 or 6 members, you would like to be able to accommodate that by charging for the 5th and 6th member.

Would love to hear opinions on this.

GinkgoDOB

  • I post occasionally
  • **
  • Posts: 54
  • Karma: 1
  • Dir. of Product Development, Ginkgo Street Labs
    • Ginkgo Street Labs
  • CiviCRM version: v4.5-4.7
  • CMS version: Drupal
Re: Limit the number of related memberships
July 23, 2012, 05:31:57 pm
I'm going to throw in a vote for this feature. I'm working with a client (Chamber of Commerce) that's got different levels of memberships that allow for different named contacts (Corporate Members, 6 contacts; Premier Members, 3 Contacts; other memberships, 1 contact).

I was looking at creating a relationship types of "Named contact for"/"Named contact of" and doing an exception report out of the database, but this is a much cleaner implementation.

Pages: [1] 2
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Feature Requests and Suggestions (Moderator: Dave Greenberg) »
  • Limit the number of related memberships

This forum was archived on 2017-11-26.