VSTO Reloaded

Today the MSE team did a Tech Preview to fellow developers on Visual Studio 2008 which actually available for MSDN subscribers late last year and is available for sales now.

My session is about Visual Studio Tools for Office (VSTO) 2008 and a lot of productivity enhancements have been put inside the package in this current version. They include but not limited to:

  1. Better UI Development on Office UI
    • Form Regions in Outlook
    • Custom Task Pane
    • Custom Ribbon for Excel, Word and PowerPoint.
    • No relearn, leverage on Windows Form Development skill
    • Windows Form able to host WPF app and extends this capability via Custom Task Pane
  2. SharePoint Workflow development
    • No more manual writing of workflow.xml, feature.xml (both are SharePoint feature config files) and deployment script
    • Streamline development process from 15 steps to 3 steps in VSTO 2008
  3. Word Content Control data binding with VSTO addin
    • Bringing unstructured data from Word documents to a structured world
    • Able to attach custom XML such as RosettaNet or UNeDoc which as industry based XML schema to Word data.
  4. Easy deployment of VSTO – Office Addin via Click Once
    • No more reliant on CASPOL
    • Transparent to end users

vstodemo

I demo a cool VSTO addin for Word 2007 hosting a WPF user control with colossal effect and acting as a client to a WCF services at the back end. The data access is done using LINQ for XML. After that I will publish

It is based on an article in MSDN Dec 2007 issue but the source codes there is not working for RTM version of VS 2008. Many thanks for fellow MS staff Andrew Whitechapel for making it work for VS2008 RTM.

You can download the slides and working version of the source code here. They are hosted on Windows Live Skiydrive/ Folders.

Slides in PDF

Slides in XPS

Source Code in C#

I will come out with a tutorial for the SharePoint Workflow later and also a VB9 version of the source code. So stay tuned. :)

Oracle BI’s blog poll about .NET 2.0 installation and support for Office 2007

Oracle Business Intelligence blogger  is doing a poll on .NET 2.0 installation out there. This maybe because that the new Oracle BI Add In for MS Office 2007 requires the .NET 2.0 installation. Yes, and I think this is a fantastic OBA adoption here with Office 2007 as the front end to Oracle’s OLAP Cube than creating a new one.

And to my surprise there is a 58% YES (23/ 39) response out there.

image

Search Enable Your Application with SharePoint Search and Business Data Catalog

Search (such as those of Live Search and Google) is so ambiguous now that users would have start asking it especially if your system spans a few terabytes where searching for information is tedious. Within OBA architecture is the Search services which is powered by SharePoint Search and BDC, basically what you need to do are:

  1. Create a DBA Application Definition XML with IEnumertor and Specific Finder method instance.
  2. Define the BDC app as Content Source
  3. Setup Authentication
  4. Perform a content crawl
  5. Setup metadata properties and crawled property
  6. Create Search Scope
  7. Publish the scope to site
  8. Create a search web page

So it is that simple, more details you can get it from winsmarts website here.

Offline OLAP Cube browsing in Excel 2007

Just realize today that I can actually download the whole OLAP cube and browse with Excel 2007 when you offline. Below are the steps:

1. Access the .ODC file online

image

2. When you click Open, you will fire up Excel and the Pivot Table Field List.

image

Construct you Excel Pivot Table view. For example I put Reason on Row Labels, Calendar Year, Quarter and Month on Column Labels and Incidents Count on Values.

image

To take the cube offline, click on Options –> OLAP Tools –> Offline OLAP

image

Because you don’t have a Offline data file,  on the Offline OLAP Settings window you will see Offline OLAP option is grayed out. Create the data file by click on Create Offline Data File.

image

 You will be presented by a wizard, click Next on the first screen

image

Because a real life data warehouse is huge and you might not want every data, you can choose the level of field you want to store in the offline data file. Then click Next.

image

Then specify the item within the level and click Next.

image

 Finally specify where you want to store the data file and click Finish

image

Now you see Offline OLAP option is enabled.

image