Hello,
I think there are two minor bugs with the excel exports functionality in EE 3.1.32.B.2
On admin.php/?page=events :
– For every exports (every buttons) : accented and special characters in the files exported are badly encoded. Excel uses UTF-16LE+BOM as default Unicode encoding, so there should be a conversion of the output somewhere.
– When exporting all the datas with the buttons at the bottom (export all visitors, export all events), the generated file has no .xls extension.
Thanks for reporting. I’m not sure that this is a new bug in 3.1.32.B2 but if it is we can look into it. Do you happen to know if you’ve seen this happen in 3.1.31?
Well yes I think it’s the same in the 3.1.31 version. I’m using at the moment the beta version on my dev site so I thought I’d report it in that branch first (and it’s not super important by the way).
If this is similar to a related issue that has been reported before with the exports + excel, it may help to try using the CSVFileView application. Another Event Espresso user recommended it to us because he was having some character encoding issues when importing the reports to excel.
We are going to be refactoring the reporting tools for Event Espresso 4 and I’ll be sure to include your findings with the character encoding.
We’re pretty excited with how Arabica is shaping up and looking forward to seeing it being used outside of our testing and onto real sites.
Viewing 5 reply threads
The support post ‘Excel exports with EE 3.1.32.B.2’ 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.