I have to export the entries of almost every form that I create, and everything about gravity forms is great up until you try to export entries, then it kind of just sucks. I have never, and I do mean never, had a form to export entries properly. I have created about twenty five forms now and without fail, exporting to csv always contains problems, mainly when it comes to addresses. I believe that exporting with a pipe delimiter rather than a comma might help this. In every export there will be addresses in the city field, cities in the zip code, states in the zip code, you name it. This needs some serious attention.
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.
Pipe Delimited Exports - Please!
-
Are you inspecting the CSV or is the problem when you import the CSV into another application such as Excel?
I ask because i'm unable to recreate the issue. The CSV escapes any commas that appear so that they aren't treated as new fields. I created a test form that consisted of a few fields, including 2 address fields and submitted a test with all the fields filled out. I then exported to CSV and the CSV is exactly as it should be.
Here is a screenshot of the CSV when I preview it on my Mac which shows me all of the fields in their proper columns: http://grab.by/9SML
Here is a screenshot of the CSV text itself (note the screenshot cuts it off because I turned off wrapping) which shows the fields correctly delimited: http://grab.by/9SMS
Here is a link to the CSV file itself so you can download it and view it: http://www.gravityhelp.com/wp-content/uploads/export-test.csv
Have you inspected the actual CSV file being generated or are you immediately importing into a 3rd party application?
Posted 13 years ago on Thursday April 14, 2011 | Permalink -
brent
MemberUpon further investigation, it almost looks like some entries into the database are the culprit and not the export. I'm viewing some of the entries in the admin area and can see where addresses are mixed up such as states before cities. How can that happen? One recent entry looks like this:
462 Robertson street P.O. Box 407
462 robertson Street, Louisiana Morganza
United StatesPosted 13 years ago on Thursday April 14, 2011 | Permalink -
Can you use the import/export tool to export your form and post a link to the form XML file so we can reproduce your form on our end and try to recreate this issue? Are you running the latest version of Gravity Forms?
Posted 13 years ago on Thursday April 14, 2011 | Permalink
