Combine results from two JATOS installs

steffejr

Hello,

I have JATOS running smoothly on a remote server. I did an "on-site" test with my tasks at a community center using several iPads. I used the community center's guest wifi account. It was SUPER slow. My thought is to set up a LAN. Then I can go "on-site" using my laptop as the JATOS server and connect a series of iPads using the router/LAN. I have not tested this yet.

My question is, if I have two installs of JATOS, how can I combine the results? After running "on-site" testing, I want to push all the results to the main server-based JATOS install. I am using MySQL on the laptop and the server.

My first thought would be that this would require a bunch of MySQL coding. Any other ideas?

Thank you,

Jason

kri

Hi Jason!

Sorry for answering so late. I strongly advise against changing JATOS' MySQL via the command line. It's not easy to do and it's likely you break the database.

But having JATOS installed on a laptop and do your field experiment this way is feasible.

My spontaneous idea is to buy a mobile wifi router and use this wifi instead of the slow one from the community center. Then you can use your institute's JATOS server.

Another idea is to combine the result data afterwards, not on the JATOS server, but after exporting from JATOS by using some script language. You'd might need some kind of identifier to align studies and participants.

Hope this helps,

Kristian

steffejr

Hello Kristian,

Thank you for the reply.

These are great ideas. I never thought of the mobile wifi router. And you are absolutely correct that combining exported results after the fact is the most straightforward idea.

That being said, I, of course, like the approach you strongly advise me against! ;) Your warnings are noted.

My initial work demonstrates that, yes, it is not easy. I do have a production server and a development server running. I will work on the development server so I don't break my production server, and I have nightly backups of the SQL dB.

I am more than willing to share anything I make with you if you are interested.

Jason

kri

Hi Jason,

That being said, I, of course, like the approach you strongly advise me against! ;) Your warnings are noted.

It's possible, I guess. I've never done it myself. Just a sketch: You have to export/impost the rows of the tables ComponentResult and StudyResult. And you have take care of the IDs: the ComponentResult.id and StudyResult.id always have to be unique, id you have to change the ids, you also have to change ComponentResult.studyResult_id. You might have to change StudyResult.study_id, StudyResult.batch_id, StudyResult.worker_id, and ComponentResult.componentId too and let them point to the proper objects in your database.

I still think exporting/importing the data directly on the database is not worth the effort and I still recommend doing it afterwards, on the exported result data, in some script. But on the other side why not.

Best,

Kristian