export issue

  • Resolved delawaregrad

    (@delawaregrad)


    7 years, 8 months ago

    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

    (@jasongreen)

    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 7 years, 8 months ago by jasongreen.

    Hi,
    @jasongreen, Any updates on it, please share the solution as soon as possible.

    Thanks

    Hi Jason, I have problem 1) and 2) too.

    Thanks a lot

    Plugin Author jasongreen

    (@jasongreen)

    Hi

    Thanks for your patience.

    1 and 2 have now been fixed in the latest version (1.5.4).

    Thread Starter delawaregrad

    (@delawaregrad)

    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?

    Hi Jason,

    THX!

    #2 is solved.
    #1 it is the same Problem that delawaregrad has.

    Greetings, Michael

    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

    THX, Michael

    • This reply was modified 7 years, 6 months ago by mischa69.

    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

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘export issue’ is closed to new replies.