0%

Book Description

This book takes a practical problem-solution approach to common business challenges. You'll not only encounter interesting code samples, but also see how to combine these examples with the Microsoft collaboration platform's services. The book's solutions focus on using Visual Studio 2008 and its built-in Office development tools to construct the user interface layer. And solutions can interact with SharePoint as a service provider, taking advantage of SharePoint's many collaboration features like document repositories, collaboration sites, and search functions.

This book is unique because it starts with challenges that end users deal with every day when using the Microsoft collaboration platform to support business processes. The solutions are presented as hypothetical business challenges of a fictional company. By presenting the examples in this context, author Ed Hild makes it easier to relate to the challenges and solution value. The goal of these examples is to build applications that apply the benefits of the Office desktop interface to the richness of SharePoint collaboration features. This book will help you develop real-world solutions to complex business problems and challenges.

Table of Contents

  1. Copyright
  2. About the Authors
  3. About the Technical Reviewer
  4. Introduction
    1. Who This Book Is For
    2. Downloading the Code
    3. Contacting the Authors
  5. 1. Office Business Applications
    1. 1.1. Overview of the Solutions Chapters
    2. 1.2. Development Environment Requirements
  6. 2. SharePoint 2010: Overview and New Features
    1. 2.1. History of SharePoint Technologies
    2. 2.2. SharePoint 2010 Overview
      1. 2.2.1. Sites
      2. 2.2.2. Communities
      3. 2.2.3. Content
      4. 2.2.4. Search
      5. 2.2.5. Insights
      6. 2.2.6. Composites
    3. 2.3. Leveraging the Platform
  7. 3. SharePoint Development with Visual Studio 2010
    1. 3.1. SharePoint for the Professional Developer
      1. 3.1.1. A Brief History of SharePoint Development
      2. 3.1.2. What's New in SharePoint for Developers
      3. 3.1.3. What's New in Visual Studio for SharePoint
    2. 3.2. Building Your First Project
      1. 3.2.1. Creating the HelloWorld Project
      2. 3.2.2. Exploring the HelloWorld Project
      3. 3.2.3. Creating the HelloWorldFeature Feature
      4. 3.2.4. Deploying the HelloWorld Project
    3. 3.3. Further Reading
  8. 4. Microsoft Office Overview for Developers
    1. 4.1. History of Microsoft Office Development
    2. 4.2. Why Developers Should Care About Office
    3. 4.3. Development Opportunities with Office
      1. 4.3.1. The Open XML File Format
      2. 4.3.2. The Open XML Format SDK
      3. 4.3.3. Moving Toward Managed Code
      4. 4.3.4. Visual Studio Tools for Office
    4. 4.4. Developing with VSTO
      1. 4.4.1. Add-Ins
      2. 4.4.2. Ribbon Customization
      3. 4.4.3. Custom Panes
      4. 4.4.4. Outlook Form Regions
      5. 4.4.5. Document-Level Projects
    5. 4.5. The 2010 Enhancements
    6. 4.6. Deployment Guidelines
    7. 4.7. Further Reading
  9. 5. Beyond the Spreadsheet
    1. 5.1. Real-World Examples
    2. 5.2. Solution Overview
    3. 5.3. Solution Walkthrough
      1. 5.3.1. Introducing the Spreadsheet
      2. 5.3.2. Storage for Our Solution Files
      3. 5.3.3. Supporting Business Process
        1. 5.3.3.1. Create the Form
        2. 5.3.3.2. Add Lookups
        3. 5.3.3.3. Submitting the New Event
        4. 5.3.3.4. Deploying Our Form
      4. 5.3.4. Providing Insight
        1. 5.3.4.1. Viewing the Spreadsheet
        2. 5.3.4.2. Adding Comments
        3. 5.3.4.3. Creating the Chart Browser
    4. 5.4. Important Lessons
    5. 5.5. Extension Points
    6. 5.6. Further Reading
  10. 6. Merging SharePoint List Datainto Word Documents
    1. 6.1. Real-World Examples
    2. 6.2. Solution Overview
    3. 6.3. Solution Walkthrough
      1. 6.3.1. Creating Content Types
      2. 6.3.2. Building the Customer Documents Feature Project
      3. 6.3.3. Defining the Feature
      4. 6.3.4. Deploying the Feature
      5. 6.3.5. Building a Custom Application Page
      6. 6.3.6. Using a Custom XML Part in a Document Template
      7. 6.3.7. Performing the Merge
    4. 6.4. Important Lessons
    5. 6.5. Extension Points
    6. 6.6. Further Reading
  11. 7. Automating Document Assembly
    1. 7.1. Real-World Examples
    2. 7.2. Solution Overview
    3. 7.3. Solution Walkthrough
      1. 7.3.1. Setting up the SharePoint Site and Document ID Service
      2. 7.3.2. Preparing the Document Template
      3. 7.3.3. Creating the Visual Studio Tools for Office Solution
      4. 7.3.4. The Document Actions Pane
      5. 7.3.5. Extending Backstage
      6. 7.3.6. Deploying the Proposal Template Tool
      7. 7.3.7. Using SPMetal
      8. 7.3.8. The Proposal Document Event Handler
      9. 7.3.9. The Résumé Tasks Event Handler
      10. 7.3.10. Incorporating Word Automation Services
    4. 7.4. Important Lessons
    5. 7.5. Extension Points
    6. 7.6. Further Reading
  12. 8. Extending PowerPoint to Build a Presentation Based on Site Content
    1. 8.1. Real-World Examples
    2. 8.2. Solution Overview
    3. 8.3. Solution Walkthrough
      1. 8.3.1. Creating the Project
      2. 8.3.2. Customizing the Ribbon
      3. 8.3.3. Architecture of the Task Pane and Wizard Step User Controls
      4. 8.3.4. The step1 User Control: Examining the Site
      5. 8.3.5. The step2 User Control: Building Objectives
      6. 8.3.6. The step3 User Control: Building Agenda Items
      7. 8.3.7. The step4 User Control: Integration with Slide Libraries
    4. 8.4. Important Lessons
    5. 8.5. Extension Points
    6. 8.6. Further Reading
  13. 9. Building a Presentation Server-Side within a Web Part
    1. 9.1. Real-World Examples
    2. 9.2. Solution Overview
    3. 9.3. Solution Walkthrough
      1. 9.3.1. Setting Up the Team Site and Content
      2. 9.3.2. Creating the Presentation Template
      3. 9.3.3. Creating the Project and Defining the SharePoint Feature
      4. 9.3.4. Adding the Visual Web Part
      5. 9.3.5. Building the Web Part User Interface
      6. 9.3.6. Overview of Office XML Formats, SDK Tool, and PresentationML
      7. 9.3.7. The SPMetal Tool
      8. 9.3.8. Iterating through the Template
      9. 9.3.9. Building the Title Slide
      10. 9.3.10. Building the Slide for Hardware Issues
      11. 9.3.11. Building the Slide for Software Issues
      12. 9.3.12. Deploying and Debugging the Web Part
    4. 9.4. Important Lessons
    5. 9.5. Extension Points
    6. 9.6. Further Reading
  14. 10. Surfacing Line-of-Business Data in Outlook
    1. 10.1. Real-World Examples
    2. 10.2. Solution Overview
    3. 10.3. Solution Walkthrough
      1. 10.3.1. The Sample LOB Database
      2. 10.3.2. Creating the External Content Type with SharePoint Designer
      3. 10.3.3. Connecting the External List to Outlook
      4. 10.3.4. Visualizing Customer Order Data using Excel
      5. 10.3.5. Extending the Outlook Contact Form
    4. 10.4. Important Lessons
    5. 10.5. Extension Points
    6. 10.6. Further Reading
  15. 11. Site Provisioning Workflows
    1. 11.1. Real-World Examples
    2. 11.2. Solution Overview
    3. 11.3. Solution Walkthrough
      1. 11.3.1. Proposing the Workflow Using Visio
      2. 11.3.2. Building the Custom Workflow Activity
      3. 11.3.3. Deploying the Activity through a SharePoint Feature
      4. 11.3.4. Preparing the SharePoint Site
      5. 11.3.5. Building the Workflow with SharePoint Designer
      6. 11.3.6. Exporting the Updated Visio Diagram
      7. 11.3.7. Testing the Solution
    4. 11.4. Important Lessons
    5. 11.5. Extension Points
    6. 11.6. Further Reading
  16. 12. Rapid SharePoint Application Development Using Access
    1. 12.1. Real-World Examples
    2. 12.2. Solution Overview
    3. 12.3. Solution Walkthrough
      1. 12.3.1. Create the Asset Tracking System Database
        1. 12.3.1.1. Create a Web Database
        2. 12.3.1.2. Add Some Forms
        3. 12.3.1.3. What about the Code?
        4. 12.3.1.4. Reporting is Key
        5. 12.3.1.5. Publishing Our Asset Tracking System to SharePoint Using Access Services
      2. 12.3.2. Now What?
    4. 12.4. Important Lessons
    5. 12.5. Extension Points
    6. 12.6. Further Reading
  17. 13. Using Visio Services to Visualize Data
    1. 13.1. Real-World Examples
    2. 13.2. Solution Overview
    3. 13.3. Solution Walkthrough
      1. 13.3.1. Creating the Floor Plan
      2. 13.3.2. Setting up the Data
      3. 13.3.3. Linking Data to our Shapes
      4. 13.3.4. Giving Our Floor Plan Life
      5. 13.3.5. Sharing Your Floor Plan
      6. 13.3.6. Adding More Interactivity
        1. 13.3.6.1. Setting up the Project
        2. 13.3.6.2. Writing Some Code
        3. 13.3.6.3. Adding an Overlay
        4. 13.3.6.4. Adding a UI
        5. 13.3.6.5. Responding to Clicks
      7. 13.3.7. The Home Stretch
    4. 13.4. Important Lessons
    5. 13.5. Extension Points
    6. 13.6. Further Reading
  18. 14. Building Mashups
    1. 14.1. Real-World Examples
    2. 14.2. Solution Overview
    3. 14.3. Solution Walkthrough
      1. 14.3.1. Getting the Bing Maps Silverlight SDK
      2. 14.3.2. Create the Silverlight Mashup Application
      3. 14.3.3. Retrieve and Parse the Geocoded RSS Feed
      4. 14.3.4. Retrieve and Parse the KML file
      5. 14.3.5. Add the SharePoint List to the Mashup
      6. 14.3.6. Deploy the Mashup as a Sandboxed Solution
      7. 14.3.7. Create a Geocoded Contacts List Feature
      8. 14.3.8. Setting up the SharePoint Site
    4. 14.4. Important Lessons
    5. 14.5. Extension Points
    6. 14.6. Further Reading
  19. 15. Realizing the Vision
    1. 15.1. Viewing SharePoint as a Set of Services
    2. 15.2. A Real-World Example
    3. 15.3. A Thank-You
3.141.30.162