You are viewing the PKP Support Forum | PKP Home Wiki

Change Submitter

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.

Change Submitter

Postby Lee_bel » Thu Jul 13, 2006 5:46 pm

I'm 'learning the ropes' of OJS as Journal Manager/Editor. A terrific system!

To simplify submission for a set of conference abstracts, we have opted to link submissions through the conference page. This means that I register an author and then login as the author an act as the 'submitter'.

On one submission, I forgot to change my login as the 'author'. This meant that when the author went to look at his submissions (2), it didn't list the one submission I made as submitter, even though he was down as the author.

Therefore, is there any way of editing the submission so that it can be linked to the author as submitter? I couldn't see how to correct the record and tidy the sytem back to reality.


Posts: 2
Joined: Thu Jul 13, 2006 4:50 pm

Postby asmecher » Fri Jul 14, 2006 1:11 am

Hi Lee,

Unless you re-submit the article and start fresh, you'll have to do this in the database. In MySQL:
  • Determine the user ID of the person who should be the submitter.
    Code: Select all
    SELECT user_id FROM users WHERE username = 'username-here';
  • Determine the article ID of the article you want to re-assign:
    Code: Select all
    SELECT article_id FROM articles WHERE title = 'article-title-here';
  • Re-assign the article:
    Code: Select all
    UPDATE articles SET user_id = user_id_here WHERE article_id = article_id_here;
Alec Smecher
Open Journal Systems Team
Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm

Changing a submitter

Postby Lee_bel » Sun Jul 16, 2006 3:47 pm

Thanks Alec

Our sysadmin performed the SQL. I suggest that it would be very helpful in the role of Editor to be able to change the submitter in future versions on the Submission section of the page-

Home > User > Editor > Submissions > # > Review

Thanks again

Posts: 2
Joined: Thu Jul 13, 2006 4:50 pm

Return to OJS Technical Support

Who is online

Users browsing this forum: Exabot [Bot] and 2 guests