Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

How to get SQID for all Qs in a Survey

  • pt1234
  • pt1234's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 5 months ago #176485 by pt1234
Dear all,

I hope that this is the right sub-forum; if not, please feel free to move my post to a different sub-forum.

Here's my question: I have set up a survey where participants enter free text into a small text box. Everything worked fine during testing, but when using the survey "in the wild" (to collect some ratings for stimuli for an experiment), some answers could not be saved into the database because subjects responses were too long (I think that's the reason) and I received an e-mail containing ALL the answers and the corresponding SGQA identifier. It seems that still all the data was "saved", at least in this e-mail (actually, I got several, whenever a question could not be saved; but the last one contains ALL answers, as far as I could see).

Now, I don't want to enter the data by hand (it's more than 300 questions) but would simply like to convert the SGQA identifier to the respective Code that has been assigned to the question when setting up the survey. Can someone point me to an easy way in which I can extract the association between SGQA identifier and the respective code for every question in my survey? This will make it possible for me to also use the data that could not be saved to the database but was e-mailed to me.

Thank you very much in advance for your help!

All the best,
Patrick
The topic has been locked.
  • pt1234
  • pt1234's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 5 months ago #176489 by pt1234
Replied by pt1234 on topic How to get SQID for all Qs in a Survey
I forgot to mention, the server on which I'm using LimeSurevy is running version 2.73.1.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Away
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 5 months ago - 5 years 5 months ago #176495 by DenisChenu
Replied by DenisChenu on topic How to get SQID for all Qs in a Survey

pt1234 wrote: because subjects responses were too long (

Some million of character ??? Really strange … something other happen.
[strike]Are you on the last version ?[/strike] … more strange …

Else : you can :
1. Export VV file with new version : You have Question code at 2nd line
2. Export VV file old version : you have SGQA on 2nd line (and question text in first)

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.
Last edit: 5 years 5 months ago by DenisChenu.
The topic has been locked.
  • pt1234
  • pt1234's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 5 months ago #176512 by pt1234
Replied by pt1234 on topic How to get SQID for all Qs in a Survey
I'm not a LimeSurvey expert, could you elaborate on what you mean by VV file and the different versions?
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Away
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 5 months ago #176528 by DenisChenu
Replied by DenisChenu on topic How to get SQID for all Qs in a Survey

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.
  • pt1234
  • pt1234's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 5 months ago #176609 by pt1234
Replied by pt1234 on topic How to get SQID for all Qs in a Survey
This worked like a charm. Thank you very much for you help!

All the best,
Patrick
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose