2007 Office Sample: Using the Business Data Catalog and Smart Tags with the 2007 Office System

Learn how to build custom applications that use the business data catalog and smart tags. This code sample and white paper walks through a custom solution that integrates LOB data with the 2007 Microsoft Office system to support the preparation of documents within Microsoft Office Word 2007. The solution presented uses product information contained within a Microsoft SQL Server 2005 database to support the creation of a quote sheet.

Resources for Interoperability with Microsoft Office SharePoint Server 2007. Cool

Recommended Guidelines for Search Boundaries

I have been asked a lot for guidelines around some of the boundaries for MOSS Search. Here is a quick table that does a good job on this:

Content Tagging Feature in MOSS 2007

I have had several customers meetings recently to discuss how Microsoft Office SharePoint Server (MOSS) 2007 along with WF may be used to support their workflow solutions. One of several requested features (not necessarily related to workflow) is content tagging. The good news is that the newly released community kit for SharePoint supports taxonomy management and content tagging. A list of the ohter features available in the kit is published at CodePlex.

Green Mountain Gets the [Share]Point

Coffee maker deploys Web-based portal to solve data-sharing problems

Caution: User Profile Image

I came across a weird thing the other day and wanted to share it. I was working with a my site and uploaded a large image for my user profile image. When it updated my profile, it did what I expected it to do. It put the image into a picture library and the library created a small and medium thumbnail of that image.

SharePoint Database Growth Rates

I am not sure about everyone else, but I have seen SharePoint databases grow out of control. This happens especially when you have people install SharePoint that don’t maintain or even understand SQL Server 2005. I have seen configuration databases around 12GB where 11GB+ of that is all log file. A lot of this is because the configuration and content databases are set to a Full Recovery model by default and full backups do not automatically truncate log files.

Scripting excel trusted file locations in MOSS

It turns out there is an stsadm command for this, so you can script it fairly easily:

%STSADM% -o add-ecsfiletrustedlocation -ssp %sspname% -location %1 -includechildren true -locationtype %LocationType% -allowexternaldata dclandembedded -warnondatarefresh true -abortonrefreshonopenfail false

Full article here:

SharePoint: Resolve DCOM Errors

Follow the steps outlined to resolved DCOM errors on Windows 2003 Servers running Microsoft Windows SharePoint Services v3.

Steps for IIS WAMREG admin service

Step 1: Click Start, Click Run, type dcomcnfg and click ok

Step 2: Expand Component Services / Computers / My Computer / DCOM Config

Site Collection Logical Architecture

This post is probably not relevant to most people, but I keep running into the same discussions with companies that are setting up SharePoint for the first time or have already set it up and are asking a lot of questions about why their environment is not as flexible as they thought it was going to be. I also seem to get into discussions about this with other SharePoint integrators who don’t feel that this topic is important. Maybe they assume people already know the concept or maybe they don’t understand it themselves.

ISSUE - Deleted SharePoint document library re-appears in Outlook 2007

Issue: After syncing a document library to Outlook, our user tried to deleted it. A short time later, it reappeared! In the example below,the folder of note is the “My Site – Private Documents” folder at the bottom of the Outlook folder list:

 

Using the content query web part with a custom query

 

As you may have noticed, I am on a content query web part (CQWP) kick these days… J Here is one more installment in the saga… I have a requirement to create a CQWP that shows the pages in a pages library that have a custom date field that is between today and a week from today. I tried to do this via the CQWP UI but that UI won’t let you enter in a date in the format of Today + 7; it only allows you to specify a specific date.

 

 

Quick STSADM tip regarding the “Windows SharePoint Services Search” Service.

 

Just a quick little STSADM tip regarding the “Windows SharePoint Services Search” Service.

 

Recently during a MOSS implementation, the WSS Search Service wouldn’t start up with its status stuck on “starting” after filling in the appropriate details.

 

I tried several steps including stopping services, IISRESETs, several changes in CA with no luck.

 

In the end the fix was this simple STSADM command:

 

 

MOSS Usage Log Processing File parsing

Parsing STS logs in SharePoint 2003 was fairly well documented. However, that is not the case yet in 2007.

First, there is an additional 300 bytes added to the head of each log file. The additional 300 bytes contains the text “Windows SharePoint Services HTTP log file” followed by space characters making up the difference. You can simply ignore these.

Secondly, the header of the each entry appears to have grown as well, including the ordering of the definition.

Setting SPListItem Moderation Status In C#

I ran into something simple today when I was writing a new event receiver for my current gig at Shaw AFB. The event handler itself was very simplistic. All it does is reference a piece of metadata within the SPListItem being uploaded into a document library, and based on that piece of metadata, route the document to possibly other locations, in this case a different instance. Besides the obvious limitation of the SPFile.MoveTo() function not being able to go cross-sites (which, honestly, I really despise since the method name is misleading IMHO), I had to set the the moderation status of the SPListItem being consumed within a seperate method via passing it in by a parameter to pending.

KB Articles:

Description of the SharePoint Server 2007 hotfix package for SharePoint Server 2007 and for SharePoint Server 2007 for Search: May 31, 2007

Description of the Windows SharePoint Services 3.0 hotfix package: May 31, 2007

Getting a SharePoint Field Value In C#

Someone asked me this morning when doing a code review of my code how I got a field value. They were not looking very closely. Here is how I do it, although there are 50,000 other ways of doing it.

This is my getFieldValue helper method, that will be called at other instance points throughout the code.

Return Your SharePoint List Items In XML

A reader (people read this crap?!?!?!) asked me how to return SharePoint list items in XML. It’s very easy!

Say you want to run a simple return with some very simple parameter types:

Select For Unformatted Code

C#:

Creating the Clear List Items Capability for WSS v3

BackgroundI was developing a multi-threaded SharePoint application that added a lot of items to a list during the course of testing. To reset my test environment, I had to go in and manually delete all of the list items. Even using the datasheet view, this got quite tedious and time consuming. I think I had over 10,000 items in the list at one point in the testing.  So, as is quite common for me, laziness at doing one task (clearing the list) prompted me into doing another task (creating a feature to clear list items).  My RequirementsMy first requirement was that I needed the ability to clear out all of the list items in one shot.

Kerberos Authentication Fun

As many true admins of Sharepoint are aware Kerberos Authentication is the preferred method to set up in our environments. I was talking to a few people over the past week and have been mulling over the possibility of doing a Screen Cast on setting up Kerberos on a single web application in my lab and sharing it out to everyone…. I may still do this in the next week but before I do I want to explain a little brain cramp I experienced recently as it has been a while since working with this…. Most of my clients have been happy going with NTLM authentication so the less you use it and the older you get (or I get) you forget some things.

WSS FAQ additions and changes LX - 18th - 24th June 2007