CSV exporter not working

  • Resolved alexxxsg

    (@alexxxsg)


    6 years, 1 month ago

    Hello team

    I have been using form entries CSV export tool for several months without problems, but after last update (1.6.6), all text fields are exported including CR/LF (new lines) so CSV file is not well formed.

    Thanks in advance

Viewing 8 replies - 1 through 8 (of 8 total)
  • Deepak Sharma

    (@sharmadpk03)

    6 years, 1 month ago

    Hi @alexxxsg,

    Can you please provide me a copy of the exported CSV file of your entry? Please let me knows and I will get back to you accordingly.

    Regards!

    Thread Starter alexxxsg

    (@alexxxsg)

    6 years, 1 month ago

    Hi @sharmadpk03

    Thx for your reply, here you have how the entries were exported before:

    ID,Nombre,Apellidos,Email,Asunto,”A quién va dirigida su consulta”,Mensaje,Estado,”Fecha de creación”,”Fecha de creación GMT”,”Dispositivo del usuario”,”Dirección IP del usuario”
    260,xxx,”xxx xxx”,[email protected],”Cambio de domicilio”,RRHH,”Hola buenas tardes, quisiera informar de mi cambio de domicilio. Mi domicilio actual es : xxx xxx xxx xxxx. N5. xxx xxx. xxx xxx. Muchas Gracias”,Publicado,”27/03/2020 18:03″,”27/03/2020 20:03″,”Google Chrome/Linux”,xxx
    357,xxx,xxx,[email protected],Nómina,RRHH,”Buenas tardes, rellené el formulario para que me mandaran la nómina por correo, pero no me a llegado, quiero saber si esta todo correcto, gracias, un saludo”,Publicado,”27/03/2020 18:16″,”27/03/2020 20:16″,”Google Chrome/Linux”,xxx

    and here how it looks for the same entries now:

    ID,Nombre,Apellidos,Email,Asunto,”A quién va dirigida su consulta”,Mensaje,Estado,”Fecha de creación”,”Fecha de creación GMT”,”Dispositivo del usuario”,”Dirección IP del usuario”
    260,xxx,”xxx xxx”,[email protected],”Cambio de domicilio”,RRHH,”Hola buenas tardes, quisiera informar de mi cambio de domicilio.
    Mi domicilio actual es :
    xxx xxx xxx xxx.
    N5. xxx xxx. xxx xxx.

    Muchas Gracias”,Publicado,”27/03/2020 18:03″,”27/03/2020 20:03″,”Google Chrome/Linux”,xxx
    357,xxx,xxx,[email protected],Nómina,RRHH,”Buenas tardes, rellené el formulario para que me mandaran la nómina por correo, pero no me a llegado, quiero saber si esta todo correcto, gracias, un saludo”,Publicado,”27/03/2020 18:16″,”27/03/2020 20:16″,”Google Chrome/Linux”,xxx

    I have copied/pasted same part of the file, so you can see the differences as they are. I have also hidden sensitive info.

    Thanks in advance

    Shiva Poudel

    (@shivapoudel)

    6 years, 1 month ago

    @alexxxsg So only text field or other fields like Textarea field data are affected. Let me know so that I can proceed further. Thanks!

    Thread Starter alexxxsg

    (@alexxxsg)

    6 years, 1 month ago

    Hi @shivapoudel

    Fields with LF/CR are affected, I guess only textarea fields are allowed to include LF/CR characters.

    Thanks!

    Shiva Poudel

    (@shivapoudel)

    6 years, 1 month ago

    Hey @alexxxsg,

    Please have a look to this commit and see if reverting code resolves your issue:
    https://github.com/wpeverest/everest-forms/commit/04a5747f4891fb60511458269f4a1346648c9552

    I need to have a look at why this was introduced!

    Thanks!

    Thread Starter alexxxsg

    (@alexxxsg)

    6 years, 1 month ago

    Hi @shivapoudel

    It is working.

    It seems that textarea fields must be sanitized for the whole value, not exploding by ‘\n’. That made the trick in my case.

    I will wait for an official update, in the meanwhile I’ll keep this workaround in the plugin code

    Thanks a lot!!

    Shiva Poudel

    (@shivapoudel)

    6 years, 1 month ago

    @alexxxsg That’s great! You can keep the changes in the plugin code. We will patch this bug in Everest Forms upcoming version update.

    Have a great day!

    Thread Starter alexxxsg

    (@alexxxsg)

    6 years, 1 month ago

    Thanks for your help,

    Have a nice day!

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

The topic ‘CSV exporter not working’ is closed to new replies.