garetjax
  •  garetjax
  • 54.8% (Neutral)
  • YAF Forumling Topic Starter
2014-02-04T21:25:14Z
Is there a stored procedure/script/module for import users information from one table into the YAF Users Table?

I have around 4k+ users with the following table schema
member_id bigint,
member_login varchar(500),
member_password varchar(500) - MD5/Salt Encrypted Password,
member_name varchar(500),
member_email varchar(500)

I've looked at the YAF_USERS table and tried a single import but am getting an error on the import something about the Guest User.

???

Any help greatly appreciated.
Sponsor
Zero2Cool
2014-02-04T21:40:08Z
I can't see a database right now to tell you specifically, but if you look for a SP using the SQL Server filter tool for "user" or "save" that should narrow down the options and you could find what you're looking for.

If you're getting an error about the guest user, you might be trying to import a user with the UserID of 1... that userid is reserved for Guest. So if you have a user with userid 1, you'll have to change it.
garetjax
  •  garetjax
  • 54.8% (Neutral)
  • YAF Forumling Topic Starter
2014-02-05T02:56:13Z
user accounts on around 20 of them were to long on the login name for the import. I've since updated..and I was way off on the import count by 43K+/-

now, I just have to change out the authentication model, add a column for the member_id, add a trigger to create a new member_id in the old table and update the yaf_user table with the new member_id....

yay me.
tha_watcha
2014-02-05T12:08:47Z
Originally Posted by: garetjax 

Is there a stored procedure/script/module for import users information from one table into the YAF Users Table?



You do know that YAF.NET has an user import function (Under Admin -> Users & Roles -> Users -> Import User(s))?



UserPostedImage
garetjax
  •  garetjax
  • 54.8% (Neutral)
  • YAF Forumling Topic Starter
2014-02-06T00:27:40Z
Didn't work for my purpose...SQL Table to SQL Table; as all user information from the Original Table was Encrypted MD5/Salt Key/Value Pair.

So, I had to run each user through a custom procedure (CLR) then import each user based on their decrypted 'credentials'
garetjax
  •  garetjax
  • 54.8% (Neutral)
  • YAF Forumling Topic Starter
2014-02-06T04:51:41Z
Everything is working with one exception...

User Login -> Do Stuff -> Post Message -> User Logout

New User -> Come to site shows (my account name)....(derp????)

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved