Armysniper89
-
5/24/2011 9:41:20 PM
Importing Data into Custom Document Type
I have a custom version of the Event document type that has a bunch of different fields. The reason I have these fields is due to the fact that we want to have Events important from an external site. The plan is to import daily, new events added to this external site into our Kentico site. Ideally I can run a SQL script to merge the values from one table into my custom Event document type. Will this work? I have read some responses to imports suggest using the API which I will if I have to but I would like to use SQL code to keep it on the back end. Second question, if I import through SQL, what is needed to get these Events to show up in the site?
|