Advertisement

Quick Steps to displaying data using PivotViewer and Silverlight

Last week or so the PivotViewer control was released, which is from the Microsoft LiveLabs team.  It’s a Silverlight control that enables you to visualize data information in a DeepZoom type experience.  Be sure to check out the PivotViewer learning section for some initial information if you haven’t seen any demonstrations.

I received an email a few days back hoping for a more quick “how to” on using this control.  After all, it is a control for Silverlight and requires some implementation.  Honestly, I hadn’t even used it myself until I got that note.  I thought I’d jot down my notes in creating and consuming the simplest form of data and display using PivotViewer.  I say “simple” because you can get much more complex, but I wanted to simply show the quick steps.

Understand first that Pivot collections are a combinations of imagery and metadata that describe that imagery.  If you’ve ever seen the Hard Rock Memorabilia site that was done in early Silverlight days, this is the similar concept.

Step 1 – Get PivotViewer

The first thing you need to do is get the bits.  I’m going to assume you already have Visual Studio 2010 and Silverlight 4 Tools installed.  You can get the PivotViewer SDK at the PivotViewer learning section of the Silverlight community site.  Once you run the installer, the SDK will be installed to %ProgramFiles%\Microsoft SDKs\Silverlight\v4.0\PivotViewer\<RELEASE>.  There is a sample folder with source for an implementation as well if you want to look at it, but it has custom actions and things that you may not need.  My steps below are the “PivotViewer 101” steps to get a simple collection.  The sample provides more sample code to do other things with PivotViewer.

Step 2 – Get Pivot collection building tools

In order to use the control, you must have a Pivot collection source.  This is a specific data format in XML that the PivotViewer (and Pivot full client) use to understand the data.  The XML schema is documented here: PivotViewer Collection XML Schema.  As you can see it is fairly simple.  You could certainly build this by hand, but why would you when there are a few tools to help you!

There are 3 primary methods to create collection sources the way I see it: command-line, code library, and Excel.  The first two are most likely what any dynamic collection source will want to use.  These would be code-based approaches to looking at various types of data sources, appending metadata, and creating dynamically created collection sources or JIT-created ones as well.

The latter, using Excel, is the simplest.  The LiveLabs team created an Excel add-in to create the collection data using a familiar interface without having to really wrestle with the collection schema.  Once installed you have a new tab in Excel:

Excel PivotViewer collection tool

When you click the New Collection button on this tab, you’ll get a simple spreadsheet to start building your collection source.

Step 3 – Begin to build your collection data

For my sample, I’m going to use Bing’s wallpaper images from their last “Bing’s Best” Windows 7 themes.  Having my Excel sheet opened and already clicking on the New Collection function, I can now use the Import Images function to do this in bulk.  Now I don’t have to do this.  In fact, I can do one-by-one using the Choose Image function and select individual items.

I then wanted to provide a category column to enable my user to filter based on categories.  I used the Insert Column feature and gave it the title of Category.  These columns translate to Facets and if you see the schema definition diagram you will see that those visually translate to filters in the control.

Building collection data

Add your data until you are satisfied that you have all your data and metadata represented in this spreadsheet.  I only added one column but you could add more.  I am now complete and can choose to Publish my collection.

The result of the Publish function is that it will produce a file (CXML) and a folder of your DeepZoom-sliced images.  Remember this location of your data.

Step 4 – Build a Silverlight application implementing PivotViewer

Assuming you have the SDK installed, start a new Silverlight project in Visual Studio.  After that here were my simple steps:

Add reference to System.Windows.Pivot – add a reference to this assembly as this is where the PivotViewer control resides.

In my MainPage.xaml I then add an XMLNS declaration for the namespace and implement the control:

   1: <UserControl x:Class="SilverlightApplication164.MainPage"
   2:     xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
   3:     xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
   4:     xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
   5:     xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
   6:              xmlns:pivot="clr-namespace:System.Windows.Pivot;assembly=System.Windows.Pivot"
   7:     mc:Ignorable="d"
   8:     d:DesignHeight="300" d:DesignWidth="400">
   9:  
  10:     <Grid x:Name="LayoutRoot" Background="White">
  11:         <pivot:PivotViewer x:Name="MainPivotViewer" />
  12:     </Grid>
  13: </UserControl>

That’s it for my simple scenario on the UI front.  I’m taking the approach that my app *is* the entire PivotViewer experience.

The next thing I wanted to do was make my simple viewer dynamic.  I wanted this same XAP to be used for any collection.  In my MainPage.xaml.cs code in the Loaded event I use the PivotViewer API and call the LoadCollection function:

   1: public MainPage()
   2: {
   3:     InitializeComponent();
   4:     Loaded += new RoutedEventHandler(MainPage_Loaded);
   5: }
   6:  
   7: void MainPage_Loaded(object sender, RoutedEventArgs e)
   8: {
   9:     string collection = App.Current.Host.InitParams["collection"].ToString();
  10:  
  11:     MainPivotViewer.LoadCollection(collection, string.Empty);
  12: }

You’ll notice that I’m getting a value from Silverlight’s InitParams model.  This enables me to send in the URL of the collection dynamically in my HTML hosting page:

   1: <object data="data:application/x-silverlight-2," type="application/x-silverlight-2" width="100%" height="100%">
   2:   <param name="source" value="ClientBin/SilverlightApplication164.xap"/>
   3:   <param name="onError" value="onSilverlightError" />
   4:   <param name="background" value="white" />
   5:   <param name="minRuntimeVersion" value="4.0.50424.0" />
   6:   <param name="autoUpgrade" value="true" />
   7:   <param name="initParams" value="collection=URL_TO_CXML" />
   8:   <a href="http://go.microsoft.com/fwlink/?LinkID=149156&v=4.0.50424.0" style="text-decoration:none">
   9:        <img src="http://go.microsoft.com/fwlink/?LinkId=161376" alt="Get Microsoft Silverlight" style="border-style:none"/>
  10:   </a>
  11: </object>

So I can re-use this XAP in many places and just change the initParams value in the <object> tag.  I build the XAP and now I can place it anywhere.

Step 5- Publish the result

The final step is to publish everything.  Remember the CXML file and the folder of images?  They need to reside somewhere.  Here are two critical things to note:

  • If they (collection CXML file and images) are not residing in the same location as the XAP implementing the PivotViewer control, it must have cross-domain policies (clientaccesspolicy.xml) in place persuant to the rules of Silverlight and cross-domain.  Otherwise it won’t work.  PivotViewer makes network requests and this policy is required by Silverlight in cross-domain situations.
  • You may need to add a MIME type mapping on your server in order to serve the CXML file.  I did (on Windows 2003).  I simply added a MIME type mapping for .cxml and gave it the content type of text/xml and it worked.

Once I have all that published, I can deploy my HTML page hosting the XAP and pointing to my collection source.  As an example, here is my final result for this: Bing’s Best Pivot Collection.  Notice how the Category column now shows as a filter source on the left.  Had I made more columns, there would be more filter options.  I also could have made more metadata and populated the HREF attribute of the data to actually link to something.

The cool thing as well is that any collection that works with the Pivot schema works.  You can find some samples at the GetPivot Developer site:

Using the project the way I created it, I can just input these URLs in my initParams to change the collection I want it to view.  I was also able to use the Microsoft Organization Pivot Collection that LiveSide created directly in this without modification as well: MSFT Organization Pivot in Silverlight.

Summary

After spending a few minutes with the control, the simplest display scenario is very simple.  In fact, creating the collection source I think will be the most challenging…to determine what is the appropriate metadata that you need and want to display to your users to interact with in your application.

You can download my sample project here: PivotViewerSimpleSample.zip

Hope this helps!


This work is licensed under a Creative Commons Attribution By license.

  1. Gravatar
    7/10/2010 7:01 PM | # re: Quick Steps to displaying data using PivotViewer and Silverlight
    Tim,
    The PivotViewer is cool.

    Not sure if this is the right place to ask this, but I am perplexed by this issue (could be a bug in Silverlight). I was trying to databind the IsEnabled property of a Silverlight TextBox using the following:

    <TextBox IsEnabled="{Binding Path=SomeDateProperty.HasValue}" Text="{Binding SomeDateProperty, Mode=TwoWay}" x:Name="DateTextBox" />

    where SomeDateProperty is a property of type "DateTime?"

    Any ideas as to why the TextBox does not get disabled using Databinding in Silverlight if SomeDateProperty.HasValue is false? If the same thing is done in code-behind as follows then it works!

    DateTextBox.IsEnabled = MyObject.SomeDateProperty.HasValue;
  2. Gravatar
    7/10/2010 7:39 PM | # re: Quick Steps to displaying data using PivotViewer and Silverlight
    If it helps - and just to clarify - "MyObject" has INotifyPropertyChanged implemented and all the usual stuff for databinding is taken care of.
  3. 7/11/2010 3:24 PM | # re: Quick Steps to displaying data using PivotViewer and Silverlight
    Great! I've been waiting on this control for weeks. Thanks for the update.

    I have not had time to play around with the new SL Pivot control and not sure if announced during this release, but I wanted to know if there are any new tools on how to create collections ( both data and images )?

    The Excel tool is nice, but seems there are better ways to do this programmatically for nightly collection builds and publishing to server. Also, some of the Pivot guys from videos and Mix session mentioned there was a Photo Shop tool ( tab delimited file ) to create the images. I hope they are going to release a better tool to integrate within Expression suite and/or DeepZoom Composer. I don't have Adobe tools and don't plan on it, so all my collection images are blank until then:(

    Thanks again. Can't wait to use control and read Jesse's tutorials.
  4. 7/12/2010 8:40 AM | # re: Quick Steps to displaying data using PivotViewer and Silverlight
    I have issues with opening your sample page for the Bing best. You have a minruntimeversion set with a build of 50424 - did you mean to put 50524?

    Your sample page sends me to the autoupdate page where I am assured that I have the latest version:
    The version of Silverlight installed is:
    Silverlight 4 (4.0.50524.0)

    I've cleaned my temp folder several times, but I can't access your sample page. Any ideas?
  5. 7/12/2010 9:58 AM | # re: Quick Steps to displaying data using PivotViewer and Silverlight
    Nice, definetely going to create some samples using this new tool.
  6. 7/12/2010 11:14 AM | # re: Quick Steps to displaying data using PivotViewer and Silverlight
    shaggygi - actually there is links I put up there to the SDK talking about how you would do dynamic collections programmatically, etc.

    ShawnF - thanks for pointing out my bug...fixing now!
  7. 7/12/2010 12:23 PM | # re: Quick Steps to displaying data using PivotViewer and Silverlight
    ShawnF - Version 50524 is higher than 50424. Shouldn't it run anyway?
    Or didn't I get the meaning of "MinRuntimeVersion" ?
  8. 7/12/2010 3:14 PM | # re: Quick Steps to displaying data using PivotViewer and Silverlight
    I'm sorry I didn't elaborate - I have the higher version and I don't think that there was a version 50424 anyway. I posted because I keep getting sent to the Autoupdate page.
    It's likely just something weird with my connection at work, but since I'm new at this I thought I would ask.
  9. 7/12/2010 7:32 PM | # re: Quick Steps to displaying data using PivotViewer and Silverlight
    I have the same problem as shawnF. I was redirected to the installation page, but my installation information is:
    The version of Silverlight installed is:
    Silverlight 4 (4.0.50524.0)
  10. Gravatar
    7/17/2010 10:40 AM | # re: Quick Steps to displaying data using PivotViewer and Silverlight
    You are giving silverlight a bad reputation with those bad implemented samples... people enter here, click on your sample and are asked to update SL, even when using the latest version.
  11. 7/17/2010 10:14 PM | # re: Quick Steps to displaying data using PivotViewer and Silverlight
    A couple things, you forgot to mention that you need the Silverlight Toolkit from codeplex http://silverlight.codeplex.com/ and the .cxml file needs an absolute URI or you'll get an error
  12. 7/17/2010 10:57 PM | # re: Quick Steps to displaying data using PivotViewer and Silverlight
    Ric - I doubt I'm giving Silverlight a bad reputation. I had thought I uploaded the right version, but just fixed it. Sorry about that. I am actually working with daily builds and neglected to remember that.

    Peter - true, this is just *my* adaptation and doesn't account for anything but an absolute URI. VERY easy to change that of course, but this was just sample code.
  13. 7/18/2010 12:36 AM | # re: Quick Steps to displaying data using PivotViewer and Silverlight
    Very nice. I never used PivotViewer before, but defiantly going to give it a try.
  14. 7/18/2010 7:26 PM | # re: Quick Steps to displaying data using PivotViewer and Silverlight
    Thanks. It works now.
  15. 7/29/2010 9:28 AM | # re: Quick Steps to displaying data using PivotViewer and Silverlight
    How would one go about having Pivot not just display an image but a rather something like a tile that displayed an image as well as some of the data being pulled in. I would love to use this within the application we are building and use it almost like a record search, but in order to do this I could not just display an image but also data. And this is data that is constantly changing so the tiles would have to be created dynamically when the pivot control is loaded.
  16. 7/29/2010 5:27 PM | # re: Quick Steps to displaying data using PivotViewer and Silverlight
    Jim - PivotViewer requires some type of image as the focal point. The meta-data can be displayed for that image like it is above when an image is selected. You could also dynamically generate PivotViewer data on the fly (look at their samples to see how to do that).
  17. 7/29/2010 9:53 PM | # re: Quick Steps to displaying data using PivotViewer and Silverlight
    Thanks for sharing this information with us.I would love to use this within the application we are building and use it almost like a record search, but in order to do this I could not just display an image but also data.What are you think about this?
  18. 7/30/2010 2:24 AM | # re: Quick Steps to displaying data using PivotViewer and Silverlight
    I like your article.You are giving silverlight a bad reputation with those bad implemented samples... people enter here, click on your sample & are asked to update SL, even when using the latest version.
  19. Gravatar
    8/5/2010 10:20 AM | # re: Quick Steps to displaying data using PivotViewer and Silverlight
    My question is about this line in the HTML file

    <param name="initParams" value="collection=URL_TO_CXML" />

    I want to set the URL_TO_CXML to a relative URI but I keep getting errors that it is unable to resolve the URI.

    ie set it to
    <param name="initParams" value="collection=Collection/Sample.cxml" />
    rather than my working version
    <param name="initParams" value="collection=Http://localhost/Collection/Sample.cxml" />
  20. 8/5/2010 12:27 PM | # re: Quick Steps to displaying data using PivotViewer and Silverlight
    Jef - in order to do that your XAP has to be at the same relative root level. Relative paths in Silverlight are relative *to the XAP* only. So if you move the XAP to the root (at the same place where the Collection folder is located) then your relative path should work.
  21. 8/9/2010 2:22 PM | # re: Quick Steps to displaying data using PivotViewer and Silverlight
    thanks for the article.
    Very very helpful.
  22. 8/10/2010 1:43 AM | # re: Quick Steps to displaying data using PivotViewer and Silverlight
    I hope they are going to release a better tool to integrate within Expression suite and/or DeepZoom Composer. I don't have Adobe tools and don't plan on it, so all my collection images are blank until then..
  23. 8/17/2010 10:10 AM | # re: Quick Steps to displaying data using PivotViewer and Silverlight
    Do you need Visual Studio 2010 to use the PivotViewer and Silverlight or can it be done using Visual Web Developer Express 2010?
  24. 8/17/2010 11:37 AM | # re: Quick Steps to displaying data using PivotViewer and Silverlight
    Dorothy - this should all work with VWD Express -- but you will need the Silverlight tools (which are free and can be installed on VWD Express)

 
Please add 4 and 4 and type the answer here:
First time here? You are looking at the most recent posts. You may also want to check out older archives. Please leave a comment, ask a question and consider subscribing to the latest posts via RSS or email. Thank you for visiting! (hide this)