YAFLogo

AndyGarrett
  • AndyGarrett
  • 53% (Neutral)
  • YAF Forumling Topic Starter
12 years ago
I am currently upograding a site I created years ago in asp to .NET 4, with BlogEngine and YAF.

I have YAF integrated with BlogEngine, and I'm able to create Boards, Fourms, Topics, etc..

I'm to the point of trying to migrate forum data from some forums I had created on the old site using ASP to YAF. I can get to the data using a Class I built to interact with my old database, but I am not seeing good resource on how to import that into YAF.

It appears that I must use YAF.Classes.Data.LegacyDb to do this, but is it documented anywhere what this might look like.

I have users in asp.net membership tables, but I think I still have to do the following:

1) Create the users in YAF.NET

2) Create the forums

3) Create the topics

4) Create the Messages

I would love to be able to do this all using C# in a script.

Any help or thoughts would be greatly appreciated.

Thanks!

Sponsor
Zero2Cool
  • Zero2Cool
  • 100% (Exalted)
  • YAF Leader YAF Version: YAF 3.1.16
12 years ago
It's been nearly a year since I did this myself. I believe it's safe to say, users have to be imported first, then the forums, then the topics and then the messages. As you have indicated as well.

I went from DragonFly CMS (php) to DotNetNuke w/YetAnotherForum. I mention that because, well, I guess it doesn't matter, but I exported everything into Excel documents. It was about 2,000 users with I think 160,000 messages.

I exported my Users, Forums, Topics and Messages into their own Excel documents.

If you're not using DotNetNuke, this first link will be of no use to you. This tool here  imported my Users from Excel into my database, then I used the DNN to YAF UserImporter to create the DNN users into YAF.

The YAF-ImportTools.zip  is two applications I threw together to import my MySQL messages into YAF.

YAF-AddMessages imports the topics/messages from an Excel file into your database.

YAF-Maintenance to sync up forum categories, topics, and whatever else you find in there.

These tools are very ad-hoc and are not a final product for anyone not using the same structure as myself, however, I believe this is a very solid first step in your goal. The code will need modifying to meet your needs of course. It is C# and it's in VS2010.

I think the most fun I had was actually doing the data migration from the old site to the new site, lol.

AndyGarrett
  • AndyGarrett
  • 53% (Neutral)
  • YAF Forumling Topic Starter
12 years ago
Zero2Cool

Thanks for those files. I looked at them briefly, and they looked helpful. At work now, but I will try to look at them more. I think seeing the queries will be what I need.

Andy

asherrick
11 years ago

The YAF-ImportTools.zip  is two applications I threw together to import my MySQL messages into YAF.

YAF-AddMessages imports the topics/messages from an Excel file into your database.

YAF-Maintenance to sync up forum categories, topics, and whatever else you find in there.

These tools are very ad-hoc and are not a final product for anyone not using the same structure as myself, however, I believe this is a very solid first step in your goal. The code will need modifying to meet your needs of course. It is C# and it's in VS2010.

Originally Posted by: Zero2Cool 

Zero2Cool, the link to the YAF-ImportTools.zip file is broken. Can you fix it? This code example would be helpful with my current migration. Thanks!