.XLSX and .CSV Download Error
-
Hi there,
We have been experiencing issues for the last 3 or so months that have made exporting Gravity Forms the standard way (.xlsx) impossible as the files are unable to be opened. To mitigate this issue we started exporting our forms as .CSV and this was working for most forms, however, this does not work with our contests that utilize the photo uploads field.
I have attached a link to a file that includes an image upload. It seems the image is being wrapped somehow and it not openable/downloadable if you open the URL from the CSV file. It presents an error similar to the one we get when we try and export/open .xlsx files.
We found that if we use the import/export option through Gravity Forms, we can manually export the form and the images are then downloadable, however, many of our staff are not trained to do this.
We use Gravity Forms and Gravity Forms Lite on over 50 of our websites, we love the features this plugin offers and want to continue to use it. Any feedback about a possible solution would be greatly appreciated.
Thank you!
The page I need help with: [log in to see the link]
-
Hey @brandonjza80,
I took a quick look at the URL you provided. I can see that the output is adding 3 extra empty lines. This is the reason the XLSX does not work. You can also see this at the top of your CSV file.
This means somewhere in your code, there are extra empty lines added. The usual suspect in this case is the
functions.phpfile, which either has extra lines before the PHP open tag<?php(The tag should be at the very top of the file), or a PHP closing tag, with extra lines after it.If the latter is the case, I would suggest removing the
?>tag at the end of the file, as it is not needed for PHP, and it will prevent any extra output if empty lines are added there.Hope this helps you out.
Kind regards,
Doeke
The topic ‘.XLSX and .CSV Download Error’ is closed to new replies.
