Is there any way of querying / generating reports from the full database of reviewers? I need stats about reviewers (name, university, rating, and most importantly how many reviews they’ve done over a certain period of time), for a funding application, and it seems all but impossible.
There are two ways I can see of interacting with the database or reviewers:
via the Users & Roles menu - but this only lets you see name, university and e-mail. I can of course see individual reviewers this way, but I do not have the time to check and copy information individually from all 1200+ reviewers we have. This is pretty much useless for what I need.
via Submissions, selecting an active submission, and using the ‘Add Reviewer’ button. This brings up a pop-up which allows you to see potentially every reviewer, it has filters for ratings and numbers of reviews and more, and this seems great, except it only loads up 15 reviewers at a time, and if I press ‘load more’ more than 2 or 3 times, I get another pop-up with:
‘Error. An unexpected error has occurred. Please reload the page and try again.’
This is a completely uninformative error! But what all this tells me is that the information I need is there somewhere, but I can’t get to it. Is there any way of doing so? (And for future development, why can’t the Users & Roles section actually provide more useful output?)
I’m wondering if you could let us know your specific version number, as this is helpful for troubleshooting. If you don’t know how to check your specific version number, please see this post: How do I determine my PKP software's version?
A few more options to potentinally try:
Have you looked at the reporting feature? You might be able to tease information out of it. Statistics → Report → Review report.
This is a report of all the reviews, but would contain any reviewers that were used for the journal - you’d just have to do some filtering and sorting to get at the specific information you’re after.
Also, in version 3.3, you can export users and then identify reviewers: Introduction - but I’m not sure if you’re using 3.3, so you’d have to upgrade, if not, in order to take advantage of this feature.
As for the error you pointed out. In order to determine what is happening here, typically one would have to have a look at the PHP error logs - if you could look for any relevant output on your error log and post here, that would be helpful in diagnosing what might be causing the error.
Thanks for the reply. It’s Version 3.1.2.1, so we don’t have the export users feature. That would be great…
As for the Reviews report, when I first looked at the this, the data looked entirely corrupt and useless - all dates looked like ****** for example. But after a few hours of working on it, I’ve actually got a workable database of reviewers for the period I need. It might not be 100% accurate but it wll do me fine!