Extract data

Question

Hello, I have a question regarding collected data, In the "View data set " part under collected data , I can see all of the cases and if I click print button there is information separately for every case. I have downloaded my data in a excel file but the problem is that I cannot see in which order each of the participant answered my questions (the questions were randomized, I wrote a php code so every participant was assigned the questions in a different order) Now I need to extract that information but I can only see it individually by clicking print, but I want them in excel together with other data as well. How can I do it ?

Answer 1

You give no specifics on how you rotated the question order, therefore I have to guess that you used shuffle() on an array.

It is important to know that this order will NOT be stored in the dataset at all, unless you use put() to explicitly store the random order in the data set. This is why a notice about this requirements pops up below a PHP code, whenever you use shuffle() in it.

Please note that the "view data set" feature will NOT reproduce the original order as displayed in the questionnaire (see the note at the top), but any random order.

Comments

This is my PHP code,if (!isset($pages)) {
  $pages = array('PA', 'PB', 'PC', 'PD', 'PE', 'PF');
  shuffle($pages);
  $pages[] = 'PX';
  registerVariable($pages);
}
setPageOrder($pages);
 I did not use put () but can I DO IT now ? so there is no way to get the data regarding in which order did each of my participant answered the questions ?
and I did not get this "Please note that the "view data set" feature will NOT reproduce the original order as displayed in the questionnaire (see the note at the top), but any random order." does this mean that when I click "view data set" and I click each of the cases separately , then that is not the order they really answered the questions but just any random order ?
This is my PHP code, I did not use put () but can I DO IT now ? so there is no way to get the data regarding in which order did each of my participant answered the questions ?
and I did not get this "Please note that the "view data set" feature will NOT reproduce the original order as displayed in the questionnaire (see the note at the top), but any random order." does this mean that when I click "view data set" and I click each of the cases separately , then that is not the order they really answered the questions but just any random order ?

---

> so there is no way to get the data regarding in which order did each of my participant answered the questions ?

No. The order has been deleted when the respondents reached the "last page" and FINISHED has been set to 1.

> does this mean that when I click "view data set" and I click each of the cases separately , then that is not the order they really answered the questions but just any random order ?

Yes. As the information is not available any more, SoSci Survey simply runds the code from the Questionnaire which sais to randomly rotate the options.