Export character problems

-- HikaShop version -- : 2.3.2
-- HikaMarket version -- : 1.4.1

Hi,

I'm trying to export on frontend the orders and ordered products in export view (HikaMarket). I'm writing here, because I see HikaMarket uses HikaShop's helper for that. I also use on our site quickbook plugin , to be totally clear.

I had character problems with Hungarian language (á,é,í,ó,ő,ö,ü,ű,ú). When exported in CSV I had to import it as text, when I opened it automatically in Excel, the chars was confused as well in XLS.

For example:
SOS kiszállítás
Másik tűzjelző

So I tried to solve it myself by editing /administrator/com_hikashop/helpers/spreadsheet.php and it's almost perfect both in XLS and CSV. Now only 'ő' and 'ű' chars are converted to '?' all the other chars exported correctly.

In the file I added around line 85:

if( $this->format == 0 )
echo mb_convert_encoding($this->buffer, 'Windows-1252');
else {
echo $this->buffer;
}

$len = strlen(utf8_decode($value));

$this->buffer .= utf8_decode($value);

nicolas wrote: Hi,

You should not need to change any code. HikaShop already exports your data in UTF8 which handles almost all the existing characters of almost all the existing languages on earth.
The issue is more during the import process in Excel where you need to choose UTF8 when you open the file so that it displays the characters properly.
What you're doing with your code is to convert the UTF8 data into Windows-1252 which is a format which supports only a handful of specific characters and thus, for the characters it doesn't support, it puts a question mark instead.

echo mb_convert_encoding($this->buffer, 'Windows-1252');

echo mb_convert_encoding($this->buffer, 'utf8');

After hours of playing solved it this way, maybe someone has the same problem.

In file /administrator/com_hikashop/helpers/spreadsheet.php

In the file I added around line 85:

if( $this->format == 0 )
echo mb_convert_encoding($this->buffer, 'iso-8859-2', 'auto');
else {
echo $this->buffer;
}

$len = strlen(utf8_decode($value));

$this->buffer .= mb_convert_encoding($value, 'iso-8859-2', 'auto');