21
Jun
07

Sharepoint link love 06-21-2007

Incoming email on MOSS 2007

This post is not about how to configure incoming email (there is a GREAT white paper on the subject here: http://www.combined-knowledge.com/Downloads%202007.htm ). Instead, I will focus on an issue that I ran into while setting it up in a server farm environment with Microsoft Forefront Security. Forefront was installed on both of the front-end web servers.

MOSS 2007 Spell Check Issue

For months we have been having a problem with spell check in my environment where non-admin users were unable to run spell check within MOSS and receive the error “Spelling did not complete properly. If this problem persists, notify your system administrator.”

In my case, users have Read access across the portal except to certain sub-sites where they are given Contribute and other permissions. As it turned out, the library for the custom dictionary that I had created also only had Read permissions for general users. Changing their permissions to Contribute solved the problem.

Custom Cross List Search Development Pitfalls (Part One)

This is the first of two posts about developing custom cross-list search solutions using either MOSS or WSS 3.0. The two part series will compare and contrast developing cross-list search solutions with MOSS and WSS. This will include issues you should be aware of relating to metadata management, accuracy of results and UI presentation of fields to query against.

Custom Cross-List Search Development Pitfalls (Part Two)

In my previous post Custom Cross-List Search Development Pitfalls (Part One) I talked about the importance of managing Meta data in order to provide effective ways for users to search for documents. Meta data can be managed via “Managed Properties” in MOSS or having some concerted policy and standards for naming of columns in WSS. In Part One I illustrated a scenario where a column could be renamed to a display name that was also was being used on another document library.

Adding table headers and/or footers to a Content Query Web Part Layout

Ah the Content Query Web Part (CQWP)… This little guy is a pretty powerful mechanism for displaying different views of the data within your MOSS 2007 installation. The problem I had to solve today was how do I get properly formatting table where there is a table header row with column headings and then each element returned by the query shows up as a row within the table.

Importing and exporting webparts in SharePoint 2007 using the object model

I have been working on a little utility to move webparts from one site to another using the ImportWebPart and ExportWebPart methods of the SPLimitedWebManager class. Here are already some code snippets which give you an idea what I’m doing…. I’m also going to incorporate some ideas which I found in this blog posting - Customizing MOSS 2007 My Sites within the Enterprise.

Adding custom fields to the Enhanced Content Quey Web Part (Beta 1.2)

I just got around to adding another important feature to the Enhanced Content Query Web Part and I uploaded it to codeplex.
I am sure you read my articles, or articles by other MVPS like Heather about showing custom columns in the content query webpart. This requires (as Heather’s article shows) that you export the web part to a file, manually modify the file to add the fields you want, and import it back.

Modifying the Workflow Association Data in SharePoint 2007 Pre-Initiation

One of our customers wanted to use the out-of-the-box Approval workflow but wanted to pre-fill the Approvers field with users from the items metadata. In another words, each document in a document library can potentially have a difference approver so rather than have the Approvers field pre-filled from the initial Association data, they want it populated from the Approvers field on the initiated item.

Download! Using the Business Data Catalog and Smart Tags

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.

Windows SharePoint Services Document: Application Templates for Windows SharePoint Services 3.0 – Under the Hood

This white paper describes how Microsoft developed the Application Templates, identifying best practices for how to work with core capabilities within both Microsoft Windows SharePoint Services and Microsoft Office SharePoint Designer 2007, with the goal of empowering customers and partners to create their own applications.

Adding New SSP Administrators

Delegating administration duties for a SharePoint Shared Service Provider (SSP) separates duties while keeping the environment secure and practicing the principle of least privilege. The process to grant access to other administrators might not be so obvious at first because you do not assign all SSP permissions in the Site Permissions section using SharePoint groups as one might expect.

When you add a new user account to the SSP site, even if you grant them Full Control permissions or add them as a Site Collection Administrator, initially they will experience access denied error messages when they click on any of the following links:

Governing Programs and Projects with SharePoint KPI’s

t has been awhile since I posted a video and I hope you like this one. In looking at the new features of SharePoint Server 2007, I started looking into KPI’s — or Key Performance Indicators — and how they can support programs and projects. This is a nice new feature and although maybe not as full-functioned as you might want it is still very powerful.

Development Tools and Techniques for Working with Code in Windows SharePoint Services 3.0 (Parts 1 and 2)

We just published a must see paper written by Patrick Tisseghem of U2U, Mike Fitzmaurice, and heavy consultation from Mike Ammerlaan:

Development Tools and Techniques for Working with Code in Windows SharePoint Services 3.0 (Parts 1 and 2)

Don’t name the URL for a sub-site ‘CON’ in MOSS 2007

n trying to create a team site for a department called …/Commercial/Content, I use short names (e.g. …/CML/CON). Apparently CON is some kind of a system no-no. I have not searched on this problem, so there may be information posted out there on this issue somewhere:

When creating a site in Microsoft Office SharePoint Server (MOSS) 2007, the URL cannot be …./con

Displaying Current User Information in WSS v3

Here’s a tip that’s really simple but I had a number of people ask me about it at TechEd so I thought I’d post it here.  Apparently it’s a common requirement to display user information, such as name, login name, or email address on various master and layout pages throughout a site.  Although the Welcome/Login control at the top of the page shows the name of the currently logged in user, either people are removing this control or simply need the information duplicated elsewhere on the page.

Versioning WebParts and SharePoint Solution Deployment caveats

The scenario is the following: Version one of a WebPart is developed and deployed to the SharePoint farm using Solution Deployment. The solution Manifest.xml contains the assembly reference to deploy the assembly to GlobalAssemblyCache and further more the SafeControl definition.

When deploying the solution, the assembly will be placed in the GAC and a SafeControl entry will be written to the web.config files of the selected WebApplications. You are now ready to create the WebPart definition and start using the little wonder.

SharePoint Designer Workflow Tips

I spent some time this week creating workflows in SharePoint Designer. I have done SharePoint workflows in Visual Studio before, but this was my first time using Designer. I was surprised at how powerful it is, and yet also confused at several points as to how the UI worked.

One particular thing I wanted to do was collect some information from the user at various points in my workflow. There is an imaginatively named Collect Data from a User workflow action to do just this. It gives me a wizard where I can define the data items I want to collect.

MOSS 2007 - community WCM code samples

we would like to announce three new CodePlex projects created to enable the community to share examples of useful Publishing site elements built using the Web Content Management features of Office SharePoint Server 2007.

Backup Script for MOSS 2007

As you have seen from previous posts, I am a big fan of Disaster Recovery planning.  Having a good backup in place should allow you (and your business users) to sleep better at night… knowing that your SharePoint data is protected.

MOSS 2007 has some fantastic backup/restore functionality… but it still doesn’t have a scheduler.  However, it is possible, like with SPS 2003, to create a batch job to use the stsadm tool for a scheduled backup.

SharePoint 2007 Flash Animation Web Part

Register ‘Reads’ for Office SharePoint Server 2007

The Register has compiled a list of suggested reading on MOSS. I can’t endorse any particular book but the Register has provided a brief overview of each title.

http://www.regdeveloper.co.uk/2007/06/20/register_books_june/

Preventing users to add a beer that already exists in the beer list (or, how to work with the ItemAdding event)

I have a good crowd here in Sydney. They keep me busy with lots of interesting questions. I still have no news though regarding my bags so I went again to the shops and bought the things that a man needs abroad (socks, underwear and some shirts) J.

Anyway, question from a student was: ‘How can we using an event handler to prevent a user from adding an item in a list that is already there?

SQL Server 2008 - Helping SharePoint Scale cost effectively

With the covers coming off the SQL Server 2008 (Katmai) I have been looking at how this may impact on SharePoint.   When we first started to introduce WSS v2/SPS 2003 there was often comments from people:

“You store the documents in SQL Server!”

alerts

this past weekend we had a sharepoint farm where we needed to detach the databases and reattach them to a different web application.

this can break a lot of things, dr watson has a good list of some of them.

i’m going to focus on alerts and how to fix them (yep they break)

first of all there is a nice chunk of sample code to help fix this but its incomplete:

http://support.microsoft.com/default.aspx?scid=kb;en-us;936759

here’s the piece of code we care about:

A Pre-configured MOSS 2007 Virtual Machine from Microsoft Download Center


0 Responses to “Sharepoint link love 06-21-2007”


  1. No Comments