Misc Really Useful Demos

1
Welcome to the Minnesota SharePoint User Group
December 12th, 2007 Miscellaneous really useful
demos
Wes Preston, Ryan Oliveira, Femi Oyekan
http//www.sharepointmn.com
2
Agenda

• Quick Intro
• Demo Digital Forms and Workflow
• Break
• Demo Excel Services
• Demo Intranet home page
• Q A

http//www.sharepointmn.com
3
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
4
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
5
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
6
MNSPUG _at_ Facebook!

• Additional way to network with members
• Show your support for the MNSPUG!

http//www.sharepointmn.com
7
Upcoming Schedule

• Next Meeting
• January 9th 900 AM to 1130 AM
• Microsofts Bloomington Office
• Topic SharePoint Vendor Showcase
• Ongoing Schedule
• 2nd Wednesday of every month
• 900 to 1130 am
• Microsofts Bloomington Office

http//www.sharepointmn.com
8
Crowd Control

• Thank you for your patience

http//www.sharepointmn.com
9
Other Events

• SharePoint Server 2007 Search Deep
  DiveWednesday, January 16th 830 AM to NoonAt
  New Horizons (see their site for more details)
• High Monkey Consulting - Making your MOSS Grow
  (class)January 28-31 - Las Vegas,
  NVhttp//www.highmonkey.com/MOSS.html

http//www.sharepointmn.com
10
Conferences

• Microsoft Office System - Developer Conference
  2008 Feb 10-13, 2008San Jose,
  CAhttps//microsoft.crgevents.com/ODC2008/Content
  /default.aspx?pUC3HYF (Bill Gates keynote)
• Microsoft Office SharePoint Conference 2008
  March 2-6, 2008Seattle, WAhttp//www.mssharepoin
  tconference.com/default.aspx
• Tech Ed (Splits into two conferences)Tech Ed
  Developers June 3-6, 2008Tech Ed IT
  Professionals June 10-13, 2008Orlando,
  Flhttp//www.microsoft.com/events/teched2007/defa
  ult.mspx

http//www.sharepointmn.com
11
Blog Posts / News

• SharePoint Team Blog
• SharePoint Technologies and Products Service
  Pack 1http//blogs.msdn.com/sharepoint/archive/20
  07/12/11/announcing-the-release-of-wss-3-0-sp1-and
  -office-sharepoint-server-2007-sp1.aspx TechNet
  article http//technet.microsoft.com/en-us/office
  /sharepointserver/bb735839.aspx
• System Center Operations Manager 2007 Updated
  Packs for WSS 3.0 and MOSS 2007http//blogs.msdn.
  com/sharepoint/archive/2007/12/10/announcing-new-s
  ystem-center-operations-manager-2007-packs-for-wss
  -3-0-and-moss-2007.aspx
• RSS feed for SharePoint content on
  MSDNhttp//blogs.msdn.com/sharepoint/archive/2007
  /12/03/rss-feed-for-sharepoint-content-on-msdn-now
  -available.aspx

http//www.sharepointmn.com
12
Blog Posts Composite Applications follow-ups
(new!)

• Raymond Mitchells Blog http//blogs.inetium.co
  m/blogs/rmitchell
• Out of the Box Composite Apps - Navigation for
  Custom Pages
• Out of the Box Composite Apps - Customizing
  Navigation
• See Raymonds blog or the November MNSPUG slide
  deck for 7 more articles
• Related content http//dataformwebpart.com/

http//www.sharepointmn.com
13
InfoPath and SharePoint Designer Workflows
http//www.sharepointmn.com
14

• 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
15
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 users computer
• A few features are not available on browser
  enabled forms
• Not all SharePoint installations come with Form
  Services

http//www.sharepointmn.com
16
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
17
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 users manager must approve the
  PTO

http//www.sharepointmn.com
18
Using Excel Services
http//www.sharepointmn.com
19
Overview

• Excel Services Features
• Excel Services Technical Overview
• Configuring Excel Services
• Excel Services Demonstrations

20
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

21
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

22
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)

23
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

24
Building an Intranet Home Page
http//www.sharepointmn.com
25
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
26
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
27
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
28
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
29
Other Items
http//www.sharepointmn.com
30
References

• InfoPath Homepagehttp//office.microsoft.com/en-u
  s/InfoPath
• SharePoint Designer Homepage http//office.micro
  soft.com/en-us/sharepointdesigner
• .NET Framework 3.0 Developer Center
  http//msdn2.microsoft.com/en-us/netframework
• Inetium Blogshttp//blogs.inetium.com
• I need to Web Part http//msmvps.com/blogs/share
  blog/archive/2006/09/27/I-need-to_2E002E002E00_.as
  px

http//www.sharepointmn.com
31
Q A
http//www.sharepointmn.com
32
Thanks for coming!
http//www.sharepointmn.com