OFC210 Microsoft Office SharePoint Designer 2007: Create and Customize SharePoint Web Sites and Build Workflow-Enabled Applications Alex Malek Program Manager Microsoft Corporation blogs.msdn.com/alexma Session Objectives Learn how Microsoft Office SharePoint Designer can be used to create applications on SharePoint servers See app-building features such as Data Views and Workflow Learn about customizing pages using CSS and ASP.net Master Pages A SharePoint Application SharePoint Applications Use SharePoint Designer to build вЂњno-codeвЂќ composite apps Ideal for tracking & reporting apps, information portals Integrate external data into SharePoint solutions Application glue using workflow Leverage platform to quickly build apps Lists and libraries to store data Read and write data with Data Views SharePoint rights/roles, presence , search, notification вЂњNo CodeвЂќ Solutions Office SharePoint Designer вЂњno codeвЂќ features mean solution creators donвЂ™t have to be developers to: Create custom list views and forms Integrate external data into SharePoint solutions Build custom workflows for adding business logic The value of вЂњno codeвЂќ applications No code = No risk Designed for Rapid Development Administrator-controlled developers extensibility points Collaborative Development Integration with Visual Studio Office SharePoint Designer + Browser Web site construction Microsoft Visual Studio Custom Coding (if necessary) Create lists and doclibs Design Web pages Web Controls and Parts No-code data view/forms ASP.NET page coding No-code workflows Workflow actions Web part hookup Event handlers Sample SharePoint Applications Current set of 30 Windows SharePoint Services (v2) app templates already has over 900,000 downloads Working on 40+ new templates for V3 Horizontal focus on common roles & tasks Range from simple single-list apps to full workflow integration and cross-site rollups Application Templates for WSS V3 The new upcoming вЂњFantastic 40вЂќ Absence Request and Vacation Schedule Basic Survey Site Board of Directors Call Center Change Request Management Classroom Management Competitive Intelligence Dashboards Compliance Process Support Site Contacts Management Document Review Employee Activities Site Employee Self Service Benefits Employee Training Materials Event Planning Expense and Reimbursement Approval Sites Help Desk Inventory Tracking Job Requisitions and Interview Management Knowledge Base and Document Management Lending Library New Product Development Team Work Site Performance Review Site Physical Asset Tracking and Management Project Tracking Site (Multiple Projects) Project Tracking Site (Single Project) Publication Review Room and Equipment Reservations Sports League Timecard Management Timesheet and Billing Building a SharePoint Application Data View Web Part вЂњвЂ¦ the Swiss Army Knife of web partsвЂќ Data Views вЂ“ Presentation Improved: WYSIWYG design experience Conditional formatting Static and Ad-hoc sort, and group New: Ajax support for filter New: XPath Expression / Formula Builder New: Code view experience XSLT intelliSense (with XPath data context) Selection syncing between design and code view New: Customizable forms to write back to data sources New: Workflow integration to add business logic Data Views вЂ“ Access to Data Improved: OOB support for: Lists, SQL, OLEDB, XML, SOAP Services, Server Scripts, RSS, Business Data Catalog (w/MOSS) New: Combine data from multiple sources into single views New: Fully extensible ASP.Net Data Source control model Adding Application Logic Using вЂњno codeвЂќ Workflow to enhance a SharePoint Application The Workflow Designer Creating application logic without code Rule-Based вЂњNo CodeвЂќ Workflows Built on Windows Workflow Foundation hosting in SharePoint Workflows are composed of pre-existing building blocks and conditional logic Based on Events, Conditions, and Actions Described by XOML files in Web site Triggered by initiation form or list events Supports rich data binding to list items Extensible via custom actions, conditions Sample Workflow Actions Assign Custom Task Send Email Create/Update/Delete List item Collect Data from User Wait for Timer Wait for Data Change Workflow Scenarios Microsoft SharePoint Designer workflows Document Processes Auto-create InfoPath form Conditional Expiration Custom Review Custom App Logic Link lists together Custom alerts Flag list items Document Approval (parallel/serial) Signature Collection Form Actions Push SQL data to a list Email notifications Simple validation Task & Issue Tracking (WSS, Access, & Project) Ad Hoc Out-of-the-Box Solutions Purchase Order Processing Structured Microsoft Visual Studio & workflow SDK LOB Integration (BizTalk) Application Customization Changing the application look and feel using CSS and Master Pages Site Customization Use custom Master Pages for application chrome Quick global changes CSS tools for customizing SharePoint styles вЂњCore.cssвЂќ automatically copied to local site New safety nets Users can restore original contents of site template pages, i.e. вЂњre-ghostвЂќ pages Versioning and Recycle Bin вЂњContributor ModeвЂќ for fine-grained restrictions Deep support for ASP.NET Summary Learned what Office SharePoint Designer is Learned about core app-building features, including data views and workflows Call to action: Visit blogs.msdn.com/alexma for more on building SharePoint Apps Deploy Microsoft Office 2007 Beta 2 Start thinking about application scenarios The 2007 Microsoft Office System Clients. Servers. Solutions. Install Beta 2 today! ItвЂ™s in your attendee bag Talk Lab Learn more at the Office System TLC Demo Stations / Hands-on-Labs / Chalk-talks Demo Get more information http://www.microsoft.com/office/preview/default.mspx http://msdn.microsoft.com/office/ Resources Technical Chats and Webcasts http://www.microsoft.com/communities/chats/default.mspx http://www.microsoft.com/usa/webcasts/default.asp Microsoft Learning and Certification http://www.microsoft.com/learning/default.mspx MSDN & TechNet http://microsoft.com/msdn http://microsoft.com/technet Virtual Labs http://www.microsoft.com/technet/traincert/virtuallab/rms.mspx Newsgroups http://communities2.microsoft.com/ communities/newsgroups/en-us/default.aspx Technical Community Sites http://www.microsoft.com/communities/default.mspx User Groups http://www.microsoft.com/communities/usergroups/default.mspx Fill out a session evaluation on CommNet for a chance to Win an XBOX 360! В© 2006 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.