Reset Password · YAF.NET Support Forum

Welcome Guest! To enable all features please Login or Register

Posted by: kflowers - Tuesday, 23 November 2010 02:51:35
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?

Posted by: kflowers - Saturday, 27 November 2010 01:07:26
Anyone have any experience with this?

Posted by: squirrel - Saturday, 27 November 2010 03:49:49
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.

Posted by: squirrel - Saturday, 27 November 2010 03:49:49

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.

Posted by: kflowers - Monday, 29 November 2010 20:31:22
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!

Posted by: squirrel - Tuesday, 30 November 2010 04:49:18
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 :)

Posted by: squirrel - Tuesday, 30 November 2010 04:49:18

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 :)

Posted by: Zero2Cool - Monday, 21 January 2013 17:01:04
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.

Posted by: Zero2Cool - Monday, 21 January 2013 17:01:04

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.

Posted by: tha_watcha - Tuesday, 22 January 2013 10:51:47
[quote=Zero2Cool;57350]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.[/quote] There is an User Importing feature for that under Admin -> Users and Roles -> [b]Users[/b] 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.

Posted by: tha_watcha - Tuesday, 22 January 2013 10:51:47

[quote=Zero2Cool;57350]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.[/quote] There is an User Importing feature for that under Admin -> Users and Roles -> [b]Users[/b] 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.

Posted by: Zero2Cool - Tuesday, 22 January 2013 15:02:45
[quote=tha_watcha;57363][quote=Zero2Cool;57350]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.[/quote] There is an User Importing feature for that under Admin -> Users and Roles -> [b]Users[/b] 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. [/quote] 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)

Posted by: Zero2Cool - Tuesday, 22 January 2013 15:02:45

[quote=tha_watcha;57363][quote=Zero2Cool;57350]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.[/quote] There is an User Importing feature for that under Admin -> Users and Roles -> [b]Users[/b] 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. [/quote] 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)

Important Information: