I am creating a site for employees.  Each employee will have a couple of pages.  Since there are over 4000 employees, and I am lazy and don't want to manually create pages for each user, I am planning to set it up programmatically by adding tabs, modules, roles and users via sql.

I have succeeded in adding the tabs, modules and roles via sql, but hit a snag with adding users.

I have added a user  to the User, aspnet_Users, and aspnet_Membership tables via sql.  But the login doesn't work, and the user is not found under Admin Accounts in the interface.  Is there another table I need to add data to?

One confusing problem is that the aspnet_membership and aspnet_users tables have a GUID for the UserID.  Not at all sure what that is about.  I created a unique GUID for my user, and used the same GUID in both tables, but it didn't help.

Am I missing something?  Does someone know of a way to programmatically add users?  I am NOT using Active Directory logins, just a username and password.

Thanks in advance ...

John Mitchell wrote a program to do this.

It will probably need a bit of tweaking but it works great.  I imported 300 users yesterday to my site based on a modified version of his posted code.

http://blogs.snapsis.com/PermaLink,guid,c9d3082b-d7b1-4dfb-8c9c-67c0e864964d.aspx

Stuart Hilbert

You also need to add a record in UserPortals to link the Users record to the Portals record for the site the user is allowed to access.

Then you need to add a record to UserRoles to link the Users record to the Roles record for the Registered Users role (look up the RoleID for this in the Roles table).

Your user should show up after this, but it won't have a user profile. You can complete this by adding records to UserProfile.