Batch Import of "News" Document Type

James Jarrett asked on April 17, 2014 12:26

I need to import roughly 3,000 news stories from another CMS. Moving the data is the easy part.

My question is after I have migrated these ~3000 rows of data into my Kentico Custom News Document Type table what issues might I run into getting the system to recognize the new records?

I'm not quite ready to take on this task but I thought someone might have some advice on what the gotchas might be.

Recent Answers

Brenden Kehren answered on April 17, 2014 13:24

As long as you have defined the custom doc type prior to the import, you should be able to use the Kentico Import Toolkit to do your import. With that tool you can do everything needed for what is needed for Kentico to "recognize" the new records. If you plan to manually import them (via sql script or custom program) I'd suggest NOT to because you'd need to know the other relationships that are needed. You won't simply insert into one table, you'd need to insert into multiple and make references to other records from other tables as you would with any other relational database.

If you're not able to use the Import Toolkit, I'd suggest writing a program and using the Kentico API.

0 votesVote for this answer Mark as a Correct answer

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