OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Changing user status in the system

Are you an Editor, Author, or Journal Manager in need of help? Want to talk to us about workflow issues? This is your forum.

Moderators: jmacgreg, michael, vgabler, John

Forum rules
This forum is meant for general questions about the usability of OJS from an everyday user's perspective: journal managers, authors, and editors are welcome to post questions here, as are librarians and other support staff. We welcome general questions about the role of OJS and how the workflow works, as well as specific function- or user-related questions.

What to do if you have general, workflow or usability questions about OJS:

1. Read the documentation. We've written documentation to cover from OJS basics to system administration and code development, and we encourage you to read it.

2. take a look at the tutorials. We will continue to add tutorials covering OJS basics as time goes on.

3. Post a question. Questions are always welcome here, but if it's a technical question you should probably post to the OJS Technical Support subforum; if you have a development question, try the OJS Development subforum.

Changing user status in the system

Postby ramon » Wed Oct 29, 2003 5:48 am

Dear fellolws,

We have a problem when registering users as Reviewers, then trying to change their status to Board Members (we´ve only tried Editorial Board Members so far)...

What happens in our journal is that the board members are not permanent, and many times reviewers become board members, and after some time, they leave that post, for many reasons.

The problem is that once a reviewer is registered, we cannot use the same user as a Board Member...

We know Board Members are reviewers, but how do we change their status to not being a member and back again, if we need to?

thanks
ramon
 
Posts: 931
Joined: Wed Oct 15, 2003 6:15 am
Location: Brasí­lia/DF - Brasil

Postby kevin » Sat Nov 08, 2003 5:33 pm

If you find you use this often, you may wish to implement some functionality for making reviewers into board members, and vice versa.

To change a board member into a regular reviewer:
Code: Select all
UPDATE tblreviewers SET chReBoard = NULL where nReviewerID = '$reviewer_id'


To change a reviewer into a review board member:
Code: Select all
UPDATE tblreviewers SET chReBoard = 1 where nReviewerID = '$reviewer_id'


To change a reviewer into an editorial board member:
Code: Select all
UPDATE tblreviewers SET chReBoard = 0 where nReviewerID = '$reviewer_id'
kevin
 
Posts: 338
Joined: Tue Oct 14, 2003 8:23 pm

Another Missregistered user

Postby ramon » Fri Mar 19, 2004 2:24 pm

Dear fellows,

I have the following problem (and others like this) in my database: a few users were registered many times, instead of changing the current registered user (same real life person, but with different entries for author, reviewer, etc).. here´s an example:
Code: Select all
nUserID | chUsername | fkAuthorID | fkEditorID | fkReviewerID | fkCopyEdID | fkProofID | fkReaderID | chFirstName | chSurname |
  12    | alvarenga  |    NULL    |     NULL   |     NULL     |     NULL   |    NULL   |    NULL    |    Lidia    | Alvarenga |
  66    | alvarenga1 |    NULL    |     NULL   |      29      |     NULL   |    NULL   |    NULL    |    Lídia    | Alvarenga |
  119   | alvarenga2 |    NULL    |     NULL   |      47      |     NULL   |    NULL   |    NULL    |    Lídia    | Alvarenga |
  167   | alvarenga3 |     82     |     NULL   |     NULL     |     NULL   |    NULL   |    NULL    |    lidia    | alvarenga |


Can I change all the entries in all the tables of the db, so that I would end up with just one user (say change all 29 for 47, and then add it to the one with the fkAuthorID=82)?? will there be any problems??

the only problematic entry is fkReviewerID=47, for it has done reviews.
fkReviewerID=29 has not reviewed anything, even though it did get schedule to it..

then i could delete the repeating entries....and maybe change the username ?? :)

this issue happens with a few other users....

thanks to all
ramon
 
Posts: 931
Joined: Wed Oct 15, 2003 6:15 am
Location: Brasí­lia/DF - Brasil

Postby kevin » Sat Mar 20, 2004 12:42 pm

That could probably work, assuming you update any other tables referencing entries you delete.
kevin
 
Posts: 338
Joined: Tue Oct 14, 2003 8:23 pm


Return to OJS Editorial Support and Discussion

Who is online

Users browsing this forum: No registered users and 0 guests