OsCommerce Data Importer - Errors

[skipwater]

I'm assuming that since they aren't on the same server, that's what's causing the problem...is that possible?

Yes, each host sets up there sql differently you would need remote access to connect to a sql data base on a different server.

A work around is to transfer the old database to the new server. So the new zen-cart and old osc are on the same server.

Skip

[bbemis]

so basically, that would be just moving the back up I made to the new server right?

[skipwater]

so basically, that would be just moving the back up I made to the new server right?

Yes, Just restore your backup to a new data base file on your new server.

[bbemis]

Thanks so much Skip! I'll give it a try....

[TesterServers]

Hello all,

My issue isn't any errors, it's just that after it completes the process and says everything is done, there is nothing in the Zen database. Here's what I've done:

1. I have a localhost and Zen Cart installed with sample products and such.
2. I have osCom on a remote server with my products in the database.
3. I backed up the osCom from the remote server and loaded it locally. It displays my data with no issues.
4. I have put the contrib files in my root folder of my Zen Cart, which is locally. I've made all the needed changes to the two files as required.
import_osc_meta_tags.php
import_osc_configure.php

I've double-checked every thing to make sure I didn't miss anything, but no products are showing up in the Zen Cart.

To be sure to get the data to transfer correctly, I emptied all of the sample data from the Zen Cart tables
categories
categories_description
products

and tried the process again. The tables are still empty, yet I'm not getting any errors at all and when it finishes, it says that everything imported ok.

Any help would be appreciated, and thanks for your valued time.

Here are the results of each attempt I've made

Test connection to localhost Target Server OK!
Test ironman_zencart Target Database OK!
Connected to the localhost Source Server
Opened wifence_i749osc Source Database
Starting Exportation of osCommerce wifence_i749osc Data Base
Exporting Categories Meta Tags........................ Done 21 Records Exported
Exporting Products Meta Tags.................................... Done 33 Records Exported
Closing wifence_i749osc Source Database
-----------------------------------------------------------------------------------------
Connected to the localhost Target Server
Opened ironman_zencart Target Database
Starting Importation of osCommerce Data Into ironman_zencart Data Base

Importing Categories Meta Tags...
..................... Done 21 Records Imported
Importing Products Meta Tags...
................................. Done 33 Records Imported
Closing ironman_zencart Target Database
-----------------------------------------------------------------------------------------
All Done

[skipwater]

1. I have a localhost and Zen Cart installed with sample products and such.

OK.

2. I have osCom on a remote server with my products in the database.
3. I backed up the osCom from the remote server and loaded it locally. It displays my data with no issues.
4. I have put the contrib files in my root folder of my Zen Cart, which is locally.

OK.

I've made all the needed changes to the two files as required.

OK.

import_osc_meta_tags.php

This script is the one script that needs the must user intervention. This is due to osc default, it has no meta tag data. So if you have meta tag data it is because a mod was added to osc. You will have to match the osc meta tag tabels and fields to the zen cart tabels and fields.

import_osc_configure.php

Only import_osc_products.php, import_osc_customers.php and import_osc_orders.php use this file.

I've double-checked every thing to make sure I didn't miss anything, but no products are showing up in the Zen Cart.

If you just run import_osc_products.php it should give you export record counts and import record counts. If they match then go into you zen cart and see if you now have categories and products.

To be sure to get the data to transfer correctly, I emptied all of the sample data from the Zen Cart tables
categories
categories_description
products

Each script empties the tables before they load data. They do not append any records.

So if you run import_osc_customers.php all the customers are transfered?
Also if you run import_osc_products.php are the products transfered?
Same gos for import_osc_orders.php.

[TesterServers]

Thanks for the reply skipwater.

However, the problem not only still exists, it's the same even when I use a default oscom database.

But never the less, I ran the import_osc_products.php file and it says everything is completed but at the very bottom of the page it says

Importing Customers ...
Incorrect integer value: '' for column 'customers_authorization' at row 1

When I run import_osc_meta_tags.php it says this at the end of the page after it says everything is transferred.

Importing Categories ...
Incorrect datetime value: '' for column 'last_modified' at row 1

This is a new database. When I run import_osc_meta_tags.php it says everything is done, but still, no data has been transferred. I double-checked my databases and they're not using any prefixes in the table names.

The osc database with my products on it has "Easy Populate" on it. That's the only addon my osc has.

The strange thing is that all of my databases work perfectly, locally and remotely, but trying to transfer from the osc to the DEFAULT Zen Cart is a challenge right now.

I'm going to keep trying to figure this out, and I appreciate the info you've provided because it did help me understand a bit more of what I need to do and why.

Hopefully I can get this task at hand dealt with soon.

Thanks for your help.

[UPDATE]
I also noticed that the tables/fields that are to be populated are emptied, but noting is replaced, even though they had data in them.

[skipwater]

But never the less, I ran the import_osc_products.php file and it says everything is completed but at the very bottom of the page it says

Importing Customers ...
Incorrect integer value: '' for column 'customers_authorization' at row 1

You say import_osc_products.php but state a import_osc_customers.php error

Incorrect integer value: '' for column 'customers_authorization' at row 1

The customers_authorization value come from the drop down menu
value="0" Approved
value="1" Pending Approval - Must be Authorized to Browse
value="2" Pending Approval - May Browse No Prices
value="3" Pending Approval - May browse with prices but may not buy
value="4" Banned - Not allowed to login or shop

This value is not originating from the osc data base.

The osc database with my products on it has "Easy Populate" on it. That's the only addon my osc has.

If this is true you do not need to run import_osc_meta_tags.php because you do not have any meta tags to transfer.

Skip

[TesterServers]

Hi skipwater,

Thanks for all of your help. You've helped me out quite a bit. Here's my results.

1. I decided to do the transfers from my remote server/databases, and it works perfectly. (remote server to remote server, on the same server)

2. There must be an issue on my end locally, because the local database only has 33 products in it, but the online database has over 2,800 products in it.

I ran the
import_osc_products.php 1st, but I didn't check it until after I ran
import_osc_meta_tags.php

I am so happy and glad that you helped me understand things I didn't understand. I am taking a master database and I'm splitting it up amongst 15 domains. Once I transfer the database to each site, I'm simply deleting the data I don't need.

Question 1... If I am using just a default osc database, do I have to run import_osc_meta_tags.php?

Question 2... When I upload my images for my products to the /images/ folder, will my images show up for each product?

Question 3... Will I have to manually put the options back in for each product?


Once again, thanks for your help and time you've taken out to assist me. I'll work on the local transferring issue after I get this 1st remote site down-packed.


Tester

[skipwater]

Question 1... If I am using just a default osc database, do I have to run import_osc_meta_tags.php?

NO.

Question 2... When I upload my images for my products to the /images/ folder, will my images show up for each product?

YES.

Question 3... Will I have to manually put the options back in for each product?

NO. (What ever was in the osc product will be in your new zen product.)

Skip