Our client has a requirement to export the custom properties of all pages within a tree node to Excel or CSV. The property types are simple Heading (string), MainBody (XhtmlString) etc.
Is this possible? I know the export data feature exports to .episerverdata format which is a zip file that contains an XML file called epix which does technically store all the data but the format isn't correct to display correctly in Excel and it contains a lot of meta data that the client really doesn't need.
Thanks in advance for any help you can provide.
There isn't a built in function for this. But you could either use the export function as you mention, but as you say the xml will need some "washing".
Or you could create your own scheduled job that takes the tree node and then create a csv or execel file of the properties in question. I would go for this as it gives a more explicit functionality.
Thanks Petter, I'm thinking scheduled job is the way to go.