Manuscript numbering in OJS

[jrumford]

We are closing down our old database manuscript tracking system and moving to OJS. Our old system supplied a tracking number to each submitted article. This number was carried through as identification for the final published file, location on the site, and eventually, the DOI.

We don’t want to end up with our new documents carrying the same article number as previously published documents. So the last number of our old system might be 1450, and we would want to start the first submitted article in OJS at number 1600.

Is it possible to set the number of the articles? Right now in our test files we have 1-20 files in progress. When we officially open the OJS portal - can we set the first number?

Thanks for any thoughts on this,
Jennifer

[rcgillis]

Hi @jrumford,

This post here: OJS Auto Generated Submission ID number

suggests that this is possible (but only for published content), so that wouldn’t really apply for ones that were being more recently submitted.

Other community members who may have faced this situation and found a solution may wish to comment, though.

-Roger
PKP Team

[jrumford]

All I really need is to be able to set the first number so that is not #1, but something like #1600, and that all incoming manuscripts would fall in line after that as 1601, 1602, etc.

At this time we are only looking at using OJS for our manuscript tracking system, but I want the manuscript numbers to end up being the published numbers.

Thanks,
Jennifer

[asmecher]

Hi @jrumford,

You can do this in MySQL; there are details in StackOverflow e.g. here:

https://stackoverflow.com/questions/1485668/how-to-set-initial-value-and-auto-increment-in-mysql

The ID in question is the submission_id column in the submissions table.

Regards,
Alec Smecher
Public Knowledge Project Team