I have tried exporting data from LS to SPSS. We have a large amount of participants (5043: 2503 completed questionnaires). When I look at my data on SPSS I don't get the correct amount of participants and everytime I try to export data I get a different number of participants in my database (once I had 1902, the other time I had 1867, and so on...). I have tried exporting the data separately (only completed questionnaires) but the problem still occured. We would like to know how we could fix this data export problem.

I have tried exporting data from LS to SPSS. We have a large amount of survey responses (5043: 2503 completed questionnaires). When I look at my data on SPSS I don't get the correct amount of survey responses and everytime I try to export data I get a different number of survey responses in my database (once I had 1902, the other time I had 1867, and so on...). I have tried exporting the data separately (only completed questionnaires) but the problem still occured. We would like to know how we could fix this data export problem.

You go into the responses & statistics screen, in that screen you see an overview with three numbers: full, incomplete and total responses.

Then in the same screen you go to spss export and do the export. The numbers should match, and the only thing that could be different is what happended in the time between you looking at the response overview and you doing the export. So when someone is filling out the survey that will ofcourse change the numbers.

If the numbers in the response overview do not match that of the spss export, could you try exporting to excel and see what the numbers do there?

We were able to export all of our data when we had less survey responses.
The problem occured when we suddently had more than 2000 responses... Our
export was inconsistent with the survey responses we had.

For example, I tried to export all my completed survey responses (2200) but
when I opened the data file with SPSS I had only 1660. I tried another time
and it gave me 1590. It seems like I can't export all of these reponses
at once...

When I tried to export into Excel LimeSurvey crashed. I have tried exporting data using only one variable and it worked... so I guess this is linked to our massive database (with lots of survey responses).

Think SPSS/R export don't have "restrict from/to id" and maybe some "restrict to this column".

Maybe future plugin .

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member,
professional service on demand
(or search sondages pro).
An error happen ? Before make a new topic : remind the
Debug mode
.

The problem is related to exporting in SPSS or R. If I export in CSV, I can get all complete cases (3600), but not the total incomplete and complete (over 6K). However, I need an importation syntax (R or SPSS).

The .csv file for complete cases only is 6MO.
The maximum file size I can get with R or SPSS export is 2MO.

One solution would be to make available extraction by ID range (it would be awesome if this function, already available in the general export tab, was also made available for R or SPSS!).
Who that be possible?

Another solution would be to use the SPSS syntax to import the csv file. Unfortunetaly, the number of variables differ between what is extract in the .dat (SPSS) file and the .csv file. I get 400 variables in SPSS and 435 in the .csv file, so this is not easily implemented.

Is there any log of file I can join that could help identify the problem(s)?

Thanks for your quick reply. I changed the parameters, I'll come back to you as soon as I have something...

As I really need the complete database soon... I was wondering if there is a way a can either
1) export cases by batch (e.g. by extracting first 1500ish cases, deleting them, then extracting the folling 1500ish cases, and so on? would that be possible?)
2) accelerate the process of solving the issue (like by making a donation)?