Sync Tool and osCommerce Data Export

Pasted the errormsg below as I get the message it includes too many links when trying to post it here directly:

http://pastebin.com/Dw89Pvjh

What I did was install Sync Tools in Litecart and it shows up correctly. osCommerce importer was installed into the directory of the osc-store where admin.php, index.php, login.php etc etc are as it didn't state clearly where it should go so the 'root' seemed the most obvious. Any ideas?

After changing back to php 5.3 from 5.4 (getting some osC issues with 5.4 but been ignoring them as we're moving over to LC anyway) the following error is shown instead. Quite similar but not 100% the same, and prior to changing PHP version it was always exactly the same errormsg

http://pastebin.com/gGM32zTe

osC is built for PHP 4 early 5.

The xml output is probably invalid and we will see if this is by the addon or your custom osc platform.

I see, that explains the issues we were having when going from 5.3 to 5.4 perhaps. Could it have something to do with the charsets? osc is using latin1_swedish_ci and litecart utf8_general_ci which is also database default

To answer my own question: This does not fix things, I ran a script to change all collations to utf8_general_ci and I still get the same error as in the 2nd pastebin since I stuck to 5.3 for now

Scrambled characters in the output data.

Make sure your php mysql client is set to input/output the charset for oscommerce. LiteCart is no trouble.

Perhaps this can help. http://oscommerce-addons.com/addon.php?AddonID=12

Once the data is correct in the oscommerce database. The feed will automatically take into consideration if the output needs charset conversion or not.

header('Content-Type: application/xml; charset=UTF-8');
echo strtolower(CHARSET) == 'utf-8' ? $xml : utf8_encode($xml);

The CHARSET definition is stated in the language pack in osCommerce. Use ISO-8859-1 for 2.2 and UTF-8 for 2.3+.

Well, I suppose I'm answering the same person on email and here but figured I'll post here still anyway in case anyone else checks in that might have a clue as well. :)

Our oscommerce uses version 2.2-MS2 so it should all be ISO-8859-1 there then I suppose, just looked that up now. Suppose we'll need to find a way to unscramble the characters..

Iconv could be your friend. There is a paramter to discard unmatched byte records instead of turning them to question marks.

http://php.net/manual/en/function.iconv.php

Thanks! I'll try to find a way to incorporate the //ignore iconv command somehow. :)