Check out the LimeSurvey source code on GitHub!

Export to Excel - Help with detailed report output

More
5 years 4 months ago #67110 by craigrosewarne
Hi all

I have recently conducted my first survey using LimeSurvey - great tool!

I have 88 respondents to 49 questions I asked.

My question:

1. When I click the GET statistics button and under the OUTPUT option I select EXCEL - I get a nice summary of the everyone's results but how can I see a more detailed report with allthe 88 respondents on the left (rows) and the 49 questions as columns? Is this possible? ( I basically want to run filters in Excel to see different angles from different response groups)

Regards
Craig

Please Log in to join the conversation.

More
5 years 4 months ago #67118 by Mazi
If you browse the results, you'll get a tabular overview: docs.limesurvey.org/Browsing+survey+resu...tions+for+LimeSurvey

You can also export all the data to Excel for filtering: docs.limesurvey.org/Exporting+results&st...lication_Excel_.csv_


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

More
5 years 4 months ago #67121 by craigrosewarne
Thanks Mazi

For the first result I am able to only get a 1 page overview per responder (even if I select multiple people in the browse results area)

When I then click the EXPORT THIS RESPONSE button i get the one line in Excel which is exactly what i want for all 88 - does it only do it for 1 and i must repeat the exercise 88 times - else what am i missing?

Please Log in to join the conversation.

More
5 years 4 months ago #67123 by holch
Go to "Responses & statistics", then go to the symbol with the simple blue arrow to the right which says "Export results to application". There you choose "All responses" and to the right you choose the columns you want in your data file (probably all!).

Then choose the application you want and there you go, your results in one file.

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 4 months ago #67126 by craigrosewarne
Hi Holch

When I followed your advice I got the following error upon opening the .XLS:

<b>Fatal error</b>: Allowed memory size of 67108864 bytes exhausted (tried to allocate 3 bytes) in <b>/home2/public_html/surveys/admin/classes/phpexcel/PHPExcel/Cell.php</b> on line <b>634</b><br />

However when I ran it again and only selected 10 or so columns then it came out perfectly? What do you think the problem is?

Please Log in to join the conversation.

More
5 years 4 months ago #67128 by holch
The problem is that you have not enough memory allocated for the script. You would either export in smaller portions and later copy them together in one excel or you probablly need to give more memory for your scripts.

What you also could try is to export as CSV, which might need less memory (just a guess!).

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 4 months ago #67129 by craigrosewarne
Yeah - broke the export up into 3 smaller batches and that did the trick!

shot for the great support!

Please Log in to join the conversation.

More
5 years 4 months ago #67145 by Mazi
If you want to solve this technically, raise the max_execution time and the allowed max memory at your server settings (if you are able to do so).


Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in to join the conversation.

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