PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Problem with .csv export files

Gravity Support Forums » Plugin Support » Gravity Forms

  1. maelle
    Member

    I have 6 forms on my website right now (actually 2 forms split into 3 languages since the WPML multilanguage plugin for Gravity Forms does not work) and I have some issues exporting data into Excel. The .csv generated by the Export functionality gives really messy files and I have seen from the forum that I was not the only one but no real solution was provided. I have tried exporting data directly from the database (wp_rg_lead_detail) but forms are mixed (ID not corresponding) and I do not have all the data I see from Form Entries.

    Is there also a way to have accents and special characters kept? We have entries in French and Italian.

    I am ready to give you a temporary access to my Wordpress dashboard via e-mail as I need these entries really quickly.

    Looking forward to your answer,
    Maëlle

    Posted 12 years ago on Thursday January 19, 2012 | Permalink

  2. Chris Hajer
    Key Master

    What do you mean "really messy files"? It might be from non-English characters in the data, but I've never experienced that. If you would like someone to take a look, please send a WordPress admin login to chris@rockegenius.com and let us know which form you would like to export entries for. Please also reference this topic. Thanks.

    Posted 12 years ago on Friday January 20, 2012 | Permalink

  3. maelle
    Member

    I do have problems with accents in French and Italian but my main issue (in all languages) is that fields are mixed up when placed in columns. Text paragraphs for example are split up and some entries are missing. I sent you and email with Wordpress access.

    Thanks, Maëlle

    Posted 12 years ago on Friday January 20, 2012 | Permalink

  4. Chris Hajer
    Key Master

    Maëlle - I emailed you. I was able to open your CSV in OpenOffice without incident and paragraphs were preserved in the Description field.

    Posted 12 years ago on Saturday January 21, 2012 | Permalink

  5. petros
    Member

    Hello, I have the same issue but with excel 2007 witch my client uses, in openoffice the .csv file is PERFECT but in excel 2007 and in Libreoffice it is a mess (column data is mixed with field data and is fragmented). Is there any setting that you know of that fixes the excel 2007 issue or should i just press my client to install openoffice?

    Thank you for your help.
    Petros

    Posted 12 years ago on Thursday July 19, 2012 | Permalink

  6. petros
    Member

    Found a good tool for the csv files, it is CSV Reader 3.2
    Problem solved ;)

    Posted 12 years ago on Thursday July 19, 2012 | Permalink

  7. David Peralty

    Most likely though, your CSV problem was that it wasn't parsing the data based on commas correctly. This does sometimes happen if you don't set the program to UTF-8 and Comma when importing the exported files. Glad you found a solution that works for you though.

    Posted 12 years ago on Thursday July 19, 2012 | Permalink

  8. petros
    Member

    In excel one must rename the csv to txt, use something that is called "Import Text Wizard" to be able to select UTF-8 and Comma. UTF-8 is so necessary for non-latin characters isnt it?

    Posted 12 years ago on Thursday July 19, 2012 | Permalink

  9. Chris Hajer
    Key Master

    Yes, please select UTF-8 for all characters to be properly imported.

    Posted 12 years ago on Friday July 20, 2012 | Permalink

  10. coolstate
    Member

    Hi there!

    I'm having the same problem as Maelle. My site is using WPML and an extract of the CSV exported looks like this:

    3xŬ]Ë:Ù–Ó²\’í\9 î ã'V0‚3’iì‹ýt£îªnº±ûn£6ªP°ó¾b¿@¿BoŒÿ%Ùži‡ä\éé™&ƒdÿqãûþÿûÿ¹ùÊ]¨ÍÖæY‡òjw†ÿn»~@/^¹©…nà§+z÷<º´<ß³VQfÍ•[î8ÊR+Kþ

    Here are the forms is my site:

    http://barcelona-sounds.com/solicitud-guest-list-offbarcelona-2013/
    http://barcelona-sounds.com/en/offbarcelona-2013-guest-list-subscription/

    I've tried importing the CSV into Excel and changing the Character Encoding to any possible option. No luck.

    Any solution please?
    Thanks in advance.

    Posted 11 years ago on Wednesday May 22, 2013 | Permalink

  11. coolstate
    Member

    Any help with this please? Thank you! :O)

    Posted 11 years ago on Wednesday May 29, 2013 | Permalink

  12. David Peralty

    Can you send your export file to peralty@rocketgenius.com with a link to this thread, so I can look at it? If you are willing, I'd love the login details for your site, so I can generate and export just to confirm it is coming out wrong and that there aren't any on page errors.

    Posted 11 years ago on Wednesday May 29, 2013 | Permalink