Title: export issue
Last modified: March 30, 2017

---

# export issue

 *  Resolved [delawaregrad](https://wordpress.org/support/users/delawaregrad/)
 * (@delawaregrad)
 * [9 years, 2 months ago](https://wordpress.org/support/topic/export-issue-4/)
 * I noticed the submitted form data looks great in the admin (Submissions > View),
   but the export is not it’s not very useful:
 * 1)The columns don’t line up because optional fields that are empty collapse. 
   You end up with mismatched columns.
    2)The CF7 checkboxes show, for ex: a:1{i:
   0;s:11:”Checkbox Value”;} – instead of just the checkbox value. 3) One of my 
   forms, although listed in the admin, ends up empty in the export.
 * Do I have settings wrong somewhere?
    thank you

Viewing 8 replies - 1 through 8 (of 8 total)

 *  Plugin Author [jasongreen](https://wordpress.org/support/users/jasongreen/)
 * (@jasongreen)
 * [9 years, 2 months ago](https://wordpress.org/support/topic/export-issue-4/#post-8982032)
 * This looks like some issues with the export functionality not your settings.
 * I’ll take a look and post an update soon to fix these.
    -  This reply was modified 9 years, 2 months ago by [jasongreen](https://wordpress.org/support/users/jasongreen/).
 *  [veeren9](https://wordpress.org/support/users/veeren9/)
 * (@veeren9)
 * [9 years, 2 months ago](https://wordpress.org/support/topic/export-issue-4/#post-8985550)
 * Hi,
    [@jasongreen](https://wordpress.org/support/users/jasongreen/), Any updates
   on it, please share the solution as soon as possible.
 * Thanks
 *  [mischa69](https://wordpress.org/support/users/mischa69/)
 * (@mischa69)
 * [9 years, 2 months ago](https://wordpress.org/support/topic/export-issue-4/#post-8997286)
 * Hi Jason, I have problem 1) and 2) too.
 * Thanks a lot
 *  Plugin Author [jasongreen](https://wordpress.org/support/users/jasongreen/)
 * (@jasongreen)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/export-issue-4/#post-9057220)
 * Hi
 * Thanks for your patience.
 * 1 and 2 have now been fixed in the latest version (1.5.4).
 *  Thread Starter [delawaregrad](https://wordpress.org/support/users/delawaregrad/)
 * (@delawaregrad)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/export-issue-4/#post-9057324)
 * Thanks, the checkboxes (#2) now appear correctly in the export. I still have 
   an issue with #1, though. I have an optional phone field and if someone doesn’t
   add a phone number, in the CSV phone column, the input from the _next_ field 
   displays.
 * The other issue (#3) may be because those forms are redirected through PayPal?
 *  [mischa69](https://wordpress.org/support/users/mischa69/)
 * (@mischa69)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/export-issue-4/#post-9058349)
 * Hi Jason,
 * THX!
 * #2 is solved.
    #1 it is the same Problem that delawaregrad has.
 * Greetings, Michael
 *  [mischa69](https://wordpress.org/support/users/mischa69/)
 * (@mischa69)
 * [9 years, 1 month ago](https://wordpress.org/support/topic/export-issue-4/#post-9105226)
 * Hi Jason, regarding #1 empty fields are missing.
 * When a field has no value it is not written to the database and is missing in
   the csv
 * See: export issue.JPG (Title field is present “Dr.”)
    and EmptyFieldsNotInDatabase.
   JPG
 * [https://www.dropbox.com/sh/wk1v729om5mpap8/AABtiQcjfIgrg2UAZtBB_bJBa?dl=0](https://www.dropbox.com/sh/wk1v729om5mpap8/AABtiQcjfIgrg2UAZtBB_bJBa?dl=0)
 * THX, Michael
    -  This reply was modified 9 years, 1 month ago by [mischa69](https://wordpress.org/support/users/mischa69/).
 *  [dachande](https://wordpress.org/support/users/dachande/)
 * (@dachande)
 * [8 years, 11 months ago](https://wordpress.org/support/topic/export-issue-4/#post-9243865)
 * I have created a patch which will fix this issue by not skipping empty fields
   when storing a submission in database anymore.
 * This will however not fix the CSV export of already stored submissions as they
   will still miss out the empty fields because they cannot be restored as empty
   fields.
 * You can find the patch on pastebin:
    [https://pastebin.com/TYYBizJR](https://pastebin.com/TYYBizJR)

Viewing 8 replies - 1 through 8 (of 8 total)

The topic ‘export issue’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/contact-form-submissions_181c39.svg)
 * [Contact Form Submissions](https://wordpress.org/plugins/contact-form-submissions/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/contact-form-submissions/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/contact-form-submissions/)
 * [Active Topics](https://wordpress.org/support/plugin/contact-form-submissions/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/contact-form-submissions/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/contact-form-submissions/reviews/)

 * 8 replies
 * 5 participants
 * Last reply from: [dachande](https://wordpress.org/support/users/dachande/)
 * Last activity: [8 years, 11 months ago](https://wordpress.org/support/topic/export-issue-4/#post-9243865)
 * Status: resolved