FORUMS


The Form Tools forums are no longer active, but the old posts have been archived here. Please see the Help page on how to get help / report issues.

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
XLS export not UTF?
#1
Excel export of form submissions shows all kinds of character mayhem in unicode characters. I'm correcting heaps of international submissions from abroad: germany, scandinavia and the like. Also Excel 2007 complains about damage on opening the generated file, but does open it.
Reply
#2
Hi Nowton,

I get the same error, but haven't figured out a solution yet.

Regarding the UTF-8 problem, try editing the export group via the Export Manager module and adding in the following line somewhere in between the <head> and </head> in the "Smarty template" field:

Code:
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

I think I remember reading somewhere in these forums that someone fixed it like that.

Let me know how it goes.

- Ben
Reply
#3
Thanks Ben, I adapted the template and make sure I test this later this week.
Reply
#4
just to mention... that's a soluction for the issue !
thanks again and again!
Reply
#5
Photo 
Hi Ben
I did it but did not result
I took photos of it
Please help me

[Image: csv-utf-8-fa.jpg]
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)