OsCommerce Data Importer - Errors

[skipwater]

Following earlier dialogues with Skipwater, I am now trying to include the metatags that appear in OSC categories_description and transfer them to the separate table meta_tags_categories_description

The osc default categories_description table only includes fields:
categories_id
language_id
categories_name

If I remember the default osc data base has no meta tags stored any where.

Your code looks correct.

But I can not tell if the source fields are there and spelled correctly and you have data in them.

I would start looking at your source for the fix.

Skip

[Centec2b]

If I remember the default osc data base has no meta tags stored any where. Your code looks correct. But I can not tell if the source fields are there and spelled correctly and you have data in them. I would start looking at your source for the fix.
Skip

Hi Skip

Thank you for those thoughts - sorted! A mixture of typos and I wrongly assumed that just because the code said that there was no data, that it was true...

I omitted to put

$ii++;

in the end of the insertion loop so it was always going to be zero....

I propose to put it into the downloads with an explanation. It might be useful for others who are coming across from OSC and have meta data etc

It saved a lot of typing anyway!

Thanks again

Centec2b

[skipwater]

As Albert said (who started this thread)
Feel free to upload your contribution (hey, it's open source).

Thats what it is all about

I have written a review transfer script but have not had time to put it up.

As with every project we need these little utilities and it is a great help that Zen Cart gives us a place that we can share the code so all benefit.

Skip

[embepo]

Hello guys!

Well I have a serious problem here. I tried to use this Data Importer and it was working well till i realised the I download only english database from OScommerce. The oscommerce store has two languages but I could download only english. Please can you give me some advise how to download both databases from oscommerce to zen.

embepo

[skipwater]

embepo

Attached is a languages table importer for osc to zen. Unzip and add the sql data same as the other scripts.
This will be included in an up date that I am working on.

Let us know if this fixes your issue.

Skip

[embepo]

I tried it but it didnt work. I guess that its really complicated to write a script like that. The problem is that I could copy only english version of oscommerce but when I change language in zencart to my default slovak version, all what I see are prices. No names, no description, only prices....

[skipwater]

The problem is that I could copy only english version of oscommerce but when I change language in zencart to my default slovak version, all what I see are prices. No names, no description, only prices....

If you can 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 is slovak?

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

These values will transfer to the zen cart data base.

Now look at the zen cart data base and you should see that all the language_id have your slovak id value.

I do not have a osc data base with your slovak language for testing if you want pm me with a sample of the data base and I can do some testing.

skip

[bbemis]

I'm trying to move my store from oscommerce to zen, but I can't seem to get this contribution to work. The error message I'm getting is:

Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host 'blowinin.ipowermysql.com' (2) in /home/content/b/l/o/blowinin/html/import_osc_products.php on line 239
Could not connect: Unknown MySQL server host 'blowinin.ipowermysql.com' (2)

This is the database host listed on my server information page on oscommerce. I have no idea why I keep getting this error? Any ideas of what I should try?

[skipwater]

Based on your error you connect to the zen-cart target database fine.

This is the database host listed on my server information page on oscommerce.

Is this where you found the source database information?
OsCommence configure file:

/includes/configure.php

// define our database connection
define('DB_SERVER', 'server'); // eg, localhost - should not be empty for productive servers
define('DB_SERVER_USERNAME', 'username');
define('DB_SERVER_PASSWORD', 'username_password');
define('DB_DATABASE', 'name of database');
define('USE_PCONNECT', 'false'); // use persistent connections?
define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql'

Skip

[bbemis]

Actually, I think I might have figured it out....was doing something STUPID! I need to not only change from oscommerce to zen but I also need to change service providers. One database is with ipower and the other is with godaddy....I'm assuming that since they aren't on the same server, that's what's causing the problem...is that possible?