Exporting Page Data to Excel or CSV

Jonathan Wood

Vote:

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.

Jonathan.

#86802

Jun 02, 2014 8:17

Petter Klang

Vote:

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.

#86803

Jun 02, 2014 8:32

Jonathan Wood

Vote:

Thanks Petter, I'm thinking scheduled job is the way to go.

#86835

Jun 03, 2014 1:51