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
This forum is meant for general questions about the usability of OJS from an everyday user's perspective: journal managers, authors, and editors are welcome to post questions here, as are librarians and other support staff. We welcome general questions about the role of OJS and how the workflow works, as well as specific function- or user-related questions.

What to do if you have general, workflow or usability questions about OJS:

1. Read the documentation. We've written documentation to cover from OJS basics to system administration and code development, and we encourage you to read it.

2. take a look at the tutorials. We will continue to add tutorials covering OJS basics as time goes on.

3. Post a question. Questions are always welcome here, but if it's a technical question you should probably post to the OJS Technical Support subforum; if you have a development question, try the OJS Development subforum.

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: 404
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 4 guests

cron
http://pkp.sfu.ca/support/forum/viewtopic.php?p=36350
pkp.sfu.ca
crawl=CC-MAIN-2014-41
24070
application/http; msgtype=response
sha1:2NNDVYGR2PE5MAESGAOJIMBKIFB7B7VE
<urn:uuid:75f1f0bc-6c92-4f79-9492-cb464e7d4512>
2014-09-20T04:09:09Z
142.58.129.159
sha1:6VY56BKVQ4UTIJP2NDLZPIVJ35MNFXLW
<urn:uuid:356f64cc-13f9-4d1b-a334-2a113a302eeb>
http://pkp.sfu.ca/support/forum/viewtopic.php?p=36350
length
response
<urn:uuid:092f9d91-0a87-4508-9e10-2249516c8b60>
robots: classic
hostname: ip-10-196-40-205.us-west-1.compute.internal
software: Nutch 1.6 (CC)/CC WarcExport 1.0
isPartOf: CC-MAIN-2014-41
operator: CommonCrawl Admin
description: Wide crawl of the web with URLs provided by Blekko for September 2014
publisher: CommonCrawl
format: WARC File Format 1.0
conformsTo: http://bibnum.bnf.fr/WARC/WARC_ISO_28500_version1_latestdraft.pdf