OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



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.

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

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

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


Return to OJS Editorial Support and Discussion

Who is online

Users browsing this forum: No registered users and 1 guest