Windows IT Pro is the authoritative and independent resource for windows nt, windows 2000, windows 2003, windows xp. Features a collection of resources and magazines for windows IT professionals.
  
  
  Advanced Search 


October 25, 2004

Office 2003 and SharePoint: Better Together

Enhancing productivity in a team environment
RSS
Subscribe to Windows IT Pro | See More Collaboration Articles Here | Reprints | Or get the Monthly Online Pass—only $5.95 a month!

Windows SharePoint Services (WSS) and Microsoft SharePoint Portal Server (SPS) 2003 provide a unifying, integrated, and extensible technology platform that can meet the collaborative needs of small teams and large enterprises alike. Whether you're generating intellectual property or ensuring that audiences can publish and discover relevant information, the SharePoint platform provides services that can help you succeed.

WSS is a three-tier Web application that's an add-on to Windows Server 2003. You can download WSS from the Microsoft Web site (http://www.microsoft.com/windowsserver2003/techinfo/sharepoint/wss.mspx). WSS provides a site framework on which to build team sites that support the sharing of information among users. A WSS team site provides document libraries and lists for announcements, events, tasks, contacts, issues, surveys, and discussions. These libraries and lists are extensible. Although WSS can scale up and out to support the needs of hundreds of thousands of team sites, the real power of the WSS team site is that the users can design and create their own sites to meet their needs.

SPS builds on the WSS site framework by facilitating the publishing of relevant information across departments or organizations. SPS provides many features that make this facilitation possible, such as audience targeting (which makes sure the right people receive the right information), enterprise searches (data from multiple sources is indexed to provide relevant and aggregated search data), and personal Web sites for all users. Unlike WSS, SPS isn't a free add-on but rather an application that has to be purchased and licensed. For more information about SPS, go to http://www.microsoft.com/sharepoint.

By themselves, WSS and SPS provide users with many capabilities for collaboration. However, a primary goal of the SharePoint platform is to support collaboration by letting other applications easily exploit its services. In other words, the goal is to have collaborative services available from whichever application the user is currently using rather than having to always use one specific collaboration application. Built on Microsoft Internet Information Services (IIS) 6.0, Microsoft SQL Server 2000, Windows .NET Framework, and ASP.NET, the SharePoint platform achieves this goal by exposing its features through a managed object library and multiple XML Web services.

Microsoft Office 2003 is a great application to showcase how to take advantage of the SharePoint platform. There are many integration points between Office 2003 and the SharePoint platform—too many to cover here. Therefore, I concentrate on how the SharePoint platform can assist the document creation and publishing processes in Office 2003 applications. But before I discuss how the SharePoint platform can benefit Office 2003 users, I want to discuss how Office 2003 can benefit SharePoint users.

How Office 2003 Can Help SharePoint Users
Because WSS is a Web application, the primary client is a browser. Microsoft Internet Explorer (IE) 6.0, IE 5.5 Service Pack 2 (SP2), IE 5.01 SP2, and Netscape Navigator 6.2 are the officially supported browsers, but Mozilla 1.6 or later and Firefox 0.7 or later work as well. (A browser certainly isn't the only client that users can use to access the documents and lists contained inside their team sites—more about this in the next section.)

Office 2003 can help SharePoint users access their team sites through a browser. As you navigate to a document library within a team site, you have an option to upload a file. Think of this as copying a file from your hard disk to a file share. The only difference is that you're using a browser rather than Windows Explorer to invoke the copy operation. By default, the browser upload option lets you upload only one file at a time, which clearly is limiting. However, if your browser supports ActiveX controls and your system includes an ActiveX control named STSUpld.UploadCtl, a multiple-upload option is available. Office 2003 installs this ActiveX control.

There are other ways in which Office 2003 helps you access team documents and lists through a browser. For example, Office 2003 lets you use the Data Sheet View to do Microsoft Excel­like editing directly in the browser. In addition, Office 2003 lets you use the New option to directly create a document in a library and lets you import entries from the Outlook Address Book so that you can add users to a team site or populate a contacts list.

How SharePoint Assists Document Creation in Office 2003
Traditionally, people think of the primary Office products (e.g., Excel, Outlook, Microsoft PowerPoint, Microsoft Word) as personal productivity tools. SharePoint raises the stakes by enhancing team productivity while maintaining a familiar way of working. For example, most people are used to creating documents in Word and storing them on the C drive or a file share and perhaps attaching them to a mail message for distribution and commentary. These actions are fairly personal and don't involve much team collaboration. But what if the document in question was stored inside a SharePoint document library instead?

The first item to note about document libraries is that they're accessible from more than just a browser. The WWW Distributed Authoring and Versioning (WebDAV) protocol is used for document library access, which means you can access document libraries from Windows Explorer (through Web Folders), directly from Office 2003 applications and, if running on the Windows XP platform, directly from any application through the DAV redirector. (The DAV redirector essentially lets you map a document library like a network drive and translates the Server Message Block—SMB—calls into WebDAV calls.)

Thus, you can easily open and save documents directly into a document library. This ability offers several benefits to team members. First, the document library becomes part of a team site and other data (e.g., tasks or contacts in a list) can augment it. Second, like lists, the metadata associated with a document library is extensible. Thus, you can add descriptive information about a document, which facilitates discovery and usage by other team members. Something as simple as a check box that specifies whether the document is ready for wider distribution can be extremely beneficial in a team environment. Office 2003 recognizes this metadata and lets users set it directly from the application when saving the document to a library. In addition, document libraries support check-in/check-out and versioning, and these options are available directly from within the Office 2003 application.

Here's another example of how the SharePoint platform raises the stakes. If the document you currently have open inside your Office 2003 application is from a document library, you can view the Shared Workspace task pane, which Figure 1 shows. This pane lets you see and manipulate other team-site collateral that's affiliated with the document, without leaving the Office application. "So what?" I hear you cry. Well, maybe something in the document raises a question in your mind that one of your team members might be able to answer. You can immediately see which team members are online and start an Instant Messaging (IM) conversation with them. Or perhaps you want to assign a task to a team member or open another document that's associated with the site. You can perform all these actions from the Shared Workspace pane. This pane is also available programmatically through the SharedWorkSpace object and associated objects in the Office Object library.

   Previous  [1]  2  Next 


Reader Comments

You must log on before posting a comment.

If you don't have a username & password, please register now.




Top Viewed ArticlesView all articles
The Memory-Optimization Hoax

Don't believe the hype. At best, RAM optimizers have no effect. At worst, they seriously degrade performance. ...

Friday at PASS Europe 2006

Kevin talks about the closing day of the event and shares a funny Microsoft film. ...

Escape From Yesterworld

Kevin points you to the funniest SQL Server website ever! ...


Exchange Server and Outlook Whitepapers Anonymizers – The Latest Threat to Your Web Security

Replay for Exchange: Enterprise Protection and an Affordable Price

ETX Driving Embedded I/O

Related Events Check out our list of Free Email Newsletters!

Exchange Server and Outlook eBooks Spam Fighting and Email Security for the 21st Century

Understanding and Leveraging Code Signing Technologies

The Expert's Guide for Exchange 2003: Preparing for, Moving to, and Supporting Exchange Server 2003

Related Exchange Server and Outlook Resources Become a VIP member of the Windows IT Pro community!
Get it all with the VIP CD and VIP access. A $500+ value for only $279!

Subscribe to Windows IT Pro!
Solve your toughest technical problems with our experts and access 10,000 + articles online. 30% off

Monthly Online Pass - Only $5.95!
Get instant access to 10,000+ articles from Windows IT Pro Magazine!

TechNet Virtual Labs
Evaluate and test Microsoft's newest products.

Exchange & Outlook UPDATE eNewsletter
News, strategies, products, and developments in Exchange Server and Outlook messaging.
Job Openings in IT


ADS BY GOOGLE SPONSORED LINKS FEATURED LINKS

Maximize your SharePoint Investment – 8 Cities
Discover best practices and tips for both architecting and administering SharePoint. Early Bird Price of $99 through Sept 15th.

Find a new job now on the all new IT Job Hound!
Search jobs, post your resume, and set up job e-mail alerts!

Master SharePoint with 3 eLearning Seminars
Learn how to build a better SharePoint infrastructure and enable powerful collaboration with MVPs Dan Holme and Michael Noel. Register today!

Top Tools for Virtualization Disaster Recovery & Replication
View this web seminar on August 14th to learn about two tools that will result in faster backup and restore with P2V disaster recovery.

SharePointConnections Conference Fall 2008
Don’t miss the premier event for Microsoft IT Professionals in Las Vegas, November 10-13. Register and book your room by August 25 and receive a FREE room night (based on a three night minimum stay).

VMworld 2008 - Sign Up Today!
Join your peers on September 15-18 at The Venetian Hotel in Las Vegas as VMware hosts VMworld 2008, the leading Virtualization event.



Entrust Unified Communications Certs
Secure Exchange 2007 and save 20%. Now through Sept. 2008.

Increase Application Performance
Free White Paper by Editor's Best winner, Texas Memory Systems.

Need to convert between XML, DBs, EDI, and Excel? Try MapForce free!
Drag & drop to transform between popular data formats – get results instantly or generate code.

Microsoft® Tech•Ed EMEA 2008 IT Professionals
Advance your thinking with new ideas and practical real-world solutions at Microsoft’s FIVE day technical infrastructure conference 3-7 Nov., 2008. Register before 26 September 2008 to save €300.

Order Your SQL Fundamentals CD Today!
Learn how to use SQL Server, understand Office integration techniques and dive into the essentials of SQL Express and Visual Basic with this free SQL Fundamentals CD.

Are You Really Compliant with Software Regulations?
View this web seminar that will help you with compliance best practices and check out a management solution to assure that you won’t be in jeopardy of an audit.

Virtualization Congress Oct. 14-16 in London
Don't miss Virtualization Congress, the premiere EMEA conference dedicated to hardware, OS and application virtualization. Oct. 14-16.
Windows IT Pro Home Register FAQ for Windows WinInfo News
Europe Edition About Us Contact Us/Customer Service Media Kit Affiliates / Licensing  
SQL Server Magazine Office & SharePoint Pro Windows Dev Pro IT Job Hound ITTV
IT Library Technical Resources Directory Connected Home Windows Excavator Windows SuperSite 
 
 Windows IT Pro is a Division of Penton Media Inc.
 Copyright © 2008 Penton Media, Inc., All rights reserved. Terms and Use | Privacy Statement | Reprints and Licensing