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.

Export CSV is missing data or contains extra characters

  1. Chad Ross
    Member

    PHP Version: 5.2.10-2ubuntu6.4
    MySQL Version: 5.1.37
    WordPress Version: 3.1.1
    Gravity Forms Version: 1.5.1.1

    After updating to Gravity Forms 1.5.0, some odd behaviors have crept in on the Export to CSV functionality. I now have one Form that the export is only a single field '1463', where that is not one of the columns and is not found in the data. The rest is totally empty, where this form should have around 1500 rows.

    Another form adds a row before the header row that is just '2063', and then on row 2 begins the normal header row that usually is in row 1. The first field of the header row in this export is 'Product Name' but displays as '"Product Name"'. The rest of the 2000 rows of data seem to display normally.

    Updating to 1.5.1.1 has not altered this behavior. The exported CSVs can be e-mailed if necessary.

    The CSV export is a vital part of how Gravity Forms is used, so any help is appreciated.

    Edit: checked the database, and that field in xxxx_rg_form_meta is listed just as 'Product Name', so it's stored in the DB right, but isn't being read correctly at some point.

    Posted 13 years ago on Monday April 11, 2011 | Permalink
  2. The export CSV won't help debug, we would need access to the site itself so we can do some tests if you can send us a WordPress admin login for this site via our Contact Us form we can take a look and see what is going on.

    Posted 13 years ago on Monday April 11, 2011 | Permalink
  3. Chad Ross
    Member

    It's internal only behind a company VPN, so I can't provide the log in or URL. Any other options? DB backup helpful?

    Posted 13 years ago on Monday April 11, 2011 | Permalink
  4. If you can export the form using the Import/Export tool to XML and make it available to us somewhere we can first test with your form by importing your form XML and see if it's something specific to your forms. We can go from there and see if we need additional data. If we can't replicate it, it's difficult to debug things without site access so we will have to see what we can do.

    Posted 13 years ago on Monday April 11, 2011 | Permalink
  5. Chad Ross
    Member

    Thank goodness... Granted, I should have done 'Wordpress troubleshooting 101' first... I swear I kick myself every time I don't do that, but I deactivated the only other plugin that was updated recently and now the form that wouldn't export anything at all exports successfully again. All forms still have the extra row with the number and junk characters in the first field but a major phew....

    'Better WP Security' is the seemingly incompatible plugin. http://www.chriswiegman.com/projects/better-wp-security/.

    Posted 13 years ago on Monday April 11, 2011 | Permalink