Author Topic: Auto update membership status Active t Expired after end_date of the Membership. (Read 2924 times)

gurukmlore · February 07, 2012, 10:54:37 pm

Hello,

I experiencing a issue, I had 900 'Active' members in 2011 (my rollover is Jan 1 to Dec 31).
Year passing to 2012 the Active members should be updated as Expired who is not paid for 2012 or once the contribution is added then only the members are 'Active', But my case all the members are showing as 'Active' and the event_end date is 31-12-2011.

For updating the membership status from Active to Expired the cron job 'UpdateMembershipRecord.php' will do?, I tried to do, but in my case its not done.
I am goggling from 2 days but no solution I got

.

Or I need to do manually by updating through backend or using Profiles.

Or anywhere I am missing to configure automatically membership status update after year pass in the system.

Thanks in advance.

e_mason · February 10, 2012, 06:10:24 am

Per Kurund in another post:

Quote

You need to run UpdateMembershipRecord script in order to update your membership statuses. Check this link on how to set this script: http://wiki.civicrm.org/confluence/display/CRMDOC40/Command-line+Script+Configuration

Or, in short, you need to have cron configured to run that script on a regular (e.g. daily) basis.

TwoMice · February 13, 2012, 02:10:23 pm

Quote

For updating the membership status from Active to Expired the cron job 'UpdateMembershipRecord.php' will do?, I tried to do, but in my case its not done.

gurkmlore, does the update script (UpdateMembershipRecord.php) seem to be changing status on any records and just leaving some unchanged, or is it failing to change them all?

Also, what is the script outputing? It should be giving output something like this:
Updating ..... Membership records updated. (Done)

Oddly, I have a client installation with similar behavior:

Several memberships have end dates in the past, status is Current, status override is false. Running UpdateMembershipRecord.php appears to have run properly, but status on these membership records doesn't change.

Interestingly, these records exhibit some patterns, but I'm not sure if they're relevant:
The membership is of a disabled type
OR
The membership is of a type having a duration of 1-year and rolling period, AND the start_date is less than one year in the past (meaning, someone manually entered an end_date that's less than a year after the start_date).

I'm not sure if either of these things matter.
I'm also looking for recommendations on where I can investigate more to find out why these records are being skipped.

Any suggestions?

- Allen

Lionsharz · December 15, 2014, 06:31:04 am

Bit of an old thread but I have the very same issue and I've just been putting up with it since 2013. If I manually edit the User's record (where Status Override is off) and just click save the system will update the Membership Status just fine.

However running the update scripts manually and through cron fails to update the records and no memberships status is changed to Expired, even though the end dates are way in the past. I'm sure the individual Status Rules are working ok as they function after a manual save. its the script firing that lets us down.

Any hints?

Thanks!

CiviCRM Community Forums (archive)

News:

Author Topic: Auto update membership status Active t Expired after end_date of the Membership. (Read 2924 times)

gurukmlore

Auto update membership status Active t Expired after end_date of the Membership.

e_mason

Re: Auto update membership status Active t Expired after end_date of the Membership.

TwoMice

Re: Auto update membership status Active t Expired after end_date of the Membership.

Lionsharz

Re: Auto update membership status Active t Expired after end_date of the Membership.