InstantASP Community Forums / InstantForum.NET 4.x / User / App Integration / Community Support / Importing Users into the DB / Latest Posts

RE: Importing Users into the DB

Justin Crabtree — Fri, 08 Aug 2008 10:38:39 GMT

The general steps which you are taking look to be correct, below is an excerpt of SQL I'm running to insert users into the Forums tables, hopefully you'll be able to spot some difference between this and yours.

If you post a similar (modified if necessary) bit of SQL I'll take a look for anything that looks odd/wrong.

[code]

INSERT INTO Forums.dbo.InstantASP_Users

(emailaddress, username, [password], PrimaryRoleID, OurID)

VALUES (

coalesce(@email, 'noemail@noemail.com'),

coalesce(@username, 'nousername'),

coalesce(@password, 'nopasword'),

2, @OurID

)

SET @lastid=scope_identity()

-- set up permissions

INSERT INTO Forums.dbo.InstantASP_UsersRoles

(userID, roleID)

VALUES

(@lastid, 3)

-- set up user table 2

INSERT INTO Forums.dbo.InstantForum_Users

(userID, permissionID)

VALUES

(@lastID, 0)

-- set up users folders

INSERT INTO Forums.dbo.InstantForum_Folders

(UserID, FolderName, Inbox, sortorder)

VALUES

(@lastID, 'PMFolder_InBox', 1, 1)

INSERT INTO Forums.dbo.InstantForum_Folders

(UserID, FolderName, DeletedItems, sortorder)

VALUES

(@lastID, 'PMFolder_DeletedItems', 1, 2)

INSERT INTO Forums.dbo.InstantForum_Folders

(UserID, FolderName, SentItems, sortorder)

VALUES

(@lastID, 'PMFolder_SentItems', 1, 3)

[/code]

RE: Importing Users into the DB

scieszynski — Tue, 15 Jul 2008 19:16:55 GMT

I've done the following as the post suggests:

1. insert user into InstantASP_Users
2. insert into InstantASP_UsersRoles
3. insert user into InstantForum_Users
4. insert three PM folders into InstantForum_Folders

After items 1-3, I was able to login but it would say I was logged in as guest. Once I completed step 4, I now get an ASP.NET error.

Exception Type: System.NullReferenceException
Exception Message: Object reference not set to an instance of an object.
Exception Source: InstantASP.InstantForum.UI
Exception Target Site: BuildRightOptions

Any ideas to why this would not work? We'd like to bulk register our users so I'm first attempting to create one with direct sql inserts to test.

Thanks!

RE: Importing Users into the DB

fadi — Sun, 29 May 2005 21:05:27 GMT

[quote][b]DigiChaos (5/21/2005)[/b][hr]Ok, I figured out the issue. I had to do one more step...

- For each user create a row for the three PM folders "PMFolder_InBox", "PMFolder_SentItems", and "PMFolder_DeletedItems" in the table InstantForum_Folders.

This resolves my problem :w00t:[/quote]

This information has helped me today :) I was going nuts trying to figure out why my registration form was not creating accounts properly in IF til I remembered your post :w00t:

RE: Importing Users into the DB

Ryan Healey — Mon, 23 May 2005 12:38:06 GMT

Hi All,

I've uploaded some updated documentation which offers a little guidance on this...

http://support.instantasp.co.uk/FindPost6756.aspx

See specifically the "Existing User Integration" section. Hope this helps a little. The documentation is not yet complete and i'm very happy to take any suggestions for any additional information you find useful.

RE: Importing Users into the DB

fadi — Sun, 22 May 2005 14:57:15 GMT

Great work, this will help the rest of us when we port our users :)

RE: Importing Users into the DB

Bare — Sat, 21 May 2005 20:34:46 GMT

Awesome... I'm actually going to rate this topic with a bunch of stars...

Thanks, much!!

RE: Importing Users into the DB

DigiChaos — Sat, 21 May 2005 17:38:59 GMT

Ok, I figured out the issue. I had to do one more step...

- For each user create a row for the three PM folders "PMFolder_InBox", "PMFolder_SentItems", and "PMFolder_DeletedItems" in the table InstantForum_Folders.

This resolves my problem :w00t:

RE: Importing Users into the DB

Bare — Sat, 21 May 2005 15:26:21 GMT

I wish I could help.. but I'm not scheduled to start my user import script until this upcoming week.. Obviously, anything you could offer, in regards to tips & tricks (through your experience) would be greatly appreciated.

Importing Users into the DB

DigiChaos — Sat, 21 May 2005 14:44:07 GMT

So, I am working on an import script that will import the Users from my SQL database into the InstantForum database. I am 99.9% of the way there but I am running into one small problem. Here are the steps I am taking to import... am I missing anything?

- Insert my Users into InstantASP_Users, setting PrimaryRoleID to 2
- Insert Users from InstantASP_Users into InstantForum_Users, setting PermissionID to 2
- Inserting a row into InstantASP_UsersRoles for each UserID (RoleID = 1)
- Inserting a row into InstantASP_UsersRoles for each UserID (RoleID = 2)

I can see all the users in the database, the system allows me to login with one of the users.... but... Once the login is successfull it looks as though I am still logged in as a guest and I am not logged in at all.