Support

Home Forums Event Espresso Premium Encoding in the XLS export

Encoding in the XLS export

Posted: August 31, 2012 at 4:16 pm


Jano Costard

August 31, 2012 at 4:16 pm

At the moment, when exporting the attendee list into the XLS file, German characters such as “ä2” are displayed wrong. Is there a bugfix to display the characters correctly?


Dean

September 3, 2012 at 1:25 am

Hello Jano,

I tried a little fix (adding the UTF-8 headers to the export code if you’re interested) but it didn’t work.

I have filed a bug report to the developers.

However, there is a workaround (tested with Excel 2010). Download the xls file. Open the xls file in Notepad, copy and paste it into a new Excel workbook.

I didn’t need to do anything it all went into columns fine, but if needed, highlight the text in the spreadsheet and go to Date tab, text to columns.

This was tested with Scandinavian characters (äöå) but I assume it will be the same for German ones.

The support post ‘Encoding in the XLS export’ 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.

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: closed

Updated by  Dean 8 years, 5 months ago ago

Topic Tags

Notifications

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