Importing external forum content into Kentico Forums

Comet Halley asked on August 26, 2014 22:02

Hi,

We need to import the content of an existing forum system into Kentico 8.x. The source forum is based on Telligent Community which looks like that http://zimbra.com/forums/

Sorry the information I have right now is rather vague. Can you please give me some guidelines to help me estimate the development effort?

Q1. Is it possible to do the import directly from Source Database to Target Database? Which means an ETL process that reads the source data and inject them directly into the right tables in Kentico database.

Q2. In case Q1 is impossible. Possibly because the import into Kentico must go through an API or a specific Import tool? Can you give a high level description of the process? Example: 1) Create users via Kentico API, 2) Create Forum Groups, 3) Create Forums, ...

Q3. Documentation: If it is necessary to use specific Kentico tools or Kentico API programming. Can you please give me links to the appropriate documentation?

Thanks very much in advance for any help.

Recent Answers


Brenden Kehren answered on August 27, 2014 15:00

I've worked through this with the forum base you talk about in the past with Kentico v6. The client wanted to have all old posts and images imported from the old site to the new Kentico site. Unfortunately, in v6 or v7 (or v8 I believe) there is no import tool for forum posts. I started to write some code to do the import although the client decided it was too much effort.

Kentico uses post id's to help generate the URLs so its not a straightforward import process not to mention the mapping of the different systems.

Regarding the API use, you are off to a good start. You'd need the following:

1. All user ID's who have posted (assuming UserID is stored in Telligent)
2. Import users using Import Toolkit from Kentico (assuming license allows) and use existing UserID
3. Create forum group
4. Create forum posts using recurrsion to ensure the posts are linked from top to bottom thread.  Note, There is a limitation of roughly 63 replies to a post(at least in v6 and v7) because of SQL Server Full-Text search limitation of 450 characters.  This goes back to what I mentioned before about using the post ID's to generate a URL.

Hopefully this helped a little!

Good luck! Brenden

0 votesVote for this answer Mark as a Correct answer

Comet Halley answered on August 27, 2014 18:17

Hi Brenden,

Thank you very much for your help. When you did the migration in the past. How did you extracted data (users, posts, forum metadat, etc) from Telligent Community? Did you read directly in the database or was there some Stored Procedures?

0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on August 27, 2014 20:46

I went direct to the tables. I found all the users who made posts and exported them into another table and imported them into Kentico with the same userid. If I remember right, the table structure was a bit confusing in Telligent as well for the posts. It was considerably more complex than Kentico. I still have some of my code as well as all the data and I know I'll be asked to import them some day, just a matter of time and $$$. :)

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.