Hello
a reviewer “forgot” to upload the files which contain the notes to the article submitted. Unfortunatelly she entered her recommendation. Is there a way for the editor to re-open the process so that the reviewer can upload her file?
The only way to do this is by editing the review assignment in the database. Alternately, you could create a new round of review, assign the reviewer to it, and request them to re-review the submission.
Regards,
Alec Smecher
Public Knowledge Project Team
If you are comfortable with SQL, you can access your database from a command line client, or from a tool such as phpMyAdmin. In the OJS database, you’ll find a review_assignments table, which describes the status of each review assignment as:
Yes I already came to this view using phpMyAdmin. But what to change in this database if I want to, as Editor or Journal manager or login as Reviewer, upload a forgotten file on behalf reviewer.
The second step is to upload the file where OJS will look for it: For the above mentioned submission ID 124, the file has to be placed into ojs_files/journals/<journal_id>/articles/124/submission/review/124-1192-1-RV.pdf.
The third step is to set reviewer_file_id in review_assigments table to the file ID, i.e. 1192.
I am only guessing on some values of the record, luckily for the same article this was the second review with a file attached so I have simply copied info from the other attached review file. I have no clue whether the file_stage value is correct, for the first review round both the reviewed article version and the first attached review file the file_stage is set to 2, for the second review round the review article version has that value set to 3. I have no time to check the sources now, so be warned that my changes could have introduced an inconsistency that could cause problems when upgrading to new OJS version.