Chapter 8: The Microsoft Office System


Along with upgrades to the Windows operating systems, upgrades to the Office suite form the financial backbone of Microsoft. To support this business model, Microsoft has traditionally focused on improving the feature set of the Office suite. Customers were asked to upgrade based on new fonts, new toolbars , new editing capabilities, and the like. With Office 2003, Microsoft has changed its focus from features to collaboration. Everything in the Office suite is designed to allow teams to work together more effectively, and SharePoint Services forms the foundation for the collaboration. When referring to the combined capabilities of Office 2003, SharePoint Services, and SharePoint Portal Server (SPS), Microsoft uses the term Office System.

Office Integration

As we all know, the Microsoft Office suite is primarily concerned with creating documents. We also know from our discussions throughout the book that SharePoint Services is primarily concerned with managing documents. Although much of their value comes from complementary functionality centered on document creation and management, both Microsoft Office and SPS have non-document capabilities. In this section, I'll show you the document-centric integration between Office and SharePoint Services and follow it with an overview of additional integration points.

Document Management

The cornerstone of document management within the Office 2003 system is the document library. Document libraries are fully integrated with Office 2003. Fundamental document management features like check-in, check-out , and versioning are available directly from the File menu in most products. Additionally, you can access any document library directly from the Open dialog.

Once SPS is set up with an area taxonomy and document libraries, you can access documents by selecting File Open from the main menu of most Office products. However, the integration with SharePoint Services is not immediately obvious in the Open dialog because no special icons or options suggest that the document libraries are available. Instead, you can simply type the URL of the portal site into the dialog to reveal the same area taxonomy that is present in SPS. Figure 8-1 shows the Open dialog with the area taxonomy displayed.

click to expand
Figure 8-1: Viewing the area taxonomy

Because the area taxonomy provides a critical and familiar way to find documents, you may want to make it more easily accessible to end users. You can do this by adding it to the Look In list that appears in the Open dialog. Once you add it, end users can just click the icon to gain immediate access to the area taxonomy.

To add the area taxonomy, follow these steps:

  1. From an Office product select File Open.

  2. In the Open dialog, type http://spsportal into the File Name text box and click Open.

  3. When the area taxonomy is displayed, select Tools Add to My Places from the menu in the dialog box.

  4. Locate the reference to the portal in the Look In list.

  5. Right-click the icon and select Move Up from the pop-up menu until the icon is at the top of the list.

  6. When it is positioned correctly, right-click the icon again and select Rename from the pop-up menu.

  7. Name the icon SharePoint Portal .

Using the area taxonomy, you can access any of the libraries that are immediately associated with an area, but you cannot easily navigate the site structure of the portal. Instead, document libraries associated with sites are treated as web folders. This means you can access them directly, if you know the URL. However, you will not find an easy way to manage URLs associated with sites. The only way to use them with a team is to e-mail them to others, but this is no better than e-mailing a link to a document on a file server.

When it comes to accessing document libraries associated with sites, users will have an easier time using SPS to locate the library. From the library, users can then create new documents or open existing ones. These actions will in turn start the appropriate Office product to view and edit the document. Later, when the user wants to save the document, Office will automatically open the correct document library. This approach ensures that users never have to know complicated URL addresses to access a document.

Document Workspaces

Regardless of how the document is accessed, when it is ultimately opened in a Microsoft Office product, it will be associated with a document workspace. Document workspaces are SharePoint Services sites that contain a document library, tasks , links, and other information. Document workspaces may exist because they were created directly in SPS as a new site, or they may be created ad-hoc from within an Office product. Because document workspaces provide many of the capabilities associated with SharePoint Services directly in the Office product, end users can collaborate without having SPS open alongside Office. This is significant not only because SharePoint Services capabilities are integrated, but also simply because it requires less screen real estate.

A good way to create general ad-hoc sites is to create a new site collection in SPS called "adhoc" under which all ad-hoc sites will be created. Then you can assign users to the Administrators site group for this master site. Additionally, users may choose to build personal workspaces beneath My Site. In fact the first time a user visits My Site, Office will prompt the user to designate My Site as the default collection for the user's personal workspaces.

To create a document workspace from Microsoft Word, perform these steps:

  1. Log in to SPSClient as a member of the Administrators site group for the site where the new workspace will be created.

  2. Start Microsoft Word 2003.

  3. Select File New from the menu.

  4. In the New Document pane, select Templates On My Computer.

  5. In the Templates dialog, click the Memos tab.

  6. On the Memos tab, select the Professional Memo template.

  7. Click OK.

  8. From the main menu, select Tools Shared Workspace.

  9. In the Shared Workspace pane, click the Members tab.

  10. In the Document Workspace Name box, type Meeting memo .

  11. In the Location for New Workspace box, type the address of a site that you have created already (e.g., http://spsportal/sites/adhoc ).

  12. Click Create.

The center of document collaboration within Office 2003 is the workspace pane. A workspace pane is directly associated with a document workspace and will appear whenever a document is opened from an existing workspace or a new workspace is created. The workspace pane consists of tabs for the document status, workspace membership, tasks, a list of documents in the workspace, links, and the document profile. Figure 8-2 shows a typical workspace pane.

click to expand
Figure 8-2: The workspace pane

The Membership Tab

Once a new workspace is created, portal users can be invited to join the workspace. It is important to note that document workspaces created in Office 2003 do not inherit permissions from the site collection in which they reside. This means that users must be invited to the document workspace in order to participate. The user who initially creates the workspace typically does this.

These are the steps you would take to invite portal users:

  1. In the Shared Workspace pane, click the Members tab.

  2. On the Members tab, click the Add New Members link to open the Add New Members dialog.

  3. In the Add New Members dialog, type the e-mail addresses or user names for the portal users you want to invite.

  4. Assign the members to a site group for the workspace. Most members will belong to the Contributors site group.

  5. Click Next.

  6. Verify the user information is correct and click the Finish button.

  7. When you are invited to send an e-mail to the new members, click OK to start Microsoft Outlook.

  8. Edit the invitation message to your liking and click Send.

The Status Tab

The Status tab in the workspace displays information regarding the status of the current document. Status changes can occur, for example, because edits were made to the document that have not been reflected in the document workspace. When this happens, the Status tab will notify members of the workspace that there is a difference between the two versions. It will also present a link to allow the document library version to be updated. Additionally, if a portal user updates the document directly in the library, members of the workspace will be given a link to get the latest copy.

Of course with this level of flexibility, conflicts are bound to occur. If users make changes to the same documents that are in conflict with each other, then the Status tab displays a message noting the conflict. In this case, you are presented with a set of options for resolving the conflict. Figure 8-3 shows the available options.

click to expand
Figure 8-3: Conflict resolution options

The first option is to merge the changes. In this case, you may view all of the changes and accept or reject them individually or all at once. The second option is to open both documents simultaneously and resolve the conflicts by hand. The final option is to simply override one copy of the document with the other. Once the document conflicts have been resolved, you can save the document back to the workspace.

The Tasks Tab

The Tasks tab in the workspace is used to assign and track tasks associated with the document. This is especially useful if several people are going to work on preparing a document. In such a case, you might assign certain sections of the document to a user. Each user can add their section to the document and track the progress through the task list.

The Documents Tab

The Documents tab in the workspace is used to see all of the documents that are available in the document library. This is useful when a document is being prepared from a set of subdocuments. For example, a sales proposal might consist of a product description copied from a catalog. This description could be excerpted by a member and placed in the library as a separate document. The team leader could then open the excerpt and add it into the master document later.

The Links Tab

From the Links tab in the workspace, you can add links for resources associated with the document preparation. This is useful when some of the information for the document will come from other web sites ”for example, background information on a customer's organization. This way, the document preparation team can lift the text from the site and paste it into the final document.

The Document Information Tab

The Document Information tab contains metadata about the current document. This includes basic information such as who created the document or who modified it. It also allows you access to the different versions that exist in the document library and a quick link for checking in/checking out functionality. You can also configure an e-mail alert from this tab to notify you when the document has changed.

Meeting Workspaces

Although organizations often collaborate around documents, not every meeting results in a document. Instead, the organization may have a meeting to make a decision, update a project's status, or review a sales report. In these cases, people need a different set of tools to facilitate the meeting.

The Microsoft Office System provides a location specifically designed to track meeting participants , agendas , and a set of tasks called a meeting workspace. A meeting workspace is a specialized SharePoint Services site. It can be created directly in SPS or in Microsoft Outlook as part of a meeting request. Figure 8-4 shows a meeting workspace in SPS.

click to expand
Figure 8-4: A typical meeting workspace

Although meeting workspaces offer a set of tools for managing information associated with a meeting, it is important to realize that they are not intended to actually host a meeting. This means that meeting workspaces should never be confused with the functionality found in Microsoft Live Meeting or similar competing services like WebEx. In a typical scenario, you could use Microsoft Live Meeting to host a meeting while tracking the agenda and action items on the meeting workspace. This way, a complete record is available to the participants after the meeting is completed.

When preparing SPS to allow meeting workspaces, follow the same approach you used for document workspaces. Allow users to create these workspaces under a site collection. This way, all portal users can create meeting workspaces as they are needed whenever a meeting is scheduled in Outlook.

Here are the steps to create a meeting workspace:

  1. Log in to SPSClient as a user with permissions to create a new workspace.

  2. Open Microsoft Outlook.

  3. In Microsoft Outlook, click the Calendar icon.

  4. On the calendar, right-click a time slot and select New Meeting Request from the pop-up menu.

  5. Give the new meeting a subject and location.

  6. Click the Scheduling tab.

  7. Select Add Others Add from Address Book.

  8. In the Select Attendees and Resources dialog, add several users to the meeting request by double-clicking their names.

  9. Click OK when you are done.

  10. Click the Appointment tab.

  11. Click the Meeting Workspace button.

  12. Select to create the workspace in an appropriate location.

  13. Click Create.

  14. When the new workspace is created, click the Send button to notify the attendees.

When a new meeting workspace is created from Outlook, attendees will receive the traditional message inviting them to the meeting. The body of the meeting invitation will contain a link to the meeting workspace so that they can visit it before, during, or after the meeting. This will allow attendees to upload important documents before the meeting takes place and review action items after the meeting ends.

Contacts and Calendars

Contacts and calendars in Outlook are fully integrated with SPS. Whenever you encounter a contact list in SPS, you can import or export contacts with your personal Outlook. Anywhere you find an event in SPS, you can also export it to your local Outlook calendar. Additionally, you can link an entire event list as a calendar in your Outlook; you will be able to access it as a separate folder under the Calendars icon.

Linked Lists

For all of the line-of-business applications that have been created by independent software vendors (ISVs), Microsoft Excel remains a significant tool for creating and analyzing data. The use of Excel seems to be a testament to the way most people work. They simply want to grab a blank piece of paper, write down what they need, analyze it, and make a decision. Often it appears that line-of-business systems try to make the user conform to the process embodied in the software instead of the other way around.

It is for this reason that end users should find the list integration capability between Excel and SPS truly worthwhile. Instead of fighting the way many people work, Excel now lets end users create a list and then link it to a SharePoint Services site. This link is a simple idea, but it allows Excel users to continue editing the list directly while the data is available to all portal users through a public site.

To create and link a list, follow these steps:

  1. Log in to SPSClient .

  2. Open Microsoft Excel.

  3. In Microsoft Excel, set up a simple list with the column headers and data as detailed here:

    • Column headers: Sales Rep, Quarterly Sales

    • Row 1 data: Bellotti, 500

    • Row 2 data: Mineweaser, 400

    • Row 3 data: Hillier, 475

  4. Select the entire list you just created.

  5. From the menu, select Format AutoFormat.

  6. In the AutoFormat dialog, select the Accounting 1 layout and click OK.

  7. Select any cell in the list you just created.

  8. From the menu, select Data List Create List.

  9. When prompted by the Create List dialog, click OK.

  10. When the new list is created, the List toolbar should appear. Click the Toggle Total Row button on the List toolbar.

  11. From the List toolbar, select List Publish List to start the Publish List wizard.

  12. In the Publish List wizard, type the URL of a site that you have already created in SPS where you have permission to add content.

  13. Check the "Link to the new SharePoint list" box.

  14. In the Name text box, type Sales Performance .

  15. Click Next.

  16. Verify the data types in your list and click Finish.

  17. If you do not have appropriate permissions, you will be prompted with a logon box. Provide credentials, if necessary, to publish the list.

When the list is published to the site, it will not be immediately visible. Instead, it will be available under the Lists link on the site. If you want to make it visible on the home page, you must edit the page. The published list can be dragged onto the page from a web part gallery just like any other list.

Whenever you update the list, the changes will be reflected on the SharePoint site if you click the Synchronize button on the List toolbar. Just like documents, however, the synchronization process can result in conflicts when the data is updated in both Excel and SPS. In these cases, clicking Synchronize displays a conflict resolution dialog. In this dialog, you can discard your changes, force your changes, or unlink the list. Figure 8-5 shows a typical conflict resolution dialog.

click to expand
Figure 8-5: Resolving list update conflicts



Microsoft SharePoint[c] Building Office 2003 Solutions
Microsoft SharePoint[c] Building Office 2003 Solutions
ISBN: 1590593383
EAN: N/A
Year: 2006
Pages: 92

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net