Welcome, Guest
Username: Password: Remember me

TOPIC: Textfields in Export

Textfields in Export 3 years 8 months ago #54377

  • Ingrimmsch
  • Ingrimmsch's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 11
  • Karma: 0
Hi, is there an easy way to get the Free Text fields from the survey in excel and pdf export?
The administrator has disabled public write access.

Re:Textfields in Export 3 years 8 months ago #54382

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 2640
  • Thank you received: 313
  • Karma: 115
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.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.

Re:Textfields in Export 3 years 8 months ago #54384

  • Ingrimmsch
  • Ingrimmsch's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 11
  • Karma: 0
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.
The administrator has disabled public write access.

Re:Textfields in Export 3 years 8 months ago #54385

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 2640
  • Thank you received: 313
  • Karma: 115
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.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.

Re:Textfields in Export 3 years 8 months ago #54386

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 2640
  • Thank you received: 313
  • Karma: 115
Where and how do you export the results?
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.

Re:Textfields in Export 3 years 8 months ago #54387

  • Ingrimmsch
  • Ingrimmsch's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 11
  • Karma: 0
hmmm..

i install a new version on localhost and try it... i answer if i get my results
The administrator has disabled public write access.

Re:Textfields in Export 3 years 8 months ago #54389

  • Ingrimmsch
  • Ingrimmsch's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 11
  • Karma: 0
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
The administrator has disabled public write access.

Re:Textfields in Export 3 years 8 months ago #54391

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 2640
  • Thank you received: 313
  • Karma: 115
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.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.

Re:Textfields in Export 3 years 8 months ago #54393

  • Ingrimmsch
  • Ingrimmsch's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 11
  • Karma: 0
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
The administrator has disabled public write access.

Re:Textfields in Export 3 years 8 months ago #54394

  • holch
  • holch's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 2640
  • Thank you received: 313
  • Karma: 115
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.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.137 seconds
Donation Image