OsCommerce Data Importer - Errors

[skipwater]

Double check your DB access user name and password. To check you can use phpmyadmin or similar mysql utility to see if you have access.

Skip

[silkvixen]

Double check your DB access user name and password. To check you can use phpmyadmin or similar mysql utility to see if you have access.

Skip

all done :) it was the hosts prob they forgot to open up something to link to 2 together?? no idea but its done and i love it :)

[FreeStyleUK]

Hiys

Wonder is anyone can help me. I need to migrate customers only from OS Com to an established Zen Cart setup. I have tried the import_osc_customers.php script but of course it deleted the existing customers in Zen. I have tried to modify the script but it is well above my knowledge levels!

Has anyone modified this script or written one to to do what I am trying to do? Or can someone point me in the right direction

[NemesisNG]

I've run this on a test server with a view to moving from OSCommerce to Zen in the near future.

The problem I now have is that I can't use any of the customer reccords at all. They have been imported ok, no errors reported but from Customers from the drop down menu in the admin console I can see the list of customers names but cannot click on them or edit them.

If I register a new customer it works fine, but not for any of the imported ones.

All orders and products are working ok.

Thanks

Nick

[skipwater]

The problem I now have is that I can't use any of the customer reccords at all. They have been imported ok, no errors reported but from Customers from the drop down menu in the admin console I can see the list of customers names but cannot click on them or edit them.

First the customer data in osc was ok?

Looking at the customer list there is a ID# and after that 1 of 1 or a 1 of 2 etc. Find a record that has 1 of 2 and click the link this should show the two address tied to this customer.

As you click each customer record once the information window under the edit button changes to show that records info?

You have clicked a customer record once. It is now highlighted and you click the edit button. You get no action?

What version of zen cart?
What version php?
What OS ?

[NemesisNG]

Thank you for responding :)

Right, the customer data is currently still live and being used in the OSc shop, I just coppied the database to a test server to work on.

Where a customer has 2 address' logged, I can click the link and it will display all of the correct data, both addresses etc etc listed.

Clicking the customer data from the list once does nothing, the space below the edit button stays blank. With a new customer, not one imported, it does show the info correctly.

After selecting a imported customer and clicking edit, I get taken to the edit page but all of the fields are blank.

What I can see is that if I hover over the edit button the part which says "zen/storeadmin/customers.php?page=1&cID=&action=edit" seems to be missing the actual ID number. If I manually edit that url and add in a number for the cID=1234 it works fine.

This is a fresh install of Zen, I think it was 1.3.8 which I have upgraded in the last couple of weeks to 1.3.9a and now 1.3.9b.

From my web hosting I can see: PHP version 5.2.11, and it's a Linux shared hosting package I believe.

[skipwater]

Try looking at the zen cart mysql data base using myphpadmin or similar.

customers table (How many records)
customers_info table (How many records)

They should match record count.

Next address_book table (This should have > customer records)

The only thing that I can think of that might be causing this is bad data in a record. I think it would be in the customer_id field.

Skip

[NemesisNG]

Both the customers table and customers_info tables have 2,737 reccords in them.

The address_book table has 3,056 in it.

Not really sure where to go from here now...

Thanks

Nick

[NemesisNG]

I've tried it in IE and Firefox unless I was being stupid with the browser but it's the same. I've also tried it on the test server by backing up the OSc database and setting it back up on the test server and them importing it to Zen. I've now also tried it on the live server by setting up a fresh Zen instance and temporary database and importing to Zen directly from the live OSc database on the same server, in case something was going wrong with me moving it to a test server. But it's all still the same.

Nick

[skipwater]

Can you pm me with a sampling of the data so I can take a look at it. Because I can not duplicate your error.

Skip