Form results export charset problem

Permalink
Hi, the accents in the forms and on the site are working just fine (in utf-8), everything is shown correctly (like á, í, ő, ű) - but when exporting the submissions to excel, the characters are just scrambled... Any hint where to start tracking down this problem?

Thanks a lot,
Tamas

1 Attachment

tamas42
 
frz replied on at Permalink Reply
frz
wooops. we'll put this in our fixit list.
Remo replied on at Permalink Reply
Remo
I think I've already fixed that on one site..

goto /concrete/controllers/dashboard/form_results.php

in the function excel, there's this stmt
echo "\t\t\t".$answer....."\r\n";


surround it with utf8_decode and it should work

echo "\t\t\t".utf8_decode($answer....)."\r\n";
tamas42 replied on at Permalink Reply 1 Attachment
tamas42
Thanks! I made the temp fix, now everything is fine - expect, that our famous "ő" and "ű" characters are resulting a "?" in the export... But I think I can live with this, I would just be quite curious, why is that :)

best for you guys, you are doing great,
Tamas
Remo replied on at Permalink Reply
Remo
all the fancy characters are working fine for me!

your page gets printed using utf-8, doens't it? meta tag - content type set to utf-8 right?
tamas42 replied on at Permalink Reply
tamas42
...yes, utf-8 is everywhere. Seems this is a punishment from the gods for using such characters in one's language :) Thanks for your support again, I will make some further research later and post the results.

best,
Tamas
andrew replied on at Permalink Reply
andrew
Unless you have some objections we'll add this to our code.