One of the demos I showed this week was the integration of the new SharePoint 2010 client object model (SP COM) and an external list. The SP COM is a way to work with lists where you create and execute batch commands against your SharePoint 2010 server. You can find more information here: http://channel9.msdn.com/learn/courses/SharePoint2010Developer/ClientObjectModel/ .
Read the rest here:
Reading Data from External List using the SharePoint 2010 Client Object model
Continued here:
Sneak Preview of Project Gemini
On the topic of “teasers”, one of the things we’ll be talking about in the coming weeks is project Gemini. I won’t get into the details just yet (otherwise it wouldn’t be a teaser), other than to say it’s a powerful data analysis feature, it’s an add-in to Excel (i.e. not a built-in Excel feature), and it’s the result of collaboration between the Excel and SQL teams. The BI Blog has been covering all news related to Gemini . From the BI Blog, here are a couple sneak peak videos : BI Power Hour: Sneak Preview of Gemini – part 1 Get a sneak preview of the new functionality for BI within Excel with Project Gemini. This demo shows how you can quickly analyze massive amounts of data, create connections to data, and share insights all within the familiar Excel environment
Within Microsoft, there is a web service already implemented that I can use in my solution to call the bug tracking system and get back the data described in the previous article. For my demo, I’m going to implement a demo web service that will stand in for that internal Microsoft web service. It will return the same basic data structures as the internal web service does, so when I run my own copy of VSTO bug tracker, I can swap out this demo web service for the real one. The demo web service will have three web methods. The first method is called BulkDataExport. This method takes a start date and an end date and returns back a dataset with all the bug data for that time period. This is a simplified version of the Microsoft provided web service that I use internally. That web method has more parameters to specify milestone, release, team, etc. But I will omit those for simplicity since my data is specific to my team. <WebMethod()> _ Public Function BulkDataExport( ByVal dateFrom As String , _ ByVal dateTo As String ) As System.Data.DataSet [WebMethod()] public System.Data.DataSet BulkDataExport( string dateFrom, string dateTo) The second method is called to get one particular bug stat value for one particular date. This will be used by the UDF I will write later. This takes a particular team (milestone and release I omit) as well as the name of the column I want to retrieve (e.g.
More here:
2. VSTO Bug Tracker : The Web Service
If you’re going to TechEd in Los Angeles next week, then don’t miss these four sessions: DTL03-INT Meet the Microsoft Visual Studio Team Christin Boyd, Eric Carter , Paul Yuknewicz, Jay Schmelzer, Dustin Campbell , Jonathan Aneja, Luke Hoban , Igor Zinkovsky, Faisal Nasir, Harry Pierson , Lisa Feigenbaum Mon 5/11 2:45 PM-4:00 PM | Blue Theater 1 OFC325 Building Custom Applications in Microsoft Office Outlook 2007 Ty Anderson , Damon Armstrong Tue 5/12 2:45 PM-4:00 PM | Room 408A DTL324 – Microsoft Visual Studio 2010 Overview for the Business Application Developer Jay Schmelzer Tue 5/12 4:30 PM-5:45 PM | Room 515B OFC324 Advanced Microsoft Office Word and Excel 2007 Development in Microsoft Visual Studio 2008 with Visual Studio Tools for Office Eric Carter Thursday 5/14 1:00PM-2:15PM | Room 515A Of course, there are a dozen other sessions that appeal to Office developers and SharePoint developers. These are the four that I highly recommend. Originally I was going to list the 3 not-to-be-missed sessions, but then I couldn’t drop any of these from my list, so we have 4 Must See Sessions! If you’re not going to TechEd, then please click the links on these speakers’ names to read their blogs where the will eventually post some of their demo code. Expect the posts to happen the Monday after their sessions. In the case of Eric Carter, he would probably love it if you’d buy his book, Visual Studio Tools for Office 2007: VSTO for Excel, Word and Outlook . Or you could just download a zip file with all of the of code from the book here . That should keep you busy for a while. The explanations in the book really do add to the overall value. I should credit the co-author, Eric Lippert. Both men are brilliant and funny, and very modest. At the Holiday Party this year, Eric Carter got up to sing karaoke and astounded us all with a bouncy rendition of “Sesame Street.” -Christin Boyd, Program Manager, Visual Studio
Read more:
TechEd Sessions on Office Development
This video explains how to deploy a custom form region to a user’s system. This demo shows how to publish the form region addin for deployment and install the addin to the user’s system.
Here is the original post:
How Do I: Deploy a Custom Outlook Form Region?
I just wanted to make sure that anyone into SharePoint branding knows about this. Chris Auld from Intergen shows how to construct and deploy themes to SharePoint using Microsoft Visual Studio 2008 and VSeWSS (which Intergen wrote) .
See the rest here:
Must watch Mix 09 session: State of the Art in Web Site Design on Microsoft SharePoint
I just wanted to make sure that anyone into SharePoint branding knows about this. Chris Auld from Intergen shows how to construct and deploy themes to SharePoint using Microsoft Visual Studio 2008 and VSeWSS (which Intergen wrote) .
View original post here:
Must watch Mix 09 session: State of the Art in Web Site Design on Microsoft SharePoint
This video shows how to create a “mini-OBA” that integrates Outlook with Office Small Business Accounting 2008. This demo shows how to: build an adjoining form region, work with the Small Business Accounting API, fill form region controls with Small Business Accounting data, create time slips from within Outlook and store data from Office Small Business Accounting in Outlook.
More:
How Do I: Build an Outlook Form Region to Input Time Records in Office Accounting?
This demo shows how employees at a fictitious company use a Report Center site to create and manage reports, dashboards, and key performance indicators (KPIs).
Read the original:
Office SharePoint Server 2007 Demo: Make better business decisions with reports and dashboards
This demo shows you how to create a dashboard page on a Report Center site and how to add a KPI Web Part to the dashboard page to display KPIs.
See original here:
Office SharePoint Server 2007 Demo: Display KPIs in a dashboard