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) »
  • Alpha and Beta Release Testing »
  • 4.5 Release Testing »
  • Scheduled Reminder for Org memberships not sent to permissioned individuals
Pages: [1]

Author Topic: Scheduled Reminder for Org memberships not sent to permissioned individuals  (Read 1817 times)

Upperholme

  • Administrator
  • Ask me questions
  • *****
  • Posts: 568
  • Karma: 8
    • MC3
  • CiviCRM version: 4.x
  • CMS version: Drupal 6.x/7.x, Wordpress, Joomla
Scheduled Reminder for Org memberships not sent to permissioned individuals
September 18, 2014, 08:27:19 am
Further to this discussion thread - http://forum.civicrm.org/index.php/topic,33926.0.html I checked the issue tracker and found https://issues.civicrm.org/jira/browse/CRM-11342 which pretty clearly indicates that this functionality  - where a scheduled reminder for a membership will be sent to the email address(es) of permissioned individual(s) in the case where the member is an organisation - was up and running in version 4.2.7 (and very likely earlier).

This functionality is critically important in enabling membership retention where organisations are members. As is indicated by the linked forum thread this functionality appears to have been lost in recent times. I've tested for it in 4.4.7 and 4.5beta9 and couldn't get ti to work - the scheduled reminder just gets sent to the email address of the organisation record, and nothing is getting sent to any individual, whether linked by a permissioned relationship, or otherwise. However as the feature is not discussed in the documentation it is possible that I've not configured my tests correctly.

It would be fabulous to get this feature back in 4.5.
Graham Mitchell
http://mc3.coop

nae

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
    • Play Australia
  • CiviCRM version: 4.4.7
  • CMS version: Drupal 7.31
  • MySQL version: 5.1
  • PHP version: 5.3
Re: Scheduled Reminder for Org memberships not sent to permissioned individuals
September 25, 2014, 10:04:24 pm
Hi Upperholme,
We are the client of Pete's from Fuzion agency in NZ  - Pete mentioned we were doing some testing in the thread that you linked to.
So far I have had success on  4.4.7 in setting this up in the way you describe, with the email being sent to the individual who has the permissioned relationship. We do not have any email addresses associated with our Organisational records, so the email could not be sent there, but so far, I have had the permissioned relationship contact receive the shceduled reminder letter, while the other members of the org do not.
However I am testing this again and will report back, as we want to be sure this is going to work before we change all of our memberships to this new system. Currently we have the membership located on the 'member representative' individual contact of the Org, but we wish for the Org record to now hold the membership so we can take advantage of the related members feature.
I am expecting another renewal reminder to be sent in the next 24 hours so will confirm if it comes through.
Renaee.

Upperholme

  • Administrator
  • Ask me questions
  • *****
  • Posts: 568
  • Karma: 8
    • MC3
  • CiviCRM version: 4.x
  • CMS version: Drupal 6.x/7.x, Wordpress, Joomla
Re: Scheduled Reminder for Org memberships not sent to permissioned individuals
September 25, 2014, 11:31:52 pm
Hi Renaee
Many thanks for taking the time to report your findings. I'm not clear from what you've written whether your memberships are associated with the organisational record or the permissioned individual?

Looking at the comment from Dave Greenberg on the issue linked to in this thread (https://issues.civicrm.org/jira/browse/CRM-11342) it appears that my experience - i.e. that this doesn't work as it should - is confirmed, so maybe Fuzion are providing you with a specialised version that is not showing this problem.
Graham Mitchell
http://mc3.coop

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: Scheduled Reminder for Org memberships not sent to permissioned individuals
September 25, 2014, 11:37:56 pm
ha ha - not this time - or not yet afaik

renaee - can  you please clarify - were you testing on Memberships that are being inherited via a relationship?
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

nae

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
    • Play Australia
  • CiviCRM version: 4.4.7
  • CMS version: Drupal 7.31
  • MySQL version: 5.1
  • PHP version: 5.3
Re: Scheduled Reminder for Org memberships not sent to permissioned individuals
September 27, 2014, 03:59:28 am
Ok - will do my best here to convey what we are trying to do and what I think I have confirmed works and what does not at this stage, but it is still in progress....

The first time I did get this to work was when I had is set up as follows.

Membership type of example 'MetroCouncil' was attached to an Organisational record called 'TestCouncil' (to answer your question, they are not on the individual contact record in this test)

There were two staff members of TestCouncil who had an inherited or related membership based on their employment with TestCouncil. (as set up in the membership type)

One of the members - memberA, had a Permissioned Relationship which enabled them to edit TestCouncil Org and for TestCouncil Org to edit them.

I set up a scheduled reminder to go 1 day before membership end date.

I then set up a Smart Group, with the following search criteria:

Employee of ...AND...
Relationship - Active and Current ...AND...
Relationship - Permissioned ...AND...
Membership Type = MetroCouncil

This search returned only the member with the permissioned relationship as expected. So I saved the result of this search for use in the scheduled letter.

I went into the Scheduled letter and in the 'recipients' area I put Limit to and Select From Group and then I selected my saved Smart group called MetroCouncilTest.

This sent a renewal reminder to only MemberA and not to the Org TestCouncil and not to the other related member either.

So this was the first test and is the method that does work.

based on the comments in the previous thread I thought the step of creating the smart group was unnecessary and it would send it to the permissioned related member by default, but based on the test I did last night, which did not return a result, ie no reminders were sent at all (as we do not have email addresses on our Org Records) then I think that this shows that it does not work in this way.

I hope this clarifies and it would be great if you could test this method too as a way to confirm. I am going to do it another time with a different membership type just to be sure.

Renaee.


nae

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
    • Play Australia
  • CiviCRM version: 4.4.7
  • CMS version: Drupal 7.31
  • MySQL version: 5.1
  • PHP version: 5.3
Re: Scheduled Reminder for Org memberships not sent to permissioned individuals
September 27, 2014, 04:19:08 am
I also wanted to add that when we use this for our live site, we have around 45 MetroCouncil memberships so the smart group would include this number of permissioned, related members. The way I hope it will work, is if their membership falls into the 2 weeks before End Date criteria, and they are also included in the smart group of recipients, then they will get the automatically sent emailed invoice asking them to pay without us having to do anything else. Also when ever we get a new membership sign up, they will be added automatically to this smart group too based on them being the permissioned member.

This system would have to be set up for each of our membership types that are based on employer/employee relationship.

nae

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
    • Play Australia
  • CiviCRM version: 4.4.7
  • CMS version: Drupal 7.31
  • MySQL version: 5.1
  • PHP version: 5.3
Re: Scheduled Reminder for Org memberships not sent to permissioned individuals
October 26, 2014, 04:14:20 pm
#upperholm and #petednz
I wanted to let you know that we are now using Memberships on the organisational record for our larger membership types, with the permission relationship of Employer/Employee and with one person from the org having the special permissions to update the org record and the org record to update them.

Renewal reminders via the scheduled letters are starting to be sent, and what is happening is that a reminder is being sent to the Org record AND the permissioned member.

There has been no need to use smart groups.

So it seems that it was not neccesary for me to have copied the email address and the physical address onto the Org record, as the reminder would have been sent to the nominated member rep anyway.  :(

Any questions about this let me know.
Renaee.


Upperholme

  • Administrator
  • Ask me questions
  • *****
  • Posts: 568
  • Karma: 8
    • MC3
  • CiviCRM version: 4.x
  • CMS version: Drupal 6.x/7.x, Wordpress, Joomla
Re: Scheduled Reminder for Org memberships not sent to permissioned individuals
November 05, 2014, 11:57:31 pm
Hi Renaee

Many thanks for posting this information. I hadn't considered the possibility of using a smart group to handle the scheduled reminder - that's really interesting.

In your most recent post you state that the expected behaviour is now working (nearly) without the need to use a smart group. As far as I understand it what happens is dependent upon which version of CiviCRM is running. The issue at https://issues.civicrm.org/jira/browse/CRM-11342 shows that this is fixed in 4.5.1, and also 4.4.9. If you use one of these versions I think the org record should not receive the reminder, but the permissioned employee/s will, and you won't need to use the neat smart group workaround.
Graham Mitchell
http://mc3.coop

nae

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
    • Play Australia
  • CiviCRM version: 4.4.7
  • CMS version: Drupal 7.31
  • MySQL version: 5.1
  • PHP version: 5.3
Re: Scheduled Reminder for Org memberships not sent to permissioned individuals
November 06, 2014, 01:48:20 am
Hi Graham - we are on 4.4.9 and it is definitely going to both the Org record and to the permissioned relationship. I don't know if this is unexpected behaviour but it is not really a problem for us. Mostly we have the billing address on the Org record as the same email as the primary rep with the special permission, but sometimes it is a different billing address so I am quite happy with it being sent to both, as we operate with one person from that org being responsible for contacting their finance dept and getting it paid.

No other employees are getting it either which is the main problem on the earlier versions.

Upperholme

  • Administrator
  • Ask me questions
  • *****
  • Posts: 568
  • Karma: 8
    • MC3
  • CiviCRM version: 4.x
  • CMS version: Drupal 6.x/7.x, Wordpress, Joomla
Re: Scheduled Reminder for Org memberships not sent to permissioned individuals
November 06, 2014, 01:57:09 am
You're right. I just re-read the thread in the issue: the org record will get a reminder as well as any permissioned employees.
Graham Mitchell
http://mc3.coop

nae

  • I post occasionally
  • **
  • Posts: 36
  • Karma: 0
    • Play Australia
  • CiviCRM version: 4.4.7
  • CMS version: Drupal 7.31
  • MySQL version: 5.1
  • PHP version: 5.3
Re: Scheduled Reminder for Org memberships not sent to permissioned individuals
November 09, 2014, 03:02:15 pm
Yep - and turns out this is not what we need after all! as we use the civi ID number to make up unique invoice numbers in our renewal reminder invoices for membership, so now they are getting two invoices with 2 different numbers, so I am going through and deleting the email addresses off the org record - live and learn, just posting this in case it helps anyone else out in the same boat.
Renaee.

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: Scheduled Reminder for Org memberships not sent to permissioned individuals
February 28, 2015, 02:11:30 pm
I tried re-reading this slowly. The summary i get from what both of you say is if
- membership belongs to Org
- there is no 'inheritence' happening
- individual has permissioned relationship to org
- scheduled reminder is set up to go out to those with Org membershiip
then
- the org will get a reminder assuming they have an email
- the permissioned individuals will also get the reminder

This is not happening in the scenario i am testing on 4.4.11

All i see is a reminder going to the 'club'
Am I still misreading this? Does one of you have the above working
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

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Alpha and Beta Release Testing »
  • 4.5 Release Testing »
  • Scheduled Reminder for Org memberships not sent to permissioned individuals

This forum was archived on 2017-11-26.