Post by kornovec » Thu Sep 10, 2009 5:34 pm

Hello,

im using export/import module as well. But there is a problem with characters of my country on output view in description.

Example: http://www.petrsyrovatka.cz/index.php?r ... uct_id=341

And there should be:
Všechny stroje Echo mají výkon měřený dle ISO 8893, tato norma není porovnatelná s běžně uváděnými výkony u jiných přístrojů evropských značek měřených podle jiné normy. Obsah(cm3) 23,6, výkon(kW/PS) 0,66, hmotnost(kg) 6,1, délka lišty(cm) 101

Where should i change something in code to view all characters ok? I see there are the same characters in table product_description, but only description on output is viewed bad. = Name and the rest of all data is viewed OK.
It is excatly characters: "á é í ó ú ý"

I cant set charset on excel file, or i can?
Would be cool to fix it for non english use.

Thanks,
K.

New member

Posts

Joined
Mon Jun 15, 2009 5:02 pm

Post by kornovec » Thu Sep 10, 2009 7:25 pm

FIXED!

/catalog/controller/product/product.php - #206:

FROM:

Code: Select all

$this->data['description'] = html_entity_decode($product_info['description']);
TO:

Code: Select all

$this->data['description'] = html_entity_decode($product_info['description'], ENT_QUOTES, 'UTF-8');
Thanks to POŤA!

New member

Posts

Joined
Mon Jun 15, 2009 5:02 pm

Post by julicek » Tue Jan 03, 2012 7:36 pm

Hello,

I have this problem:
http://www.zlatebobule.cz/palava-2008-ps-krist

CTRL+U

in description, title,...

there are á......

I am using import made in google docs

Previous solution in your posts is already implemented in opencart.

How to solve this? thanks

Newbie

Posts

Joined
Wed Aug 24, 2011 4:50 am

Post by straightlight » Tue Jan 03, 2012 11:50 pm

From catalog/controller/common/header.php file,

if you replace these two lines:

Code: Select all

$this->data['title'] = $this->document->getTitle();
$this->data['description'] = $this->document->getDescription();
with:

Code: Select all

$this->data['title'] = html_entity_decode($this->document->getTitle(), ENT_QUOTES, 'UTF-8');
$this->data['description'] = html_entity_decode($this->document->getDescription(), ENT_QUOTES, 'UTF-8');
What would be the results in your case ?

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by julicek » Thu Jan 05, 2012 10:38 pm

Hello,

Thank you very much, it helped in part of showing code.

Unfortunately, it also do this problem in category names, and other parts of web
<div id="categories" class="s_nav">

I must replace many parts of code.

But my problem i expect is mainly in importing products into database with tool export/import. Upper solution does not solve searching problem

f.e.
rulandské šedé
http://www.zlatebobule.cz/index.php?rou ... A1ed%C3%A9

and also export for system, which compare products - google,heureka and zbozi in czech republic
http://www.zlatebobule.cz/zbozicz_oc15.php

Because it take it from databese, where it is wrong.

:-(

Newbie

Posts

Joined
Wed Aug 24, 2011 4:50 am

Post by straightlight » Thu Jan 05, 2012 10:47 pm

It is possible that some characters may be rejected from SQL libraries in rare cases when it comes in string but I have not seen this very often with UTF-8 binary. Do you use a contributed module when importing / exporting or the one from the admin's core that is already implemented ?

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by julicek » Fri Jan 06, 2012 4:00 am

Hello,

I am using this extension and in attachment is imported file.

http://www.opencart.com/index.php?route ... order=DESC

I also tryied change coding to UTF in pspad.

If you can find mistake in my file or some advice how to tranform fole into format which opencart(import tool) accept it would by great! :-)

Thanks

Attachments


Newbie

Posts

Joined
Wed Aug 24, 2011 4:50 am

Post by straightlight » Fri Jan 06, 2012 4:04 am

Since this is about a contribution, did you contacted the author regarding these problems ?

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Who is online

Users browsing this forum: No registered users and 52 guests