book

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

by Ed Hild, Chad Wach

June 2010

Intermediate to advanced

391 pages

10h 57m

English

Apress

Read now

Unlock full access

Who This Book Is ForDownloading the CodeContacting the Authors
1.1. Overview of the Solutions Chapters1.2. Development Environment Requirements
2.1. History of SharePoint Technologies2.2. SharePoint 2010 Overview2.2.1. Sites2.2.2. Communities2.2.3. Content2.2.4. Search2.2.5. Insights2.2.6. Composites2.3. Leveraging the Platform
3.1. SharePoint for the Professional Developer3.1.1. A Brief History of SharePoint Development3.1.2. What's New in SharePoint for Developers3.1.3. What's New in Visual Studio for SharePoint3.2. Building Your First Project3.2.1. Creating the HelloWorld Project3.2.2. Exploring the HelloWorld Project3.2.3. Creating the HelloWorldFeature Feature3.2.4. Deploying the HelloWorld Project3.3. Further Reading
4.1. History of Microsoft Office Development4.2. Why Developers Should Care About Office4.3. Development Opportunities with Office4.3.1. The Open XML File Format4.3.2. The Open XML Format SDK4.3.3. Moving Toward Managed Code4.3.4. Visual Studio Tools for Office4.4. Developing with VSTO4.4.1. Add-Ins4.4.2. Ribbon Customization4.4.3. Custom Panes4.4.4. Outlook Form Regions4.4.5. Document-Level Projects4.5. The 2010 Enhancements4.6. Deployment Guidelines4.7. Further Reading
5.1. Real-World Examples5.2. Solution Overview5.3. Solution Walkthrough5.3.1. Introducing the Spreadsheet5.3.2. Storage for Our Solution Files5.3.3. Supporting Business Process5.3.3.1. Create the Form5.3.3.2. Add Lookups5.3.3.3. Submitting the New Event5.3.3.4. Deploying Our Form5.3.4. Providing Insight5.3.4.1. Viewing the Spreadsheet5.3.4.2. Adding Comments5.3.4.3. Creating the Chart Browser5.4. Important Lessons5.5. Extension Points5.6. Further Reading
6.1. Real-World Examples6.2. Solution Overview6.3. Solution Walkthrough6.3.1. Creating Content Types6.3.2. Building the Customer Documents Feature Project6.3.3. Defining the Feature6.3.4. Deploying the Feature6.3.5. Building a Custom Application Page6.3.6. Using a Custom XML Part in a Document Template6.3.7. Performing the Merge6.4. Important Lessons6.5. Extension Points6.6. Further Reading

7.1. Real-World Examples7.2. Solution Overview7.3. Solution Walkthrough7.3.1. Setting up the SharePoint Site and Document ID Service7.3.2. Preparing the Document Template7.3.3. Creating the Visual Studio Tools for Office Solution7.3.4. The Document Actions Pane7.3.5. Extending Backstage7.3.6. Deploying the Proposal Template Tool7.3.7. Using SPMetal7.3.8. The Proposal Document Event Handler7.3.9. The Résumé Tasks Event Handler7.3.10. Incorporating Word Automation Services7.4. Important Lessons7.5. Extension Points7.6. Further Reading
8.1. Real-World Examples8.2. Solution Overview8.3. Solution Walkthrough8.3.1. Creating the Project8.3.2. Customizing the Ribbon8.3.3. Architecture of the Task Pane and Wizard Step User Controls8.3.4. The step1 User Control: Examining the Site8.3.5. The step2 User Control: Building Objectives8.3.6. The step3 User Control: Building Agenda Items8.3.7. The step4 User Control: Integration with Slide Libraries8.4. Important Lessons8.5. Extension Points8.6. Further Reading
9.1. Real-World Examples9.2. Solution Overview9.3. Solution Walkthrough9.3.1. Setting Up the Team Site and Content9.3.2. Creating the Presentation Template9.3.3. Creating the Project and Defining the SharePoint Feature9.3.4. Adding the Visual Web Part9.3.5. Building the Web Part User Interface9.3.6. Overview of Office XML Formats, SDK Tool, and PresentationML9.3.7. The SPMetal Tool9.3.8. Iterating through the Template9.3.9. Building the Title Slide9.3.10. Building the Slide for Hardware Issues9.3.11. Building the Slide for Software Issues9.3.12. Deploying and Debugging the Web Part9.4. Important Lessons9.5. Extension Points9.6. Further Reading
10.1. Real-World Examples10.2. Solution Overview10.3. Solution Walkthrough10.3.1. The Sample LOB Database10.3.2. Creating the External Content Type with SharePoint Designer10.3.3. Connecting the External List to Outlook10.3.4. Visualizing Customer Order Data using Excel10.3.5. Extending the Outlook Contact Form10.4. Important Lessons10.5. Extension Points10.6. Further Reading
11.1. Real-World Examples11.2. Solution Overview11.3. Solution Walkthrough11.3.1. Proposing the Workflow Using Visio11.3.2. Building the Custom Workflow Activity11.3.3. Deploying the Activity through a SharePoint Feature11.3.4. Preparing the SharePoint Site11.3.5. Building the Workflow with SharePoint Designer11.3.6. Exporting the Updated Visio Diagram11.3.7. Testing the Solution11.4. Important Lessons11.5. Extension Points11.6. Further Reading
12.1. Real-World Examples12.2. Solution Overview12.3. Solution Walkthrough12.3.1. Create the Asset Tracking System Database12.3.1.1. Create a Web Database12.3.1.2. Add Some Forms12.3.1.3. What about the Code?12.3.1.4. Reporting is Key12.3.1.5. Publishing Our Asset Tracking System to SharePoint Using Access Services12.3.2. Now What?12.4. Important Lessons12.5. Extension Points12.6. Further Reading
13.1. Real-World Examples13.2. Solution Overview13.3. Solution Walkthrough13.3.1. Creating the Floor Plan13.3.2. Setting up the Data13.3.3. Linking Data to our Shapes13.3.4. Giving Our Floor Plan Life13.3.5. Sharing Your Floor Plan13.3.6. Adding More Interactivity13.3.6.1. Setting up the Project13.3.6.2. Writing Some Code13.3.6.3. Adding an Overlay13.3.6.4. Adding a UI13.3.6.5. Responding to Clicks13.3.7. The Home Stretch13.4. Important Lessons13.5. Extension Points13.6. Further Reading
14.1. Real-World Examples14.2. Solution Overview14.3. Solution Walkthrough14.3.1. Getting the Bing Maps Silverlight SDK14.3.2. Create the Silverlight Mashup Application14.3.3. Retrieve and Parse the Geocoded RSS Feed14.3.4. Retrieve and Parse the KML file14.3.5. Add the SharePoint List to the Mashup14.3.6. Deploy the Mashup as a Sandboxed Solution14.3.7. Create a Geocoded Contacts List Feature14.3.8. Setting up the SharePoint Site14.4. Important Lessons14.5. Extension Points14.6. Further Reading
15.1. Viewing SharePoint as a Set of Services15.2. A Real-World Example15.3. A Thank-You

Content preview from Pro SharePoint 2010 Solution Development: Combining .NET, SharePoint, and Office 2010

Chapter 5. Beyond the Spreadsheet

Just about everyone we speak with uses Microsoft Excel in one fashion or another. Information workers have become accustomed to modeling business calculations, analyzing information, or tracking data with spreadsheets and, typically, these spreadsheets are shared and distributed throughout the organization using e-mail, file shares, or, ideally, using SharePoint and Excel Services. SharePoint 2007 introduced Excel Services to overcome many of the challenges organizations face when building critical business processes around a spreadsheet, such as supplying a single source of the truth; saving bandwidth and processing resources by keeping much of the work on the server; and overcoming security issues by hiding ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Start your free trial

Microsoft SharePoint 2010: Building Solutions for SharePoint 2010

Publisher Resources

ISBN: 9781430227816Purchase book

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

by Ed Hild, Chad Wach

Chapter 5. Beyond the Spreadsheet

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

You might also like

Microsoft SharePoint 2010: Building Solutions for SharePoint 2010

Pro SharePoint 2007 Development Techniques

Pro SharePoint 2013 Business Intelligence Solutions

Beginning SharePoint 2013 Development

Publisher Resources

Chapter 5. Beyond the Spreadsheet

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,and much more.

You might also like

Microsoft SharePoint 2010: Building Solutions for SharePoint 2010

Pro SharePoint 2007 Development Techniques

Pro SharePoint 2013 Business Intelligence Solutions

Beginning SharePoint 2013 Development

Publisher Resources

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.