Export review form results to csv/xml

Software Support
1

Hi,
I’d like to export the results of the review forms of the submission to csv or xml to do data analysis.

I tried with the rest api with no success (same problem as in While iam calling ojs submissions API got Class 'Application' not found error)

Also been doing some google search and I found this post OCS - How to obtain review form results which is’nt very helpful.

I tried to do a mysql query to obtain the data, but it seems like the answers aren’t stored, only the position of the answers in the options array.

Here is the query I tried using and the results:

SELECT ra.submission_id as Submission, ra.review_id as Review, rfes.setting_value as Question, rfr.response_value as Answer
FROM review_form_responses rfr, review_assignments ra, review_form_element_settings rfes
WHERE ra.review_id = rfr.review_id
AND rfr.review_form_element_id = rfes.review_form_element_id
AND rfes.setting_name = “possibleResponses”;

imagen
imagen1321×240 10.4 KB

I’m using OJS 3.3.0.14

Thank you for your help!!

2

Take a look to this post:

Cheers,
m.

1 Like
3

Thank you for your help. But I think this does’nt really help me.
What I really need is the data form this form.

imagen
imagen1175×999 33.3 KB

You can see that form when you click on “Read Review”

imagen
imagen936×864 30.3 KB

I need to export that info into a CSV or xml or some format that I can import in Excel

Thank you!

4

Sorry Manuel,

I missunderstood you.
Then, I think only PKP devs could answer you question.

Cheers,
m.

1 Like
5

Till we wait for their feedback, you will probably like to take a look to this:
https://docs.pkp.sfu.ca/dev/database/ojs/3.4/

This document it’s for 3.4 only… but you can run schemaspy (or any other alternative) over your DB to understand the relationships.

2 Likes
6

@manuel_uib did you manage to find the tables you were looking for?