Moving AD users to SQL Provider - Bulk Import?

Apr 29, 2014 at 9:22 PM
I'm hoping I can find a recommendation on how to bulk import from a csv or something a large list of users into the SQL database, and have them be accessible in SharePoint?
Coordinator
Apr 30, 2014 at 1:38 AM
I've created import tools for clients, similar to how it's done here:

http://stackoverflow.com/questions/1506805/import-users-to-asp-net-membership-from-a-file

To allow the user to access SharePoint, you could either put them all in a membership role, and then give that role permissions on SharePoint. Alternatively you could add another line of code to add the created user directly to SharePoint and put them in a SharePoint group.
Apr 30, 2014 at 2:23 AM
Awesome! Exactly what I was looking for. Thank you!
Apr 30, 2014 at 4:04 PM
OK... I really thought this would be much simpler than it is... I'm completely lost. I've been trying to figure out the code posted above and looking at other solutions that are similar... I am NOT a developer by any means. I understand code, and PowerShell is my friend, but other than that I haven't even touched VB in about 15 years... I can't believe there is not a ready made tool for this somewhere already. :(
Coordinator
Apr 30, 2014 at 4:47 PM
I'm surprised myself. I've added an issue for this, so I can look at adding this feature in a later version:

https://sharepoint2013fba.codeplex.com/workitem/21

In the meantime, if you like we can probably code up something for you within a couple of hours to do the trick. If you're interested, please call to quickly review the requirements:

http://www.visigo.com/purchase.html
Apr 30, 2014 at 4:51 PM
I'm going to see if I have someone internally who can help me out. I work for a development firm (go figure) I am the only "Non-Developer" consultant, as I am an infrastructure specialist. So I'll have to see if one of our ASP.net guys can give me a hand... I really appreciate your help with this. Thanks
Apr 30, 2014 at 8:07 PM
I got it! Used this - https://membership.codeplex.com/
Like I said, PowerShell is my friend!
Coordinator
May 1, 2014 at 12:24 AM
Nice find!