OsCommerce Data Importer - Errors

[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

[chinelly]

OMG!! Thank you so mcuh!! It worked! Everything went GREAT! Thank you for your wonderful wonderful add-on. I literally spent the past 2 days trying to do phpmyadmin, compare the files, but it DOESN'T work. Thank you so much for your quick reply. You are AMAZING.

So here is how I solve the problem (insights for other users who experience the same problem)

problem: For my table prefix, I set it to : osC DB Table Prefix -- NO Table Prefix ZenCart DB Table Prefix -- NO Table Prefix

solution: Skip,thank you so much for your help

go to Filezilla and go to zencart directory>>open includes folder>>open configure.php. There should be line in the document that says define('DB_PREFIX', 'yourprefix'); Copy what is in your prefix in the zencart configure file to the target DB prefix in the import_osc_configure and import_osc_meta_tags files. Leave the source DB prefix blank.

upload,and it works!

[needs_a_nap]

Does anyone know if this mod can be altered to also import product weight & dimensions (for the Canada Post shipping module)?

Thanks!

[willie bee]

SkipWaters I do apologize for not reading through 19 pages first of all.

I have an osCommerce store with medium modifications to it. Very little table modifications.

I have a brand new store with no modifications to it and it is vanilla. All I did was create a database.

I know there will be issues in some order histories, etc. etc. It's a given.

My question(s) is and are.

I have my current store and database in another server.

My new store and database is in a new server.

If I run this will it ...

1. Other than slow the store down somewhat, MODIFY ANY FILES OR DELETE ANY FILES IN THE CURRENT RUNNING PRODUCTION SERVER.

Thank you very much for your time.

[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.