OsCommerce Data Importer - Errors

[alexoverton]

osCommerce Online Merchant v2.2 RC1 exported to Zen Cart 1.3.9g
Clean install
No Addons - French and English Language installed on both OSC and Zen

Hi Thanks for your add on !

I have successfully exported my osc database but for some reason I can not get French product descriptions to show up .......It looks like the data was imported ok (it shows the tables) but does not show up if I select French language from the admin ? In my database the language code for French is 4 and English is 1

please help ........any Ideas thoughts gratefully received

Thanks

Alex

[skipwater]

osCommerce Online Merchant v2.2 RC1 exported to Zen Cart 1.3.9g
Clean install
No Addons - French and English Language installed on both OSC and Zen

Hi Thanks for your add on !

I have successfully exported my osc database but for some reason I can not get French product descriptions to show up .......It looks like the data was imported ok (it shows the tables) but does not show up if I select French language from the admin ? In my database the language code for French is 4 and English is 1

please help ........any Ideas thoughts gratefully received

Thanks

Alex

No change is made on the language codes.

Look at your osc languages table and see what is the value of your languages_id (1 is normally English, 2 is Deutsch, 3 is Español ) so what value is French 4 ?

After you check and see what value French 4 is look at products_description table. You should find that the language_id has the same value.

Now all you need to do is in the new zen cart languages table make a record that matches the languages_id in you products table languages_id.

Skip

[achyuta]

First let me vigorously agree, fantastic life-saving script! Many many thanks!

I am having a similar trouble with my address book as previously described. I have changed all my address_book_id entries to unique sequential numbers. All the data is there (in database), but I cant see it through admin > customers. All other imports went fine.

OSC was set up back in 2002, although it was updated to v2.2 RC2a. ZC is 1.3.9h. PHP 5.2.14 and Linux OS.

Another symptom, when I log in as a previously stored customer in my new zen-cart store, my shipping address is a ","

Any clue? Thanks,
Achyuta

[skipwater]

First let me vigorously agree, fantastic life-saving script! Many many thanks!

I am having a similar trouble with my address book as previously described. I have changed all my address_book_id entries to unique sequential numbers. All the data is there (in database), but I cant see it through admin > customers. All other imports went fine.

OSC was set up back in 2002, although it was updated to v2.2 RC2a. ZC is 1.3.9h. PHP 5.2.14 and Linux OS.

Another symptom, when I log in as a previously stored customer in my new zen-cart store, my shipping address is a ","

Any clue? Thanks,
Achyuta

Is this what you are referring to?
http://www.zen-cart.com/forum/showpo...1&postcount=98

What you should look for is customers ID in the customers table and then find that customers ID in the address_book table and see if that address goes with that customer.

Also in the customers table you will find customers_default_address_id field the value in this field matches the address_book table field address_book_id.

The osc data is skewed some how you just need to find out where.

Skip

[achyuta]

Is this what you are referring to?
http://www.zen-cart.com/forum/showpo...1&postcount=98

What you should look for is customers ID in the customers table and then find that customers ID in the address_book table and see if that address goes with that customer.

Also in the customers table you will find customers_default_address_id field the value in this field matches the address_book table field address_book_id.

The osc data is skewed some how you just need to find out where.

Skip

That is what I was referring to, and your suggestions have corrected the problem.

I ran this code from my PHPAdmin:

UPDATE customers,address_book SET customers.customers_default_address_id=address_book.address_book_id WHERE customers.customers_id=address_book.customers_id;

and as far as I can tell, it has corrected the problem. Much appreciation! Both for the quick reply, and for the great program! Thanks,
---Achyuta

[Dustie]

No change is made on the language codes.

Look at your osc languages table and see what is the value of your languages_id (1 is normally English, 2 is Deutsch, 3 is Español ) so what value is French 4 ?

After you check and see what value French 4 is look at products_description table. You should find that the language_id has the same value.

Now all you need to do is in the new zen cart languages table make a record that matches the languages_id in you products table languages_id.

Skip

I am also having the same problem, that we can transfer datas for English and German, but it's not working for the Dutch.

I am confused as to where I can find the values of the languages? Can someone point me in the right direction??

thank you

[Dustie]

okay we found it. Changed the values in the MySQL

All working now

[skipwater]

I am also having the same problem, that we can transfer datas for English and German, but it's not working for the Dutch.

I am confused as to where I can find the values of the languages? Can someone point me in the right direction??

thank you

1. In ZC check language setting
admin -> localization -> language
Is your language selected as default?

If 1 is true goto 2

2. Open the osc data base and look at the languages table now what is the value
of your languages_id (1 is normally English, 2 is Deutsch, 3 is Español ) so
what value is the language you need?

Next look at products_description table. You should find the language_id
field has the same value.

Example: languages table - field languages_id = 3
products_description table - field languages_id = 3

After you know the language value # open the ZC data base.

Open ZC languages table is there a record for your language?

Yes - And the language_id field is the correct value and the products_description table
languages_id field is correct.

No - Then add a record that matches the languages_id in you products table languages_id.
Note: The laguages table languages_id field is auto incremented this means that if
the languages_id you need = 3 and you only have one record you will need to add a dummy
record for 2 and then add record 3 that is your language.

Skip

[xanthous]

Firstly, thank you for this script.

I ran it and got no errors, but the products are not showing up in Zencart. They show up in phpmyadmin, but not in the admin of zencart, nor in the shop.

I didn't get any errors...so any idea where to start?

Many thanks

Zen Cart Product Optional Settings
Set Product Review - Pending or Approved --
Transfer Product Specials - YES or NO --

Exporting Categories ...
..................................................50 -|

Records Exported 50

Importing Categories ...
..................................................50 -|

Records Imported 50
Exporting Categories Description ...
..................................................50 -|

Records Exported 50

Importing Categories Description ...
..................................................50 -|

Records Imported 50
Exporting Products ...
................................................................................ ................................................................................ ......166 -|

Records Exported 166

Importing Products ...
................................................................................ ................................................................................ ......166 -|

Records Imported 166
Exporting Products Description ...
................................................................................ ................................................................................ ......166 -|

Records Exported 166

Importing Products Description ...
................................................................................ ................................................................................ ......166 -|

Records Imported 166
Exporting Products to Categories ...
................................................................................ ................................................................................ ..........170 -|

Records Exported 170

Importing Products to Categories ...
................................................................................ ................................................................................ ..........170 -|

Records Imported 170
Exporting Products Options ...
.1 -|

Records Exported 1

Importing Products Options ...
.1 -|

Records Imported 1
Exporting Products Options Values ...
.2 -|

Records Exported 2

Importing Products Options Values ...
..2 -|

Records Imported 2
Exporting Products Options Values to Products Options ...
.1 -|

Records Exported 1

Importing Products Options Values to Products Options ...
.1 -|

Records Imported 1
Exporting Products Attributes ...
.1 -|

Records Exported 1

Importing Products Attributes ...
.1 -|

Records Imported 1
Exporting Products Attributes Download ...
.1 -|

Records Exported 1

Importing Products Attributes Download ...
.1 -|

Records Imported 1
Exporting Products Notifications ...
................................................................................ ................................................................................ .......................................200 -|
................................................................................ ................................................................................ .......................................400 -|
...........................................................................475 -|

Records Exported 475

Importing Products Notifications ...
................................................................................ ................................................................................ .......................................200 -|
................................................................................ ................................................................................ .......................................400 -|
...........................................................................475 -|

Records Imported 475
Exporting Manufacturers ...
...3 -|

Records Exported 3

Importing Manufacturers ...
...3 -|

Records Imported 3
Exporting Manufacturers Info ...
...3 -|

Records Exported 3

Importing Manufacturers Info ...
...3 -|

Records Imported 3
Exporting Reviews ...
...............15 -|

Records Exported 15

Importing Reviews ...
...............15 -|

Records Imported 15
Exporting Reviews Description ...
...............15 -|

Records Exported 15

Importing Reviews Description ...
...............15 -|

Records Imported 15
Exporting Languages ...
.1 -|

Records Exported 1

Importing Languages ...
.1 -|

Records Imported 1
Exporting Specials ...
0 -|

Records Exported 0

Importing Specials ...

Warning: Variable passed to each() is not an array or object in /home/aurora/public_html/loja/import_osc_products.php on line 1502
0 -|

Records Imported 0
Exporting Tax Class ...
.1 -|

Records Exported 1

Importing Tax Class ...
.1 -|

Records Imported 1
Exporting Tax Rates ...
.1 -|

Records Exported 1

Importing Tax Rates ...
.1 -|

Records Imported 1
DONE

[skipwater]

Firstly, thank you for this script.

I ran it and got no errors, but the products are not showing up in Zencart. They show up in phpmyadmin, but not in the admin of zencart, nor in the shop.

I didn't get any errors...so any idea where to start?

Many thanks

1. Is your zen cart set to use the data base you are looking at in phpmyadmin?

2. Is your zen cart setup to use a table prefix?

3. Looking at the data in phpmyadmin are you seeing a table prefix? ie. zen_customers or no prefix customers

Skip