Textfields in Export

More
6 years 10 months ago #54377 by Ingrimmsch
Ingrimmsch created the topic: Textfields in Export
Hi, is there an easy way to get the Free Text fields from the survey in excel and pdf export?

Please Log in to join the conversation.

More
6 years 10 months ago #54382 by holch
holch replied the topic: Textfields in Export
Hmm, what do you mean with "easy way"? You could always go the results, mark the columns that contain your text answers and export them to CSV.

If this is not the solution to your problem, please describe it more in detail.

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
6 years 10 months ago #54384 by Ingrimmsch
Ingrimmsch replied the topic: Textfields in Export
im using the version 1.90 and the text answers are not in the export. I can only see the Text answers in the Html Export, where is a Button to show them.

If i export in Excel or Pdf limesurvey dont export the text answers.

Please Log in to join the conversation.

More
6 years 10 months ago #54385 by holch
holch replied the topic: Textfields in Export
Hmm, I am using the latest version of 1.90 as well, and when marked all questions are exported. I just tested it. The text based questions are just another column in the table and import just fine to excel.

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
6 years 10 months ago #54386 by holch
holch replied the topic: Textfields in Export
Where and how do you export the results?

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
6 years 10 months ago #54387 by Ingrimmsch
Ingrimmsch replied the topic: Textfields in Export
hmmm..

i install a new version on localhost and try it... i answer if i get my results

Please Log in to join the conversation.

More
6 years 10 months ago #54389 by Ingrimmsch
Ingrimmsch replied the topic: Textfields in Export
I installed a version on localhost

and made a test survey a test gruop and a test question (Long Free Text)

i activated the survey and made one answer.

then i exported the survey in excel my result:

Number of records in this query: 1
Total records in survey: 1
Percentage of total: 100.00%


Field summary for 1
Test
Answer 1 100.00%
No answer 0 0.00%
Not completed or Not displayed 0 0.00%


nowhere i can see what the user wrote in the text field

Please Log in to join the conversation.

More
6 years 10 months ago #54391 by holch
holch replied the topic: Textfields in Export
When I export the results those figures do not show up. Where is this export?

Here is what I do to export the survey results:
-> Browse responses for this survey
-> Export results to application
-> Then you have a screen with different export options. Pick CSV and mark the columns you want to export on the right.

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
6 years 10 months ago #54393 by Ingrimmsch
Ingrimmsch replied the topic: Textfields in Export
oh sry now i see the problem export is maybe the wrong word... my fault.

I talk about the statistic function where i make an exceloutput

Please Log in to join the conversation.

More
6 years 10 months ago #54394 by holch
holch replied the topic: Textfields in Export
Ohh, now I get it, you are in the statistics feature. Well, you can't really get statistics out of open ends, can you. This is probably why this is not included in the export of survey statistics.

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
6 years 10 months ago #54396 by Ingrimmsch
Ingrimmsch replied the topic: Textfields in Export
yeah its not a statistic but i think its really helpful if you make a survey with text fields you want see what the people answered there... and in the html version you can see the output...

hmmm maybe a developer of limesurvey can give me a good hint how i can easy implement it.

its not easy to understand the complete excel process in the statistic_function.php

Please Log in to join the conversation.

More
6 years 10 months ago #54398 by holch
holch replied the topic: Textfields in Export
Well, I'd consider it is a nice to have, but I wouldn't consider this vital, because you can export those open-ended answers at the export. There are other functions that I'd consider a lot more urgent to be implemented.

So the statistics section is basically a quick and dirty statistical sum up of the survey, but when you want all the results including answers to open-ended questions you will have to go to the export of the data.

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
6 years 10 months ago #54401 by Ingrimmsch
Ingrimmsch replied the topic: Textfields in Export
Ok... i think i will build my own solution. I think it will be dirty but if it works ok.

thanks for the fast answers

Please Log in to join the conversation.

More
6 years 10 months ago #54421 by Mazi
Mazi replied the topic: Textfields in Export
Ingrimmsch wrote:

Ok... i think i will build my own solution. I think it will be dirty but if it works ok.

thanks for the fast answers

It would be great if you could share your solution so we could take it over into the core.

Please have a look at docs.limesurvey.org/How+to+contribute+new+features


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
6 years 10 months ago #54450 by Ingrimmsch
Ingrimmsch replied the topic: Textfields in Export
i think the code will not be very clean... there will be a quick & dirty solution. But i looked at your link. And i want to make a Powerpoint Export in the Future with PHPPowerpoint. I will share the solution for Powerpoint definitely.

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!