320 likes | 332 Views
Welcome to the Minnesota SharePoint User Group. December 12 th , 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
E N D
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 DiveWednesday, January 16th 8:30 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
Conferences Microsoft Office System - Developer Conference 2008 – Feb 10-13, 2008San Jose, CAhttps://microsoft.crgevents.com/ODC2008/Content/default.aspx?p=UC3HYF(Bill Gates keynote…) Microsoft Office SharePoint Conference 2008 – March 2-6, 2008Seattle, WAhttp://www.mssharepointconference.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/default.mspx http://www.sharepointmn.com
Blog Posts / News: SharePoint Team Blog: SharePoint Technologies and Products – Service Pack 1http://blogs.msdn.com/sharepoint/archive/2007/12/11/announcing-the-release-of-wss-3-0-sp1-and-office-sharepoint-server-2007-sp1.aspxTechNet 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-system-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
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
Default page: Only uses static links for News Set to show all ‘pages’ Must be manually updated regularly Starting from the Intranet Template 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 Homepagehttp://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 Blogshttp://blogs.inetium.com • I need to… Web Part http://msmvps.com/blogs/shareblog/archive/2006/09/27/I-need-to_2E002E002E00_.aspx http://www.sharepointmn.com
Q & A http://www.sharepointmn.com
Thanks for coming! http://www.sharepointmn.com