You are viewing the PKP Support Forum | PKP Home Wiki

Reordering the archive: year, vol and number

Are you responsible for making OJS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher

Forum rules
What to do if you have a technical problem with OJS:

1. Search the forum. You can do this from the Advanced Search Page or from our Google Custom Search, which will search the entire PKP site. If you are encountering an error, we especially recommend searching the forum for said error.

2. Check the FAQ to see if your question or error has already been resolved.

3. Post a question, but please, only after trying the above two solutions. If it's a workflow or usability question you should probably post to the OJS Editorial Support and Discussion subforum; if you have a development question, try the OJS Development subforum.

Reordering the archive: year, vol and number

Postby elbaek » Wed Mar 15, 2006 4:38 am


We have been uploading back issues into OJS the hard way, e.g. not using the XML-import facilities but going through the Author – Editor/Review – Layout – Send article to Scheduling process.

The first journal working fine, because I was doing the job myself :) But then I laid out the job for two other journal to more people who chose not to put up the issues and volumes in the same order :shock: . The result:

Vol 14, No 1 (2003)
Vol 14, No 2 (2003)
Vol 14, No 3 (2003)
Vol 14, No 4 (2003)

Vol 15, No 4 (2004)
Vol 15, No 3 (2004)
Vol 15, No 2 (2004)
Vol 15, No 1 (2004)

And the other journal volumes from the same year don’t get listed together.

Vol 6, No 2 (2005)

Vol 3, No 2 (2002)
Vol 3, No 1 (2002)

Vol 1, No 2 (2000)
Vol 1, No 1 (2000)

Vol 2, No 2 (2001)

Vol 6, No 1 (2005)

Vol 2, No 1 (2001)

Can I somehow change the order of numbers and volumes and can I list volumes together years after an issue has been published in OJS?

Is there a reason why the archive isn’t ordered according to Year – Vol – Issue?

Thanks for a great system. Actually I’m going to OA Publishing / Berlin4 http://berlin4.aei.mpg.de/ to talk about our experience with OJS.

- Mikael K. Elbæk
Copenhagen Business School Library
Ejournal@cbs http://ej.lib.cbs.dk
Posts: 13
Joined: Wed Jun 22, 2005 1:51 am
Location: Denmark

Postby asmecher » Wed Mar 15, 2006 10:32 am

Hi Mikael,

Glad to hear OJS is working for you!

Currently, the only way to re-order published issues (aside from deleting and re-publishing them) is via the database. In mysql, you can get a list of issues like this:
Code: Select all
SELECT issue_id, year, volume, number, date_published, SUBSTR(title, 1, 20) FROM issues WHERE published = 1 ORDER BY year, volume, number;
The leftmost column is the issue ID; for each issue, use the following code to set the published dates to the proper values by hand: (The example sets the published date for issue ID 5 to January 25, 2004)
Code: Select all
UPDATE issues SET date_published = '2004-01-25' WHERE issue_id = 5;
This will correct the sorting order.

Alec Smecher
Open Journal Systems Team
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm

Re: Reordering the archive: year, vol and number

Postby mbria » Mon Oct 29, 2012 4:20 am

For those like me that arrive to this old, old post... you will be happy to know that now sorting is easy as a piece of cake:
http://pkp.sfu.ca/ojs/docs/userguide/2. ... ssues.html

Posts: 352
Joined: Wed Dec 14, 2005 4:15 am

Re: Reordering the archive: year, vol and number

Postby springday » Mon Oct 29, 2012 12:51 pm

Oh, there's no doubt to me that OJS is constantly improving :-)


Kai Weber
Posts: 111
Joined: Wed Jul 25, 2012 2:56 pm
Location: Munich, Germany

Return to OJS Technical Support

Who is online

Users browsing this forum: Bing [Bot], Yahoo [Bot] and 3 guests