|
iASolutions
|
March 27, 2020 at 1:10 pm
We are using Event Espresso Plugin for event management. we used to export event registration with “Registration CSV Report” option, which allow us have to store registered events in a excel sheet. It doesn’t seem to work now. When we hit “Registration CSV Report” it displays non formatted text on the browser window. We are not able to import the content in a sheet as before. Please help us to fix the issue asap
|
|
Josh
|
March 27, 2020 at 1:19 pm
Hi,
May I ask which browser were you using (e.g. Safari, Chrome, Firefox) and can you try an alternative browser to see if it makes any difference?
|
|
iASolutions
|
March 27, 2020 at 1:23 pm
Hi,
I tried Safari, Chrom, and Microsoft edge to no luck.
Thanks
|
|
Josh
|
March 27, 2020 at 1:32 pm
Have any edits been made to the site’s theme or edits to plugins been made since the last time the CSV report generated as expected?
If you’re not sure, you could disable all plugins and switch to a default theme such as twentytwenty then run CSV report. This will rule out any potential issues caused by the theme or other plugins.
|
|
iASolutions
|
March 27, 2020 at 1:42 pm
Hi Josh,
I am not sure but I went and deactivated each plug in besides EE and even changed my Theme to twentytwenty and it is still producing the same issue. Any other suggestions?
Thanks
|
|
Josh
|
March 27, 2020 at 1:55 pm
It may be that your server is returning an incorrect MIME type for CSV files. What that means is the server is telling the browser the content is HTML (not a CSV file) so the browser tries to open the content instead of saving to a file.
You can open a ticket with your host (which appears to be Kinsta, so it’s nginx) 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 this on your site for you.
|
|
iASolutions
|
March 27, 2020 at 2:09 pm
Boom thank you josh!!!
|
|
Josh
|
March 27, 2020 at 2:21 pm
You’re most welcome.
|
