OsCommerce Data Importer - Errors

[skipwater]

PLEASE DISREGARD MY FIRST TWO POSTS.

I have ran the importer fine. The only problem is maybe a time out on the orders converter file?

I have over 15000 orders.

This is what i get on the screen.

and it stops.

If you are importing the old data from another server the time between the two servers might be timing out.
If you can move the old database to the new (same server) and see if it still times out.

Skip

[willie bee]

They are on the same server

[willie bee]

Is there a way you can modify the script to do a certain amount of rows at a time while importing because the order history is what is timing out I belive. The other two scripts were fine.

it's like over 15000 order history.

[skipwater]

Try edit import_osc_orders.php
Around line 304 find

/* start of export of orders */
        source_osc();

Change to look like

 /* start of export of orders */
        set_time_limit(0);
        source_osc();

See if that fixes the error or shifts it to import. If import fails add the same set_time_limit(0); to the import code.

Skip

[willie bee]

It did not.

See if that fixes the error or shifts it to import. If import fails add the same set_time_limit(0); to the import code.

Where?

[willie bee]

/********** start of import of Orders */
set_time_limit(0);
target_zen(); // Get target db info

is what i did is that rigth becuase it still stops at around 8400

................................................................................ ................................................................................ .......................................8000 -|
................................................................................ ................................................................................ .......................................8200 -|
................................................................................ ................................................................................ .......................................8400 -|
..................

anywhere where it said target_zen and target_osc. I put that no time limit code. There were several.

[willie bee]

Would it be possible to split these?

Orders
Orders Products
Orders Products Attributes
Orders Products Download
Orders Status
Orders Status History
Orders Total
Currencies

and have them do it all each separatey? Then I can find out which scection is timing out.

I'm sure it is orders status or orders status history. It's about 15K orders.

[skipwater]

Would it be possible to split these?

Orders
Orders Products
Orders Products Attributes
Orders Products Download
Orders Status
Orders Status History
Orders Total
Currencies

and have them do it all each separatey? Then I can find out which scection is timing out.

That is the way it is done now you just can't get pass Exporting Orders.


Try this edit import_osc_orders.php
Around line 304 find

/* start of export of orders */
        source_osc();

Change to look like

 /* start of export of orders */
        ini_set("memory_limit","512M");
        set_time_limit(0);
        source_osc();

Tell me if this gets a higher record count then 8400

Skip

[willie bee]

That is the way it is done now you just can't get pass Exporting Orders.


Try this edit import_osc_orders.php
Around line 304 find

/* start of export of orders */
        source_osc();

Change to look like

 /* start of export of orders */
        ini_set("memory_limit","512M");
        set_time_limit(0);
        source_osc();

Tell me if this gets a higher record count then 8400

Skip

I took a clean file from your zip, made the change and it still stops at the same place.

[skipwater]

Look at you orders table in the OSC database with phpMyAdmin around records 8410 up and see if there is bad data in one of the records.


Skip