kflowers
  •  kflowers
  • 53% (Neutral)
  • YAF Forumling Topic Starter
2010-11-23T01:51:35Z
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
2010-11-27T00:07:26Z
Anyone have any experience with this?
squirrel
2010-11-27T02:49:49Z
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
2010-11-29T19:31:22Z
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
2010-11-30T03:49:18Z
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
2013-01-21T16:01:04Z
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
2013-01-22T09:51:47Z
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.




UserPostedImage

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