/AF_YAF.Net_Migration

Script tp migrate DNN Active Forums to DNN YAF.Net Forum

Primary LanguagePLpgSQL

Active Forums to YAF.Net Migration

Script to migrate DNN Active Forums to DNN YAF.Net Forum

© Sebastian Leupold, dnnWerk 2016.

Latest version is available on GitHub.

This Script is provided "as is" with no liabilities or guarantees.

What will be migrated?

  • AF Module → YAF.Net Board
  • AF ForumGroups → YAF.Net Categories
  • AF Forums → YAF.Net Forums
  • AF Threads → YAF.Net Topics
  • AF Topics & Replies → YAF.Net Messages
  • AF Attachments → YAF.Net Attachments
  • AF Notifications → YAF.Net Forum & Topic Watches
  • DNN Users with forum posts → YAF.Net Users
  • DNN Roles with AF module permission → YAF.Net Groups & ASP.net Roles

What will not be migrated?

  • Permissions and a number of settings for forums and forum groups
  • Messages (if you are still using AF Messages, I suggest migrating it to Core Messages)
  • YAF.Net does not support forums for DNN Social Groups, i.e. those AF forum modules cannot be migrated atm!
  • Data from Polls

Prerequisites

  • You need to have DNN with Active Forums installed (V 5.0+).
  • You need to have YAF.Net DNN module installed, using default database objet qualifier "yaf_".
  • Make sure, there are no open polls, because those will not be copied over.
  • You should inform your users to dismiss all notification messages, as they will get lost during migration.
  • You need to have Yaf.Net module placed on a page and configured it to create board #1. This board with first category and first forum will be used as a template for imported data. If you prefere to use a different board, you need to modify the migration script.

Performing a Migration

Please make sure you start with a database backup!!!

  • Please make sure you are using latest version of the migration script from GitHub.

  • In Host > SQL, run ListModules.sql to get a list of migratable AF moduleIds. Enter the preferred moduleID into MigrateForums.sql

  • Execute script MigrateForums.sql in Host > SQL or SSMS

  • to get AF file attachements being displayed and provided for download, you need to copy manually the files from portals[PortalID]\activeforums_Upload folder to folder \DesktopModules\YetAnotherForumDotNet\uploads and append ".yafupload" to each file name.

  • Afterwards add a new YAF.Net DNN module instance to a page and select highest existing Board to be displayed. Enter Board administration and review/adjust permissions and settings for board, forums and forum groups.

  • Inform your users about the migration and tell them to review their forum settings.

Known issues

Script not finished yet - work in progress:

  • datetime values need to be converted to UTC
  • not yet tested