Willkommen, Gast
Benutzername: Passwort: Angemeldet bleiben:
  • Seite:
  • 1
  • 2

THEMA: Export data to SPSS: missing participants in our database ?

Export data to SPSS: missing participants in our database ? 1 Jahr 1 Monat her #94160

  • EPRIS
  • EPRISs Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 6
  • Karma: 0
Hello everyone,

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.

Thank you !

- Limesurvey Version 2.00+ Build 130317
- Our survey has 400 variables

(if you need more info to help you figure out our problem, please tell me)


Carl
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Export data to SPSS: missing participants in our database ? 1 Jahr 1 Monat her #94161

  • mdekker
  • mdekkers Avatar
  • OFFLINE
  • LimeSurvey Team
  • Beiträge: 340
  • Dank erhalten: 68
  • Karma: 38
You can not export participants to spss, only survey respsones. When a participant does not start the survey you can not see him in spss export. Only when he starts the survey it will be incomplete.
---
Menno Dekker
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Export data to SPSS: missing participants in our database ? 1 Jahr 1 Monat her #94167

  • EPRIS
  • EPRISs Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 6
  • Karma: 0
Ok sorry I just didn't use the right words:

Hello everyone,

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.

Thank you !

- Limesurvey Version 2.00+ Build 130317
- Our survey has 400 variables

(if you need more info to help you figure out our problem, please tell me)


Carl
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Export data to SPSS: missing participants in our database ? 1 Jahr 4 Wochen her #94201

  • mdekker
  • mdekkers Avatar
  • OFFLINE
  • LimeSurvey Team
  • Beiträge: 340
  • Dank erhalten: 68
  • Karma: 38
Ok so we forget about the participants and tokens etc.

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?
---
Menno Dekker
Letzte Änderung: 1 Jahr 4 Wochen her von mdekker.
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Export data to SPSS: missing participants in our database ? 1 Jahr 4 Wochen her #94205

  • EPRIS
  • EPRISs Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 6
  • Karma: 0
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).

Where do I go from here ?
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Export data to SPSS: missing participants in our database ? 1 Jahr 4 Wochen her #94206

  • mdekker
  • mdekkers Avatar
  • OFFLINE
  • LimeSurvey Team
  • Beiträge: 340
  • Dank erhalten: 68
  • Karma: 38
You probably hit the php max execution time. Try if you can get that number up (use google to find out how)
---
Menno Dekker
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Export data to SPSS: missing participants in our database ? 1 Jahr 4 Wochen her #94211

  • holch
  • holchs Avatar
  • OFFLINE
  • LimeSurvey Team
  • Beiträge: 2447
  • Dank erhalten: 254
  • Karma: 94
As a quick solution you could try to export in steps of 1000 responses.

But the best solutions (for a long term) is probably what mdekker suggests.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Export data to SPSS: missing participants in our database ? 1 Jahr 4 Wochen her #94223

  • DenisChenu
  • DenisChenus Avatar
  • OFFLINE
  • Moderator Lime
  • Beiträge: 5866
  • Dank erhalten: 718
  • Karma: 222
Think SPSS/R export don't have "restrict from/to id" and maybe some "restrict to this column".

Maybe future plugin ;).
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Export data to SPSS: missing participants in our database ? 1 Jahr 4 Wochen her #94237

  • holch
  • holchs Avatar
  • OFFLINE
  • LimeSurvey Team
  • Beiträge: 2447
  • Dank erhalten: 254
  • Karma: 94
Ahhh, I didn't know that Denis!

I thought those functions would be available for all export. Thanks for letting me know!
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
Der Administrator hat öffentliche Schreibrechte deaktiviert.

Export data to SPSS: missing participants in our database ? 1 Jahr 3 Wochen her #94483

  • EPRIS
  • EPRISs Avatar
  • OFFLINE
  • Fresh Lemon
  • Beiträge: 6
  • Karma: 0
Unfortunately the problem is still ongoing.

Complete cases: 3592
Incomplete: 3335
Total: 6927

The .sql file size is 15MO.


I don't think tht mem_limit or max_exec are in cause here.
extract from the php.ini file:
default_socket_timeout = 1200
max_execution_time = 2400
max_input_time = 1200
memory_limit = 1024M
post_max_size = 128M

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)?

Very many thanks for your input and suggestions!
Der Administrator hat öffentliche Schreibrechte deaktiviert.
  • Seite:
  • 1
  • 2
Moderatoren: ITEd
Ladezeit der Seite: 0.171 Sekunden
Donation Image