I followed the below post, but still could not get it work for my UTF8 content. My UTF8 Exported content shown all as ?????.
http://www.bestdownloadsites.com/export_content/component/option,com_fireboard/Itemid,13/func,view/id,1167/catid,1/

Please help!

Hi skyfranky,

I will need some info first like what versions of Joomla you are moving data between?

What versions of PHP?

Are both source and destination sites UTF8?

What versions of export content have you got installed?

I am trying to migrate contents from Joomla 1.0.12 to Joomla 1.5.4

running PHP 5, and all sites (old and new) are in UTF8 with the latest ver of export content.

I had the convert_img.php modifed as below:
first part

Code:

function numeric_html($text){ return $text; }

second part

Code:

function high_order($text){ return $text; }

QUOTE:
I am trying to migrate contents from Joomla 1.0.12 to Joomla 1.5.4

running PHP 5, and all sites (old and new) are in UTF8 with the latest ver of export content.

So to be clear you have:

Export Content version 1.7.0 installed on the Joomla 1.0.12 site.

Export Content version 2.0.0 installed on the Joomla 1.5.4 site.

You made the above changes to "convert_img.php" on the Joomla 1.0.12 site.

On the Joomla 1.0.12 when you compile for 1.5+ and look at the SQL data file on the download page (trouble shooting) a lot of the content is showing as ?? marks.

A few more questions:
What language is the content in?
Is "iconv library" enabled on the servers?
Is there any spaces in the image names like "this is an image name.gif" for example?
Export content will look for the "mosimage" bot and attempt to covert to proper <img tags but may have a problem if there are spaces in the names.

Another thing to check is to make sure:
/administrator/components/com_export_content/zip...
/administrator/components/com_export_content/new_version...
Are both writable 777

If all the above info checks out ok maybe convert_img.php was not saved correctly after the changes.
I have attached a new convert_img.php try removing the old one first before FTP this one into place on the Joomla 1.0.12 site.
Note: It is zipped so you will need to unzip locally first.

Please post back with you results.

when I view the Compiled Content SQL installation File in Joomla 1.0.12, everything looks fine and I can see my chinese content there without ??? problem. but when I import to J1.5.4, I got ??? as shown in the attached image.

QUOTE:
So to be clear you have:

Export Content version 1.7.0 installed on the Joomla 1.0.12 site.

Export Content version 2.0.0 installed on the Joomla 1.5.4 site.

You made the above changes to "convert_img.php" on the Joomla 1.0.12 site.

On the Joomla 1.0.12 when you compile for 1.5+ and look at the SQL data file on the download page (trouble shooting) a lot of the content is showing as ?? marks.

Yes, this is what I did.

A few more questions:
What language is the content in?
Chinese

Is "iconv library" enabled on the servers?
Yes

Is there any spaces in the image names like "this is an image name.gif" for example?
Export content will look for the "mosimage" bot and attempt to covert to proper <img tags but may have a problem if there are spaces in the names.
No space images

Another thing to check is to make sure:
/administrator/components/com_export_content/zip...
/administrator/components/com_export_content/new_version...
Are both writable 777
Yes, they are in 777

If all the above info checks out ok maybe convert_img.php was not saved correctly after the changes.
I have attached a new convert_img.php try removing the old one first before FTP this one into place on the Joomla 1.0.12 site.
Note: It is zipped so you will need to unzip locally first.
replace with your file, but still the same.

Please see attached image here.

Can you send me the data downloaded so I can get a better idea of whats going on.

Also can you send a text file with one of the articles that is not being exported correctly.

Email to: This e-mail address is being protected from spam bots, you need JavaScript enabled to view it or post a link here.

OK received the data.
But I won't have the time to look into it until tomorrow.

Hi Franky,

I have had a look at it and done a bit of research and believe it may be due to the version of mysql you have on the source site.

There is a bug when importing from MySQL 4.0.x. the Chinese text will be garbled.

Could you please report what version of MySQL you are running on the Joomla 1.0.13 site.

Steve wrote:

QUOTE:
Hi Franky,

I have had a look at it and done a bit of research and believe it may be due to the version of mysql you have on the source site.

There is a bug when importing from MySQL 4.0.x. the Chinese text will be garbled.

Could you please report what version of MySQL you are running on the Joomla 1.0.13 site.

That's not likely because I am using bluehost.com, and it is using MySQL 5.0.45, which supports UTF8 for Chinese very well.

Did you try to import the content in your J1.5? Do you have the ???? issue?