When exporting form data with DVG Webform components, the column names are outputted in the first row, instead of in the third row. 

"test","","","","","","","","","","","Postal code",""
"Submission Details","","","","","","","","","","",""
"Serial","SID","Submitted Time","Completed Time","Modified Time","Draft","IP Address","UID","Username","Betaling","Textfield","Select"
"1","1","19-09-2017 - 12:54","19-09-2017 - 12:54","19-09-2017 - 12:54","0","10.0.92.1","1","Beheerder","","Baris","3512CL","Groen"

For example, see above. Postal code should be on the third line. Same goed for the other DVG webform components. Having the field name in the wrong line results in columns shifting. The data from the next column is displayed in the Postal code column.

Also, DVG always uses the field labels, even if the user wants to export keys.

CommentFileSizeAuthor
#3 exporting_results-2909914-3.patch4.28 KBralphvdhoudt
#2 exporting_results-2909914-2.patch2.84 KBBarisW

Comments

BarisW created an issue. See original summary.

BarisW’s picture

BarisW commented
Status: Active » Needs review
StatusFileSize
new exporting_results-2909914-2.patch2.84 KB
ralphvdhoudt’s picture

ralphvdhoudt commented
StatusFileSize
new exporting_results-2909914-3.patch4.28 KB

Enhanced the export a little bit more now includes
* Correct key names
* Better second row (includes correct columns of extra data)
* House letter en addition
* PO Box support

ralphvdhoudt’s picture

ralphvdhoudt commented

  • ralphvdhoudt committed 1b8388e on 7.x-1.x 
    Issue #2909914 by BarisW, ralphvdhoudt: Exporting results results in...
ralphvdhoudt’s picture

ralphvdhoudt commented
Status: Needs review » Fixed

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.