New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForumForumImport ContentImport Content
Previous
 
Next
New Post
12/3/2009 6:51 PM
 

I have forums up and running on my site and I've been tasked with importing the content from our legacy system into this one.  Before I go through and look at table structures figuring out what maps to what and then writing a sql statement to move content from one system to the other I thought I'd pick your brains here.

Is there an "easier" way to import content from an old system?  Is the route I'm going a good route to take?

 
New Post
12/3/2009 10:16 PM
 

Sorry, there is no other way.  There are many different Forums, so that we do not deliver any scripts or imports from other Forum systems.  I think you are on the right way.

 
New Post
12/4/2009 11:22 AM
 

Thanks for the update Matthias.  You mean you don't have scripts for every other forum solution out there???

Just kidding.  That would be quite an undertaking that no one in there right mind would do.  I'll stick with my route and get them over.  Thanks again.

 
New Post
12/4/2009 2:05 PM
 

I have experience in importing data into the module (as the developer of this module) and I am also very clear on the data structure. While I can't promise to take this task on with you, I can certainly answer any questions you may come across while you go through this. Please feel free to post them here as they come up. Do you plan on writing an application to handle this import process (if you want to move in users, you most likely will need to do this) or do you plan on just using SQL?


Chris Paterra

Get direct answers to your questions in the Community Exchange.
 
New Post
12/4/2009 5:46 PM
 

I'm not exactly sure on what the Users table does.  I belive it holds info for the users who have posted/read things in the forum and that it pulls user id's from the standard DNN user object.  If that's the case we'll be fine.

The users from the old system don't all exist on our new website so I was planning on migrating all of the posts under one username.  My plan is to Create the Groups and Forums via the module which will update the FORUM_GROUPS and FORUM_FORUMS tables.  Then I will write queries to move the data into the FORUM_THREADS and FORUM_POSTS table.  At the end I'll do some cleanup queries to update the number of threads/posts which is used in the FORUM_FORUMS table.

I'm going to look through all of the forum tables in detail early next week, but those were the foure tables that jumped out at me as needing updating.  I was thinking the users table would be updated on it's own as people start viewing/updating on their own.

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForumForumImport ContentImport Content


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.