Welcome to the LimeSurvey Community Forum

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

Group Responses in Response Export

  • andyrue
  • andyrue's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
2 years 2 weeks ago - 2 years 2 weeks ago #226123 by andyrue
Group Responses in Response Export was created by andyrue
Please help us help you and fill where relevant:
Your LimeSurvey version: Version 5.3.4+220309 Community Edition
Own server or LimeSurvey hosting: Own Server
Survey theme/template: Vanilla core
==================

I'm wondering if there is a way to export responses and group the responses for each question together. Example:

With the following data.
Respondent 1 responses:
  • Question 1: Name a part of a dog.
    • Answer: Paw
  • Question 2: Name a plant.
    • Answer: Oak Tree

Respondent 2 responses:
  • Question 1: Name a part of a dog.
    • Answer: Ears
  • Question 2: Name a plant.
    • Answer: Lilly
With these responses I would like a way to group the responses in a printable format that looks like this:

Question 1: Name a part of a dog.
Answers:
  • Paw
  • Ears
Question 2: Name a plant.
  • Oak Tree
  • Lilly
It doesn't need to be that exact format, just the general idea. Thanks for any advice on how this might be accomplished!
Last edit: 2 years 2 weeks ago by andyrue.

Please Log in to join the conversation.

  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 2 weeks ago #226131 by Joffm
Replied by Joffm on topic Group Responses in Response Export
Hi,
this is exactly what you get when you export the data.

LS answer table
   
Export to EXCEL

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

Please Log in to join the conversation.

  • andyrue
  • andyrue's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
2 years 2 weeks ago #226132 by andyrue
Replied by andyrue on topic Group Responses in Response Export
Haha, yes yes, you are right. I should have clarified that I'd like it in a printer friendly format. If there are 25 questions, an excel spreadsheet becomes very very wide, so I'm looking for something more like the PDF export, but just organized by question instead of by respondent.

Please Log in to join the conversation.

  • Joffm
  • Joffm's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
2 years 2 weeks ago - 2 years 2 weeks ago #226138 by Joffm
Replied by Joffm on topic Group Responses in Response Export
That's up to you.

If you have some knowledge in php (or other) you may write a small script to query the database directly or by the API and create a good looking pdf report (or whatever).
[url] manual.limesurvey.org/RemoteControl_2_API [/url]
[url] api.limesurvey.org/classes/remotecontrol_handle.html [/url]

And an EXCEL spreadsheet doesn't become wide, if you insert vertical pagebreaks. It becomes long.
Or you create a small macro.

Here you are free to design the layout of your report.

Anyway:
Why don't you like the built-in pdf-report in "Statistics"?
 

 

Joffm

Volunteers are not paid.
Not because they are worthless, but because they are priceless
Last edit: 2 years 2 weeks ago by Joffm.

Please Log in to join the conversation.

  • andyrue
  • andyrue's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
2 years 2 weeks ago #226139 by andyrue
Replied by andyrue on topic Group Responses in Response Export
Hey that's pretty good. That statistics PDF report might work well enough. Thank you for pointing me to that, and for the other suggestions. I suppose there isn't an easy way that I'm overlooking to not have it page break for every question? If there are only a few responses, there is a lot of blank space on every page. Thank you again for your help!

Please Log in to join the conversation.

Lime-years ahead

Online-surveys for every purse and purpose