|
Jim Meyer
|
October 27, 2015 at 3:02 am
Original Thread – https://eventespresso.com/topic/csv-export-renders-text/
I am suffering the same error. I am using Firefox 41.0.2 and have made sure that in Options > Applications “Microsoft Excel Comma Separated Values File” is set to “Save File”.
The first three characters rendered in the browser window are: 
-
This topic was modified 9 years, 1 month ago by
 Tony.
-
This topic was modified 9 years, 1 month ago by Tony. Reason: Split thread
|
|
Jim Meyer
|
October 27, 2015 at 3:11 am
(I have tried the solution of adding “AddType application/octet-stream .csv” to my htaccess file but, alas, no luck)
|
|
Tony
|
October 27, 2015 at 5:23 am
Hi Jim,
Did you try an export with only Event Espresso running?
Also try an export with one of the default themes active.
This is to rule out a theme/plugin conflict. We often see the first the characters “” when the theme is hooking in and altering the output.
|
|
Jim Meyer
|
October 27, 2015 at 11:05 am
I’ve tried a default theme and disabling everything other than ee4 but still no joy.
|
|
Tony
|
October 28, 2015 at 7:01 am
I’ve split your thread into is own so we can troubleshoot your issue separately.
So to confirm, you have tested your site running only EE4 (no other plugins at all) and using a default theme such as twentyfourteen (whilst no other plugins are active)?
Usually when this happens either the theme or a plugin is altering the output when EE outputs the CSV, so I want to rule that out before moving on.
Is this a Windows or Linux based server?
|
|
Jim Meyer
|
November 1, 2015 at 3:21 pm
Yes, all plugins disabled. I tried the latest default theme.
It’s a Windows server.
|
|
Jim Meyer
|
November 2, 2015 at 7:58 pm
BUMP
|
|
Lorenzo Orlando Caum
|
November 3, 2015 at 7:18 am
Hi Jim,
We do not develop on Windows servers so we are not familiar with them but we can try to help you troubleshoot this issue.
On an earlier reply, you shared that you added an entry to the htaccess file:
https://eventespresso.com/topic/split-csv-export-renders-text/#post-178229
However, Windows servers use something called a web.config file:
http://www.iis.net/learn/application-frameworks/install-and-configure-php-applications-on-iis/translate-htaccess-content-to-iis-webconfig
Do you have the option of migrating to an apache or nginx server?
—
Lorenzo
|
|
Jim Meyer
|
November 5, 2015 at 10:11 am
OK. I have updated the web.config file as follows:
`
<system.webServer>
<staticContent>
<remove fileExtension=”.csv” />
<mimeMap fileExtension=”.csv” mimeType=”application/octet-stream” />
</staticContent>
</system.webServer>
Sadly, this has not fixed the issue. It is odd because the CSV export has suddenly stopped working. It definitely worked in the past. The s2member csv export feature works fine but obviously ee and s2m are doing things differently.
If push comes to shove I could migrate but I would much rather not.
|
|
Lorenzo Orlando Caum
|
November 5, 2015 at 11:02 am
Hello,
I ran some searches and found these pages:
https://lazyloaders.com/threads/csv-file-export-tip.431/#post-6706
http://www.sqlservercentral.com/Forums/Topic1161339-1633-1.aspx
Was IIS restarted after you updated the web.config file?
—
Lorenzo
|
|
Jim Meyer
|
November 7, 2015 at 1:29 am
Thanks very much.
I did restart it, yes. I will try some of the other suggestions and let you know how it goes.
|
