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
solved: UTF8 special chars, importing ft exports in excel
#3
Hi Alexis,

I owe you a thanks after 4 years your post. I spent a lot of time for this problem. And it is solved by add following code.

Now Turkish Chars are look fine when i export in xls.

That's way to correct problem;

1st Option,

Click blue icon at the right side of the export module under the submission page.

Open Export Manager > Click Edit icon across the Excel line > Main Menu > Smarty Template > Add following code;

2th Option.

Settings > Menu > Edit(click pen icon) > Add Row > Choose Export > Click Update and Refresh page.

Export Manager will appear left side of the page > Click Export Manager Menu;

Click Edit icon across the Excel line > Smarty Template > Add following code;


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

{$export_type_smarty_template}

</body>
</html>


That's all.


Thank you.



(Jul 1st, 2009, 3:42 AM)Alexis Wrote: Hello

I have a problem when importing in excel FT exports. Many of my submissions contain special chars (éàç ....),everything is UTF 8 encoded.

i tried to export in xls and csv format, if i look at the file with a text viewer everything is fine, but if i open it with excel special chars are scrambled (Réanimation Médicale instead of Réanimation Médicale). i could not find the way to import correctly

solved by adding <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
in the headers of the xls file

Reply


Messages In This Thread
RE: solved: UTF8 special chars, importing ft exports in excel - by coskundemir - Jun 8th, 2013, 11:09 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)