language problem in excel backup file

hr hry 20 Nov, 2009
Hi all! I'm new around here (as you can see it's my first post!) and i'd like some help...

It's a little problem that i have, and although i've search a lot around this forum and web in general, i wasn't able to find a solution. I've created a form for a site that is in greek. Firstly, i had a problem with validation while writing in the fields in greek, but that was solved by unchecking the alphas selection. But afterwards, i realized that when i was trying to make a backup of registered users in axcel format, characters that had been written in greek was recognized only as question marks! I tried a lot of possible solutions (even changing the encoding in "admin.chronocontact.php" file but nothing :-( . It's interesting to mention that when i receive the email about the registered user's information, i can see it in greek without any problem.

Does anyone has a different solution to propose? thanx in advance!
Gr GreyHead 20 Nov, 2009
Hi hry,

Hard to tell exactly - from memory the Excel write has a utf-8 setting included. You might need to check that in the code. I assume that your database table is also using utf-8 and not a Greek encoding? Might be worth checking that too.

Bob
hr hry 23 Nov, 2009
I've already done this. Encoding in my database is also utf-8.
Gr GreyHead 24 Nov, 2009
Hi hry,

Check that this line exists - in my version it's at line 1610 of administrator/components/com_chronocontact/admin.chronocontact.php
$sheet =& $xls->addWorksheet($formname.' at '.date("m-d-Y"));
$sheet->setInputEncoding('utf-8'); // add this line 


Bob
hr hry 25 Nov, 2009
I've already done that. As i told in my first post, i tried to change that encoding to see if any change occurs, but no result 😟
Gr GreyHead 25 Nov, 2009
Hi hry,

Sorry, missed that. I haven't got anything else to suggest :-(

Bob
This topic is locked and no more replies can be posted.