I was just wondering, is there any way that I can take a list of email addresses from a SQL Server 2005 database table and create a new user in DotNetNuke for each email address in that list without writing code?
Yes, I am lazy. I know I could write a console app or something similar to retrieve the email addresses to a datatable, then use the following code from
Michael Washington to generate a user for each email address:
Dim oUserInfo As New UserInfo()
oUserInfo.PortalID = IWebCredentials.PortalID
oUserInfo.Membership.Username = email
oUserInfo.Username = email
oUserInfo.FirstName = email
oUserInfo.LastName = email
oUserInfo.DisplayName = email
oUserInfo.Membership.Email = email
oUserInfo.Email = email
oUserInfo.Membership.Approved = True
oUserInfo.AffiliateID = Null.NullInteger
oUserInfo.Membership.Password = email ' DNN allows the @ symbol in passwords, thank goodness
Dim objUserCreateStatus As Security.Membership.UserCreateStatus = IWebUser.CreateUser(oUserInfo)
If objUserCreateStatus = Security.Membership.UserCreateStatus.Success Then
objResponse = "Success"
Else
objResponse = [String].Format("Error: {0}", objUserCreateStatus.ToString())
End If
However, did I mention that I was lazy?
Is there any pre-programmed way to generate users on a DNN site given email addresses in a database table? Surely I am not the only one out there transferring an existing mailing list from a custom made site to DotNetNuke!!
Thanks,
Shan