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 


June 2008

Integrating Office Applications with SharePoint Document Libraries

Leverage the client integration features of Office and SharePoint to provide the best experience for Office users working in SharePoint document libraries
RSS
Subscribe to Windows IT Pro | See More Windows OSs Articles Here | Reprints | Or get the Monthly Online Pass—only $5.95 a month!

Download the Code Here

You can also configure other settings for the content type, including columns that describe the content, also called metadata, properties, or attributes. Properties appear on the Information tab in the Shared Workspaces task pane in Office 2003. In Office 2007, properties appear in the document information panel, which can be turned on by choosing the Properties command from the Prepare menu under Office. You can force the document information panel to be visible by configuring the Advanced Settings of the content type.

For example, if you create a content type for Sales Proposals, you can add a column called Customer. You can then use the property to create views of the document library that sort, filter, or group documents based on Customer. SharePoint search also indexes the column, so that users can search for a proposal using the Customer attribute. You can even make that column a required property. When users create Sales Proposals, they will be required to enter the Customer property. If checkout is required, documents cannot be checked in until required properties are populated.

After you create the content type, you can use the content type in one or more document libraries. In a document library, click Settings, then click Document Library Settings. Select Advanced Settings and click the Yes radio button that enables management of content types. Then click OK. The Document Library Settings page will now display a new section, Content Types. Click the link Add from existing site content types, select your custom content type, click Add, then click OK. You can delete the default Document content type from the library, assuming no documents have been added to the library. If you add more than one content type, you can change the order in which they appear on the library’s New menu, and set the default content type.

Now navigate back to the document library. Click the drop-down arrow on the New button in the library toolbar, and you’ll see the content type as an available document in the New menu. Documents that are created from a document library will be saved to the same library, by default, by both the Save command and the Publish to Document Management Server command.

Comparing Document Versions
In many work scenarios, users revise a document before the document is finalized. Most users save each new version of a document with a slightly different name, resulting in version proliferation that is difficult to manage. SharePoint’s support for versions, combined with Word’s ability to compare documents, unleashes a valuable capability.

You can enable versioning in the Versioning Settings page from a document library’s Settings page. Then, SharePoint automatically creates a new version of a document each time the document is saved. The document library displays only the most recent version of a document, but you can use the Version History command of the document’s edit menu to view, restore, or delete a previous version.

You can perform the same operations from within Office applications. Open the document from the library, click the Office Button, select the Server menu, then View Version History. You can even compare versions by using Word 2007. From the View Version History command, select an earlier version and click the Compare button. Word will compare the current opened version of the document with the selected previous version, allowing you to identify the differences between the versions.

Publishing Blog Entries
SharePoint offers blog capabilities through the Blog site template. You can post a blog entry using SharePoint’s Web interface, but for a richer editing experience you can use Word 2007 to create and publish a blog entry. Simply choose New Blog Post when you create a Word document, or use the Blog command on Word’s Publish menu. The first time you publish a blog entry, you’ll be prompted to configure the URL to the blog site, and if necessary, your user credentials, with permission to post entries.

Troubleshooting Client Integration Features
If you’re having trouble working with document libraries, you can find quite a few resources on the Internet with a quick search. The most common causes of trouble are:

• Browser choice: Before you spend too much time troubleshooting document library functionality, be sure you’ve tried it with Microsoft Internet Explorer (IE). Some functionality is reduced on other browsers.

• Browser security settings: Make sure your SharePoint server is in the Local Intranet or Trusted Sites zone. Experiment with those zones to decide which provides the functionality you desire. IE 7.0’s protected mode also creates additional prompts for user credentials, but before you turn it off for a zone, be sure you’ve researched the implications.

• Permissions: SharePoint’s UI is security trimmed, so you’ll only see commands and features based on the permissions given to your user account.

• Client integration: Some SharePoint functions, such as the Edit in Application (e.g., Edit in Word) command on the edit menu, or the Connect to Outlook command in the Actions menu, are visible only when Client Integration is enabled in the authentication provider for the Web application and zone. To check whether integration is enabled, open Central Administration, Application Management. Click Authentication Providers, then click the link to the zone. Ensure that Client Integration is selected— it’s enabled by default for Windows authentication, but is disabled by default for forms-based authentication (FBA).

• FBA: Some client integration features work differently, and a limited number of features aren’t available at all, when you use FBA instead of Windows authentication.

• Sign-in: If you use FBA, make sure that you select the Sign me in automatically check box in the logon screen, as Figure 4 shows. This option creates a cookie that lasts until the browser is closed, and client integration features can use that cookie to authenticate against SharePoint. You must select this option and leave the browser open while using client integration features against a SharePoint application using FBA. Despite its label, the option doesn’t sign you in to the site automatically the next time you return.

More than Word Can Say
I’ve focused on Word in this article, but PowerPoint, Excel, Access, OneNote, and Info- Path use similar processes to integrate with SharePoint document libraries. Although I’ve mainly discussed Word 2007, many of the core integration features are available in Office 2003 applications as well. There’s extraordinary integration between SharePoint lists and both Excel and Access—producing valuable solutions that I’ll cover in future articles. Be sure to visit office.microsoft.com and www.officesharepointpro.com for details about the capabilities and configuration of these other applications.

End of Article

   Previous  1  [2]  Next  


Reader Comments
How do I run the script in listing 1?

hayess June 17, 2008 (Article Rating: )


It is a VBScript. Copy & Paste it to NOTEPAD.
Choose File--> Save As
Enter a name like "NetworkPlace.vbs"
BE SURE TO INCLUDE THE QUOTES around the name, otherwise notepad will save it as NetworkPlace.vbs.txt

REMOVE THE LINE that say "Begin Callout A"
Change the "friendly name" in sFolderPath (currently "Marketing...") to the right friendly name for your nemtwork place.
Change the target in sTargetPath to point to the right location.

Save again

Open a command prompt and run

cscript.exe "NetworkPLaces.vbs"
(or whatever name you used for the script)

danholme June 19, 2008 (Article Rating: )


You must log on before posting a comment.

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




Top Viewed ArticlesView all articles
Command Prompt Tricks

One reader shares his tip for setting up the command prompt to reflect a remote path. ...

New Microsoft/Yahoo! Deal? No

On Sunday, the Times of London reported that Microsoft had renewed talks with failing Internet giant Yahoo! and would manage its search engine for 10 years, while Yahoo! would retain control of its email, messaging, and content services. This report ...

How can I stop and start services from the command line?

...


Windows OSs Whitepapers Why SaaS is the Right Solution for Log Management

Related Events Check out our list of Free Email Newsletters!

Windows OSs eBooks Understanding and Leveraging Code Signing Technologies

A Guide to Windows Certification and Public Keys

SQL Server Administration for Oracle DBAs

Related Windows OSs 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.


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 Technology Resource 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