Import utils - Forum

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

Home All Forums

1
2
3
4
5

8/27/2006 6:31 AM

David Lumley

www.go-real.net
Joined: 5/3/2006

Posts: 107

Import utils

I have an existing forum with an access database and wondered if thehre were any utilities to import these to the database

I know the user data needs to be imported too -

If it doesnt exist any chance of pointing me in the right direction as to wht I need to look out for and what tables are involved and their contents that relate

so that I can work on my own utility to do this?

Dave DNN 4.3.5 IIS - 6 ?? SQL Server 2005

8/27/2006 3:51 PM

Chris Paterra

Joined: 4/5/2003

Posts: 4377

Re: Import utils

I doubt there is any importers available from an access database. My advice is doing a dts of the tables into your DNN db, then writing a set of sql cursor statements. You will have to get the users in first, then get them in as forum users, then the groups, then the forums. You will also have to handle the possibility of subforums if your first forum had them because this one doesn't. This is a lot of work.

Chris Paterra

Get direct answers to your questions in the Community Exchange.

11/11/2006 10:15 PM

Matthew Christenson

Joined: 10/19/2006

Posts: 164

Re: Import utils

I would also like to do this - Specifically I would like to import from SMF forums.

Alternatively i may consider a 3rd party forum module for DNN; if it would allow for this.

Does anyone have any suggestions for me? I was planning to tackle this later in the month but hadn't considered the issue of subforums... usernames isn't as important, i would be content having all messages posted by the same user -- with an appended header to the message giving the original author; in short - i want to preserve history without keeping the old forum up.

thanks

12/7/2006 9:20 AM

David Lumley

www.go-real.net
Joined: 5/3/2006

Posts: 107

Re: Import utils

I have been looking quite deeply at this module for a while now - if you want to send some sample data in acess I'll see what i can do

Dave

Dave DNN 4.3.5 IIS - 6 ?? SQL Server 2005

12/8/2006 7:12 AM

Tomas Alsbro

www.whiplashinfo.se
Joined: 2/5/2006

Posts: 144

Re: Import utils Modified By Tomas Alsbro on 12/8/2006 7:15:54 AM

Lummers wrote

I have been looking quite deeply at this module for a while now - if you want to send some sample data in acess I'll see what i can do

Dave

Hi Dave,

I have similar problem. I haven’t got a clue on how to import my old Snitz Forums 2000 to DNN Forum Module. It’s used as a help forum where injured and sever ill persons can help each other and even get help from specialists. The whole site and its help forum are free of charge, as I run it as a private person with out any profit interest.

The forum data is as follow:

464 of 1924 Members have made 16798 posts in 84 forums, with the last post on 06 dec 2006 13:02:00 by: iren.

There are currently 2543 topics and no active topics since you last visited.

There are 2823 archived posts in 495 archived topics

Tomas, WhiplashInfo.se

Trafic injured non profit Site owner/webmaster/admin/user without programming skills, eager to help other injured and sever ill persons.

Page 1 of 2

1

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:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
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.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

DNN Corp. (DotNetNuke)