Importing Data From A Non-ZenCart System

[JDTechnics]

I'm setting up a ZenCart site to replace an old (12+ years) hand-rolled one. The old database has been converted to MySQL, but now I'd like to bring over the existing customers and give them new accounts on the ZenCart system.

I've copied over the relevant fields to the CUSTOMERS table, but the old database has the account passwords in the clear. I think it'll work if I can encrypt the in-the-clear passwords from the old database. Is there any way I can run the encryption on the old passwords, so that the customers won't have to create new accounts?

The fields the two database have in common, and that I copied over, were all in the CUSTOMERS table:

customers_id
customers_firstname
customers_lastname
customers_email_address
customers_telephone
customers_password

Do I need to bring over any other old data from the old system?

ZenCart v1.3.8a.
No upgrade; this is a fresh install.
No add-ons.
Running on one of GoDaddy's UNIX servers.

Thanks in advance!

JDTechnics

[DrByte]

Customer Data is stored in several tables, so you'll need to reconstruct the data in the corresponding new structures. Here's a link to categorized groupings of database tables to help you reconstruct your data: http://www.zen-cart.com/wiki/index.p...er_Information

As to passwords, this discussion may be of interest to you: http://www.zen-cart.com/forum/showthread.php?t=50059

[JDTechnics]

Dr. Byte, you ROCK!

Your script is slick-slick-SLICK!

Thank you so very much!

Marsha @ JDTechnics