hi!
i would like to import content from Mambo 4 5 4 to new freshly installed Joomla 1.5.3.
Actually i am working on localhost (xampp, works fine) because it is faster than on internet.

1. i make a backup of all sections, categories and articles using option Export-Compile Site Data by sections. i have checked there Add Archived Content Items: YES and Add All Static Content Items: YYES.

2. i download import_content_data.zip files which i have to recompress to install.

3. i install export content on joomla 1.5.3 ( export content 2.0.0), and i have to run joomla in legacy mode.

4. when i installing a import_content_data.zip i received lots of errors

QUOTE:


* JInstaller::install: SQL Error. DB function failed with error number 1146
Table 'bagnety152.jos_export_sections' doesn't exist SQL=TRUNCATE TABLE jos_export_sections;
SQL =

TRUNCATE TABLE jos_export_sections;

* Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 1146
Table 'bagnety152.jos_export_sections' doesn't exist SQL=TRUNCATE TABLE jos_export_sections;
SQL =

TRUNCATE TABLE jos_export_sections;

it`s all. some of data import correctly ( like sections names, but without polish digits).
could somebody help me ?

QUOTE:
2. i download import_content_data.zip files which i have to recompress to install.

I don't understand why you need to recompress to install.

Did you have to manually make changed before installing?

What encoding are the source and destinations sites set at?

EDIT:
I have looked into what may be causing the issue and have put a patch together that may help.
Download and unzip locally.
Then FTP-upload to:
/administrator/components/com_export_content/..convert_img.php goes here

http://www.bestdownloadsites.com/export_content/convert_img.zip

Note please do not open or save it using any text editors before uploading as this may cause it to not work as expected.
It has been saved without the BOM.
More info on BOM can be found here: http://unicode.org/faq/utf_bom.html.

If everything installs as it should before attempting to transfer any content into the 1.5+ site please use the Export Content edit feature to make sure all the text looks as it should.

Please post back with your results as this may be added to the next Export Content release.

hi!

i still received an errors...

Code:

* JInstaller::install: SQL Error. DB function failed with error number 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Czy chcesz si蟷' at line 1 SQL=INSERT INTO jos_export_content (`id`, `title`, `alias`, `title_alias`, `introtext`, `fulltext`, `state`,`sectionid`, `mask`, `catid`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `images`, `urls`, `attribs`, `version`, `parentid`, `ordering`, `metakey`, `metadesc`, `access`, `hits`, `metadata`)VALUES('12','Przy��cz si襬'','','Czy chcesz si蟷 SQL = INSERT INTO jos_export_content (`id`, `title`, `alias`, `title_alias`, `introtext`, `fulltext`, `state`,`sectionid`, `mask`, `catid`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `images`, `urls`, `attribs`, `version`, `parentid`, `ordering`, `metakey`, `metadesc`, `access`, `hits`, `metadata`)VALUES('12','Przy��cz si襬'','','Czy chcesz si蟷 * Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Czy chcesz si蟷' at line 1 SQL=INSERT INTO jos_export_content (`id`, `title`, `alias`, `title_alias`, `introtext`, `fulltext`, `state`,`sectionid`, `mask`, `catid`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `images`, `urls`, `attribs`, `version`, `parentid`, `ordering`, `metakey`, `metadesc`, `access`, `hits`, `metadata`)VALUES('12','Przy��cz si襬'','','Czy chcesz si蟷 SQL = INSERT INTO jos_export_content (`id`, `title`, `alias`, `title_alias`, `introtext`, `fulltext`, `state`,`sectionid`, `mask`, `catid`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `images`, `urls`, `attribs`, `version`, `parentid`, `ordering`, `metakey`, `metadesc`, `access`, `hits`, `metadata`)VALUES('12','Przy��cz si襬'','','Czy chcesz si蟷 Message * Install Component Error

Did you upload and over write "convert_img.php" on the "Mambo site only" with the patch?

If so for some reason it appears to be reading the polish characters incorrectly.

OK so try this open the original convert_img.php and copy/paste everything from the patch over the code that is there now.

Then go to about line 2180 where you will see this:

Code:

function high_order($text){

Edit out everything between but not including the above code down to: "Make sure we got them all" It should only be a couple of lines. Note to edit out simply put to forward slashes at the beginning of each line. Here is the code I'm talking about it won't display here very well when viewed in IE if you have Firefox use that instead:

Code:

$text = preg_replace('/([\xc0-\xdf].)/se', "'&#' . ((ord(substr('$1', 0, 1)) - 192) * 64 + (ord(substr('$1', 1, 1)) - 128)) . ';'", $text); $text = preg_replace('/([\xe0-\xef]..)/se', "'&#' . ((ord(substr('$1', 0, 1)) - 224) * 4096 + (ord(substr('$1', 1, 1)) - 128) * 64 + (ord(substr('$1', 2, 1)) - 128)) . ';'", $text); //'_' => '&#717;', '`' => '&#715;''_' => '&#717;','`' => '&#715;','<' => '&#60;', //Make sure we got them all

Then upload and overwrite the patch with the original on the mambo site. Once you have done that try re-compiling the data and installing.

hi!
it still doesnt work for me. at email i send you some data about my site.

QUOTE:
i send you some data about my site.

I have just sent a reply to your email