YAFLogo

garetjax
  • garetjax
  • 54.8% (Neutral)
  • YAF Forumling Topic Starter
11 years ago
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
  • Zero2Cool
  • 100% (Exalted)
  • YAF Leader YAF Version: YAF 3.1.16
11 years ago
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
11 years ago
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
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 4.0.0 rc 2
11 years ago

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

Originally Posted by: garetjax 

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

garetjax
  • garetjax
  • 54.8% (Neutral)
  • YAF Forumling Topic Starter
11 years ago
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
11 years ago
Everything is working with one exception...

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

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