OsCommerce Data Importer - Errors

[digidiva-kathy]

Not sure what you mean. I've never had this problem before with any cart I've installed (and I have done quite a few) and the only thing about this one that is unique is this import. I don't think any of these were set up manually, they imported the entire database from OSCommerce and that is what set up the categories as far as I know.

[skipwater]

Not seeing the input records of categories I am guessing that there is a bad charter in a field.
Look at the input data for "Designer Resources/Comm. Use" which woks but then "Extended Use Licenses" which is bad so I would look around these records to see if there is some bad data.

If you need to pm me the input sql data and I will look at it.

[gisco]

Hello, all,

I tried to apply this OsCommerce Data Importer but meet difficulties of characteres cannot be copied to the new database.

My Database includes UTF8 characters, and it seems to be typical "UTF8 in ADODB" problem.

Normally, use set names query like this once when firstly connect to DB to solve this problem, but I have no skill to write script.

---- sample -----

somewhat and somewhere need to write something like this:
================================================== ==========
$db->Connect( $dbhost, $dbuser, $dbpasswd, $dbname );
// Make sure any results we retrieve or commands we send use the same charset and collation as the database:
$db_charset = $db->Execute( "SHOW VARIABLES LIKE 'character_set_database'" );
$db->Execute( "SET NAMES '" . $db_charset->fields['Value'] . "'" )
$db_charset->Close(); // Optional
================================================== ==========
Resources:
http://phplens.com/lens/lensforum/topics.php?id=4
http://adviesenzo.nl/examples/php_mysql_charset_fix/

note: this was copied from PAP suport forum, but the nature is the same. This error is quite a lot for scripts from "Lain1" countries...

Is it possible to rewrite some code to apply this???

Or is there anyone who can show me where to change in the OSC data importer???

Thank you!

[skipwater]

gisco

This mod is not using ADODB it is using traditional mysql.
So the script would look like this.

mysql_query("set names 'utf8'",$con);

Find the connect sql lines .

$connected = mysql_connect($target_db_host, $target_db_username, $target_db_password);

And change to this.

$connected = mysql_connect($target_db_host, $target_db_username, $target_db_password);
mysql_query("set names 'utf8'",$con);

I have not tested let us know if this worked.

[swamyg1]

This will make my life much easier! However when trying to import customers and/or oders the export freezes before import happens, there's no error message it just stops. How to fix this? Importing products works just fine.

Here's what the end of my page looks like:

Starting Exportation of osCommerce testDB Data Base
Exporting Customers ...
................................................................................ ................................................................................ .......................................200 -|
................................................................................ ................................................................................ .......................................400 -|
................................................................................ ................................................................................ .......................................600 -|
................................................................................ ................................................................................ .......................................800 -|
................................................................................ ................................................................................ .......................................1000 -|
................................................................................ ................................................................................ .......................................1200 -|
................................................................................ ................................................................................ .......................................1400 -|
................................................................................ ................................................................................ .......................................1600 -|
................................................................................ ................................................................................ .......................................1800 -|
................................................................................ ................................................................................ .......................................2000 -|
................................................................................ ................................................................................ .......................................2200 -|
.............................2229 -|

Done 2229 Records Exported
Exporting Address Book ...
................................................................................ ................................................................................ .......................................200 -|
................................................................................ ................................................................................ .......................................400 -|
................................................................................ ................................................................................ .......................................600 -|
................................................................................ ................................................................................ .......................................800 -|
................................................................................ ................................................................................ .......................................1000 -|
................................................................................ ................................................................................ .......................................1200 -|
................................................................................ ................................................................................ .......................................1400 -|
................................................................................ ................................................................................ .......................................1600 -|
................................................................................ ................................................................................ .......................................1800 -|
................................................................................ ................................................................................ .......................................2000 -|
................................................................................ ................................................................................ .......................................2200 -|
................................................................................ ................................................................................ .................................2393 -|

Done 2393 Records Exported
Exporting Customers Info ...
................................................................................ ................................................................................ .......................................200 -|
................................................................................ ................................................................................ .......................................400 -|
................................................................................ ................................................................................ .......................................600 -|
................................................................................ ................................................................................ .......................................800 -|
................................................................................ ................................................................................ .......................................1000 -|
................................................................................ ................................................................................ .......................................1200 -|
................................................................................ ................................................................................ .......................................1400 -|

[skipwater]

Not seeing the input records of Customers Info I am guessing that there is a bad charter in one of the records around 1400 and up.

With phpmyadmin look at the table customers_info and see if there is any bad data above record 1400.

Bad data could be as simple as a ' that would upset the array content.

[gisco]

gisco

This mod is not using ADODB it is using traditional mysql.
So the script would look like this.

mysql_query("set names 'utf8'",$con);

Find the connect sql lines .

$connected = mysql_connect($target_db_host, $target_db_username, $target_db_password);

And change to this.

$connected = mysql_connect($target_db_host, $target_db_username, $target_db_password);
mysql_query("set names 'utf8'",$con);

I have not tested let us know if this worked.

Hello, thank you for the info. I have been working on this code but still not get desired result. I will try also changing some configuration of mysql.

Need more time to report the result...

[skipwater]

My Database includes UTF8 characters, and it seems to be typical "UTF8 in ADODB" problem.
gisco

Here is a fix for storing data in mysql with the utf8 Character Set.

Find the following two lines that start with. (there are more then one set in each script fix all of them)

	$connected = mysql_connect( 
	$dataopened = mysql_select_db(

Add this line below them

	mysql_set_charset('utf8',$connected);

I should look like this:

	$connected = mysql_connect(
	$dataopened = mysql_select_db(
	mysql_set_charset('utf8',$connected);

If you need other then utf8 character coding just replace utf8 with the required character code.

Skip

[kaddie]

When trying to switchover customer from OSC to ZC it starts from 200 and ends at 5200. The next line I get is this:

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 16 bytes) in /home/xxxxx.com/public_html/import_osc_customers.php on line 251

Any help would be apreciated.

Kaddie

[skipwater]

When trying to switchover customer from OSC to ZC it starts from 200 and ends at 5200. The next line I get is this:

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 16 bytes) in /home/xxxxx.com/public_html/import_osc_customers.php on line 251

Any help would be apreciated.

Kaddie

If you have a Shared Hosting account you need, if you don't have already, a 'php.ini' file which is put in your DOCUMENT ROOT dir.

In it, add the following statement:

memory_limit = 16M

Try the above setting and keep doubling till the error msg. goes away.

Skip