Importing Customer Info

[heinscott]

Has anyone had to import a lot of customer information into your store? Right now, I am looking at close to 20,000 customers, and I am wondering the best way to go about doing the import. For starters, it looks like the DataPort utility does not create an address record for each customer... Is that true? Also, what about importing passwords? I guess the big question I need to ask is... How many tables are affected each time a customer is created? I think that I will need to touch the Users, UserPasswords, and Addresses tables in order to get all the information in manually.
Please let me know if you have any information for me that could help. I'll be writing something to do the import (at least for the passwords) in the meantime.
Thanks,

Scott

[Robbie@FireFold]

FireFold has the same question..

Except take 20,000 and make it 200,000.

[jmestep]

If you use an xml import the dataport will provide the right info- I'm not sure about how to get the passwords' encryption changed. I have done a couple of Able 5 store exports and those users imported correctly into Able 7 with all the data intact. You could format your xml using that xml format or the Able7 store export format as a pattern. I think I posted the xsd schema on the forum, but I can't find it now.

[mazhar]

Well guys i think you want a CSV import. We have already created an enhancement that DataPort should be capable to import User Password and User Primary address information including the telephone and fax numbers.
http://bugs.ablecommerce.com/show_bug.cgi?id=7124

[kastnerd]

Id like to import my wholesale customers, But the password it used MD5+ Hash witch is basically impossible to decode.
Can i set a random password and then send out a mass email with a forgot password link?

[kastnerd]

Any idea's on setting a random password for imported users?