Welcome, Guest
Username: Password: Remember me

TOPIC: export data to spss

export data to spss 1 year 2 months ago #98705

  • byegooo
  • byegooo's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 13
  • Karma: 0
Hello ,

Just have a question regarding exporting the data. Can we export only the most recent data to SPSS instead of the entire responses?

Thanks in advance
The administrator has disabled public write access.

export data to spss 1 year 2 months ago #98710

  • mdekker
  • mdekker's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 341
  • Thank you received: 68
  • Karma: 38
This is not possible, it's all or nothing. In the upcoming 2.05 you can add selectors to export only from a certain response ID and up. You would still need to merge your resultsets in SPSS when you dp it that way.
---
Menno Dekker
The administrator has disabled public write access.

export data to spss 1 year 2 months ago #98790

  • DenisChenu
  • DenisChenu's Avatar
  • OFFLINE
  • Moderator Lime
  • Posts: 6451
  • Thank you received: 844
  • Karma: 249
mdekker wrote:
TIn the upcoming 2.05 you can add selectors to export only from a certain response ID and up.
Hi Menno.

Great news :). But did you think it's can be done:
- Add a question selector in SPSS/R export
- Export SPSS files with only this question ?

Denis
The administrator has disabled public write access.

export data to spss 1 year 2 months ago #98821

  • mdekker
  • mdekker's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 341
  • Thank you received: 68
  • Karma: 38
The spss export will operate just like the excel / word / pdf exports, so you can select what fields you would like to export. I think I will be able to finish that this week.
---
Menno Dekker
The administrator has disabled public write access.

export data to spss 1 year 2 months ago #98923

  • byegooo
  • byegooo's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 13
  • Karma: 0
Thanks Menno,

If I want to update my current lime to 2.05, is it possible to do so? Sorry about this stupid question.

Thanks,
The administrator has disabled public write access.

export data to spss 1 year 2 months ago #99027

Why would you want to do the selection in limesurvey? It is much simpler to do the selection in spss. Even if it would be possible to do it in limesurvey, I would never do it
The easiest way to do it is to add a selection line to the syntax file that spss generates (survey_XXXXXX_SPSS_syntax_file.sps) (select if submitdate>"XXXXXXX"). You could even save the date/time of the last import batch and run the select dynamically.
Frans
Last Edit: 1 year 2 months ago by fransmarcelissen.
The administrator has disabled public write access.
The following user(s) said Thank You: byegooo

export data to spss 1 year 2 months ago #99127

  • byegooo
  • byegooo's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 13
  • Karma: 0
Thank you very much. could I add a line on SPSS syntax saying select from the number of the ID instead of the date?

Thanks!
The administrator has disabled public write access.

export data to spss 1 year 2 months ago #99128

Yes, you can make whatever selection you want.
Bye and succes
Frans
The administrator has disabled public write access.
The following user(s) said Thank You: byegooo
Moderators: ITEd
Time to create page: 0.117 seconds
Donation Image