Transcript Misc Really Useful Demos - Minnesota SharePoint User Group

Welcome to the
Minnesota SharePoint
User Group
December 12th, 2007
Miscellaneous really useful demos
Wes Preston, Ryan Oliveira, Femi Oyekan
http://www.sharepointmn.com
Agenda
•
•
•
•
•
•
Quick Intro
Demo: Digital Forms and Workflow
Break
Demo: Excel Services
Demo: Intranet home page
Q&A
http://www.sharepointmn.com
User Group Goal / Objectives
Develop and support a local community focused on Microsoft
SharePoint Technologies
•
•
•
•
Educate user group members about SharePoint Technologies
Transfer knowledge within the community
Communicate best practices
Introduce new products / solutions
http://www.sharepointmn.com
Introductions – MNSPUG Sponsors
Inetium (www.inetium.com)
• Technology consulting company
• Microsoft Gold Certified Partner
• Practice area focused on SharePoint
New Horizons – Minnesota (www.newhorizonsmn.com)
• Microsoft Gold Certified Partner
• Training on many technologies
Microsoft (www.microsoft.com)
http://www.sharepointmn.com
www.sharepointmn.com
•
•
•
•
•
•
Website for user group
SharePoint resource documents
SharePoint resource links
RSS Feeds
Meeting Schedule
Past User Group Presentations
www.sharepointmn.com
http://www.sharepointmn.com
MNSPUG @ Facebook!
• Additional way to
network with
members
• Show your support
for the MNSPUG!
http://www.sharepointmn.com
Upcoming Schedule
•
Next Meeting
• January 9th 9:00 AM to 11:30 AM
• Microsoft’s Bloomington Office
• Topic: SharePoint Vendor Showcase
• Ongoing Schedule
• 2nd Wednesday of every month
• 9:00 to 11:30 am
• Microsoft’s Bloomington Office
http://www.sharepointmn.com
Crowd Control
•
Thank you for your patience…
http://www.sharepointmn.com
Other Events
• SharePoint Server 2007: Search Deep Dive
Wednesday, January 16th 8:30 AM to Noon
At New Horizons (see their site for more details)
• High Monkey Consulting - Making your MOSS Grow (class)
January 28-31 - Las Vegas, NV
http://www.highmonkey.com/MOSS.html
http://www.sharepointmn.com
Conferences
• Microsoft Office System - Developer Conference 2008 – Feb 10-13, 2008
San Jose, CA
https://microsoft.crgevents.com/ODC2008/Content/default.aspx?p=UC3HYF
(Bill Gates keynote…)
• Microsoft Office SharePoint Conference 2008 – March 2-6, 2008
Seattle, WA
http://www.mssharepointconference.com/default.aspx
• Tech Ed (Splits into two conferences)
Tech Ed – Developers – June 3-6, 2008
Tech Ed – IT Professionals – June 10-13, 2008
Orlando, Fl
http://www.microsoft.com/events/teched2007/default.mspx
http://www.sharepointmn.com
Blog Posts / News:
SharePoint Team Blog:
• SharePoint Technologies and Products – Service Pack 1
http://blogs.msdn.com/sharepoint/archive/2007/12/11/announcing-the-release-ofwss-3-0-sp1-and-office-sharepoint-server-2007-sp1.aspx
TechNet article: http://technet.microsoft.com/enus/office/sharepointserver/bb735839.aspx
•
System Center Operations Manager 2007 *Updated* Packs for WSS 3.0 and MOSS
2007
http://blogs.msdn.com/sharepoint/archive/2007/12/10/announcing-new-systemcenter-operations-manager-2007-packs-for-wss-3-0-and-moss-2007.aspx
•
RSS feed for SharePoint content on MSDN
http://blogs.msdn.com/sharepoint/archive/2007/12/03/rss-feed-for-sharepointcontent-on-msdn-now-available.aspx
http://www.sharepointmn.com
Blog Posts – Composite Applications follow-ups (new!)
Raymond Mitchell’s Blog: http://blogs.inetium.com/blogs/rmitchell
• Out of the Box Composite Apps - Navigation for Custom Pages
• Out of the Box Composite Apps - Customizing Navigation
• See Raymond’s blog or the November MNSPUG slide deck for 7 more
articles
• Related content
http://dataformwebpart.com/
http://www.sharepointmn.com
InfoPath and SharePoint
Designer Workflows
http://www.sharepointmn.com
• Provide an Introduction to InfoPath and SharePoint
Workflows
• Define the PTO Request System Requirements
• Design and publish an InfoPath form to Collect
Data
• Design two SharePoint Designer workflows
• Acknowledgments / References
• Q&A
http://www.sharepointmn.com
Brief Introduction to InfoPath
InfoPath 2007
• Client application is part of Microsoft Office 2007
• Designed to allow quick development of data entry forms
• Can be used in SharePoint as the template for a forms library
InfoPath Form Services
• Allows browser enabled forms to be published to SharePoint
• Eliminates the need for InfoPath to be installed on each user’s
computer
• A few features are not available on browser enabled forms
• Not all SharePoint installations come with Form Services
http://www.sharepointmn.com
SharePoint Designer Workflows
• Windows Workflow Foundation
• Part of .NET Framework 3.0
• Development involves creation of activities
• Common usage includes approvals, help desk, and change
management.
• SharePoint Designer Workflows
• Created without having to write any code.
• Utilizes a wizard that allows a user to add conditions and activities
• SharePoint designer associates completed workflows with a single
library or list
http://www.sharepointmn.com
PTO Request System Requirements
• Create a form that allows users to request days off
• The form can only be used to request 10 days off or less
• The form must be available on the web
• If needed, the user’s manager must approve the PTO
http://www.sharepointmn.com
Using Excel Services
http://www.sharepointmn.com
Overview
•
•
•
•
Excel Services Features
Excel Services Technical Overview
Configuring Excel Services
Excel Services Demonstrations
Features
• Ability to create Dashboards supported with LOB data
• Pivot Table & Chating functionality within a Web
Context
• Support decision-making within a Web Context
• Support for KPIs within Pivot Tables
Excel Services Technical Overview
• Required Software Components
• MOSS 2007 Enterprise Edition
• Host Excel 2007 documents
• Microsoft Excel 2007 Ultimate, Enterprise or
Professional Plus
• Publish Excel 2007 documents
Excel Services Technical Overview
• Excel Web Access
• Renders Excel Workbooks (HTML)
• Excel Web Services
• Programmatic Access to its Web
Service
• Excel Calculation Services
• Loads, Calculates and calls custom
code (UDF)
Configuring Excel Services
•
•
•
•
•
•
Enabling Excel Calculation Services
Configuring a Data Connection Library
Configuring a Trusted Document Library
Adding Office Data Connection file
Connecting to LOB Data
Add Spreadsheet to SharePoint with Excel Web
Access Web Part
Building an Intranet Home Page
http://www.sharepointmn.com
Starting from the Intranet Template
Default page:
• Only uses static links
for News
• Set to show all
‘pages’
• Must be manually
updated regularly
http://www.sharepointmn.com
Use News to keep the data fresh
• Different types of news articles
• A variety of content owners and sources
• Use Content Types and Content Query Web Parts
http://www.sharepointmn.com
Events
• Add and display calendar items, but limit them to
relevant items – not too far in the future.
• Filter options for calendars are limited
http://www.sharepointmn.com
Additional Changes
• SharePoint Designer
• Layout changes, re-arrange web part zones.
• Master page changes
• Data View Web Parts
• I need to… Web Part
• Make less obscure
• Use to replace Quick Links list
http://www.sharepointmn.com
Other Items
http://www.sharepointmn.com
References
• InfoPath Homepage
http://office.microsoft.com/en-us/InfoPath
• SharePoint Designer Homepage
http://office.microsoft.com/en-us/sharepointdesigner
• .NET Framework 3.0 Developer Center
http://msdn2.microsoft.com/en-us/netframework
• Inetium Blogs
http://blogs.inetium.com
• I need to… Web Part
http://msmvps.com/blogs/shareblog/archive/2006/09/27/I-needto_2E002E002E00_.aspx
http://www.sharepointmn.com
Q&A
http://www.sharepointmn.com
Thanks for coming!
http://www.sharepointmn.com