Textfields in Export

Mehr
8 Jahre 5 Monate her #54377 von Ingrimmsch
Textfields in Export wurde erstellt von Ingrimmsch
Hi, is there an easy way to get the Free Text fields from the survey in excel and pdf export?

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

LimeSurvey Partners
Mehr
8 Jahre 5 Monate her #54382 von holch
holch antwortete auf 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

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
8 Jahre 5 Monate her #54384 von Ingrimmsch
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.

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
8 Jahre 5 Monate her #54385 von holch
holch antwortete auf 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

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
8 Jahre 5 Monate her #54386 von holch
holch antwortete auf 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

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
8 Jahre 5 Monate her #54387 von Ingrimmsch
hmmm..

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

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
8 Jahre 5 Monate her #54389 von Ingrimmsch
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

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
8 Jahre 5 Monate her #54391 von holch
holch antwortete auf 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

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
8 Jahre 5 Monate her #54393 von Ingrimmsch
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

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
8 Jahre 5 Monate her #54394 von holch
holch antwortete auf 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

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
8 Jahre 5 Monate her #54396 von Ingrimmsch
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

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
8 Jahre 5 Monate her #54398 von holch
holch antwortete auf 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

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
8 Jahre 5 Monate her #54401 von Ingrimmsch
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

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
8 Jahre 5 Monate her #54421 von Mazi
Mazi antwortete auf 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
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com
Want to use your survey offline -> www.offlinesurveys.com

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Mehr
8 Jahre 5 Monate her #54450 von Ingrimmsch
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.

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Jetzt loslegen!

Melden Sie sich jetzt an, und erstellen Sie in wenigen Minuten Ihre erste Umfrage.

Account einrichten

Abonnieren Sie unseren Newsletter

Abonnieren Sie unseren Newsletter für alle Neuigkeiten rund um LimeSurvey
captcha