Customer Database Upload

[jlemecthomas]

I have a large database of customers in an MSSQL database. I would like to move those customers to the oscommerce database. There seems to be so many related/linked fields. Is there a program out there that has been used for this purpose. Are there any documentation on the linked fields that would help in writing the necessary query for that kind of transfer?

 

I'd appreciate any assistance along those lines.

 

Thanks

 

Jean

[kgt]

Unless you're trying to import historical information like previous orders, this is not that big of a deal. (though expect to have to try it a few times to work out the snags. Don't try to import into a production database until you know your procedure will work.) If you're familiar with PHP, look at the code in create_account.php to get an idea of what's going on when you create an account. Basically, a new customer only needs information in the customers and customers_info tables. customers_id must match customers_info_id.