Saving jsPsych data to a web server using PHP
You can save the aggregated data to Qualtrics, but you may also want to look at the trial-level data for further analysis. If you have access to a web server that can run PHP, then you can save each participant's data as a CSV or JSON file on the server.
Step 0. Get access to a web server
Your institution usually provides you a free access to a web server, so that you can run your personal web site. If you are not familiar with web servers and PHP, please please ask your IT professional for help. They almost always can HELP you! Also look for resources like below.
Step 1. Go into the public_html
directory
If you have gained the access to a web server, login to the server and go to the public_html
directory. If you are not sure, please read this page first: Prerequisites for hosting web content on your account/how to setup your first PHP page.
Reading this linux command cheatsheet can also help.
$ cd ~/public_html
Step 2. Set up the directories for saving experiment files
Let's create a directory called exp_data
, which will host necessary files and serve as a parent directory for your experiments by running three separate commands one-by-one.
This command makes a directory called exp_data
:
$ mkdir exp_data
This command moves you into the exp_data
directory:
$ cd exp_data
This command shows you where you are. So you should see something like /home/<your-account>/public_html/exp_data
:
$ pwd
This command prevents others from seeing inside exp_data
by creating an empty index html file:
$ touch index.html
This command makes sure that index.html
hides the directory structure
(for details of .htaccess
, see http://www.htaccess-guide.com/directoryindex-uses/)
$ echo "DirectoryIndex index.html" >> .htaccess
Step 3. Create the save_data.php
Let's create the PHP file that will receive and save your data by using vi
. If you are not familiar with vi
,
please read this guide for using the vi editor.
This command will open an vi editor and let you edit it:
$ vi save_data.php
Copy-paste the below PHP code and save, then you are done with this step:
<?php
// WARNING: the below config can cause a serious security issue.
// Please read https://portswigger.net/web-security/cors/access-control-allow-origin
// Once you are done testing, you should limit the access
//header('Access-Control-Allow-Origin: https://ssd.az1.qualtrics.com');
header('Access-Control-Allow-Origin: *');
// NOTE: the below code expects three fields and will NOT work if any of these is missing.
// - data_dir: specify the server directory to store data
// - file_name: specify the filename of the data being saved, which can include subject id
// - exp_data: contain the full json/csv data to be saved
if (isset($_POST['exp_data']) == false) {
echo('Hello');
exit;
}
$exp_data = $_POST['exp_data'];
/* prevent XSS: */
$_POST = filter_input_array(INPUT_POST, FILTER_SANITIZE_STRING);
if (isset($_POST['data_dir']) == true)
{
$data_dir = $_POST['data_dir']; // data directory
} else { exit; }
if (isset($_POST['file_name']) == true)
{
$file_name = $_POST['file_name']; // mturk_id
} else { exit; }
// write the file to disk
// NOTE: you must make the data directory by all users
// For example, by running `chmod 772` to give a write access to EVERYONE
file_put_contents($data_dir.'/'.$file_name, $exp_data);
exit;
?>
Your save_data.php
url will look like https://<server-url>/~<your-account>/exp_data/save_data.php
, like my url -- https://users.rcc.uchicago.edu/~kywch/exp_data/save_data.php. Note that the exp_data/save_data.php
part should be the same if you followed the above steps.
If your script is running, you will see Hello in your browser.
Step 4. Make an experiment directory
The above PHP script requires the experimenter to specify data_dir
, in which experiment files are saved.
Here, let's create a folder called hello-world
under exp_data
and save files there.
Make sure that you are in the exp_data
folder with pwd
.
This command makes a directory called hello-world
:
$ mkdir hello-world
You also need to adjust this directory's permission so that the PHP script can save files. To learn more about permissions, see this page: http://linuxcommand.org/lc3_lts0090.php.
This command allows the PHP script to write files in the hello-world
directory, while preventing other people from seeing inside:
$ chmod 772 hello-world
Step 5. Add the save function to the experiment HTML script
The server side work is done. Now, you need to add scripts to send the result file when an experiment session is done.
The experiment-with-display-element-save-php.html
file in this GitHub repository contains three additional changes from experiment-with-display-element.html
. When you open experiment-with-display-element-save-php.html
in a browser, you should see the same "Hello world!".
In addtion, you will find new json and csv files under hello-world
when you put correct url of save_data.php
below.
We start from experiment-with-display-element.html
, which you can see from the Hello World! tutorial. Let's look at these additional change.
Change 4: Defining necessary variables for saving the results
The above save_data.php
expects three fields -- data_dir
, file_name
, and exp_data
-- and will NOT work if any of these is missing.
data_dir
specifies the server directory to store data. You may want to includetask_name
in the directory name.file_name
specifies the filename of the result file. You may want to include the subject id.exp_data
contains the full json/csv data to be saved.
You need to replace save_url
with your save_data.php url.
// experimental session-defining variables
var task_name = "hello-world";
var sbj_id = "test01";
// you must put your save_data php url here.
var save_url = "https://users.rcc.uchicago.edu/~kywch/exp_data/save_data.php";
var data_dir = task_name;
// my preference is to include the task and sbj_id in the file name
var file_name = task_name + '_' + sbj_id;
Change 5. Defining save functions using jQuery
Qualtrics loads jQuery
by default, so you can use jQuery
for saving files.
However, this html script must load jQuery
library to use the save function.
<script src='https://ajax.googleapis.com/ajax/libs/jquery/2.2.4/jquery.min.js'></script>
You can use either the JSON or CSV format, whichever convenient for you. The save functions look like this.
function save_data_json() {
jQuery.ajax({
type: 'post',
cache: false,
url: save_url,
data: {
data_dir: data_dir,
file_name: file_name + '.json', // the file type should be added
exp_data: jsPsych.data.get().json()
}
});
}
function save_data_csv() {
jQuery.ajax({
type: 'post',
cache: false,
url: save_url,
data: {
data_dir: data_dir,
file_name: file_name + '.csv', // the file type should be added
exp_data: jsPsych.data.get().csv()
}
});
}
Change 6: Sending the results file upon completion
The on_finish
callback can be declared in the jsPsych.init
method.
For details, see the original jsPsych v6.3 tutorial.
The callback will trigger once all trials in the experiment have been run, so it is a great place to call save functions.
NOTE: Here, both save_data_json()
and save_data_csv()
were called to show how these can be used. Choose one.
jsPsych.init({
timeline: [hello_trial],
display_element: 'display_stage',
/* Change 6: Sending the results file upon completion */
on_finish: function() {
save_data_json();
save_data_csv();
}
})
Putting it all together
So the experiment-with-display-element-save-php.html
code looks like this. This html file should save the result files to your server.
<!DOCTYPE html>
<html>
<head>
<title>My experiment</title>
<!-- Change 5: Defining save functions using jQuery -->
<script src='https://ajax.googleapis.com/ajax/libs/jquery/2.2.4/jquery.min.js'></script>
<script src="jspsych-6.1.0/jspsych.js"></script>
<script src="jspsych-6.1.0/plugins/jspsych-html-keyboard-response.js"></script>
<link href="jspsych-6.1.0/css/jspsych.css" rel="stylesheet" type="text/css">
</link>
</head>
<body>
<!-- Change 3: Adding extra scripts for Qualtrics -->
<!-- COPY PASTE TO QUALTRICS FROM HERE -->
<link href="https://kywch.github.io/jsPsych/css/jspsych.css" rel="stylesheet" type="text/css">
</link>
<div>
<span style="font-size: 24px;">
<br><br>
If you are seeing this message for <span style="color: rgb(255, 0, 0);"><b>more than 5
minutes</b></span>,<br>
please screen-capture this screen and send the image to us.
<br><br>
<span style="font-size: 28px;">We are very sorry for the inconvenience.</span>
</span>
</div>
<!-- Change 2: Adding `display_stage` CSS and Div -->
<style>
#display_stage_background {
width: 100vw;
background-color: white;
z-index: -1;
}
#display_stage {
position: fixed;
left: 1vw;
top: 1vh;
height: 98vh;
width: 98vw;
background-color: white;
box-shadow: 1px 1px 1px #999;
border-radius: 15px;
z-index: 0;
overflow-y: hidden;
overflow-x: hidden;
}
</style>
<!-- COPY PASTE TO QUALTRICS UP TO HERE -->
<div id='display_stage_background'></div>
<div id='display_stage'></div>
</body>
<script>
/* Change 4: Defining necessary variables for saving the results */
// experimental session-defining variables
var task_name = "hello-world";
var sbj_id = "test01";
// you must put your save_data php url here.
var save_url = "https://users.rcc.uchicago.edu/~kywch/exp_data/save_data.php";
var data_dir = task_name;
// my preference is to include the task and sbj_id in the file name
var file_name = task_name + '_' + sbj_id;
/* Change 5: Defining save functions using jQuery */
function save_data_json() {
jQuery.ajax({
type: 'post',
cache: false,
url: save_url,
data: {
data_dir: data_dir,
file_name: file_name + '.json', // the file type should be added
exp_data: jsPsych.data.get().json()
}
});
}
function save_data_csv() {
jQuery.ajax({
type: 'post',
cache: false,
url: save_url,
data: {
data_dir: data_dir,
file_name: file_name + '.csv', // the file type should be added
exp_data: jsPsych.data.get().csv()
}
});
}
var hello_trial = {
type: 'html-keyboard-response',
stimulus: 'Hello world!'
}
/* Change 1: Using `display_element` */
jsPsych.init({
timeline: [hello_trial],
display_element: 'display_stage',
/* Change 6: Sending the results file upon completion */
on_finish: function() {
save_data_json();
save_data_csv();
}
})
</script>
</html>
Step 6. Add Participand ID to Qualtrics
Let's log in to Qualtrics. The basics of embedding jsPsych experiment into Qualtrics is explained in the Embedding Hello World! page.
However, if you want to save the experiment data elsewhere, you must have the Participant ID so that you can link Qualtrics data and the experiment file later. In Qualtrics, you can keep or assign the participant ID using Embedded Data elements.
The below steps will create the Embedded Data called workerId
, which will hold the Participant ID. The value of workerId
can be set from the Qualtrics survey URL (for details, see Qualtrics.com: Setting values from the Survey URL and Qualtrics.com: Passing information through query string). However, if workerId
is not set, then Qualtrics will automatically generate a random Participant ID, ranging from PID10000 - PID99999, and use this ID to save data.
Setting the name of participant ID variable depends on how you recruit your participants (see the Recruiting Participants section). I set its name to be workerId
because I have been using Cloudresearch/TurkPrime with Amazon MTurk,
and Cloudresearch uses workerId
to automatically add Mturk Worker ID.
However, other services suggest different field name -- for example, Prolific suggests PROLIFIC_PID
-- so please follow the Qualtrics integration guide from the participant recruiting service you are using.
- Click Survey Flow from the Survey tab
- Click Add a New Element Here
- Choose Embedded Data
- Click Create New Field or Choose From Dropdown and type workerId. WARNING: These fields are case sensitive. The I in Id is capitalized. All other letters are lower case.
- Click Add Below on this Set Embedded Data block
- Choose Branch
- Click Add a Condition
- Click Question --> choose Embedded Data
- Type in workerId
- Click Is Equal to --> choose Is Empty
- Click Add a New Element Here under the Branch block
- Choose Embedded Data
- Click Create New Field or Choose From Dropdown and type workerId.
- CLick Set a Value Now
- Type in PID${rand://int/10000:99999} --> This generates a random Participant ID between PID10000 and PID99999. For details, see Qualtrics.com: Assigning Randomized IDs to Respondents.
- Click Move of the new blocks you created (
Set Embedded Data
andThen Branch If
) and move these blocks the top of Survey Flow
After these steps, you should see a screen like below.
Step 7. Use the save function from Qualtrics
The qualtrics-save-php.js
file in this GitHub repository contains additional changes from qualtrics.js
and experiment-with-display-element-save-php.html
and can be direclty copy-pasted into the Qualtrics Question JavaScript Editor.
We start from qualtrics.js
, which you can see from the Hello World! tutorial.
Let's look at these additional change.
Change 6: Defining necessary variables and functions for saving the results
The below javascript defines necessary variables and functions for saving the results.
Importantly, this script will grab the Participant ID from the Embedded Data workerId
, using the piped text ${e://Field/workerId}
,
and put it in the data file name.
The above save_data.php
expects three fields -- data_dir
, file_name
, and exp_data
-- and will NOT work if any of these is missing.
data_dir
specifies the server directory to store data. You may want to includetask_name
in the directory name.file_name
specifies the filename of the data being saved.exp_data
contains the full json/csv data to be saved.
You need to replace save_url
with your save_data.php url.
// experimental session-defining variables
var task_name = "hello-world";
var sbj_id = "${e://Field/workerId}";
// you must put your save_data php url here.
var save_url = "https://users.rcc.uchicago.edu/~kywch/exp_data/save_data.php";
var data_dir = task_name;
// my preference is to include the task and sbj_id in the file name
var file_name = task_name + '_' + sbj_id;
function save_data_json() {
jQuery.ajax({
type: 'post',
cache: false,
url: save_url,
data: {
data_dir: data_dir,
file_name: file_name + '.json', // the file type should be added
exp_data: jsPsych.data.get().json()
}
});
}
function save_data_csv() {
jQuery.ajax({
type: 'post',
cache: false,
url: save_url,
data: {
data_dir: data_dir,
file_name: file_name + '.csv', // the file type should be added
exp_data: jsPsych.data.get().csv()
}
});
}
Change 7: Calling the save function -- CHOOSE ONE!
The save function was added inside on_finish
, which is called once all trials in the experiment have been run.
The participant ID, sbj_id
, was added to the data itself, so that you can match the data file even when the file name is changed.
NOTE: Here, both save_data_json()
and save_data_csv()
were called to show how these can be used. Choose one.
jsPsych.init({
timeline: [hello_trial],
display_element: 'display_stage',
/* Change 5: Add the clean up and continue functions.*/
on_finish: function (data) {
/* Change 7: Calling the save function -- CHOOSE ONE! */
// include the participant ID in the data
// this must be done before saving
jsPsych.data.get().addToLast({participant: sbj_id});
save_data_json();
save_data_csv();
// clear the stage
jQuery('display_stage').remove();
jQuery('display_stage_background').remove();
// simulate click on Qualtrics "next" button, making use of the Qualtrics JS API
qthis.clickNextButton();
}
});
Putting it all together
So the qualtrics-save-php.js
code looks like this. Embed this script in Qualtrics by following these steps and see whether your save function works.
Qualtrics.SurveyEngine.addOnload(function () {
/*Place your JavaScript here to run when the page loads*/
/* Change 1: Hiding the Next button */
// Retrieve Qualtrics object and save in qthis
var qthis = this;
// Hide buttons
qthis.hideNextButton();
/* Change 2: Defining and load required resources */
var jslib_url = "https://kywch.github.io/jsPsych/";
// the below urls must be accessible with your browser
// for example, https://kywch.github.io/jsPsych/jspsych.js
var requiredResources = [
jslib_url + "jspsych.js",
jslib_url + "plugins/jspsych-html-keyboard-response.js"
];
function loadScript(idx) {
console.log("Loading ", requiredResources[idx]);
jQuery.getScript(requiredResources[idx], function () {
if ((idx + 1) < requiredResources.length) {
loadScript(idx + 1);
} else {
initExp();
}
});
}
if (window.Qualtrics && (!window.frameElement || window.frameElement.id !== "mobile-preview-view")) {
loadScript(0);
}
/* Change 3: Appending the display_stage Div using jQuery */
// jQuery is loaded in Qualtrics by default
jQuery("<div id = 'display_stage_background'></div>").appendTo('body');
jQuery("<div id = 'display_stage'></div>").appendTo('body');
/* Change 6: Defining necessary variables and functions for saving the results */
// experimental session-defining variables
var task_name = "hello-world";
var sbj_id = "${e://Field/workerId}";
// you must put your save_data php url here.
var save_url = "https://users.rcc.uchicago.edu/~kywch/exp_data/save_data.php";
var data_dir = task_name;
// my preference is to include the task and sbj_id in the file name
var file_name = task_name + '_' + sbj_id;
function save_data_json() {
jQuery.ajax({
type: 'post',
cache: false,
url: save_url,
data: {
data_dir: data_dir,
file_name: file_name + '.json', // the file type should be added
exp_data: jsPsych.data.get().json()
}
});
}
function save_data_csv() {
jQuery.ajax({
type: 'post',
cache: false,
url: save_url,
data: {
data_dir: data_dir,
file_name: file_name + '.csv', // the file type should be added
exp_data: jsPsych.data.get().csv()
}
});
}
/* Change 4: Wrapping jsPsych.init() in a function */
function initExp() {
var hello_trial = {
type: 'html-keyboard-response',
stimulus: 'Hello world!'
}
jsPsych.init({
timeline: [hello_trial],
display_element: 'display_stage',
/* Change 5: Adding the clean up and continue functions.*/
on_finish: function (data) {
/* Change 7: Calling the save function -- CHOOSE ONE! */
// include the participant ID in the data
// this must be done before saving
jsPsych.data.get().addToLast({participant: sbj_id});
save_data_json();
save_data_csv();
// clear the stage
jQuery('display_stage').remove();
jQuery('display_stage_background').remove();
// simulate click on Qualtrics "next" button, making use of the Qualtrics JS API
qthis.clickNextButton();
}
});
}
});
Qualtrics.SurveyEngine.addOnReady(function () {
/*Place your JavaScript here to run when the page is fully displayed*/
});
Qualtrics.SurveyEngine.addOnUnload(function () {
/*Place your JavaScript here to run when the page is unloaded*/
});
Step 8. Download the data
When your experiment is done, you can easily download the result files with the following steps.
First, log in to your account. Then, this command takes you to the exp_data
that you made.
$ cd ~/public_html/exp_data
This command compresses the directory with the result files (in this case hello-world
).
You need to replace hello-world
with your own experiment/directory.
$ zip -r hello-world.zip hello-world
You can access the zipped file through your web-browser by going to https://<server-url>/~<your-account>/exp_data/hello-world.zip
, like my url -- https://users.rcc.uchicago.edu/~kywch/exp_data/hello-world.zip.
After downloading the zipped file, you may want to delete it.
$ rm hello-world.zip