Welcome to the LimeSurvey Community Forum

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

How to reliably extract Likert labels from .lss export for external processing?

  • DPF-QualiQuan
  • DPF-QualiQuan's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 day 5 hours ago #271076 by DPF-QualiQuan
Please help us help you and fill where relevant:
Your LimeSurvey version: LimeSurvey Community Edition   Version 6.15.4+250710 
Own server or LimeSurvey hosting: own server
Survey theme/template:
==================Hello everyone,I'm working on a research project using LimeSurvey Community Edition and I need to extract the full structure of my survey, including:
  • Question type and ID
  • Text and subtext (help)
  • Answer options for single/multiple choice questions
  • Likert subquestion labels and scale values (for arrays)
I’m parsing the .lss export with a Python script. It works well in most cases, but I’m struggling to retrieve the Likert scale labels properly.The problem:In the XML .lss, I do see answer options in <answer_l10ns> with aid values, but there is no clear link between the Likert scale values and the question qid.Examples:<answer_l10ns>  <aid>1017</aid>  <answer><![CDATA[Tous les jours !]]></answer>  <language><![CDATA[fr]]></language></answer_l10ns>I find the scale labels, but I can’t reliably determine which question they belong to. The mapping between qid, aid, and scale_id seems missing or incomplete.What I’ve tried:
  • Using answers, answer_l10ns, and subquestions sections
  • Mapping (qid, scale_id) to a list of aid
  • Cross-referencing with subquestions to reconstruct Likert tables
  • Combining this with .txt export — not always helpful
Still, for many "array" questions (e.g., multiple rows/columns Likert), the labels of the Likert scale ("Never", "Sometimes", "Always"...) are not reliably mapped in the export.My goal:I want to automatically generate a file compatible with the Phonic.ai format, with columns like:
  • Type, Text, Subtext, Question ID, Options,
  • Allow Multiple Selections, Custom Likert Options, Enable Custom Likert Options, Custom Likert Options Recode
Is there a recommended way to do this?Best, Eric

Please Log in to join the conversation.

  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
1 day 5 hours ago #271077 by Joffm
Did you try a "txt" export and open in Excel / OpenOffice ,...?
This should give you all you need.

Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless

Please Log in to join the conversation.

  • DPF-QualiQuan
  • DPF-QualiQuan's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
11 hours 44 minutes ago #271081 by DPF-QualiQuan
My bad..; you're definitely right.
thanks a lot.
eric

Please Log in to join the conversation.

Moderators: tpartnerholch

Lime-years ahead

Online-surveys for every purse and purpose