CSV export: changing separator

  • Resolved arfufu

    (@arfufu)


    1 year ago

    Dears,

    Not having the choice to change the separator for CSV exportation makes data collection very difficult. Indeed, we have many answers with commas and even the first field, the date, has a comma that separate in 2 columns when we want to put data in order in Excel.

    We managed to edit a file in the past to change the comma separator to ” ; ” but impossible to find it again.

    Would you be able to help us find which file and line we should edit to change the separator?

    thanks a lot

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Nebu John – WPMU DEV Support

    (@wpmudevsupport14)

    Hi @arfufu,

    I hope you are keeping well and thank you for reaching out to us.

    The plugin currently utilizes the standard PHP “fputcsv()” function to generate the CSV output, which defaults to using a comma as the delimiter.

    Although the function does allow for specifying a different delimiter, Forminator does not currently incorporate this option.

    Unfortunately, there’s no existing filter available for this purpose, which means there’s no straightforward code patch or workaround at the moment. One potential workaround could involve leveraging a third-party integration, such as Google Sheets, to export the data and then generate a CSV with a custom delimiter from there.

    Regarding Forminator itself, we’ve already had a task on our internal roadmap to enhance the plugin’s code, enabling the customization of delimiters. While I can’t provide a specific timeline for this enhancement, rest assured it’s on our radar for future implementation.

    Kind Regards,
    Nebu John

    Plugin Support Amin – WPMU DEV Support

    (@wpmudev-support2)

    Hello @arfufu ,

    We haven’t heard back from you for several days now. In this case, I will close this topic. But feel free to reopen it if needed.

    kind regards,
    Kasia

    Thread Starter arfufu

    (@arfufu)

    Dear Nebu, Kasia,

    Thank you. After your reply, I realized that the issue was maybe more due to the ” “

    I think the date field doesn’t include ” ” and it slips the data in 2 row after exportation and conversion. So maybe it could be a way of improvment.

    I also had some content in the fields with extra ” ” typed by people that messed up the data a little bit. I managed to handle it by hand.

    Have a great day

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘CSV export: changing separator’ is closed to new replies.