CiviCRM Community Forums (archive)

Relationships to Committee / organizations does seem to be the best fit for you. What functionality do you need that this does NOT give you?

BTW - There's been some conversations on replacing/merging the group model with relationships on the blog - http://civicrm.org/node/570. Another approach might be to allow folks to extend group "memberships" with additional properties. However, none of these possible changes are on tap for the short-medium term.

D'oh: Smart Groups!

Create an organization that IS the committee, then create a Smart Group that looks for individuals with a relationship to that organization. Would that work?

Did this work for you?  I tried it but the smart groups seem only to allow emailing, not access control.  My commitees want to have their own drupal forums, so it seems this solution won't do for me.  At the moment I'm looking at creating duplicate static groups and organisations, unless someone has a better idea?

I had to develop a custom search to get the relations of a committee ( we use the household for that and rename them on the translation), so it would take into account every type of relationship. Did I miss something ?

For your static groups, you can develop a program that that sync that you cron regularly, but not sure I understand how having a group is useful for the ACL in a forum.

X+

Yes I want to synchronise groups-roles for forum access, but I am still trying to figure out the best way to do this, both from a drupal and civicrm perspective (I'm new to both).  OGs look promising, but seem overkill, as I don't want self-organising groups and I see lots of people struggling with it in the forums - I also can't really visualise what it gives me.  I experimented with Forum Access and ACL, but there is a module conflict causing an error that is blocking my progress.  My existing prototype forum is in phpbb and yesterday I came across the phpbb integration module, which claims to sync phpbb groups to drupal roles, so I am wondering whether there's a chance I could sync group access across phpbb-drupal-civicrm and save myself the trouble of assembling a new forum.

The main goal is to allow people to subscribe/renew through civicrm, paying online, and get immediate access to members-only areas of the website and forums.  Members of Council and Committees (as defined in civicrm) should be able to access specific private areas.  It would have been nice to do this using a smart group as we discussed before, but if that's not possible it's a compromise we can live with for now.

Any advice would be extremely welcome. I don't mind getting my hands dirty but I'm wary of multiple learning curves sucking away all my time, so I'd prefer to come as close as possible with best practice rather than hack to perfection.

how about:

1. use the civicrm_group_roles to sync static civicrm groups to a drupal role

2. use drupal roles to control permissioning for content and forums

You can potentially enhance civicrm_group_roles to work with smart groups, that would be a great contribution I think it might be easiest done with a periodic cron job

lobo

In case anyone else is interesed in modeling Committees via Households, it looks like in my project we will be doing this too.

I made a small hack (with a colleague's help) to

civicrm/drupal/modules/views/civicrm.views.inc

to expose the field civicrm_relationship.contact_id_b in the Drupal Views UI.

This change allowed me to use Contact ID B for an Argument, to select the members of one Household.

Here's what that section of the file looks like after the change:

$data['civicrm_relationship']['contact_id_b'] = array(
'title' => t('Contact ID B'),
'real field' => 'contact_id_b',
'help' => t('The contact B'),
'field' => array(
          'handler' => 'views_handler_field',
          'click sortable' => FALSE,
          ),
'argument' => array(
             'handler' => 'views_handler_argument',
             ),
'relationship' => array(
                  'base' => 'civicrm_contact',
                  'field' => 'id',
                  'handler' => 'views_handler_relationship',
                  'label' => t('CiviCRM Contact B'),
                  ),
);


(After saving the code change, remember to do Views -> Tools -> Clear Views' Cache)

Now maybe someone can tell me:

Is it possible to override this file without editing the original here?

civicrm/drupal/modules/views/

Harry