CiviCRM Community Forums (archive)

I know this is an old topic, but has anyone found a way to update a Drupal role based on a contacts status ?? This is the only thing holder me back from using CiviCRM for a cancer group here in Aus to handle membership signup and then give them access to a newsletter that has Drupal ACL's assigned via a node.

you might want to also check: http://cvs.drupal.org/viewvc.py/drupal/contributions/sandbox/gordon/civicrm_role/

i think one simple rule could be:

reflect a civicrm group as a drupal role. so when a contact is added/removed from a civicrm group, modify the drupal roles table to add/remove that role for the corresponding user (if the contact has an associated user record). This is a bit similar to what we do with organic groups

would be great if someone from the community can make this contribution and/or sponsor its development


lobo

I am not sure that this requires any coding.  There is a screencast of the tac_lite module on Dave Cohen's site:
http://www.dave-cohen.com/node/1170/play

Also civinode should be able to expose civicrm's groups to drupal.  You would then set access permissions using tac_lite based on the civicrm status.

I am not at home to try this out (still in turkey recovery mode), but it seems like it should work. 

If no one else does so, I will try it over the weekend.

you might want to also check: http://cvs.drupal.org/viewvc.py/drupal/contributions/sandbox/gordon/civicrm_role/

i think one simple rule could be:

reflect a civicrm group as a drupal role. so when a contact is added/removed from a civicrm group, modify the drupal roles table to add/remove that role for the corresponding user (if the contact has an associated user record). This is a bit similar to what we do with organic groups

would be great if someone from the community can make this contribution and/or sponsor its development


lobo

I've been looking for someone to update this module for months with no takers - is there anyone here interested?

SB

In another thread they quoted me $4000 - $8000, which we just can't afford, so we opted to go with WildApricot instead

I'm still using civicrm for another project where we don't need the integration

SB

I don't have the time or resources to do this right now, but i would think that the addition of actions to drupal 6 would make this much more trivial if working with that version.

You would need some kind of cron hook which would check the dates on memberships and when they expire call the action which switches the role.

Or this is a better solution actually:
When a user logs in you can do a check on their membership status and use actions to change their role at login as necessary.

I sincerely doubt that it would cost 4,000 dollars to implement that functionality in a drupal module, but who knows.

Drupal 6 integration with actions is definitely a good thing 

Come to think of it, this can be done with the workflow-ng module (and probably workflow module too) on drupal 5. Now you can execute arbitrary php based on a predefined set of conditions.

You would have to select on login, and have the condition be the role that you want, then add an arbitrary php action. Then you would have to code some php using the civicrm api which queries crm_get_contact_memberships($contactID) to get their current membership status.

I don't have time to write out the pseudo code for you, but someone can probably shop this around and get someone to do this much more reasonably.

This is excellent news. It would be great if you would post a short "blog" about his once it's ready for folks to try out - since lots of people have expressed interest. Also, if you haven't already tested your code with the latest 2.0 codebase - we're in alpha and pretty stable - and it would be terrific if the module could be run under 2.0!