I am building an application that uses a daily xml feed from my client. I intend to use SSIS to do the import. Instead of building a seperate plug-in, I would like to use the feed to directly create nodes of a specific doctype. Can this be done?
One thing to keep in mind with Umbraco, while the data itself (content, properties, etc), is stored in the database, the published content pages is stored within an XML cache (written to disk and loaded into memory on app-start).
I would never insert data directly into the database. You can use the API to code the import. Or use CMSImport for the task. Comes with an option to read xml in the Free version if you need to schedule imports or want to update content also you need the pro edition.
Can content be created directly to the database?
I am building an application that uses a daily xml feed from my client. I intend to use SSIS to do the import. Instead of building a seperate plug-in, I would like to use the feed to directly create nodes of a specific doctype. Can this be done?
Hi Tony,
One thing to keep in mind with Umbraco, while the data itself (content, properties, etc), is stored in the database, the published content pages is stored within an XML cache (written to disk and loaded into memory on app-start).
It is possible to create a document/content node directly in the database - take a look at Hendy's blog post about the database schema: http://blog.hendyracher.co.uk/umbraco-database-part-2/
You would still need to find a way to trigger the publishing of the XML document.
Alternatively you could look at using CMSImport with a scheduling mechanism?
Cheers, Lee.
Hi Tony,
I would never insert data directly into the database. You can use the API to code the import. Or use CMSImport for the task. Comes with an option to read xml in the Free version if you need to schedule imports or want to update content also you need the pro edition.
Hope this helps,
Richard
is working on a reply...