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.
Hi,
Why the first two lines of the exported excel are empty?
Is it possible to change this?
Thanks!
Comment | File | Size | Author |
---|---|---|---|
#6 | webform-remove_submission_info-1886842-6.diff | 1.62 KB | jadsay |
#4 | webform-remove_submission_info-293908-4.diff | 1.82 KB | jadsay |
Comments
Comment #1
dromansab CreditAttribution: dromansab commentedIs this issue solved in new version of the module?
I've a customer who is is strongly emphasizing on this theme ;-)
Thanks!
Comment #2
quicksketchThe first row contains the full title of the Webform node.
The second row contains the title of any combination elements that have multiple columns, including grid components and select lists.
The third row contains the the title of any simple elements like text fields, or in the case of multi-element fields like grid and select lists, the labels for individual options.
So I could see you wanting to remove the first line since it doesn't contain anything else other than the title, but the second line is quite useful if you start exporting complicated elements.
Unfortunately these first lines are not changeable. We added hooks to override the output of individual component's CSV data at #1533408: Allow modules to modify exported submissions, but that won't help with the node title being added to the first line. In the 8 years of Webform's history though, no one has found this to be particular problem. I'm not sure if we need to offer the flexibility to remove it, but if there's a suggestion that is easy enough to implement we would consider it.
Comment #3
quicksketchClosing after lack of activity.
Comment #4
jadsay CreditAttribution: jadsay commentedThis patch provide the ability to remove the submission info above the csv header. Applies on 7.x-4.x.
Comment #5
jadsay CreditAttribution: jadsay commentedComment #6
jadsay CreditAttribution: jadsay commentedPatch for 7.x-4.15
Comment #8
Liam MorlandThanks for the patch. Please check your coding standards. It would be great for this to have a test. Is there a reason it sets $header[0] and $header[1] then unsets them? Could it not just not set them?
Comment #9
Chris Matthews CreditAttribution: Chris Matthews as a volunteer commented@jadsay, Is there a reason it sets $header[0] and $header[1] then unsets them? Could it not just not set them?