OsCommerce Data Importer - Errors

[kaddie]

I tried to edit my post but could not. Here is a better description of my issue.

Importing products for the second time. I already imported about 2600 products about 6 months ago. I have been working parttime on my Zen Cart Store. I need to import about 200 more new products and its options and attributes to Zen Cart. However, I do not want to import any images at all. How do I go about doing this. I have image handler installed and all images complete for each product, However, when I import the product images they are over written and change what I have already done. I have to go in and change images back to my handler images (what a pain). I do not want the images imported at all.

Thanks,
Kaddie

[skipwater]

I tried to edit my post but could not. Here is a better description of my issue.

Importing products for the second time. I already imported about 2600 products about 6 months ago. I have been working parttime on my Zen Cart Store. I need to import about 200 more new products and its options and attributes to Zen Cart. However, I do not want to import any images at all. How do I go about doing this. I have image handler installed and all images complete for each product, However, when I import the product images they are over written and change what I have already done. I have to go in and change images back to my handler images (what a pain). I do not want the images imported at all.

Thanks,
Kaddie

Kaddie

OsCommerce Data Importer imports the image files names not the true image files.

If you do not want to have the image file names transferred.

Open file import_osc_products.php around line 505 you will find:

/********** start of import of products */
        target_zen(); // Get target db info
        echo '<br /><b>Importing Products ...</b><br />';
        $idot = 0;
        $ii   = 0;
        if (count($import_products) > 0) { // Test empty
            mysql_query("TRUNCATE `" . $target_db_table_prefix . "products`");
            while (list($i, ) = each($import_products)) {
                $insert_products = "INSERT INTO " . $target_db_table_prefix . "products SET
                  products_id = '" . $import_products[$i]['products_id'] . "', 
                  products_quantity = '" . $import_products[$i]['products_quantity'] . "', 
                  products_model = '" . $import_products[$i]['products_model'] . "', 
                  products_image = '" . $import_products[$i]['products_image'] . "', 
                  products_price = '" . $import_products[$i]['products_price'] . "', 
                  products_date_added = '" . $import_products[$i]['products_date_added'] . "', 
                  products_last_modified = '" . $import_products[$i]['products_last_modified'] . "', 
                  products_date_available = '" . $import_products[$i]['products_date_available'] . "', 
                  products_weight = '" . $import_products[$i]['products_weight'] . "', 
                  products_status = '" . $import_products[$i]['products_status'] . "', 
                  products_tax_class_id = '" . $import_products[$i]['products_tax_class_id'] . "', 
                  manufacturers_id = '" . $import_products[$i]['manufacturers_id'] . "', 
                  products_ordered = '" . $import_products[$i]['products_ordered'] . "'  
             "; 

Now just delete line 517

products_image = '" . $import_products[$i]['products_image'] . "', 

as shown below:

 /********** start of import of products */
        target_zen(); // Get target db info
        echo '<br /><b>Importing Products ...</b><br />';
        $idot = 0;
        $ii   = 0;
        if (count($import_products) > 0) { // Test empty
            mysql_query("TRUNCATE `" . $target_db_table_prefix . "products`");
            while (list($i, ) = each($import_products)) {
                $insert_products = "INSERT INTO " . $target_db_table_prefix . "products SET
                  products_id = '" . $import_products[$i]['products_id'] . "', 
                  products_quantity = '" . $import_products[$i]['products_quantity'] . "', 
                  products_model = '" . $import_products[$i]['products_model'] . "',  
                  products_price = '" . $import_products[$i]['products_price'] . "', 
                  products_date_added = '" . $import_products[$i]['products_date_added'] . "', 
                  products_last_modified = '" . $import_products[$i]['products_last_modified'] . "', 
                  products_date_available = '" . $import_products[$i]['products_date_available'] . "', 
                  products_weight = '" . $import_products[$i]['products_weight'] . "', 
                  products_status = '" . $import_products[$i]['products_status'] . "', 
                  products_tax_class_id = '" . $import_products[$i]['products_tax_class_id'] . "', 
                  manufacturers_id = '" . $import_products[$i]['manufacturers_id'] . "', 
                  products_ordered = '" . $import_products[$i]['products_ordered'] . "'  
             "; 

This will leave image file name field blank.
Skip

[kaddie]

Thanks Skip. I will give it a whirl.

Kaddie

[kaddie]

I do have one question before I try this. I am almost scared to try it because it may erase the product images I have already setup. If I do the above mentioned, will it erase the images I have already setup with image handler?

Kaddie

[skipwater]

I do have one question before I try this. I am almost scared to try it because it may erase the product images I have already setup. If I do the above mentioned, will it erase the images I have already setup with image handler?

Kaddie

You are trying to append data to you ZC database?

DO NOT RUN OsCommerce Data Importer IT WILL EMPTY YOUR DATA BASE.

OsCommerce Data Importer is for a one time load of a OsCommerce data base into Zen Cart.

Skip

[chinelly]

Can you please help me? I am getting so frustrated>.<

When I try to import, customer, order, or product, it always show up Table 'chi_zc1.customers' doesn't exist

Can someone explain to me why this happen and what do I need to do? For my table prefix, I set it to : osC DB Table Prefix -- NO Table Prefix ZenCart DB Table Prefix -- NO Table Prefix

Does it has to do with that? What should I put instead?

Thank you in advance!
Chinelly

[skipwater]

Can you please help me? I am getting so frustrated>.<

When I try to import, customer, order, or product, it always show up Table 'chi_zc1.customers' doesn't exist

Can someone explain to me why this happen and what do I need to do? For my table prefix, I set it to : osC DB Table Prefix -- NO Table Prefix ZenCart DB Table Prefix -- NO Table Prefix

Does it has to do with that? What should I put instead?

Thank you in advance!
Chinelly

Your source database is using chi_zc1 as a prefix you most enter that in the osc table prefix.

Skip

[willie bee]

Also again, looking at the configure file.

$source_db_host = 'localhost'; // localhost (If not localhost you know what needs to be here)
$source_db = 'database'; // OSC database name
$source_db_username = 'username'; // OSC data base user name
$source_db_password = 'password'; // OSC data base user password
$source_db_table_prefix = ''; // Table prefix if used i.e. osc_ otherwise leave empty ''

How do I set it up if the os database is on another server.

I have the production server running with the os commerce database and want to import it into the new server running zen cart and be able to work out the kinks before actually turning off the old production server.

I know the database name user name password, etc. just wondering how do I point it to the old os commerce server?

Thank you.

[willie bee]

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.

Exporting Orders ...
................................................................................ ................................................................................ .......................................200 -|
................................................................................ ................................................................................ .......................................400 -|
................................................................................ ................................................................................ .......................................600 -|
................................................................................ ................................................................................ .......................................800 -|
................................................................................ ................................................................................ .......................................1000 -|
................................................................................ ................................................................................ .......................................1200 -|
................................................................................ ................................................................................ .......................................1400 -|
................................................................................ ................................................................................ .......................................1600 -|
................................................................................ ................................................................................ .......................................1800 -|
................................................................................ ................................................................................ .......................................2000 -|
................................................................................ ................................................................................ .......................................2200 -|
................................................................................ ................................................................................ .......................................2400 -|
................................................................................ ................................................................................ .......................................2600 -|
................................................................................ ................................................................................ .......................................2800 -|
................................................................................ ................................................................................ .......................................3000 -|
................................................................................ ................................................................................ .......................................3200 -|
................................................................................ ................................................................................ .......................................3400 -|
................................................................................ ................................................................................ .......................................3600 -|
................................................................................ ................................................................................ .......................................3800 -|
................................................................................ ................................................................................ .......................................4000 -|
................................................................................ ................................................................................ .......................................4200 -|
................................................................................ ................................................................................ .......................................4400 -|
................................................................................ ................................................................................ .......................................4600 -|
................................................................................ ................................................................................ .......................................4800 -|
................................................................................ ................................................................................ .......................................5000 -|
................................................................................ ................................................................................ .......................................5200 -|
................................................................................ ................................................................................ .......................................5400 -|
................................................................................ ................................................................................ .......................................5600 -|
................................................................................ ................................................................................ .......................................5800 -|
................................................................................ ................................................................................ .......................................6000 -|
................................................................................ ................................................................................ .......................................6200 -|
................................................................................ ................................................................................ .......................................6400 -|
................................................................................ ................................................................................ .......................................6600 -|
................................................................................ ................................................................................ .......................................6800 -|
................................................................................ ................................................................................ .......................................7000 -|
................................................................................ ................................................................................ .......................................7200 -|
................................................................................ ................................................................................ .......................................7400 -|
................................................................................ ................................................................................ .......................................7600 -|
................................................................................ ................................................................................ .......................................7800 -|
................................................................................ ................................................................................ .......................................8000 -|
................................................................................ ................................................................................ .......................................8200 -|
................................................................................ ................................................................................ .......................................8400 -|
..................

and it stops.

[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