Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 20 Nov 2017, 00:53
Scandal's Avatar
Scandal Scandal is offline
 
Join Date: Dec 2005
Real name: Peter
Product import and character encoding problem

Well, we have two boards:
- one in ISO-8859-7 (Greek) / my development board
- and another one in UTF-8

When I export a product from my dev board and import it to the UTF-8 board, there is issue with the Greek characters.
They appearing as "???????".

In the other hand, if I import the same product on another ISO-8859-7 board works perfect.

Any idea how to fix it?
Reply With Quote
  #2  
Old 20 Nov 2017, 01:41
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
Is the encoding of the database with the question marks properly set?
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #3  
Old 20 Nov 2017, 01:52
Scandal's Avatar
Scandal Scandal is offline
 
Join Date: Dec 2005
Real name: Peter
hmm yes I think so, but how I can detect that it is the correct encoding?

Both boards I noticed works perfect for posting any characters (english / greek). The issue is on the product import where the greek characters inside the template saved as "?????" cause when I visited the page where a template is called, I see "?????" instead of greek chars.
Reply With Quote
  #4  
Old 26 Nov 2017, 13:47
Scandal's Avatar
Scandal Scandal is offline
 
Join Date: Dec 2005
Real name: Peter
Any idea? The product I'm trying to import is a bit big, I can't re-build it on the utf-8 board.
I need to import it so it will be working as should.

I'm using Notepad++.
Reply With Quote
  #5  
Old 26 Nov 2017, 15:06
In Omnibus's Avatar
In Omnibus In Omnibus is offline
 
Join Date: Apr 2010
Real name: Kris
Originally Posted by Scandal View Post
Any idea? The product I'm trying to import is a bit big, I can't re-build it on the utf-8 board.
I need to import it so it will be working as should.

I'm using Notepad++.
Have you tried converting the script using iconv?

https://stackoverflow.com/questions/...19843#36619843
Reply With Quote
  #6  
Old 26 Nov 2017, 15:10
Scandal's Avatar
Scandal Scandal is offline
 
Join Date: Dec 2005
Real name: Peter
Well, I found a hard-coded solution.

1. Open the exported xml with Notepad++
2. Convert it to UTF-8 (Encoding > Encode in UTF-8 > Save)
3. Open file /includes/class_xml.php, then find:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

4. Add below:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

5. Then try to import *xml product via AdminCP.

All ok!

6. Undo step #4.

Done
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 21:04.

Layout Options | Width: Wide Color: