export error CSV with checbox fields

  • Resolved kevingauthier

    (@kevingauthier)


    7 years, 10 months ago

    Hi when i export to CSV and have a fields that was populated by a checkbox from CF7
    the results are not what is expected because of the comma separation in the CSV format. so the results is every checkbox field is in own column pushing the data incorrectly with column header.

    and the PDF doesn’t work too

    How do i fix this.

    Thanks

    • This topic was modified 7 years, 10 months ago by kevingauthier.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author nimblechapps

    (@nimblechapps)

    Hi Kevin,

    I get your point. And, there is a way to fix it, but it would be hardcoded. I will tell you why.

    Solution:
    Go to plugins->save-contact-form-7->assets->DataTables->media->js->buttons->button.html5.min.js

    In this file search for “fieldSeparator” you will find more than one results but only one result with “,” replace it with “;” (something else which you think works for you the best) save the file. Hard refresh your browser. And that’s it!!

    Reason Why:
    We have used DataTables.net as the listing and export library, and hence we can not make such provisions as you have requested. Besides if there are going to be multiple checkboxes it would have comma in between to separate the values and hence during the export the library gets confused if this is to be considered as field or value.

    Let me know if you need more clarification.

    Hi there!

    I had the same problem, and i did everything you told me to.
    But the problem still exist…

    Pleas help!!?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘export error CSV with checbox fields’ is closed to new replies.