- Posts: 2
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Exporting data to SPSS in additional language
- Firrdess
- Topic Author
- Offline
- New Member
Less
More
5 years 2 months ago #180607
by Firrdess
Exporting data to SPSS in additional language was created by Firrdess
I have a survey which has two languages:
- Base language: German
- Additional language: English
I want to export the results with SPSS. When I change the language of user and export the data, the results are still in german, but I'd like to have them in English.
I couldn't find where to select the export language.
Am I restricted to base language while exporting SPSS?
Could you please tell me how I can export data to SPSS in the additional language of the survey?
- Base language: German
- Additional language: English
I want to export the results with SPSS. When I change the language of user and export the data, the results are still in german, but I'd like to have them in English.
I couldn't find where to select the export language.
Am I restricted to base language while exporting SPSS?
Could you please tell me how I can export data to SPSS in the additional language of the survey?
The topic has been locked.
- holch
- Away
- LimeSurvey Community Team
Less
More
- Posts: 11658
- Thank you received: 2742
5 years 2 months ago #180622
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic Exporting data to SPSS in additional language
Afaik the export is limited to the base language and there is no easy way to change the base language.
Ideally you chose the base language on the most important language, which in your case actually seems to be English, not German.
Maybe someone here knows a way how to change the base language.
Ideally you chose the base language on the most important language, which in your case actually seems to be English, not German.
Maybe someone here knows a way how to change the base language.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The following user(s) said Thank You: DenisChenu
The topic has been locked.
- steve_81
- Offline
- Premium Member
Less
More
- Posts: 136
- Thank you received: 37
5 years 2 months ago #180660
by steve_81
Replied by steve_81 on topic Exporting data to SPSS in additional language
Hi Firrdess,
one possibility is changing the base language directly in the database (if you are authorized). But I take no responsibility for doing this. Maybe you want do this only with a copy of the original survey. I guess you only need the syntax for SPSS and you can then take the (german) original .dat file.
Following steps I would do:
1) Copy the survey (remember the new Survey_ID)
2) Go into your database via (phpMyadmin / mysql?)
3) search for the database ..._surveys, in this there are the settings for each survey
4) In the row of your new Survey_ID change there "language" de to en and in additional_languages en to de
5) Go to limesurvey save/open the syntax. This syntax should have the labels in English and you can use it with the "german" .dat file from the original survey.
(6) Maybe you want delete the copied survey)
Best regards
Stefan
one possibility is changing the base language directly in the database (if you are authorized). But I take no responsibility for doing this. Maybe you want do this only with a copy of the original survey. I guess you only need the syntax for SPSS and you can then take the (german) original .dat file.
Following steps I would do:
1) Copy the survey (remember the new Survey_ID)
2) Go into your database via (phpMyadmin / mysql?)
3) search for the database ..._surveys, in this there are the settings for each survey
4) In the row of your new Survey_ID change there "language" de to en and in additional_languages en to de
5) Go to limesurvey save/open the syntax. This syntax should have the labels in English and you can use it with the "german" .dat file from the original survey.
(6) Maybe you want delete the copied survey)
Best regards
Stefan
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13647
- Thank you received: 2491
5 years 2 months ago #180666
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Exporting data to SPSS in additional language
Why SPSS export is not a plugin … then can be easily fixed an improvedholch wrote: Afaik the export is limited to the base language and there is no easy way to change the base language.
…
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5033
- Thank you received: 1257
5 years 2 months ago #180667
by jelo
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on topic Exporting data to SPSS in additional language
Other question: Why is the base language fixed and cannot be switched via GUI?
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13647
- Thank you received: 2491
5 years 2 months ago #180669
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Exporting data to SPSS in additional language
Because updating CORE is less easy than updating pluginjelo wrote: Other question: Why is the base language fixed and cannot be switched via GUI?
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
- holch
- Away
- LimeSurvey Community Team
Less
More
- Posts: 11658
- Thank you received: 2742
5 years 2 months ago #180672
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic Exporting data to SPSS in additional language
For these export features I could see a plugin approach. However, it would have to be a Core Plugin that is released to together with the Limesurvey Core, because otherwise there will be weeks/months without export availability.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13647
- Thank you received: 2491
5 years 2 months ago #180685
by DenisChenu
www.limesurvey.org/community/forums/desi...oice-question#180676
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Exporting data to SPSS in additional language
Export API is strong enough :holch wrote: For these export features I could see a plugin approach. However, it would have to be a Core Plugin that is released to together with the Limesurvey Core, because otherwise there will be weeks/months without export availability.
www.limesurvey.org/community/forums/desi...oice-question#180676
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5033
- Thank you received: 1257
5 years 2 months ago #180693
by jelo
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on topic Exporting data to SPSS in additional language
The main obstacle is that none of the developers has a SPSS license to develop and check for issues. Other survey-tools export directly as SAV and rename variables inside the survey application. E.g.
help.surveygizmo.com/help/spss
A PHP library for reading and writing SPSS / PSPP .sav data files
github.com/tiamo/spss
SAV
www.loc.gov/preservation/digital/formats/fdd/fdd000469.shtml
A PHP library for reading and writing SPSS / PSPP .sav data files
github.com/tiamo/spss
SAV
www.loc.gov/preservation/digital/formats/fdd/fdd000469.shtml
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The following user(s) said Thank You: DenisChenu
The topic has been locked.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5033
- Thank you received: 1257
5 years 2 months ago #180790
by jelo
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on topic Exporting data to SPSS in additional language
Frederik ( www.limesurvey.org/about-limesurvey/team-contributors ) as "IBM Certified Specialist – SPSS Statistics" should have SPSS at his fingertips. So there is SPSS knowhow inside the LimeSurvey team.jelo wrote: The main obstacle is that none of the developers has a SPSS license to develop and check for issues.
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The topic has been locked.