Import a User List into Ablecommerce from a CSV file

[fatone]

Hi All,

I used to use an online marketing program which allows customers to subscribe to my mailing list. Since Ablecommerce already allows me to do this, i want to import all the users into Ablecommerce and create a login for them. I was able to successfully import a user into the ac_Users table, but didn't see them in the People | Users page of the admin area. I would imagine I need to add other information into other tables, such as ac_UserPasswords, but don't know which tables.

Basically, I want all my users from the old system to show up in Ablecommerce without the user having to create a login. Then I will email all the users informing them that an account has been created on the new system.

If anyone can be of some assistance, that would be appreciated.

[jmestep]

You need to have a field for passwords in your upload file. If you download the users from the store using the DataPort utility in .csv format there is a field for PasswordPlainText. If you fill that in and upload the users again into the store, they should have passwords created. I just don't remember if the dataport will update the users or only create new ones.

[fatone]

I used the Data Client Utility with a CSV file and it worked fine, the only issue was I couldn't pick a group for the newly added users.

[kastnerd]

Is there a way to add them to a group? Also is it possible to send them a link to crate a new password, as if they had clicked on forgot password?

[jmestep]

I was able to add users to a group, but I had to use an xml file.

[mazhar]

User's CSV import doesn't provides a way to import user group information. Have a look at the user information that could be imported using CSV from here
http://wiki.ablecommerce.com/index.php/ ... CSV_Import:

[mazhar]

Have a look at the following post about custom CSV import routines
viewtopic.php?f=47&t=9720