Problem with databse transfer oscommerce to zencart

[ksmglobal]

Hi,

I am moving a database from OScommerce to Zencart.
I have moved all the categories OK.
I have moved all the product structure OK.
BUT when I try to import the products I get the following error message:

Error
SQL query:

--
-- Database: `mydatabase_name`
--
--
-- Dumping data for table `products`
--
INSERT INTO `products`
VALUES ( 1, 33, '228', 'products/1.jpg', 'products/1.jpg', 'products/1.jpg', '', '', '', '', '', '', '', '', '', '', '', '', 2.8500, NULL , '2007-12-20 23:08:16', NULL , 1.00, 1, 0, NULL , 1, 0, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0.0000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'G,0', 7, '', '', '', '', 0.00, 2288, 2.85, '0' ) ;



MySQL said:

#1136 - Column count doesn't match value count at row 1

[kuroi]

This is telling you that osCommerce and Zen Cart don't have the same table structure for products.

One or both may have extra fields added since they split, and the osCommerce from which you are transferring may have mods that have added extra fields.

Have you compared the products tables in both to see what differences there are?

[ksmglobal]

I have already added all tables into zencart that existed in the oscommerce database. There are now more tables in the zencart than in the oscommerce.

[kuroi]

The issue isn't about adding tables, it's that the products table in Zen Cart appears to be a different shape to that for the osCommerce database from which you are converting.

This is getting highlighted because you have adopted a high risk approach to conversion, namely dumping each osCommerce row into a Zen Cart row in the hope that the fields will match, rather than mapping the fields so that you know that data is being taken from osCommerce and placed into the right field in Zen Cart.

[ksmglobal]

Do you have any suggestions how I can rectify this and get all the products imported?

[kuroi]

Since the tables appear to have different structures, assign the data from one to the other using column names that you have mapped between them, rather than by inserting a list of values. If Zen Cart has more column names you may need to assign default values to the new columns.

[ksmglobal]

Would you be willing to sort this out for me if I paid you?

[kuroi]

I have a partner who is especially skilled in this type of conversion, and she has contacted you separately. But we would recommend that you take a look at this mod first (sorry all documentation is in French, but it's pretty easy to use even if you don't understand the docs).

[albertsavage]

I have released a new OSC - Zen data importer.

New and improved for multi-step migrations and easy to use.

If you still need it, that will solve most of your problems.

Albert

http://www.zen-cart.com/index.php?ma...roducts_id=918

[yellow1912]

I know many people would love this, thanks alot for the great contribution.

I have released a new OSC - Zen data importer.

New and improved for multi-step migrations and easy to use.

If you still need it, that will solve most of your problems.

Albert