Exclusive ID

[jamilatta]

Hi everybody,

We have developed in our old version a feature to mask the IDs of each evaluation process inserted in the OJS. This mask intends to present to each journal their own sequence of ids for each job. This development was a demand of the SciELO Journal (www.scielo.br/www.scielo.org) editors to facilitate the identification of each job not only for their content but through a sequential number.

We intend to keep this development in the new version once the editor consider this feature important to control their workflow. But to transfer and keep this development we would like to accomplish this in a sustainable way and incorporating it in the new version of OJS.

As we do not intent to keeping a different version from OJS, we would like to develop this feature together and with your consent and the PKP community.

This development consists in a new table in OJS database to create a multiple key with the original OJS ID, journal ID, mask ID for each job.

The development of this feature in the old version is on: git@github.com: scieloorg / Submission.git

We'd like to discuss the best way to implement this feature in the newer version of OJS.

Thanks,

SciELO Team.

[asmecher]

Hi all,

Here's a couple of paragraphs from an email discussion about the same feature:

Rather than introducing a new table, I'd suggest adding a new column to the articles table. You may be able to use database sequences to have a journal-unique ID created automatically on insert, though it'll be a little bit tricky to do this in a way that'll work for both PostgreSQL and MySQL (which would be required for us to distribute it as part of OJS).

Then, to separate the internal IDs from the presentation IDs, I'd suggest introducing a new function to lib/pkp/classes/submission/Submission.inc.php called getPresentationId(). On standard installations, it would call getId and return the result. On your installation, it would get the alternate ID.

Regards,
Alec Smecher
Public Knowledge Project Team