Support

Home Forums Event Espresso Premium CSV Export (3)

CSV Export (3)

Posted: December 28, 2018 at 1:34 pm

Viewing 7 reply threads


globaldisciples

December 28, 2018 at 1:34 pm

No matter what browser I use when we batch export to a CSV it shows it on the screen. My user isn’t in a place to change the filename due to skillset. Thoughts?


Tony

  • Support Staff

December 28, 2018 at 2:14 pm

Hi there,

Are you using the latest version of Event Espresso 4? (Currently v4.9.75.p)

When you run an export, does it try to download the file straight after the click, or does it direct your to a ‘batch’ page where you can see a progress bar first?

Generally when the above happens it means the server has incorrect mime types for CSV’s so the browser opens the file as HTML. You can try adding:

AddType application/ms-excel .csv

To your sites .htaccess file within root, however, if using the batch system (progress bar) EE should be setting that mime type automatically for you.


globaldisciples

January 2, 2019 at 8:51 am

Thanks for replying! I see a progress bar then it shows the CSV right on the page.


Tony

  • Support Staff

January 2, 2019 at 9:06 am

OK, so that’s the batch export feature which is correct.

However, as mentioned that system adds a .htaccess file and sets the above mime type.

Can you send temporary login details over so I can run an export and follow the request? If so you can use this form:

https://eventespresso.com/send-login-details/


globaldisciples

January 2, 2019 at 9:08 am

Sending over now Tony. Thanks!


Tony

  • Support Staff

January 2, 2019 at 10:10 am

Ahh ok, your server is using Nginx which doesn’t support .htaccess files (which is how EE sets this on the fly).

You’ll need to contact your host and have them fix this for you, your server is returning an incorrect mime type for CSV files.

This is what I get on your site – https://monosnap.com/file/a7gFsNBAkQY4VMbN0yYRSm7S2nw0aj

This is what I see on mine – https://monosnap.com/file/DTwBhHU6dH3YJfA8qxEqRVY63jA5Mb

Because your server is telling the browser the contact is HTML ts just opening that content.

Open a ticket with your host and ask them to add this mime type to the server:

application/ms-excel .csv

This may also work:

text/csv csv;

Either way they should know how to apply it on your site for you.


globaldisciples

January 2, 2019 at 1:45 pm

Fixed. Thanks!


Tony

  • Support Staff

January 3, 2019 at 4:37 am

You’re most welcome.

Viewing 7 reply threads

The support post ‘CSV Export (3)’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso