EventManager with åäö etc.

Next topic

Author	Message
Karl H	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
Kristof Coomans	Monday 15 October 2007 6:34:02 am Hi Karl Setting $httpCharset = 'utf-8'; works fine here. With which program did you open the downloaded CSV file? It's possible that the software didn't properly recognize the character encoding. independent eZ Publish developer and service provider \| http://blog.coomanskristof.be \| http://ezpedia.org
Karl H	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.

Author

Message

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

Kristof Coomans

Monday 15 October 2007 6:34:02 am

Hi Karl

Setting $httpCharset = 'utf-8'; works fine here. With which program did you open the downloaded CSV file? It's possible that the software didn't properly recognize the character encoding.

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

Karl H

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.