Support

Home Forums Event Espresso Premium CSV Export

CSV Export

Posted: December 28, 2018 at 1:34 pm


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.

You must be logged in to reply to this support post. Sign In or Register for an Account

Support forum for Event Espresso 3 and Event Espresso 4.
Documentation for EE3 and EE4
Documentation for Event Espresso 3

Documentation for Event Espresso 4

Status: publish

Updated by  Tony 1 week, 6 days ago ago

Topic Tags

Notifications

This topic is: not resolved
Do NOT follow this link or you will be banned from the site!