|
DiabetesFeetAustralia
|
October 29, 2021 at 11:10 am
Hi there,
When we try to download a CSV report it just opens the file in a chrome window. Is there a way to download the file please?
|
|
Harshad Mane
|
October 29, 2021 at 11:56 pm
Hi there,
Does the CSV file has any content in it? Or is it a blank page?
Or do you only have issue with downloading the CSV file?
Regards,
Harshad
|
|
DiabetesFeetAustralia
|
October 30, 2021 at 7:38 am
Hi Harshad, thank you for the reply.
It has content, please see this screenshot. https://share.getcloudapp.com/mXuP5B6j
I can log in via ftp and download the csv file, but our staff member is unable to do that.
Regards
|
|
Harshad Mane
|
October 31, 2021 at 9:35 pm
Hi there,
Are you able to download the CSV file on other browser like Firefox or Safari?
Regards,
Harshad
|
|
DiabetesFeetAustralia
|
November 1, 2021 at 7:18 am
Hi Harshad,
In Safari it does not work: https://share.getcloudapp.com/E0uK4eAp
I also tested it in Opera, same result.
|
|
Harshad Mane
|
November 1, 2021 at 9:28 pm
Hi there,
Could you please try adding define('EE_USE_OLD_CSV_REPORT_CLASS', true); to your wp-config.php file and check if you are able to download the CSV reports to you computer?
Regards,
Harshad
|
|
Tony
|
November 2, 2021 at 4:49 am
Hi there,
As this is happening on multiple browsers it may be that your server is returning an incorrect MIME type for CSV files. What that means is the server is basically 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.
If you 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;
Does the file then download?
|
|
DiabetesFeetAustralia
|
November 2, 2021 at 9:40 am
Thank you! That fixed the issue.
|
|
Tony
|
November 2, 2021 at 9:54 am
Great, can I just check which fix above you used?
I don’t recommend using define('EE_USE_OLD_CSV_REPORT_CLASS', true); unless absolutely necessary as it switches your site away from the ‘batch’ system we use. If you have larger numbers of registrations (depends on the server but roughly 2/3000) you’ll need the batch system to work to be able to export them.
|
|
DiabetesFeetAustralia
|
November 2, 2021 at 9:56 am
I asked the host to add the mime type to the server.
|
|
Tony
|
November 2, 2021 at 9:57 am
Ahh, great!
Any further issues (hopefully none with the above 🙂 ) just let us know.
|
