Greetings PKP Community -
My "User" (think Tron) posted in to say that she was having trouble with the results from the OCS "Stats & Reports" page, specifically the "Papers Report". I'm offering the results of my testing.
I've take into account that spreadsheet applications may have strange initial behavior when reading csv files, but all results discussed here were confirmed by viewing the downloaded csv both through a current version of Microsoft Excel and a plain text reader (Textedit, OSX).
The csv uses a label titled "Submission ID", this seems to directly correspond to the "paper_id" field used in various tables in the database such as "papers", "paper_settings", and "paper_presenters".
The csv file's "Submission ID" and "Title" do match up with "paper_id" and "paper_settings.setting_value (where setting_name='title')" in the database. I found no cases of inaccuracies there.
The csv file's "Submission ID"/"Title" do not match with personal details of either:
1) The user that submitted the paper (users.first_name, users.last_name),
2) Any presenter associated with that paper (paper_presenters.first_name, paper_presenters.last_name).
I wasn't totally sure if this was supposed to be reporting on who submitted the paper, or who the "authors" were supposed to be. It didn't seem to matter because the results where not accurate for either case.
It seems as though there's a patch for this, though the original impetus for the patch was a very different issue, but I thought the details might help just in case. I'll post in if I have success with the patch.
- Patrick E.
PS - Thanks for checking into the reporting potentialities there Sara! Should hopefully make both our lives easier
Patrick K. Étienne
Digital Library Development
Library and Information Center
Georgia Institute of Technology