O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Pro SharePoint Solution Development: Combining .NET, SharePoint, and Office 2007

Book Description

Pro SharePoint Solution Development: Combining .NET, SharePoint, and Office 2007 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 platforms services. The books solutions focus on using Visual Studio Tools for Office to build the user interface layer. And solutions can interact with SharePoint as a service provider, taking advantage of SharePoints 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 the hypothetical business challenges of a fictional company. By presenting the examples in this context, authors Ed Hild and Susie Adams make it easier to relate to the challenges and solution value. And the goal of these examples is to build applications that apply the benefits of the Office desktop interface with the richness of SharePoints collaboration features.

Table of Contents

  1. About the Authors
  2. About the Technical Reviewer
  3. Introduction
    1. Who This Book Is For
    2. Downloading the Code
    3. Contacting the Authors
  4. I. Introduction
    1. 1. Office Business Applications
      1. Part 2: Microsoft Excel Solutions
      2. Part 3: Microsoft Word Solutions
      3. Part 4: Microsoft PowerPoint Solutions
      4. Part 5: Microsoft Outlook Solutions
      5. Part 6: Microsoft InfoPath Solutions
      6. Part 7: Conclusion
      7. Development-Environment Requirements
    2. 2. SharePoint Products and Technologies: Overview and New Features
      1. History of SharePoint Technologies
      2. Windows SharePoint Services v3
        1. ASP.NET 2.0 Foundation
        2. Repository Enhancements
        3. Deployment Model Based on "Features"
        4. Site Enhancements
        5. User Interface
        6. Workflow
      3. Microsoft Office SharePoint Server 2007
        1. Portal Enhancements
        2. Search
        3. Content Management
        4. Business Process
        5. Business Intelligence
      4. Further Reading
    3. 3. Microsoft Office 2007 Overview for Developers
      1. History of Microsoft Office Development
      2. Why Developers Should Care About Office
      3. Development Opportunities with Office 2007
        1. The Open XML File Format
        2. Using Managed Code
      4. Further Reading
    4. 4. Visual Studio Tools for Office Overview
      1. History of Visual Studio Tools for Office
      2. Versions and Compatibility
      3. Developing with VSTO
        1. Add-Ins
        2. Ribbon Customization
        3. Task Panes
        4. Outlook Form Regions
        5. Document-Level Projects
      4. Further Reading
  5. II. Microsoft Excel Solutions
    1. 5. Maintaining Offline List Content from Multiple Sites
      1. Real-World Examples
      2. Solution Overview
      3. Solution Walkthrough
        1. Creating the Projects List Definition
        2. Creating the Excel Smart Document Project
        3. Designing the DataSet
        4. Detecting Internet Connectivity
        5. Constructing the Actions Pane
        6. Maintaining the List of Site Connections
        7. Constructing the Synchronization Interface
        8. Architecting the Synchronization Process
        9. Getting the Data on the Spreadsheet
        10. Using the Tool
        11. Building Visualizations in Excel
        12. Running in Excel 2007
        13. Considering Deployment Options
      4. Important Lessons
      5. Extension Points
      6. Further Reading
    2. 6. Integrating Spreadsheets into the Enterprise
      1. Real-World Examples
      2. Solution Overview
      3. Solution Walkthrough
        1. Introducing the Spreadsheet
        2. Setting Up an External Source: Products Database
        3. Setting Up an External Source: Shipping Web Service
        4. Constructing the UDF Class
        5. Deploying the UDF Class and Registering It for Use in Excel
        6. Enhancing the Spreadsheet
        7. Preparing Excel Services for the Spreadsheet
        8. Publishing to Excel Services
        9. Integrating the Spreadsheet into a Custom Application
      4. Important Lessons
      5. Extension Points
      6. Further Reading
  6. III. Microsoft Word Solutions
    1. 7. Merging SharePoint List Data into Word Documents
      1. Real-World Examples
      2. Solution Overview
      3. Solution Walkthrough
        1. Creating Content Types
        2. Building the Customer Documents Feature Project
        3. Defining the Feature
        4. Deploying the Feature
        5. Building a Custom Application Page
        6. Using a Custom XML Part in a Document Template
        7. Performing the Merge
      4. Important Lessons
      5. Extension Points
      6. Further Reading
    2. 8. Working Collaboratively with Document Fragments
      1. Real-World Examples
      2. Solution Overview
      3. Solution Walkthrough
        1. Creating the XML Schema
        2. Applying the Schema to a Document
        3. Examining the Document's XML
        4. Building the Document Section Feature Project
        5. Defining the Feature
        6. Deploying the Feature
        7. Building a Custom Application Page for Splitting
        8. Examining the Splitter Class
        9. Building a Custom Application Page for Merging
        10. Examining the SectionMerge class
      4. Important Lessons
      5. Extension Points
      6. Further Reading
  7. IV. Microsoft PowerPoint Solutions
    1. 9. Extending PowerPoint to Build a Presentation Based on Site Content
      1. Real-World Examples
      2. Solution Overview
      3. Solution Walkthrough
        1. Creating the Project
        2. Ribbon Customization
        3. Architecture of the Task Pane and Wizard Step User Controls
      4. Important Lessons
      5. Extension Points
      6. Further Reading
    2. 10. Building a Presentation Server-Side within a Web Part
      1. Real-World Examples
      2. Solution Overview
      3. Solution Walkthrough
        1. Setting Up the Team Site and Content
        2. Creating the Presentation Template
        3. Creating the Web-Part Project
        4. Basics of the DynamicPowerPoint Web Part
        5. Deploying the Web Part
        6. Debugging the Web Part
        7. Overview of Office XML Formats and PresentationML
        8. Iterating through the Template
        9. Building the Title Slide
        10. Building the Slide for Hardware Issues
        11. Building the Slide for Software Issues
      4. Important Lessons
      5. Extension Point
      6. Further Reading
  8. V. Microsoft Outlook Solutions
    1. 11. Working with Email Messages and SharePoint
      1. Real-World Examples
      2. Solution Overview
      3. Solution Walkthrough
        1. Creating the Outlook Add-in Project
        2. Building the Custom Task Pane
        3. Customizing the Ribbon Interface
        4. Managing the Task-Pane Instances
        5. Retrieving the Document Libraries
        6. Saving the Email Message
      4. Important Lessons
      5. Extension Points
      6. Further Reading
    2. 12. Surfacing Data from Line-of-Business Applications
      1. Real-World Examples
      2. Solution Overview
      3. Solution Walkthrough
        1. The Sample LOB Database
        2. Constructing the BDC Application Definition
        3. Configuring the Profile Pages
        4. Testing in a Team Site
        5. Building the Custom Web Service
        6. Deploying and Testing the Web Service
        7. Building the Outlook Form Region
        8. Deploying the Form Region
      4. Important Lessons
      5. Extension Point
      6. Further Reading
  9. VI. Microsoft InfoPath Solutions
    1. 13. Taking InfoPath Forms to the Web
      1. Real-World Examples
      2. Solution Overview
      3. Solution Walkthrough
        1. Understanding the Cross-Domain and Multi-Hop Problems
        2. Creating the InfoPath Solution
        3. Setting Up the DatabaseLoanData
        4. Creating the Web Service
        5. Connecting the Form to the Web Service
        6. Deploying the Template to Office Forms Server
        7. Debugging and Testing Managed Code in Visual Studio
        8. Integrating Security and SSO
        9. Hosting the Form in ASP.NET
      4. Web-Part Hosting
      5. Extension Points
      6. Further Reading
    2. 14. Incorporating Workflow into Forms Processing
      1. Real-World Examples
      2. Solution Overview
      3. Solution Walkthrough
        1. Understanding Workflow in SharePoint
        2. Understanding How WSS 3.0 Processes Workflow Activities
        3. Creating the LoanWF Test Environment
        4. Creating the Workflow Template
        5. Adding Error Handling
        6. Creating the Custom Task Form
        7. Deploying the Workflow
        8. Attaching the Workflow to a Forms Library
        9. Testing and Debugging the Workflow
      4. Extension Points
      5. Further Reading
  10. VII. Conclusion
    1. 15. Realizing the Vision
      1. Viewing SharePoint as a Set of Services
        1. A Real-World Example
      2. Tools to Support the Development Environment
        1. SharePoint Solution Generator
        2. Enterprise Content Management Starter Kit
        3. Windows SharePoint Services 3.0 Tools: Visual Studio Extensions
        4. Business Data Catalog Application Definition Generators
      3. Looking Ahead
      4. A Thank-You