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) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Renewal Reminders on 4.2
Pages: 1 [2] 3

Author Topic: Renewal Reminders on 4.2  (Read 14215 times)

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Renewal Reminders on 4.2
December 13, 2012, 10:55:17 am
I'll try to clarify things a bit in terms of expected functionality. 4.2 is a transition between two different mechanisms for sending renewal reminders - which I think is adding to the confusion, and the documentation is not complete and evidently has some inaccuracies.

1. Scheduled Reminders for memberships - The doc is incorrect. Reminders are triggered relative to membership type and date points (e.g. 30 days prior to end date, etc.). There is currently no support for reminders based on membership status. I do think the current feature set should cover the majority of use cases - but if you have a use case that isn't covered, we can discuss options / work-arounds.

2. Scheduled Jobs
2.1 Update Membership Statuses and Send Renewal Reminders - This job will continue to be used to keep membership statuses updated (in 4.2 and going forward). In 4.2 it ALSO can send a single membership renewal reminder for membership types that are configured with the deprecated Renewal Reminder Days field AND a Renewal Reminder template. If the membership record has a reminder_date set and that membership type has a reminder template - a reminder s/b sent on or after reminder_date.

In 4.3 this job title is changed to Update Membership Statuses and the reminder functionality is removed.

2.2 Send Scheduled Reminders - This job must be run in order to trigger sending of configured Scheduled Reminders for memberships. It does NOT look at reminder_date field in membership records, but rather checks for the Scheduled Reminder criteria. It logs reminders sent to prevent duplicate reminders, except those which aren't specifically configured in 'Repeat' criteria.

If you've set this up and run 'send_reminders' job and reminders are not being generated, I would check the apache and CiviCRM logs to see if a useful error is being reported.

NOTE: One 'tricky' thing on send_reminders is that there is a 'window' (I think 1-2 days) for matching the reminder criteria (to prevent really stale reminders from going out). Example - a reminder is scheduled for 30 days before Membership End Date. If the job is run 30 or 29 days before a member's end date, the reminder should go out. However if job is not run until 25 days prior to that membership's end date, the reminder is not triggered.

If you're finding
Protect your investment in CiviCRM by  becoming a Member!

edc1

  • I’m new here
  • *
  • Posts: 28
  • Karma: 0
  • CiviCRM version: 4.2.6
  • CMS version: Drupal 6
  • MySQL version: 5.1
  • PHP version: 5.3
Re: Renewal Reminders on 4.2
December 17, 2012, 02:23:24 pm
Hi Dave,

thanks very much for clarifying this. It helped my out a lot. I see from stepping through the code that the civicrm_action_log table is were the state of a reminder is stored, and that's where CiviCRM works out if it needs to send another reminder or not. I certainly understand it all a bit better now.

Thanks again.

Em.

NASACT

  • I post frequently
  • ***
  • Posts: 289
  • Karma: 9
    • National Association of State Auditors, Comptrollers and Treasurers
  • CiviCRM version: 4.2.2
  • CMS version: Drupal 7
  • MySQL version: 5.1.58 (ubuntu)
  • PHP version: 5.3.5
Re: Renewal Reminders on 4.2
December 18, 2012, 08:56:55 am
Hey Dave,

Guess I am still trying to grasp this totally.  Just so we are clear and please correct me when I am wrong:

1. No reminder for membership renewal is sent based on membership status, therefore it with only send a reminder based on the remaining days criteria till expiration and will never send a reminder beyond the date of expiration nor will it send one if the days remaining is less than 1 day variance of the X days to send the reminder (29 days left on a 30 day reminder it will send but will not send one if 31 days or 28 days remain)

2. The Scheduled job "Update Membership Statuses" in 4.3 and beyond is solely for the purpose of updating membership status based on completion of renewal. It therefore relies on the Scheduled Reminders for Memberships job to run post it's run else the reminder may never be sent.

Is that correct?

Thanks.

Also, I would argue that the case where you want a reminder to be sent based on status is of equal importance in that some of us send out a reminder after the expiration of a membership in addition to before expiration including those who haven't renewed in one whole membership cycle as a means to draw constituents back into the membership.  Might be worth blogging about to get a feel if others feel the same as me.  Currently, we don't use the reminder feature because of this very reason.  The Do Not Email opt-out would serve as the control mechanism to flood with reminders and even the repeat reminder could do a + days post expiration. Say hey your membership expired 30 days ago, might want to renew it so you don't lose whatever benefits you had.  Just my two cents worth.
-AJ
My GChat - azon21@gmail.com -  This is where you can find me most days!

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Renewal Reminders on 4.2
December 18, 2012, 10:15:12 am
You can schedule renewal reminders for BEFORE and / or AFTER membership End Date. This means you can create:
* Membership ends in 30 days - scheduled 30 days before end date
* Membership ends in 2 days - scheduled 2 days before end date
* Membership expired 5 days ago - 5 days after end date
* Membership expired 1 year ago days ago - 1 year after end date
etc.

When someone renews, their end date changes - so someone renewing after getting the 30 day reminder would NOT get the 2 day reminder.

NOTE: I'm not sure this is well tested over multiple renewal cycles. If you have resources to extend the existing unit tests, we can help them get started.

Update Membership Status checks to see which memberships need to have their status updated (e.g. New -> Current, Current -> Grace, Grace -> Expired) based on the status rules and membership start and end dates. It only updates membership statuses - does NOT change membership dates. Since the Scheduled Reminders job doesn't care about statuses (only about membership start and end dates) - it shouldn't matter what order these are run.



Protect your investment in CiviCRM by  becoming a Member!

NASACT

  • I post frequently
  • ***
  • Posts: 289
  • Karma: 9
    • National Association of State Auditors, Comptrollers and Treasurers
  • CiviCRM version: 4.2.2
  • CMS version: Drupal 7
  • MySQL version: 5.1.58 (ubuntu)
  • PHP version: 5.3.5
Re: Renewal Reminders on 4.2
December 18, 2012, 10:18:59 am
OK now it makes sense. Thanks for clarifying things. This really helped to understand clearly what does what and based on what criteria.  I have to say I like that design as it accommodates many scenarios. Well done sir and team. As always thank you for taking the time to explain it all.
-AJ
My GChat - azon21@gmail.com -  This is where you can find me most days!

zaal@ohava

  • I’m new here
  • *
  • Posts: 5
  • Karma: 0
  • CiviCRM version: 3.4, 4.2
  • CMS version: Joomla 1.5, Joomla 2.5
  • MySQL version: 5.1
  • PHP version: 5.3
Re: Renewal Reminders on 4.2
December 20, 2012, 11:10:50 am
edit: oops, I posted in the wrong crosspost. Apologies

Hello, I've been having this same problem with Smarty errors in my renewal reminders.

It has to do with running the membership status processor task, and it appears to be failing where it tries to generate a string from my email template. I suspect it is because the membership data tokens are failing in some way, and in fact, when I removed

{membership.end_date} and {membership.type} I was able to run the process and schedule my reminders.

I was hoping to hear from someone who is using the Renewal membership tokens in production and getting them to work.
« Last Edit: December 20, 2012, 11:12:52 am by zaal@ohava »

zaal@ohava

  • I’m new here
  • *
  • Posts: 5
  • Karma: 0
  • CiviCRM version: 3.4, 4.2
  • CMS version: Joomla 1.5, Joomla 2.5
  • MySQL version: 5.1
  • PHP version: 5.3
Re: Renewal Reminders on 4.2
December 31, 2012, 08:32:51 am
So here is something interesting, that may have been silly on my part.
I wanted to have a different renewal mail template for members who were expired vs. haven't expired yet. And the way I did that was by scheduling two different reminders, one for 2 months before expiration, the other for the day of expiration. Well, neither one has been sending out for days.

Membership reminders interfere with each other, don't they? I disabled one of the two reminders and all the renewals went out straightaway. I will have to accomplish this through smarty conditionals in my mail template, wont I?


(Also, I think it's super helpful that the process is generating an activity record to let me know that mails are sending out.)

Yashodha Chaku

  • Forum Godess / God
  • Ask me questions
  • *****
  • Posts: 755
  • Karma: 57
    • CiviCRM
Re: Renewal Reminders on 4.2
January 01, 2013, 05:16:47 am
We 'll investigate this and get back to you on this soon.

-Yashodha
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

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: Renewal Reminders on 4.2
January 02, 2013, 02:02:59 am
zaal@ohava

I think the use case you have described is reasonable and what I expected was possible with these new scheduled reminders? Also, we should definitely be able to use the two tokens you have mentioned, membership type and end date - as these are available to select via insert token.

Also, could you please explain where you are able to see the activity record in order to know what emails are being sent? There does not seem to be any report available, and I cannot see any activity recorded under the Sender's activity tab either? Is this where you meant?

When I execute the Scheduled reminders sender (Daily) Job manually, it says Success (1). However it does not say how many emails have been sent or report on activity in the same way that the Membership Status Job does. I have a feeling that no emails are being sent as yet.

Many thanks if you or Yashodha Chaku can clarify.


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: Renewal Reminders on 4.2
January 02, 2013, 02:33:31 am
Re -  Reporting of new Scheduled Reminders:

To add to the confusion around 'Membership Renewal Reminders' and the new 'Scheduled Reminders', it appears that under the activity tab of the sender of my Scheduled Reminders, the activity is still recorded as a Membership Renewal Reminders rather than a new activity listing of 'Scheduled Reminder'.

Never the less, the emails are being sent, and they do include the membership data tokens.

I am also using one smarty token to print out the date being {$smarty.now|date_format} which used to work on my old Renewal Reminders via the membership method, so I hope they will still be working now. When I view the html email via the activity tab, none of the tokens have data, just the token itself, but this was the same with the old method as well.

CiviRocks!

  • I’m new here
  • *
  • Posts: 29
  • Karma: 0
  • CiviCRM version: 4.4.5
  • CMS version: WordPress 4.1
Re: Renewal Reminders on 4.2
January 02, 2013, 05:43:27 pm
Hi I have 4.2 installed and have a quick question.

Do cron jobs have to be set up for reminder emails to be sent?  I read the documentation and gather that cron jobs do need to be sent, but I'd appreciate clarification.  So far receipt and confirmation emails are working just fine.

If so, I'll have to ask my host to set it up.

Thanks in advance for your response.
CiviRocks!

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Renewal Reminders on 4.2
January 02, 2013, 06:31:05 pm
Yes - you'll need to set up cron jobs to trigger Scheduled Reminder emails (send_reminder Job). If you're using CiviMember you'll also need to trigger the process_membership job. Details here:

http://wiki.civicrm.org/confluence/display/CRMDOC42/Managing+Scheduled+Jobs
Protect your investment in CiviCRM by  becoming a Member!

CiviRocks!

  • I’m new here
  • *
  • Posts: 29
  • Karma: 0
  • CiviCRM version: 4.4.5
  • CMS version: WordPress 4.1
Re: Renewal Reminders on 4.2
January 02, 2013, 06:37:17 pm
Thanks for the confirmation and the link.  I'm going to pass it on to my host.

CiviRocks!

Yashodha Chaku

  • Forum Godess / God
  • Ask me questions
  • *****
  • Posts: 755
  • Karma: 57
    • CiviCRM
Re: Renewal Reminders on 4.2
January 03, 2013, 03:15:18 am
zaal@ohava :

Quote
Membership reminders interfere with each other, don't they? I disabled one of the two reminders and all the renewals went out straightaway. I will have to accomplish this through smarty conditionals in my mail template, wont I?


They shouldn't. I checked on my local install, I created 2 membership reminders one for before expiry and another one after expiry.
The emails are sent to all the respective members for before expiry as well as after expiry.

We 'll be releasing 4.2.7 shorty, I would recommend you upgrade to the lastest Civi and check if that fixes it for you.


HTH
-Yashodha
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

penguintrax

  • I post frequently
  • ***
  • Posts: 230
  • Karma: 2
  • CiviCRM version: 3.3x and 4.x depending on site
  • CMS version: Joomla 1.5 or 1.7 depending on site
  • MySQL version: 5.0.92-community
  • PHP version: 5.2.17
Re: Renewal Reminders on 4.2
January 03, 2013, 09:18:09 am
Yashoda,

Any tips on how to troubleshoot a smarty error in a template? It is preventing the scheduled reminder from being sent at all.

The error message being shown is not verbose and contains no clues whatsoever. I have a thread about it here if you want to take a look.

http://forum.civicrm.org/index.php/topic,27036.msg115884.html

Many thanks in advance.

Pages: 1 [2] 3
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMember (Moderator: Deepak Srivastava) »
  • Renewal Reminders on 4.2

This forum was archived on 2017-11-26.