Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
I reached out in slack #webform channel about this issue and was asked to report as a possible bug.
The issue is with exporting submissions to csv. Some of the characters are ansi encoded, like the apostrophe showing up '
in the csv.
Below is a simple Yaml snapshot of an example webform ( Make note of the "Master's Student" student level option.)
I attached an image of what I see in MS Excel.
This was generated using just the webform/webform ui module enabled aside from the standard modules via https://simplytest.me/
name:
'#type': name
'#title': Name
'#title__access': false
'#suffix__access': false
'#degree__access': false
student_level:
'#type': select
'#title': 'Student Level'
'#options':
'Undergraduate Student': 'Undergraduate Student'
'Post-Doctorate Student': 'Post-Doctorate Student'
'Master''s Student': 'Master''s Student'
'PhD Student': 'PhD Student'
Comment | File | Size | Author |
---|---|---|---|
#11 | 2930089-11.patch | 12.57 KB | jrockowitz |
| |||
#9 | 2930089-9.patch | 10.16 KB | jrockowitz |
#7 | 2930089-6.patch | 0 bytes | jrockowitz |
#3 | 2930089-3.patch | 5.36 KB | jrockowitz |
#2 | webform.webform.issue_2930089.yml | 3.07 KB | jrockowitz |
Comments
Comment #2
jrockowitz CreditAttribution: jrockowitz as a volunteer and at The Big Blue House commentedThe attached form replicates the issue.
Comment #3
jrockowitz CreditAttribution: jrockowitz as a volunteer and at The Big Blue House commentedAttached patch should fix the CSV but may cause regressions elsewhere, which will hopefully be caught by the tests.
Comment #7
jrockowitz CreditAttribution: jrockowitz as a volunteer and at The Big Blue House commentedComment #9
jrockowitz CreditAttribution: jrockowitz as a volunteer and at The Big Blue House commentedComment #11
jrockowitz CreditAttribution: jrockowitz as a volunteer and at The Big Blue House commentedComment #16
jrockowitz CreditAttribution: jrockowitz as a volunteer and at The Big Blue House commentedI committed the patch. Please download the latest dev release to review.