OJS OCS OMP OHS

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
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.

Reordering the archive: year, vol and number

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

Hi

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:


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


2004
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.

2005
Vol 6, No 2 (2005)

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

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

2001
Vol 2, No 2 (2001)

2005
Vol 6, No 1 (2005)

2001
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
elbaek
 
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.

Regards,
Alec Smecher
Open Journal Systems Team
asmecher
 
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:
viewtopic.php?f=8&t=5167#p23042
http://pkp.sfu.ca/ojs/docs/userguide/2. ... ssues.html

Cheers,
m.
mbria
 
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 :-)

Cheers,

Kai Weber
springday
 
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], Google [Bot] and 2 guests

cron