vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=325787

Product import and character encoding problem
by Scandal
20 Nov 2017 00:53

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?

Dave 20 Nov 2017 01:41

Is the encoding of the database with the question marks properly set?

Scandal 20 Nov 2017 01:52

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.

Scandal 26 Nov 2017 13:47

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++.

In Omnibus 26 Nov 2017 15:06

Quote:

Originally Posted by Scandal (Post 2591263)
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

Scandal 26 Nov 2017 15:10

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! :D

6. Undo step #4.

Done :)


All times are GMT. The time now is 20:26.

Powered by vBulletin® Version 3.8.14
Copyright © 2021, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.