Transcript SESSION CODE: COS-OFC307 Ben Walters BPOS TSP Microsoft Australia Elaine van Bergen Architect OBS EXPLORING THE OFFICE DEVELOPER STORY IN MICROSOFT OFFICE 365 (c) 2011 Microsoft.

SESSION CODE: COS-OFC307
Ben Walters
BPOS TSP
Microsoft Australia
Elaine van Bergen
Architect
OBS
EXPLORING THE OFFICE
DEVELOPER STORY IN MICROSOFT
OFFICE 365
(c) 2011 Microsoft. All rights reserved.
Agenda
► SharePoint Online Branding/Site Templates
► Business Process Automation
► Office Client Integration
► Exchange Integration
► Dashboards/Data visualisation
(c) 2011 Microsoft. All rights reserved.
Key Takeaways
► Office 365 has many extensibility points that developers
can leverage to build solutions
► Start with simple customisations until the platform
evolves
► Many solutions will leverage multiple parts of Office 365
► A large number of solutions will involved hybrid
elements.
(c) 2011 Microsoft. All rights reserved.
BRANDING/ TEMPLATES
(c) 2011 Microsoft. All rights reserved.
Branding Options
► Site Logo/Theme
► Custom CSS
► Custom MasterPage
► Custom Page Layouts and webparts
► Silverlight and Javascript
(c) 2011 Microsoft. All rights reserved.
Branding Limitation
► Sandboxed Solutions
► No access to Layouts or other file system folders
► Style assets deployed to Site Collection or Site
Libraries
► Custom Master Pages cannot have code-behind
(c) 2011 Microsoft. All rights reserved.
Branding Deployment
► Manually edit in SPD
► Package in sandboxed features for multiple site
collections or sites
► Consider web templates for complex sub sites
(c) 2011 Microsoft. All rights reserved.
TEMPLATES DEMO
(c) 2011 Microsoft. All rights reserved.
Branding Summary
► No site collection templates possible
► Use features for site collection or manual edit
► Use features or web templates for sub site
customisation
(c) 2011 Microsoft. All rights reserved.
BUSINESS PROCESS
AUTOMATION
(c) 2011 Microsoft. All rights reserved.
Starting a Business Process
► InfoPath online form
► Adding /Editing list item
► Adding /Editing document
► InfoPath client or on premise application via web
service
(c) 2011 Microsoft. All rights reserved.
Workflow in SharePoint Online
► SharePoint Online supports declarative
workflows
► Prototyping in Visio 2010
► Implement in SharePoint Designer 2010
► Extend with Visual Studio 2010
(c) 2011 Microsoft. All rights reserved.
New to Workflow in SP2010
► New Workflow targets
– Reusable Workflows can be applied to any list
– Site Workflows can execute on site
► New Workflow events
– Emitted by SharePoint Online (i.e. WorkflowStarted)
– Custom Events, Event Receivers
(c) 2011 Microsoft. All rights reserved.
Prototyping in Visio 2010
► SharePoint specific Workflow template
– Design in Visio using SharePoint shapes
– Provides workflow Visualization
Export to SharePoint Designer 2010
► Visio exports to a VWI file
– Renamed zip file containing all workflow files
– .xoml and .xoml.rules define workflow
– .vdx file contains Visio drawing
FORMS/WORKFLOW DEMO
(c) 2011 Microsoft. All rights reserved.
Business process summary
► Multiple methods in 365 to start process,
including off premise call
► Workflow can only be declarative
► External services can only be called from the
client
(c) 2011 Microsoft. All rights reserved.
EXCHANGE INTEGRATION
(c) 2011 Microsoft. All rights reserved.
EWS MA 1.1 Overview
► Managed API for developing applications that
use Exchange Web Services
► Functional parity with EWS*
► Makes EWS calls under the covers
► Backwards compatible
– Request versioning
new ExchangeService(
ExchangeVersion.Exchange2010_SP1);
► Cloud compatible out of the box
(c) 2011 Microsoft. All rights reserved.
Autodiscover
► Don’t hardcode EWS URL in your app!
► Use Autodiscover to find most efficient Client
Access Server URL for a given mailbox
– On-Premise
• Global & distributed deployments
– Cloud based
• Office 365
• Outlook Live
• Live@EDU
(c) 2011 Microsoft. All rights reserved.
Autodiscover – Exchange Online
EWS MA client contacts
Autodiscoversevice
EWS MA client executes
callback to Validate URL
Redirection
EWS MA
Application
Autodiscover service
returns URL for EWS
bindings
EXO Office
365
EWS MA client connects to
Exchange Web Services
Firewall
Impersonation
► Application performs actions using another
user’s
– Identity
– Permissions
► Exchange ApplicationImpersonation role needs
to be granted to a user
► Service account is typically allowed to
impersonate other accounts
(c) 2011 Microsoft. All rights reserved.
OFFICE CLIENT INTEGRATION
(c) 2011 Microsoft. All rights reserved.
Equivalent Objects
Server
.NET Managed
Silverlight
ECMAScript
(Microsoft.SharePoint) (Microsoft.SharePoint.Client)
(Microsoft.SharePoint.Client.Silverligh (SP.js)
t)
SPContext
ClientContext
ClientContext
ClientContext
SPSite
Site
Site
Site
SPWeb
Web
Web
Web
SPList
List
List
List
SPListItem
ListItem
ListItem
ListItem
SPField
Field
Field
Field
Member names mostly the same from server to client
(e. g., SPWeb.QuickLaunchEnabled = Web.QuickLaunchEnabled)
Architecture/Execution
ECMAScriptControlsand Logic
Browser
ECMAScript OM
Proxy
Proxy
Managed OM
JSON Response
Server
OM
XML Request
XML Request
Client.svc
Content
database
JSON Response
Managed Client
Managed Controls and Logic
SharePoint Server
Authentication
► Claims + Multiple Authentication Provides +
High security = Complicated !
► Use available samples/help
http://msdn.microsoft.com/en-us/library/hh147177.aspx
http://blogs.msdn.com/b/cjohnson/archive/2011/05/14/
part-2-headless-authentication-with-sharepoint-onlineand-the-client-side-object-model.aspx
(c) 2011 Microsoft. All rights reserved.
OFFICE/EXCHANGE DEMO
(c) 2011 Microsoft. All rights reserved.
Exchange/ Office Client Summary
► EWS MA 1.1 for exchange integration
► SharePoint Client Object Model for SharePoint
integration
► Authentication for SharePoint Online is
complicated. Use samples as starting point
(c) 2011 Microsoft. All rights reserved.
DASHBOARDS/DATA
VISUALISATION
(c) 2011 Microsoft. All rights reserved.
Excel Data Islands
► Data is trapped in Excel workbooks
– Excel Services lets us expose this information
– Users can interact and collaborate
– Excel “applications” can be exposed on web
What is Excel Services?
► Server hosting of Excel calculation engine
– Provides a web thin client for Excel workbooks
– Excel aggregates data from multiple sources
– Exposes data using Web Services, REST, and JavaScript
Browser
Excel 2010
Custom
applications
Chart Web Part
►Connect to:
– SharePoint list
– Another web part
– Excel Services data
►Link chart to data
►Customize type
►Customize appearance
Exposing Excel Content
► Content can be exposed in a variety of ways
– Publish workbook to a SharePoint site
• Entire workbook, specific sheets, specific items
– Excel Web Services
• Access the Excel data from a rich client app
– REST Services
• Embed chart data in a web page
– ECMAScript Object Model
• Build dashboards that tie together Excel workbooks
• Compelling in a sandboxed solution
• No custom server side code
Excel Web Services
► SOAP API
– http://<server>/<site>/_vti_bin/excelservice.asmx
► Add a service reference
► Program against SOAP API
– varexcelService= new ExcelService();
– excelService.OpenWorkbook( …
– excelService.GetRange( …
Excel Services REST API
► Access workbook elements via URL
► Atom feed to expose:
–
–
–
–
Charts
PivotTables
Tables
Ranges
► URL elements
– http://<ServerName>/_vti_bin/ExcelRest.aspx/<Docum
entLibrary>/<FileName>/<ResourceLocation>
– …/model/Charts('SampleChart')
DASHBOARDS DEMO
(c) 2011 Microsoft. All rights reserved.
Dashboards summary
► Multiple visualisations to display dashboards
► Excel service content can be accessed remotely
► Silverlight and JavaScript can be used to
integrate data from on premise or other
locations such as azure
(c) 2011 Microsoft. All rights reserved.
Key Takeaways
► Office 365 has many extensibility points that developers
can leverage to build solutions
► Start with simple customisations until the platform
evolves
► Many solutions will leverage multiple parts of Office 365
► A large number of solutions will involved hybrid
elements.
(c) 2011 Microsoft. All rights reserved.
More Information
► Office 365 Developer Toolkit
http://www.microsoft.com/downloads/details.aspx?FamilyID=E
731BF34-FF5C-444E-9AD8962D804B4D6A&amp;amp;displaylang=e&displaylang=en
► Visual Studio Power Tools
http://visualstudiogallery.msdn.microsoft.com/8e602a8c6714-4549-9e95-f3700344b0d9
► Office 365 sign up
http://www.telstrabusiness.com/business/portal/online/site/pr
oductsservices2/microsoftoffice365.532006
(c) 2011 Microsoft. All rights reserved.
Enrol in Microsoft Virtual Academy Today
Why Enroll, other than it being free?
The MVA helps improve your IT skill set and advance your career with a free, easy to access
training portal that allows you to learn at your own pace, focusing on Microsoft
technologies.
What Do I get for enrolment?
► Free training to make you become the Cloud-Hero in my Organization
► Help mastering your Training Path and get the recognition
► Connect with other IT Pros and discuss The Cloud
Where do I Enrol?
www.microsoftvirtualacademy.com
Then tell us what you think. [email protected]
© 2010 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.
(c) 2011 Microsoft. All rights reserved.
Resources
www.msteched.com/Australia
www.microsoft.com/australia/learning
Sessions On-Demand & Community
Microsoft Certification & Training Resources
http:// technet.microsoft.com/en-au
http://msdn.microsoft.com/en-au
Resources for IT Professionals
Resources for Developers
(c) 2011 Microsoft. All rights reserved.