YAFLogo

kflowers
  • kflowers
  • 53% (Neutral)
  • YAF Forumling Topic Starter
12 years ago
I have a website with an established user base, and each user has their own username and password. Is it possible to import this information, so that each user's forum login information is the same as the login info from our site?
Sponsor

kflowers
  • kflowers
  • 53% (Neutral)
  • YAF Forumling Topic Starter
12 years ago
Anyone have any experience with this?
squirrel
12 years ago
Much of it will depend on the original storage of your usernames and passwords. Is it an ASP.NET based site using a role provider or what? What encryption are you using on your password store currently -- those questions would need to be answered before an idea of whether or not it's possible. What is your current datastore (MS-SQL or Access)? There is a script that will import users from a Snitz 2000 forum database that when you combine it with alternative settings for the YAF membership provider will make the old logins work on the new forum... This opens up possibilities... I'm sure a developer with more experience can help you. Would you need users to be auto-added to YAF when they register on the main site, etc... Lots of questions here before anyone can provide further advice --

For what it's worth, someone might be able to be hired to do the conversion for you.


If you can't find it using the forum search, try my signature link -- searches this site using Google: Google is my Friend 
kflowers
  • kflowers
  • 53% (Neutral)
  • YAF Forumling Topic Starter
12 years ago
I will essentially have a CSV file containing personal info (name, email, etc.), user names and passwords - in the future more complicated integration will be necessary, but we'll have a developer who handles that portion. For right now I just need to figure out how to take the plain text data and import it into the YAF database.

Thanks!

squirrel
12 years ago
are passwords encrypted? If not, I think you will need to hash them into a format that YAF can translate, then use an SQL script to import the file into MS-SQL -- much beyond that would probably require someone from the development team to help you implement. I might be able to come up with a script but I don't have much background on YAF's membership provider - only what data I can work with inside the database after members are migrated or created from my own experience. I might be able to help, but lately my time is limited as I'm already knee-deep in a Snitz migration of my own 🙂
If you can't find it using the forum search, try my signature link -- searches this site using Google: Google is my Friend 
Zero2Cool
9 years ago
I have a CSV file with about 1,400 users with fields, first name, last name, email, username, joined date and post count. These were ignored during my initial migration to DNN/YAF and now that I'm straight YAF'ing (nice wording huh) I'd like to import those 1,400 users as well.

I was going to just import them to the yaf_User table, but I think that would fail because of the asp_net membership table. Each user would have a default password so I don't have to worry about converting their old passwords (i dont have them) from an encryption.

tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.3
9 years ago
Originally Posted by: Zero2Cool 

I have a CSV file with about 1,400 users with fields, first name, last name, email, username, joined date and post count. These were ignored during my initial migration to DNN/YAF and now that I'm straight YAF'ing (nice wording huh) I'd like to import those 1,400 users as well.

I was going to just import them to the yaf_User table, but I think that would fail because of the asp_net membership table. Each user would have a default password so I don't have to worry about converting their old passwords (i dont have them) from an encryption.

There is an User Importing feature for that under Admin -> Users and Roles -> Users you can import users from xml or csv

But currently it does not support joined date or post count. But all other Profile fields can be imported.

Zero2Cool
9 years ago
Originally Posted by: tha_watcha 

Originally Posted by: Zero2Cool 

I have a CSV file with about 1,400 users with fields, first name, last name, email, username, joined date and post count. These were ignored during my initial migration to DNN/YAF and now that I'm straight YAF'ing (nice wording huh) I'd like to import those 1,400 users as well.

I was going to just import them to the yaf_User table, but I think that would fail because of the asp_net membership table. Each user would have a default password so I don't have to worry about converting their old passwords (i dont have them) from an encryption.

There is an User Importing feature for that under Admin -> Users and Roles -> Users you can import users from xml or csv

But currently it does not support joined date or post count. But all other Profile fields can be imported.

Thanks. I will give that a try and just update the joined date afterwards.

Edit, I just did an export so I could get an idea of the format structure, and the data and column names don't sync. The UserId field for example, has parts of members signatures in it. Should this matter if I do an import using the same format?

Edit2, bah, this won't work. I have posts that correspond to the UserId and I believe this method will auto increment the UserId essentially making the posts not linked. (I have posts to import too, but I already got that tool written)