I am in the process of converting an existing installation of SmithCart to a new version on a new site under a new DNN install. That being said, rather than rebuild the ship, I'd like to import as much data as I can. Here's what I have done so far (and I have a few specific questions below that)

1. Imported product data (xls)
2. Imported category data (sql)
3. Imported productQTYdiscount data (sql)

I am wondering what tables might have the following information, and also what the best way to do the following would be:

1. Importing customer data (usernames and passwords specifically (how are passwords stored?)) Is there a way to do a SQL table transfer of the information if the passwords are stored as *** or some other encrypted method?
2. Importing role data (tax exempt by role - what SQL table does this data sit in?)

Thanks for any insight you might have into this!

-Mike

Thanks for the reply David. Very simply, could you tell me how the stored passwords work for SmithCart? I know that the dbo.Users table in SQL is really where a portion of the customer information is stored.

Really what I want to do is transfer all of the accounts of all of the users who have ever order on our site, to the new site, so when they go to login to place an order it is seamless. What table might those passwords / account information be stored in?