HOW-TO: batch renewal subscription

[ejsboregas]

Let me know if there is a way of performing renewal subscription for a set of subscribers at the same time (i.e. subscribers filtered by subscription end date).

Is not there a way of doing that in a single action?

What I'd like to do (as Subscription Manager role) is renewing all the subscriptions that end in an specific date.

TIA, ejsboregas

[michael]

Hi ejsboregas,

There's currently no way of doing this in OJS other than via the 'Renew' link for each subscription record.

If you have direct access to your database, you can manually batch-update all subscriptions records via the following example (to be safe, backup your database before making any changes):

Code: Select all

mysql> UPDATE subscriptions SET date_end = '2013-12-31' WHERE date_end <= '2012-12-31';

The above would set the end date to Dec 31, 2013 for all subscriptions (individual and institutional) that expire on or before Dec 31, 2012.

Cheers,
Michael

[ejsboregas]

Thanks a bunch, Michael... i'll do that.
Edmilson

Hi ejsboregas,

There's currently no way of doing this in OJS other than via the 'Renew' link for each subscription record.

If you have direct access to your database, you can manually batch-update all subscriptions records via the following example (to be safe, backup your database before making any changes):

Code: Select all

mysql> UPDATE subscriptions SET date_end = '2013-12-31' WHERE date_end <= '2012-12-31';

The above would set the end date to Dec 31, 2013 for all subscriptions (individual and institutional) that expire on or before Dec 31, 2012.

Cheers,
Michael