Create user accounts from existing database

[carled]

Hi all, newly installed version of oscommerce. The website already has a members section (stored in sql server, asp.net configuration) and I was wondering about the possibility of programmatically creating the accounts required for shopping from the existing member database, rather than making people go through it all from scratch again...?

 

Had a search, but can't seem to get the right keywords to find the info I need. Anyone addressed this before please?

[♥ecartz]

With care, you could export all the existing accounts from your current database (perhaps into Excel?) and then import the data into the osCommerce tables. This is not impossible, but it would require some SQL coding (definitely) and possibly some glue coding to make the data compatible. Although customer data seems like it should be relatively simple (compared to something like orders).

 

So possible, but not exceptionally easy. There is no off the shelf contribution that would provide this at this time.

[carled]

With care, you could export all the existing accounts from your current database (perhaps into Excel?) and then import the data into the osCommerce tables. This is not impossible, but it would require some SQL coding (definitely) and possibly some glue coding to make the data compatible. Although customer data seems like it should be relatively simple (compared to something like orders).

 

So possible, but not exceptionally easy. There is no off the shelf contribution that would provide this at this time.

 

OK, thanks for the info, will look into the way you've mentioned. Is there a link/reference anywhere to importing data into the oscommerce tables, or is it just a case of getting into mysql and poking around until I discover the right tables to use?