smithsson68@gmail.com
Aug 18, 2010
  7934
(2 votes)

EPiServer CMS XForm Search Gadget

In EPiServer CMS 6, XForms and their respective posts found a new home in the Dynamic Data Store (DDS). As the DDS has a Language Integrated Query (LINQ) enabled API, the opportunities for searching through XForm posts increased greatly.

With that in mind, I decided to develop a gadget with the target audience being site editors / owners / marketing guy, rather than developers.

Once the gadget has been installed using the EPiServer Deployment Center, it can be found in the EPiServer Online Center of the chosen site:

image

Once added to your dashboard, you select the XForm whose posts you want to search in:

image

Once the XForm has been selected, you are then presented with a search input panel to allow you to filter your search results:

image

The search can be filtered by all of the input fields on the XForm along with the post date and username of the poster.

You can then decide how to sort the output and which format you would like it in:

image

Once you’ve clicked the Search button, you should see the output either in the gadget or as a file download, depending on what format you chose:

image

The gadget can be configured using it’s menu in the top right hand corner:

image

The number of results per page as well as the CSV output value delimiter can be configured:

image

The default CSV output delimiter is a comma. Note that users whose Windows Region and Language settings are set to a locale that uses commas in numbers (such as Sweden) will need to set their CSV value delimiter to the appropriate value (semi-colon is used in most cases).

The EPiServer Deployment Center installation module for the gadget can be found here and the full source code here.

Developers are welcome to amend and customize the gadget as they see fit or just use it as is. It is currently localized to English and Swedish and uses the EPiServer CMS Language System (lang files) for internationalization. To localize to a new language you will need to edit the XFormSearchGadget.xml file in the site's lang folder.

Please note that the gadget is provided ‘as is’ without any warranty, guarantee or official support from EPiServer. With that said, if you do find any bugs or want to give feedback then that is always welcome by commenting on this blog or by emailing paul <dot> smith [at] episerver {dot} com.

Aug 18, 2010

Comments

Nov 18, 2011 01:11 PM

This just saved me some time. Thanks a lot.

Jonathan Roberts
Jonathan Roberts Jan 18, 2013 11:24 AM

Is it possible to override functions in the CMS to alter the Composer XForm Data search page. I have encrypted the data going into the Database but cant find away to decrypt the data when exporting to XML and Excel etc.

Jonathan Roberts
Jonathan Roberts Dec 4, 2013 11:58 AM

Does any one ever reply to posts on this forum?

Please login to comment.
Latest blogs
Plug-in manager is back in CMS 12

Plug-in manager is back in the UI, what is it and how can i use it?

Luc Gosso (MVP) | Oct 6, 2022 | Syndicated blog

Display Child Pages in Content Delivery API Response

The below example will implement an instance of IContentConverterProvider to customise the serialisation of PageData and output child pages in the...

Minesh Shah (Netcel) | Oct 4, 2022

Bring the Report Center back in Optimizely CMS 12

The Report Center has been a part of Optimizely CMS since its first debut in version 5R2 in 2008, but in CMS 12, it's removed! Don't despair! Make...

Tomas Hensrud Gulla | Oct 4, 2022 | Syndicated blog

Customizing Property Lists in Optimizely CMS

Generic property lists is a cool editorial feature that has gained a lot of popularity - in spite of still being unsupported (officially). But if y...

Allan Thraen | Oct 2, 2022 | Syndicated blog

Optimizely names Luminary Senior Developer, Ynze Nunnink, OMVP

Luminary Senior Developer and Optimizely Lead, Ynze Nunnink has secured the coveted position of Optimizely MVP. Earning a Platinum badge for his...

Ynze | Oct 2, 2022 | Syndicated blog

Content Delivery API – The Case of the Duplicate API Refresh Token

Creating a custom refresh provider to resolve the issues with duplicate tokens in the DXC The post Content Delivery API – The Case of the Duplicate...

David Lewis | Sep 29, 2022 | Syndicated blog