Export Item Data Tool (Module) for Sitecore

Download Here

Often we come across situations where we need to export data from our Sitecore instance into common formats like excel / xml / json etc. Usually we end up writing ad hoc scripts for this based on the requirements.

This is exactly what this tool does. It allows you to write sort of a query to determine what data you’d want, and let you export this data to the common formats like Excel / XML and Json.

This tool lets you nest fields to account for reference fields too. As an example, lets look at this scenario – I have a bunch of Article items, and I need to export this data into excel.

This was the structure in place:

2015-07-05_210728

So for the above templates, we would use the following query: Headline,Article Type(Title),Necessary Products(Sku,ProductType(Title)),Skill Level(Title)

The module basically does an index search and hence also needs the comma separated template id(s), search location / language and index name to do the search. In addition to the custom fields that can be added, we could also choose to include common attributes like Item Id, Item Name etc.

Here’s another simple example with the sample output data:

2015-07-05_212326

2015-05-31_114306

A look at sitecore:

2015-07-05_212710

Sample Output:

JSON

2015-07-05_213406

XML

2015-07-05_213512

The code for this tool is available in github: https://github.com/aceanindita/sitecore-export-item-data-tool

Once installed, the tool appears in the sitecore menu as:

2015-07-05_213810

To see the steps to create a sitecore module please refer: Creating a Sitecore Module

Advertisements

, , , , , , , , , ,

  1. #1 by michaellwest on July 6, 2015 - 12:52 am

    Very cool article. Something I would like to spend more time trying out. Have you seen the Sitecore PowerShell Extensions module? It provides some capabilities like a report creator you may find beneficial too.

    Like

  2. #3 by Srini Kamana on December 2, 2016 - 10:30 pm

    Thanks much. Worked well for the most part including linked data items. However, having trouble cleanly linking Item Fields that map to Media Library Items whose raw value looks like this “”. Is there a good way to specify the fields in your export tool such that it exports the media library item’s attributes also, instead of the raw value? Look forward to your insights

    Like

  3. #4 by Shalik Wagle on January 17, 2017 - 9:14 pm

    Does it work on 8.1? Or is there any updated version?

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: