HOW-TO: batch renewal subscription

Are you an Editor, Author, or Journal Manager in need of help? Want to talk to us about workflow issues? This is your forum.

Moderators: jmacgreg, michael, vgabler, John

Forum rules
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.
ejsboregas
Posts: 4
Joined: Fri May 20, 2011 6:42 am

HOW-TO: batch renewal subscription

Postby ejsboregas » Tue Nov 27, 2012 7:03 am

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
Posts: 409
Joined: Thu Mar 29, 2007 2:09 pm
Contact:

Re: HOW-TO: batch renewal subscription

Postby michael » Tue Nov 27, 2012 3:32 pm

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
Posts: 4
Joined: Fri May 20, 2011 6:42 am

Re: HOW-TO: batch renewal subscription

Postby ejsboregas » Wed Nov 28, 2012 3:54 am

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


michael wrote: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


Return to “OJS Editorial Support and Discussion”

Who is online

Users browsing this forum: Baidu [Spider] and 1 guest