solved: UTF8 special chars, importing ft exports in excel

Alexis · (This post was last modified: Jul 1st, 2009, 4:06 AM by Alexis.)

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

***Ben*** · Jul 1st, 2009, 11:46 AM

Ah, that makes sense. Thanks for reporting the problem + fix.

Since the data is all stored as UTF-8 in the DB, I'll log this as a bug and include a fix for this in the next release (i.e. the export manager export types will have that line in the header section).

- Ben

coskundemir · (This post was last modified: Jun 9th, 2013, 7:15 AM by coskundemir.)

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

FORUMS