Author Topic: Membership renewal reminders - Employer of problems (Read 623 times)

chriscant · January 25, 2013, 10:29:12 am

We've switched to use Scheduled Reminders now we're on 4.2.6.

One type of member is receiving (a) two reminders and (b) reminders after they have renewed.

For this membership type, an individual makes a payment for an organisation (Membership type: Relationship Type Employer of)
There seems to be membership records for both the individual and the organisation.

For such a case:
For the organisation membership record the reminder_date is set, eg to 2013-12-04
For the individual membership record the reminder_date is NULL

I've read "When renewal reminders are sent, the member's reminder date field will be set to NULL in the database and on screen. When the membership is renewed, the field is populated with the updated renewal reminder date."

My guess is that the individual membership record is not being set when the membership has been paid.

Does that sound like what is going on?

The most pressing problem is sending reminders after they have paid.
Stopping sending two each time would be good as well.

Is there a fix?

Thanks Chris

chriscant · January 28, 2013, 04:57:58 am

OK - this is probably more like what is happening...

I think it's a problem with repeat reminders.

As far as I can tell, ActionSchedule.php doesn't use the membership reminder_date field at all.

My repeat reminder is sent out if
- the date is more than the required time interval since the last reminder and
- the date is less than the membership end date.
(If the person has re-joined then the end date has gone forward a year.)
So there's nothing to stop repeat reminder from being sent out if someone has renewed.

Even if the membership reminder_date is factored in, I can see a problem in subsequent years as the civicrm_action_log entry from the previous years will still be present.

Does this sound right?

I've disabled my repeat reminders for now.

Chris

Example $sqlInsertValues when is_repeat set:

Code: [Select]

SELECT e.contact_id as contact_id, e.id as entity_id, 'civicrm_membership' as entity_table, 
	2 as action_schedule_id, MAX(reminder.action_date_time) as latest_log_time 
FROM civicrm_membership e 
INNER JOIN civicrm_contact c 
ON c.id = e.contact_id 
INNER JOIN civicrm_action_log reminder 
ON reminder.contact_id = e.contact_id AND reminder.entity_id = e.id AND 
	reminder.entity_table = 'civicrm_membership' AND reminder.action_schedule_id = %1 
WHERE e.membership_type_id IN (7) AND c.is_deleted = 0 AND '20130128123309' <= DATE_SUB(e.end_date, INTERVAL 0 day) 
GROUP BY reminder.contact_id, reminder.entity_id, reminder.entity_table 
HAVING TIMEDIFF(20130128123309, latest_log_time) >= TIME('504:00:00')

Yashodha Chaku · January 29, 2013, 04:54:53 am

chriscant :

We 'll investigate and get back to you on this.

-Yashodha

CiviCRM Community Forums (archive)

News:

Author Topic: Membership renewal reminders - Employer of problems (Read 623 times)

chriscant

Membership renewal reminders - Employer of problems

chriscant

Re: Membership renewal reminders

Yashodha Chaku

Re: Membership renewal reminders - Employer of problems