EventManager with åäö etc.

Tuesday 09 October 2007 9:57:10 am

Hi, this is a question about the EventManager contribution - there wasn't a folder about it in the Extension section, so I'm posting it here.

We're having problems with the CSV-function and characters such as åäö. When clicking on the "Download csv list" - in the list produced some characters don't get traslated properly. ö become ö, ä becomes ä and so on.

Does anyone know how this could be solved? We've tried changing:

header( 'Content-Type: text/csv; charset=' . $httpCharset );

into:

header( 'Content-Type: text/csv; charset='UTF-8' );

in the csv.php file for that extension, but it doesn't seem to help.

Many thanks,
Karl

Monday 15 October 2007 9:21:11 am

Thanks for the reply!

We've tried to open the CSV file in both Excel and OpenOffice. After reading a bit more about this, it seems CSV files have a problem with character encoding - hence, opening the file in OpenOffice and then choosing UTF-8 as the charset when importing the file, it works OK - not quite sure how to do the same in Excel, but oh well. Then re-saving the file as an Excel (.xls) document, it maintains the right character encoding.

Not ideal if a client runs into this problem, but otherwise works OK now.