Welcome Guest! To enable all features please Login or Register.
2 Pages12>
Options
View
Go to last post Go to first unread
Offline astreib  
#1 Posted : Wednesday, January 19, 2011 8:04:42 PM(UTC)
astreib


Rank: YAF Forumling

Reputation:

Joined: 1/19/2011(UTC)
Posts: 3

Hi,

I'm planning to migrate an ASP.NET web site into DotNetNuke. The site currently uses YAF (version 1.9.1 based on the yaf.dll) and I am hoping to be able to preserve the existing forums and posting history.

If I use the YAF module for DotNetNuke, what will be involved in migrating the data from the prior, stand-alone YAF installation? I'm hoping of course for a simple export/import, or select/insert, but I'm guessing there will be other issues to consider. Anyone done something like this and willing to offer advice?

Thanks,

Allan
Sponsor
Online tha_watcha  
#2 Posted : Sunday, January 23, 2011 4:37:40 AM(UTC)
tha_watcha


Rank: YAF.NET Project Lead

Reputation:

Medals: Medal of Honor: Portal Puzzle Master: Portal Puzzle Master for DNNMedal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.DNN Master: DNN Module ManBug Killer Medal of Honor: Medal for being a kick-ass bug killer!Medal of Honor for the Support King: Support King! Amazing asset to the YAF.NET Community.

Joined: 3/6/2010(UTC)
Posts: 3,736
Germany

Thanks: 70 times
Was thanked: 1149 time(s) in 979 post(s)
Originally Posted by: astreib Go to Quoted Post
Hi,

I'm planning to migrate an ASP.NET web site into DotNetNuke. The site currently uses YAF (version 1.9.1 based on the yaf.dll) and I am hoping to be able to preserve the existing forums and posting history.

If I use the YAF module for DotNetNuke, what will be involved in migrating the data from the prior, stand-alone YAF installation? I'm hoping of course for a simple export/import, or select/insert, but I'm guessing there will be other issues to consider. Anyone done something like this and willing to offer advice?

Thanks,

Allan


I did some basic testing, one part of migrating is very easy because you can use the same database (If backup-ed first).

What i did so far is...
- delete the all folders and files of yaf,
- replaced them with new dnn.
- Executed the dnn installation
- Installed the yaf dnn module.
- and the standalone yaf board is ready to use.

There is only one BIG issue left the current yaf users has to be exported from yaf and imported into dnn, this could been easily done with some sql scripts.
Offline itay25a  
#3 Posted : Tuesday, March 1, 2011 9:15:41 AM(UTC)
itay25a


Rank: YAF Camper

Reputation:

Joined: 9/6/2010(UTC)
Posts: 16

Guys,
What about the original URLs and the Hostname of the stand alone YAF ?
Google already index the URLs and the Hostname
What I need to do when I upgrade to YAF DNN Module ?
Thanks
Offline itay25a  
#4 Posted : Tuesday, March 1, 2011 10:47:28 AM(UTC)
itay25a


Rank: YAF Camper

Reputation:

Joined: 9/6/2010(UTC)
Posts: 16

.

Edited by user Tuesday, March 1, 2011 10:54:05 AM(UTC)  | Reason: Not specified

Offline bbobb  
#5 Posted : Tuesday, March 1, 2011 1:09:26 PM(UTC)
bbobb


Rank: YAF Developer

Reputation:

Medals: Medal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.Medal of Honor for a YAF Database Key Player: Holds the key to YAF database. Bow down!Medal of Honor for the Support King: Given for answering tons of support questions and generally helping the community.Medal of Honor for the Support Knight: Given to a community member who has answered lots of support questions.

Joined: 10/21/2008(UTC)
Posts: 1,558
Man
Russian Federation
Location: Moscow

Thanks: 51 times
Was thanked: 288 time(s) in 254 post(s)
itay25a Offline , YAF doesn't have dot bug for ages.Smile
Offline lfosdal  
#6 Posted : Monday, March 7, 2011 10:17:23 AM(UTC)
lfosdal


Rank: YAF Lover

Reputation:

Joined: 8/9/2010(UTC)
Posts: 38

Thanks: 3 times
Was thanked: 9 time(s) in 5 post(s)
I am not sure if I understand how the authentication integration works between YAF and DNN. With DNN integration, will you have to migrate existing users from YAF to DNN. After that is done, how are new users managed? Will new users exist in DNN alone, ie the old YAF user table is inactive? How do one migrate in such a way that passwords survice the migration?

Do you need to migrate all users to DNN, or is it sufficient to migrate those that are running the site?
- There are no stupid questions.
Offline ruek23  
#7 Posted : Tuesday, March 8, 2011 2:43:26 AM(UTC)
ruek23


Rank: YAF Lover

Reputation:

Joined: 3/5/2010(UTC)
Posts: 57

Thanks: 9 times
Was thanked: 6 time(s) in 6 post(s)
Originally Posted by: lfosdal Go to Quoted Post
I am not sure if I understand how the authentication integration works between YAF and DNN. With DNN integration, will you have to migrate existing users from YAF to DNN. After that is done, how are new users managed? Will new users exist in DNN alone, ie the old YAF user table is inactive? How do one migrate in such a way that passwords survice the migration?

Do you need to migrate all users to DNN, or is it sufficient to migrate those that are running the site?



I did this and completed but the only issue I had was the passwords Sad

as I have a fairly small user count at 118 it wasn't hard to send a bulk mail saying that people will have to reset their password before login.
Online tha_watcha  
#8 Posted : Tuesday, March 8, 2011 5:26:26 AM(UTC)
tha_watcha


Rank: YAF.NET Project Lead

Reputation:

Medals: Medal of Honor: Portal Puzzle Master: Portal Puzzle Master for DNNMedal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.DNN Master: DNN Module ManBug Killer Medal of Honor: Medal for being a kick-ass bug killer!Medal of Honor for the Support King: Support King! Amazing asset to the YAF.NET Community.

Joined: 3/6/2010(UTC)
Posts: 3,736
Germany

Thanks: 70 times
Was thanked: 1149 time(s) in 979 post(s)
Originally Posted by: ruek23 Go to Quoted Post
Originally Posted by: lfosdal Go to Quoted Post
I am not sure if I understand how the authentication integration works between YAF and DNN. With DNN integration, will you have to migrate existing users from YAF to DNN. After that is done, how are new users managed? Will new users exist in DNN alone, ie the old YAF user table is inactive? How do one migrate in such a way that passwords survice the migration?

Do you need to migrate all users to DNN, or is it sufficient to migrate those that are running the site?



I did this and completed but the only issue I had was the passwords Sad

as I have a fairly small user count at 118 it wasn't hard to send a bulk mail saying that people will have to reset their password before login.


So you build the sql scripts to import the yaf users to dnn? Can you send them to me? And i see what i can do, and we could create a generic import Method for that.
Online tha_watcha  
#9 Posted : Monday, March 14, 2011 5:31:58 AM(UTC)
tha_watcha


Rank: YAF.NET Project Lead

Reputation:

Medals: Medal of Honor: Portal Puzzle Master: Portal Puzzle Master for DNNMedal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.DNN Master: DNN Module ManBug Killer Medal of Honor: Medal for being a kick-ass bug killer!Medal of Honor for the Support King: Support King! Amazing asset to the YAF.NET Community.

Joined: 3/6/2010(UTC)
Posts: 3,736
Germany

Thanks: 70 times
Was thanked: 1149 time(s) in 979 post(s)
Originally Posted by: ruek23 Go to Quoted Post
Originally Posted by: tha_watcha Go to Quoted Post

So you build the sql scripts to import the yaf users to dnn? Can you send them to me? And i see what i can do, and we could create a generic import Method for that.



PM'd the script I used to you...

I don't think it's the final one as I had to do some tweeks but heres what I have


Ok i test your sql Script. The Problem with the Passwords can not be solved since the Passwords and the PasswordSalt are stored with the Application id (Maybe it would work with a defined machine Key in yaf and the same one in dnn) and dont work on the converted dnn app.

It looks like the only solution is that the user has to use the Reset Password Function to get a new Password.

I attached the sql script, if someone wants to use it
File Attachment(s):
YAFDNNUSerImportSQL.zip (2kb) downloaded 63 time(s).
Offline 3KyNoX  
#10 Posted : Tuesday, March 15, 2011 7:41:02 AM(UTC)
3KyNoX


Rank: YAF Forumling

Reputation:

Joined: 3/15/2011(UTC)
Posts: 5

Hello,

First, Thanks for this usefull post but i get stuck using my main Yaf Forum inside DNN after installation;

I did all the first parts :

- backed up my existing yaf tables (deathblow.bak) from sql server management studio
- restored it on a fresh 'deathblow' db from sql server management studio
- delete all folders and files of yaf,
- replaced them with new dnn.
- executed the dnn installation on deathblow db
- created new users while dnn installation (hostadmin and siteadmin)
- installed the yaf dnn module.
- added a forum page in dnn
- installed yaf module on this page (at this point, yaf wizard asking for web.config yaf password, etc...) --> completed
- executed without any errors the script to import users inside dnn tables (changed script to point on 'deathblow' db) from sql server management studio
- opened dnn forum page while logged at hostadmin

At this point, there is a logout and i get the following yaf error :

Quote:
Error
A system error happened. Thanks to contact administrator.
Continue Link...


After it oppen the forum with correct topics and forums inside but unlogged at this point.

Then, I try to log back hostadmin account and go back on forum and getting same error.

Also, when i try to reset the password of an imported user i get this error too :

Quote:
There was an error retrieving your password. No password was sent.


Here's the script detail :
Quote:

begin tran

DECLARE @ApplicationId uniqueidentifier

--Get DNN .NET Membership ApplicationID
SELECT @ApplicationId = ApplicationId
FROM [DeathBlow].[dbo].[aspnet_Applications]

INSERT [DeathBlow].[dbo].[aspnet_Users] (ApplicationId,UserId,UserName,LoweredUserName,IsAnonymous,LastActivityDate)
SELECT @ApplicationId, m.Userid, m.Username, m.UsernameLwd,0,
CASE
WHEN m.LastActivity IS NULL THEN getdate()
ELSE m.LastActivity
END
from [DeathBlow].dbo.yaf_prov_Membership m
Left JOIN [DeathBlow].[dbo].[aspnet_Membership] mm on m.UserID = mm.UserID
Where mm.UserID IS NULL


--INSERT into DNN .NET Membership Membership table the required Information
--from yaf membership
INSERT [DeathBlow].[dbo].[aspnet_Membership] (ApplicationId,UserId,[Password],PasswordFormat,PasswordSalt,Email,LoweredEmail,PasswordQuestion,PasswordAnswer,IsApproved,IsLockedOut,LastLoginDate,LastPasswordChangedDate,LastLockoutDate,FailedPasswordAttemptCount,FailedPasswordAttemptWindowStart,FailedPasswordAnswerAttemptCount,FailedPasswordAnswerAttemptWindowStart,Comment,CreateDate)
SELECT @ApplicationId,m.UserID,m.[Password],m.PasswordFormat,m.PasswordSalt,m.Email,m.EmailLwd,m.PasswordQuestion,m.PasswordAnswer,m.IsApproved,0,
CASE
WHEN m.LastLogin IS NULL THEN '1754-01-01 00:00:00.000'
ELSE m.LastLogin
END,
CASE
WHEN m.LastPasswordChange IS NULL THEN '1754-01-01 00:00:00.000'
ELSE m.LastPasswordChange
END,
CASE
WHEN m.LastLockOut IS NULL THEN '1754-01-01 00:00:00.000'
ELSE m.LastLockOut
END,0,'1754-01-01 00:00:00.000',0,'1754-01-01 00:00:00.000',m.Comment,m.Joined
FROM [DeathBlow].[dbo].[yaf_prov_membership] m
Left JOIN [DeathBlow].[dbo].[aspnet_Membership] mm on m.UserID = mm.UserID
Where mm.UserID IS NULL

INSERT [DeathBlow].[dbo].[Users] ([Username],[FirstName],[LastName] ,[IsSuperUser],[Email],[DisplayName] ,[IsDeleted],[CreatedByUserID],[CreatedOnDate],[LastModifiedByUserID],[LastModifiedOnDate],[UpdatePassword])
SELECT u.Name,u.Name,'',0,u.Email,u.DisplayName,0,-1,u.Joined,-1,LastVisit, 1
FROM [DeathBlow].[dbo].[yaf_User] u
JOIN [DeathBlow].[dbo].[yaf_prov_membership] m on m.UserID = u.ProviderUserKey
LEFT JOIN [DeathBlow].[dbo].[Users] uu on m.username = uu.username
WHERE uu.UserID IS NULL


INSERT [DeathBlow].[dbo].[UserPortals] (UserId,PortalId,CreatedDate,Authorised)
SELECT u.Userid,0,u.[CreatedOnDate],1
FROM [DeathBlow].[dbo].[Users] u
LEFT JOIN [DeathBlow].[dbo].[UserPortals] up on u.userid = up.userid
where u.UserID != 1
AND up.userid is null

INSERT [DeathBlow].[dbo].[UserRoles] (UserID,RoleID,IsTrialUsed,CreatedByUserID,CreatedOnDate,LastModifiedByUserID,LastModifiedOnDate)
SELECT u.UserID, 1, 1, -1,u.CreatedOnDate,-1,u.LastModifiedOnDate
FROM [DeathBlow].[dbo].[Users] u
LEFT JOIN [DeathBlow].[dbo].[UserRoles] ur ON u.UserID = ur.UserID
AND ur.ROLEID = 1
WHERE u.UserID != 1
AND ur.UserID IS NULL

INSERT [DeathBlow].[dbo].[UserRoles] (UserID,RoleID,IsTrialUsed,CreatedByUserID,CreatedOnDate,LastModifiedByUserID,LastModifiedOnDate)
SELECT u.UserID, 2, 1, -1,u.CreatedOnDate,-1,u.LastModifiedOnDate
FROM [DeathBlow].[dbo].[Users] u
LEFT JOIN [DeathBlow].[dbo].[UserRoles] ur ON u.UserID = ur.UserID
AND ur.ROLEID = 2
WHERE u.UserID != 1
AND ur.UserID IS NULL

Commit


Using DNN 05.06.01 and YAF_DNN5_1.95.5-4750

Thanks for help.

Suggestion : Once done, maybe it could be great to add the feature inside Yaf DNN Module (possibility to import users and forum content).

Offline 3KyNoX  
#11 Posted : Tuesday, March 15, 2011 8:38:08 AM(UTC)
3KyNoX


Rank: YAF Forumling

Reputation:

Joined: 3/15/2011(UTC)
Posts: 5

Resolved first error by creating in dnn a new user. and relog to HostAdmin account.

The error...

Quote:
Error
A system error happened. Thanks to contact administrator.
Continue Link...


... disappeared and forum is displayed correctly now, but I cannot no longer use previous accounts because of password that i can't change from 'reset password' button or admin panel... And while logged as HostAdmin, i don't see the admin Yaf Links. So i can't go to Yaf Admin Pages..
Offline ruek23  
#12 Posted : Tuesday, March 15, 2011 9:06:22 AM(UTC)
ruek23


Rank: YAF Lover

Reputation:

Joined: 3/5/2010(UTC)
Posts: 57

Thanks: 9 times
Was thanked: 6 time(s) in 6 post(s)
Originally Posted by: 3KyNoX Go to Quoted Post
Resolved first error by creating in dnn a new user. and relog to HostAdmin account.

The error...

Quote:
Error
A system error happened. Thanks to contact administrator.
Continue Link...


... disappeared and forum is displayed correctly now, but I cannot no longer use previous accounts because of password that i can't change from 'reset password' button or admin panel... And while logged as HostAdmin, i don't see the admin Yaf Links. So i can't go to Yaf Admin Pages..



All original users will have to get a new password... this worked fine for 75% of my users after the migration. the issue is the other 25% who couldn't have their password reset. I had to do these manually from the admin account in DNN. to get Host Access back in YAF reset the password of the original host user and login with that person

Offline 3KyNoX  
#13 Posted : Tuesday, March 15, 2011 8:29:13 PM(UTC)
3KyNoX


Rank: YAF Forumling

Reputation:

Joined: 3/15/2011(UTC)
Posts: 5

Thanks, i got access to original yaf forum admin back and added HostAdmin & SiteAdmin to the forum administrator group.

But for other members, the problem is :

If they use forgot password link, they got the following error :

Quote:
There was an error retrieving your password. No password was sent.


And if i try to do a password reset for that account in admin panel, the password is reset, temporary password is correctly sent to account email, this user using this password to login and changing the password, but at this point, new error...

Quote:
There was an error setting the password. The password has not been changed.


Tryed again and again with an old test account i was having, it changed the password to the one I set but impossible to logging in with it.

Thanks for help.

Edited by user Tuesday, March 15, 2011 8:36:02 PM(UTC)  | Reason: Not specified

Online tha_watcha  
#14 Posted : Wednesday, March 16, 2011 1:31:54 AM(UTC)
tha_watcha


Rank: YAF.NET Project Lead

Reputation:

Medals: Medal of Honor: Portal Puzzle Master: Portal Puzzle Master for DNNMedal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.DNN Master: DNN Module ManBug Killer Medal of Honor: Medal for being a kick-ass bug killer!Medal of Honor for the Support King: Support King! Amazing asset to the YAF.NET Community.

Joined: 3/6/2010(UTC)
Posts: 3,736
Germany

Thanks: 70 times
Was thanked: 1149 time(s) in 979 post(s)
You can try my way of solving the password issue manually:

- Open the Table "aspnet_Membership" in your Database
- Select a User with a password that works for example the admin
- Copy the Password and PasswordSalt Value to any user you want

And you should been able to login.
Offline 3KyNoX  
#15 Posted : Wednesday, March 16, 2011 5:44:45 AM(UTC)
3KyNoX


Rank: YAF Forumling

Reputation:

Joined: 3/15/2011(UTC)
Posts: 5

Simple one. Smile

Is it how the password have been imported ,who don't permit to change it while I am in administration panel or trying to retrieve it at login ?

So, I'll try this first, Thanks.
Rss Feed  Atom Feed
Users browsing this topic
2 Pages12>
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error