Problem with CSV Export

[tyler-ament]

I'm seeing problems with keeping data consistent in CSV exports. For example, if I have fields setup in a Formz form that are first name, state, and email address, the column headings will be correct in the csv, but the values are sporadically placed per row in the wrong columns.

Please let me know how to troubleshoot this as it causes serious problems for clients who need to export their own form submission data.

Thanks!

[tyler-ament]

@markwillis82 Hey Team, sorry to bug you guys but curious if there is anything you could point me to here for a solution. Here's an example of a CSV export via the export submissions button: "Sent On","IP Address","Question","Email","State","Last Name","First Name" "08/05/2015 22:28:14","xxx.xx.xx.xx","Tyler","Ament","email@test.com","CA","This is a question." "08/05/2015 22:29:13","xxx.xx.xx.xx","Testing. ","email@test.com","AL","Ament","Tyler"

[achterbahn]

Same problem (sometimes) here. Can not reproduce it, nor does it happen all the time. Hope you find a solution.

[neoneddy]

Seeing it here too.

[achterbahn]

I think I found a solution for the mixup during export.
Just add the following line in /core/components/formz/processors/mgr/formz/data/export.class.php
Line 62: array_multisort($fieldsData);