well i am attempting to get certain content out of umbraco and shown instead on another website we manage. In our case its a specific "section" of umbraco content that would be more apt on a dedicated jobs site we have.
initially i was looking at the approach of posting from Umbraco utilising the ContentService.Published event within a RegisterEvents class.
This works in that i can get existing content out, but i cannot seem to access children/ancestors within this event, so i do not know how i would recognise new content once it had been published as again i cannot seem to access parent/children ids....
so my other idea was to try the other way and from the jobs website, import the relevant data from the umbraco database via a web service for example. Then presumably i could target the "top" level i want and access the content tree under this node. Im not sure yet how i would render this content within the other site but hopefully i could more easily get the content tree i require.
Havent found much in the way of documentation/help on doing this....
I don't know what version of Umbraco you are using. But from 6.1.x and 7.x you can use the UmbracoApiController. That way you can create a REST API to make your data accesable for other sites.
umbraco database - content
can anyone tell me where the actual page content (title, bodytext) is stored within the umbraco db schema?
ive looked through the tables but cannot seem to locate it....
The data of your properties will be stored in the table cmsPropertyData
Here are some posts about the database schema for a older Umbraco version. But most is still actual:
http://blog.hendyracher.co.uk/umbraco-database-part-1/
http://blog.hendyracher.co.uk/umbraco-database-part-2/ ;
Can I ask why you need this information ?
Dave
well i am attempting to get certain content out of umbraco and shown instead on another website we manage. In our case its a specific "section" of umbraco content that would be more apt on a dedicated jobs site we have.
initially i was looking at the approach of posting from Umbraco utilising the ContentService.Published event within a RegisterEvents class.
This works in that i can get existing content out, but i cannot seem to access children/ancestors within this event, so i do not know how i would recognise new content once it had been published as again i cannot seem to access parent/children ids....
so my other idea was to try the other way and from the jobs website, import the relevant data from the umbraco database via a web service for example. Then presumably i could target the "top" level i want and access the content tree under this node. Im not sure yet how i would render this content within the other site but hopefully i could more easily get the content tree i require.
Havent found much in the way of documentation/help on doing this....
would you have any suggestions?
I don't know what version of Umbraco you are using. But from 6.1.x and 7.x you can use the UmbracoApiController. That way you can create a REST API to make your data accesable for other sites.
Documentation can be found here : http://our.umbraco.org/documentation/Reference/WebApi/
Dave
is working on a reply...