InstantASP Community Forums
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



Importing Users into the DB Expand / Collapse
Author
Message
Posted 21/05/2005 14:44:07


Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Customers
Last Login: 14/12/2005 15:27:57
Posts: 26, Visits: 158
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.

Post #6750
Posted 21/05/2005 15:26:21


Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Customers
Last Login: 22/09/2008 15:59:25
Posts: 693, Visits: 2,418
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.


..:: Bare ::..
http://www.livingformetal.com
Post #6751
Posted 21/05/2005 17:38:59


Junior Member

Junior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior MemberJunior Member

Group: Customers
Last Login: 14/12/2005 15:27:57
Posts: 26, Visits: 158
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

Post #6752
Posted 21/05/2005 20:34:46


Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Customers
Last Login: 22/09/2008 15:59:25
Posts: 693, Visits: 2,418
Awesome... I'm actually going to rate this topic with a bunch of stars...

Thanks, much!!


..:: Bare ::..
http://www.livingformetal.com
Post #6753
Posted 22/05/2005 14:57:15
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Customers
Last Login: 14/10/2005 18:52:24
Posts: 93, Visits: 173
Great work, this will help the rest of us when we port our users
Post #6772
Posted 23/05/2005 12:38:06


IF.NET 4.2 Coming Soon

IF.NET 4.2 Coming SoonIF.NET 4.2 Coming SoonIF.NET 4.2 Coming SoonIF.NET 4.2 Coming SoonIF.NET 4.2 Coming SoonIF.NET 4.2 Coming SoonIF.NET 4.2 Coming SoonIF.NET 4.2 Coming Soon

Group: Administrators
Last Login: Today @ 15:10:38
Posts: 1,957, Visits: 3,021
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.




Kindest Regards,

Ryan Healey
Director / Developer

Explore our products...
http://demos.instantasp.co.uk/

Post #6811
Posted 29/05/2005 21:05:27
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Customers
Last Login: 14/10/2005 18:52:24
Posts: 93, Visits: 173
DigiChaos (5/21/2005)
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

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

Post #6965
Posted 15/07/2008 19:16:55
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 2 days ago @ 13:40:18
Posts: 5, Visits: 65
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!

Post #14053
Posted 08/08/2008 10:38:39