Blocking a user using Rules when membership expires

[juillet19]

I would like to block the associated Drupal user account when a membership expires. I am using Rules and CiviCRM Entity, but can't figure out what data selector to use. I've tried both:

civicrm-membership:contact-id-contact:civicrm-user
civicrm-membership:contact-id-contact:civi-user

but neither of them seem to hold the user ID for the user.

I have the Event and Condition set up as follows and (as a test) when I enter a Drupal user ID in direct input mode, it blocks out that particular user when any membership expires. What I need is the right data-selector so that the associated user is blocked.

Event: CiviCRM Membership has been updated
Condition: Data Comparison: Parameter: Data to compare: [civicrm-membership:status-id], Data value: 4
Action: Block a User: Data Selector: ??

I have seen posts with similar questions but haven't been able to find a solution.
https://www.drupal.org/node/2191085
http://www.jackrabbithanna.com/comment/5#comment-5

Thanks for your help!

[petednz]

hi - a late reply, but can't this be achieved just by using the civimember synch module and setting the 'Role' for expired members to a Role that has no permissions beyond what Anon has?

[flug]

I would like to block the associated Drupal user account when a membership expires. I am using Rules and CiviCRM Entity, but can't figure out what data selector to use. I've tried both:

civicrm-membership:contact-id-contact:civicrm-user
civicrm-membership:contact-id-contact:civi-user

Probably that is giving you the Civicrm contact id, but to change the Drupal permissions you need the Drupal User ID.  You can use a SQL query or (better) API call to figure out the one from the other, using the civicrm uf_match table.  However, i don't think you can do that without having a bit of custom PHP code to pull that value for you.

Probably the way to go is civimember sync module, as petednz says.