November Happy Hour will be moved to Thursday December 5th.

AI OnAI Off

Exporting Page Data to Excel or CSV

Jonathan Wood
Jonathan Wood
Vote:
 

Hi

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
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
Jonathan Wood
Vote:
 

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

#86835
Jun 03, 2014 1:51
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.