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) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Custom Datasets should membership or contact type
Pages: [1] 2

Author Topic: Custom Datasets should membership or contact type  (Read 3251 times)

NASACT

  • I post frequently
  • ***
  • Posts: 289
  • Karma: 9
    • National Association of State Auditors, Comptrollers and Treasurers
  • CiviCRM version: 4.2.2
  • CMS version: Drupal 7
  • MySQL version: 5.1.58 (ubuntu)
  • PHP version: 5.3.5
Custom Datasets should membership or contact type
January 10, 2012, 07:35:02 am
Was wondering if maybe I am thinking about my custom data sets wrong.  Scenario: Custom demographics are collected about an organization at time of membership, this only relates to Organizational member type and not Individual or Associate membership (which are really treated as individual membership types).  First go round I created a custom dataset that was at the org level but this time around I rethought the issue and seemed like the membership dataset choice is a better fit.  This demographic data only is collected at time of renewal and is only used with regard to membership assessments. Where does the custom demographic data really fit best, contact or membership level?  Is there any impact to either choice?  Not every organization in the db will be a member that is why I thought it best fit under membership.  As always thank you very much.
-AJ
My GChat - azon21@gmail.com -  This is where you can find me most days!

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Custom Datasets should membership or contact type
January 10, 2012, 07:48:15 am

i would extend organization since demographics are a function of the org and not a function of the membership :)

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

NASACT

  • I post frequently
  • ***
  • Posts: 289
  • Karma: 9
    • National Association of State Auditors, Comptrollers and Treasurers
  • CiviCRM version: 4.2.2
  • CMS version: Drupal 7
  • MySQL version: 5.1.58 (ubuntu)
  • PHP version: 5.3.5
Re: Custom Datasets should membership or contact type
January 10, 2012, 07:52:34 am
Thanks Lobo - If these are required fields, how would you address those Organizations that these fields would not apply to? (i.e. Sponsors) Or rather maybe I am approaching this wrong and you could make the custom profile required when sign-up or renewal occurs for an organizational membership type?
-AJ
My GChat - azon21@gmail.com -  This is where you can find me most days!

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Custom Datasets should membership or contact type
January 10, 2012, 09:37:56 am

u can attach the required attribute on the profile and keep the custom field optional (for non-org members)

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

NASACT

  • I post frequently
  • ***
  • Posts: 289
  • Karma: 9
    • National Association of State Auditors, Comptrollers and Treasurers
  • CiviCRM version: 4.2.2
  • CMS version: Drupal 7
  • MySQL version: 5.1.58 (ubuntu)
  • PHP version: 5.3.5
Re: Custom Datasets should membership or contact type
January 30, 2012, 08:13:34 am
I am coming back to this.  After playing around with this idea of demographics being an organizational dataset for a while I have some questions.

The only time that this information is collected is when the membership sign-up or renewal process is in place.  So I am not so sure that the placement is the best spot.  Let me describe my scenario a bit to see if you might be able to help further my explanation as to best approach to handle this.

Organizational, Associate and Individual Membership Types -> Organizational is the only time that the custom dataset needs to be completed/updated and only during membership sign-up/renewal

Membership renewal and sign-up form must be exposed to all logged-in users not public/anonymous, public/anonymous is not allowed access to any CiviCRM component.  During membership sign-up/renewal the custom dataset needs to be updated.  Pre-population of fields needs to occur, thought this was automatic when logged in and renewing membership but I cannot get any fields to prepopulate when logged in user and current member because of employer of relationship is tied to membership of organization (my understanding is that they had to have been the one to originally sign-up for this to work but doesn't make sense since membership is employer of relationship).  I thought that when checked "On Behalf Of" that the fields were prepopulated with existing info, I could not get this to work on 4.1b2 assuming that pre-population is not an issue resulting from membership above the individual as mentioned before. Cannot use Organizational Custom Data Fields on Membership (Contribution) Page.  Only the custom datasets that are of membership type. Maybe I am thinking about my approach all wrong and need an expert to point me in the right direction. Maybe a group is required for access control or something here? Please read my goal below so that it might help get me in the right direction.

GOAL:

Organization Membership Type requires "On Behalf Of" at all times and must be able to complete/update organizational custom dataset (organizational characteristics but only used for membership, otherwise not collected by other membership types or other organizations that are not members)
Must be at least an authenticated user to use sign-up/renewal page. Would like to assign the renewal ability to a "primary contact" for an organization so that the "primary contact" can edit/update the organization and any individual attached through "Employer Of" relationship.  Thus each organizational membership type would have a single person that could renew the membership and update the people attached to the organization along with any changes to the person record and the organization record.
Must allow for Organization, Associate and Individual membership types to sign-up/renew membership but organization membership type is the only one with the "extra dataset" data fields.
-AJ
My GChat - azon21@gmail.com -  This is where you can find me most days!

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Custom Datasets should membership or contact type
January 30, 2012, 12:43:47 pm
I think you're pushing the edge of what's do-able w/o custom code BUT ...
1. Try including the custom organization fields you currently have as profile fields in the On Behalf Profile - I think this part should work and they should show up on a membership signup or renewal form

2. I think that the On Behalf Profile form fields should get loaded w/ existing data for a selected "related organization" if a logged in user accesses the membership renewal (or signup) form. The user's contact record needs to have permission for the related organization checked in the relationship record - e.g. "Jane Doe can view and update information for selected contact(s)" checkbox.

I think you'll need to implement a validation hook to make sure that folks selecting "Organization" membership type also select "On Behalf ..." checkbox and fill in that sub-form. Or you can have separate signup / renewal pages for that membership type vs. your other types (in that case you can make On Behalf required).

HTH
Protect your investment in CiviCRM by  becoming a Member!

sandys

  • I post occasionally
  • **
  • Posts: 41
  • Karma: 1
  • CiviCRM version: 4.1.1
  • CMS version: Drupal 6.26
  • MySQL version: 5.0.92
Re: Custom Datasets should membership or contact type
January 30, 2012, 02:16:32 pm
I can verify that both of these will work. In fact, if you create custom organization fields and add those to the "On Behalf Of" profile, they won't show up unless the user selects that they are signing up on behalf of an organization (that profile isn't loaded otherwise). 

Quote from: Dave Greenberg on January 30, 2012, 12:43:47 pm
1. Try including the custom organization fields you currently have as profile fields in the On Behalf Profile - I think this part should work and they should show up on a membership signup or renewal form

2. I think that the On Behalf Profile form fields should get loaded w/ existing data for a selected "related organization" if a logged in user accesses the membership renewal (or signup) form. The user's contact record needs to have permission for the related organization checked in the relationship record - e.g. "Jane Doe can view and update information for selected contact(s)" checkbox.

I'd probably add a little javascript to select "On behalf of" whenever someone chose the Organization type.  But, if I didn't want to write any custom code and was willing to create separate signup/renewal pages, I'd use smart groups & the CiviGroup Roles Sync module to put the appropriate link in the drupal menus (via permissions) for each contact type. That's a little bit of a side-trip, but it's something I use as I generally need to apply drupal permissions based on CiviCRM groups anyhow.

NASACT

  • I post frequently
  • ***
  • Posts: 289
  • Karma: 9
    • National Association of State Auditors, Comptrollers and Treasurers
  • CiviCRM version: 4.2.2
  • CMS version: Drupal 7
  • MySQL version: 5.1.58 (ubuntu)
  • PHP version: 5.3.5
Re: Custom Datasets should membership or contact type
January 31, 2012, 07:06:55 am
Thank you both for the explanation here.  I guess I missed the fact that you could edit the reserved profiles. That helps tremendously as I felt like I was working around this fact from the beginning.

To follow up. I was able to implement the new steps and log in with a user that had the role placed in relationships and could get the org info to populate. The custom data was placed in the on behalf of profile but doesn't populate.  The previous membership custom data doesn't populate (I could live without if not supported under the renewal feature). Am I missing something again?  I looked for any permissions I missed and didn't see any.

A follow-up to this:

Does checking the organization can edit the individual in the relationship settings result in anyone assigned the edit for organization to edit the other individuals within the organization, in techy terms does this relationship create transitive trusts?
-AJ
My GChat - azon21@gmail.com -  This is where you can find me most days!

sandys

  • I post occasionally
  • **
  • Posts: 41
  • Karma: 1
  • CiviCRM version: 4.1.1
  • CMS version: Drupal 6.26
  • MySQL version: 5.0.92
Re: Custom Datasets should membership or contact type
January 31, 2012, 07:27:56 am
Custom data that's placed in the On Behalf of Profile should populate when the profile is used, assuming that everything is set up correctly.  Of course, this would apply to custom data fields that are available to the Organization contact type.  Are you saying that you see the fields, but they are empty? 

Just to double-check, the membership type should be assigned the relationship "Employer Of."  Then, the user (individual contact) filling out the form is assumed to be the "Employee." 

I'm not sure whether any custom fields that you might have assigned to a membership type would populate.

On your follow-up, I don't believe that individuals "employed" by the same organization will be able to edit each other.  I can navigation from my user dashboard to my employer's but, while the organization technically has the ability to edit its employees, when I try to exercise that ability via the dashboard, I get this message:  "This profile is configured for contact type 'Organization'. It cannot be used to edit contacts of other types."   Then again, I have my dashboard links reconfigured to use profiles instead of contact edit forms. 

NASACT

  • I post frequently
  • ***
  • Posts: 289
  • Karma: 9
    • National Association of State Auditors, Comptrollers and Treasurers
  • CiviCRM version: 4.2.2
  • CMS version: Drupal 7
  • MySQL version: 5.1.58 (ubuntu)
  • PHP version: 5.3.5
Re: Custom Datasets should membership or contact type
January 31, 2012, 07:34:22 am
Thanks for the quick response.

Yes the custom fields are blank although they appear correct other than the data is missing.  We will wait and hear about the membership data but I would assume it would be treated the same way since it is a renewal process that is really just updating the membership data, correct? I have both relationships attached to user and the relationship type of employer of.

-AJ
My GChat - azon21@gmail.com -  This is where you can find me most days!

sandys

  • I post occasionally
  • **
  • Posts: 41
  • Karma: 1
  • CiviCRM version: 4.1.1
  • CMS version: Drupal 6.26
  • MySQL version: 5.0.92
Re: Custom Datasets should membership or contact type
January 31, 2012, 08:20:20 am
This may seem obvious, but I'm speaking from personal experience!

Make sure that the custom data you are expecting to see populated in the On Behalf Of profile is populated in the related organization's contact record (and not the individual's contact record).  The On Behalf Of profile will only pull from and record to the Organization record.


NASACT

  • I post frequently
  • ***
  • Posts: 289
  • Karma: 9
    • National Association of State Auditors, Comptrollers and Treasurers
  • CiviCRM version: 4.2.2
  • CMS version: Drupal 7
  • MySQL version: 5.1.58 (ubuntu)
  • PHP version: 5.3.5
Re: Custom Datasets should membership or contact type
January 31, 2012, 09:05:50 am
LOL, I understand completely.  Yes, all the dataset is at the organization level not the individual and all of the fields are placed in "on the behalf of" profile.
-AJ
My GChat - azon21@gmail.com -  This is where you can find me most days!

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: Custom Datasets should membership or contact type
January 31, 2012, 10:22:58 am
I feel like i am seeing this discussion about 'on behalf of' fields not prefilling in to separate threads but can't put my finger on the other one - can you set up an 'on behalf of' on demo and confirm if the fields are prefilling or not
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

NASACT

  • I post frequently
  • ***
  • Posts: 289
  • Karma: 9
    • National Association of State Auditors, Comptrollers and Treasurers
  • CiviCRM version: 4.2.2
  • CMS version: Drupal 7
  • MySQL version: 5.1.58 (ubuntu)
  • PHP version: 5.3.5
Re: Custom Datasets should membership or contact type
January 31, 2012, 11:22:01 am
Sure no problem, I will change this posting when completed.
-AJ
My GChat - azon21@gmail.com -  This is where you can find me most days!

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Custom Datasets should membership or contact type
January 31, 2012, 02:14:55 pm
Would be good to verify if there's a problem w/ existing custom organization data loading into the On Behalf profile. Can you set up a test scenario on the 4.1 sandbox?

http://sandbox.drupal.civicrm.org
Protect your investment in CiviCRM by  becoming a Member!

Pages: [1] 2
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Custom Datasets should membership or contact type

This forum was archived on 2017-11-26.