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
The Public Knowledge Project Support Forum is moving to

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.
Posts: 13
Joined: Wed Jun 22, 2005 1:51 am
Location: Denmark

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 to talk about our experience with OJS.

- Mikael K. Elbæk
Copenhagen Business School Library

Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm

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: 352
Joined: Wed Dec 14, 2005 4:15 am

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:
viewtopic.php?f=8&t=5167#p23042 ... ssues.html


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

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

Return to “OJS Technical Support”

Who is online

Users browsing this forum: No registered users and 1 guest