Check out the LimeSurvey source code on GitHub!

SPSS Export - truncating text fields

More
5 years 9 months ago #61189 by gavlar
hi there

We are running Limesurvey Version 1.82+ (6825) on Suse Linux Enterprise Server 10 with a MySQL database.

We appear to have an issue when exporting surveys to SPSS - specifically that text fields get truncated to 255 characters.

This appears to be the case whether we apply 'Short free text' or 'Huge free text' options to open questions.

When we browse the responses in Limesurvey, or export to Excel - we can see the full text the user entered. But when we export to SPSS we only get the first 255 characters.

Any help appreciated!

thanks

Gavin

Please Log in to join the conversation.

More
5 years 9 months ago #61193 by tpartner
I'm afraid 1.82 is far too old for us to offer any help. Can you update the the latest stable version?

Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

Please Log in to join the conversation.

More
5 years 9 months ago #61200 by mdekker
Support for longer text fields was added in a later version. The only solution is to upgrade.

---
Menno Dekker

Please Log in to join the conversation.

More
5 years 9 months ago #61207 by holch
As far as I know, this is mainly a problem in SPSS. I am not an expert, but in my former company it was the same. We had to export textfields to another format, because SPSS was supporting only 255 characters.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in to join the conversation.

More
5 years 9 months ago #61208 by mdekker
Newer spss versions >16 don't have the 255 char limit.

---
Menno Dekker

Please Log in to join the conversation.

More
5 years 9 months ago - 5 years 9 months ago #61209 by holch
Good to know. Now the question is which software needs an upgrade. ;-)

Well, it would be good to upgrade Limesurvey anyway, because there has changed a lot since 1.82, but if they have an old version of SPSS, the problem might still persist after an upgrade.

I know that because of the price, many companies wait as long as possible for upgrades of SPSS, as long as the version they have matches their needs. For Limesurvey there is no excuse though... :-)

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds
Last Edit: 5 years 9 months ago by holch.

Please Log in to join the conversation.

More
5 years 9 months ago #61219 by gavlar
hi there

Thanks for all the responses!

First up - I did try an upgrade to 1.90 a while back but there were issues the users couldn't get thru - so we stuck at 1.82 :( - but that version is still installed in test - so I will get them to test this there.

I imagine I will probably upgrade Limesurvey tho - always good to do and hopefully this time all will be ok.

FYI - the text was 255 characters in the export file itself - so it was Limesurvey truncating it I think - but only probably because SPSS would not support more characters at that time.

cheers

Gavin

Please Log in to join the conversation.

More
5 years 9 months ago #61222 by holch
Well, you could export it as a csv/xls file and see if the answers are truncated after 255 characters as well, just to see if it is an general issue with Limesurvey only saving 255 characters or if it has to do with the SPSS export format.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in to join the conversation.

More
5 years 9 months ago #61240 by gavlar
hi there

Yep - I tried this as part of my original diagnostics. Excel/CSV export is fine - and provides us with a work-around :)

Upgrade is the way to go

cheers

Gavin

Please Log in to join the conversation.

More
5 years 9 months ago #61266 by holch
Good to know. So Limesurvey could already do more in 1.82, but the SPSS export only allowed 255 characters.

Yeah, you really should go for the upgrade. If there are still people depending on the 1.82, then just make a parallel installation with another database, shouldn't be a big problem and you can have both worlds.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form