SharePoint 2007 Maximum Limitations

The following is a list of names and other parameters with the maximum allowable size of each

Entity

Max Permissible Size

Site Name

128 characters

Site URL

255 characters

Display name

128 characters

Connections diving

384 characters

Email address

128 characters

Version numbers

064 characters

Virtual Server Friendly Name

064 characters

SQL Database Name

123 characters

SQL Database Column

128 characters

SQL Database Table Name

128 characters

SQL Role Name

128 characters

Server Name

128 characters

Windows User Name

300 characters

Windows Password

300 characters

Dependencies per object

032 objects

Zone enumeration value

004 zones

Default SQL command timeout

300 seconds

Number of simultaneous workflows that can be run*

15

If during your course of using the product, you inadvertently cross these limits, then you would end up with errors. These are hard limits.

* This is the maximum number of simultaneous workflows that can be in memory executing code. (NOTE: there is no limit to the number of workflow instances in progress in the database)

Via Harsh

Get a hotfix without calling MS

You can now request hotfixes via the web. This saves time phoning up a MS customer service operator, explaining the problem, hot fix number and product the hot fix relates to.

Hotfixes that haven't been made public are also available.

Screen shot of the MS Hotfix Request Form

https://support.microsoft.com/contactus2/emailcontact.aspx?scid=sw;en;1410&WS=hotfix

Tip - Quickly find out an assembly's public key

When working with MOSS / WSS you need to find out the Public Key Token of your assembly for a feature, manifest or the web.config file.

One of the ways to retrieve the Public Key Token is to build the project (making sure the assembly is signed) and drop the assembly in the Global Assembly Cache (GAC).

You can however use the SN.EXE (.NET Strong Name Tool) with the -T parameter (please note the uppercase -T).

For example:
sn.exe -T MyAssembly.dll

SharePoint 2007 menu item feature - attach to debugger

The SharePoint team have posted an article about adding a new menu item to the site actions allowing users to easily debug SharePoint 2007. The updated menu looks like:



http://blogs.msdn.com/sharepoint/archive/2007/04/10/debugger-feature-for-sharepoint.aspx

SharePoint 2007 SQL Server Failure Audits in Event Log

Q. Are your event log's getting full of SQL Server Failure Audits for a service account or database access account you have created for MOSS?

Q. Have you also re-installed MOSS?

If you have answered yes to both of the above questions then you will have SQL Server Agent Jobs that are associated with old Shared Services databases running.

To resolve this

1. Open SQL Server Management Studio.
2. Expand SQL Server Agent.
3. Expand Logs.
4. Open the current log and look at the messages.
5. You should see error messages like: Cannot open database "SharedServices3_DB" requested by the login. (see figure 1).
6. Expand Jobs.
7. You should see jobs named in the following format "[SSP]_[DB]_DeleteExpiredSessions" for example: SharedServices1_DB_Job_DeleteExpiredSessions" (see figure 2).
8. Disable the jobs that don't relate to current Shared Services databases.
9. Verify that the failure audits are no longer logged.
10. Delete the disabled jobs.

Figure 1:



Figure 2:



Hope you find this helpful, it took ages to track the culprit down.

MOSS Case Study - Endsleigh Insurance

Endsleigh Insurance
Employees Gain Better Access to Corporate, Industry Information with Enterprise Search.

Read how we (CIBER UK) helped Endsleigh Insurance migrate from their SharePoint 2003 platform and improve productivity using MOSS and enterprise search.

http://www.microsoft.com/casestudies/casestudy.aspx?casestudyid=4000000373

SharePoint 2007 Running SPSecurity.RunWithElevatedPrivileges

In SharePoint Portal Server 2003 you may have needed to impersonate a user with higher priveledges than the current user executing the code. You did this using WindowsIdentity.Impersonate() method. In SharePoint 2007 and WSS V3 you have SPSecurity.RunWithElevatedPrivileges call. The code looks like:

SPSecurity.RunWithElevatedPrivileges(delegate() {

  // put your code here.  any code within these curly brackets will run with SharePoint system rights 

});

For more information see SPSecurity.RunWithElevatedPrivileges Method on MSDN.

Please note: If you use the SPControl.GetContextSite(this.Context) within the SPSecurity.RunWithElevatedPrivileges call or have an variable defined before the call this will use the current user's rights and not the system's. For example:

SPSecurity.RunWithElevatedPrivileges(delegate() {

using (SPSite site = SPControl.GetContextSite(this.Context))
 {

 // site will be based on the current user that executes this code

 }


});

You should use:

SPSecurity.RunWithElevatedPrivileges(delegate()
{
    using (SPSite site = new SPSite(web.Site.ID))
    {


      // site will be based on the rights for the system account

    }

});

MOSS SDK download updated

The MOSS 2007 SDK download has been updated and ready for download http://www.microsoft.com/downloads/details.aspx?familyid=6d94e307-67d9-41ac-b2d6-0074d6286fa9&displaylang=en.

Overview
The Microsoft Office SharePoint Server 2007 SDK is designed for solution providers, independent software vendors, value-added resellers, and other developers to learn about the new Office SharePoint Server 2007 enterprise application and platform. It features conceptual and "How to" articles, sample code, and programming references.

The download file OfficeServerSDK.exe provided for the SharePoint Server 2007 SDK contains the following:

• Compiled HTML Help files (updated with new content since RTM), OSSSDK2007.chm and WSS3sdk.chm, which contain conceptual topics, Class Library and Web Service References for SharePoint Server 2007 and Microsoft Windows SharePoint Services 3.0.
• Code samples that relate to topics in the SDK: Business Data Catalog metadata samples, Custom Single Sign-On Provider, SampleWebService, and Custom Filter Web Parts. The sample projects use Microsoft Visual C# and Microsoft Visual Studio 2005.
• Enterprise Content Management Starter Kit.

Also included in the SharePoint Server 2007 SDK, the Enterprise Content Management (ECM) Starter Kit is designed for solution providers, independent software vendors, value-added resellers, and other developers to learn about how to extend the new ECM features and platform in Office SharePoint Server 2007. It contains the following:

White Papers

• 2007 Office System Digital Signatures Developers Guide
• 2007 Office System Encryption Developers Guide
• Information Rights Management - Pluggable Rights Management, Technical Overview
• Importing Custom Actions into SharePoint Designer
• Workflow Security Topics

Code Samples

• Content Processing
• Term Replacement Document Inspector Module
• Document Converters (server-side custom property remover, docm-to-docx converter)

Records Management and Policy

• De-Duplication Router
• Document Integrity Verifier
• Records Repository Web Service Console Application
• Search, Collect, and Hold Tool
• Default Site Policy

Workflow

Note: The following workflow samples are meant to demonstrate concepts and provide a starting point for extension. They are not the same workflows that are included with Office SharePoint Server 2007.

• Custom Reports
• ECM Activities
• List Item Activities
• Hello World Sequential Workflow
• State Based Approval Workflow
• Modification Workflow
• Replication and Contact Selector Workflow ASPX Collect Feedback Workflow
• Intersystem Purchase Order
• Confidential Approval
• Group Approval
• Review Workflows
• Collect Feedback Workflow
• Multi-Stage Workflow
• Server-side Collect Signatures Workflow

Visual Studio Project Templates for SharePoint Server 2007 workflow

• SharePoint Server Sequential Workflow Library
• SharePoint Server State Machine Workflow Library

You can also view the Microsoft Office SharePoint Server 2007 SDK in the MSDN Library.

WSS V3 SDK download updated

The WSS V3 SDK has been updated and ready for download http://www.microsoft.com/downloads/details.aspx?FamilyID=05e0dd12-8394-402b-8936-a07fe8afaffd&DisplayLang=en

Overview
The Windows SharePoint Services 3.0 SDK contains conceptual overviews, programming tasks, and references to guide you in developing solutions based on Windows SharePoint Services as a platform. The SDK includes information about the following technologies:

• Web Part Framework Create, package, and deploy Web Parts on SharePoint sites.


• Server-side object model Work with individual lists and sites or manage an entire Windows SharePoint Services deployment.


• Web services Use default Web services, or create custom Web services, to interact with Windows SharePoint Services from external applications.


• Collaborative Application Markup Language (CAML) Customize the schemas that define lists and sites, define queries for use with members of the object model or Web services, and specify parameters for use with methods in Remote Procedure Call (RPC) protocol.


• Master Pages Specify all of the shared elements of your site in the master page or pages, and add content page-specific elements to content pages.


• Workflows Create workflows that encapsulate business processes to be performed on items in Windows SharePoint Services, and attach those workflows to items in Windows SharePoint Services.


• Custom Field Types Create custom field types that conform to your business data. These custom field types can be based on the base field types already included in Windows SharePoint Services, and can include custom data validation, field rendering, and field property rendering and processing.


• Information Rights Management (IRM) Specify IRM for files located in document libraries and stored as attachments to list items. Create IRM protectors for your own custom file types.


• Document Property Promotion and Demotion Use the built-in XML parser to synchronize the document properties and list column data for XML documents. Create document parsers to do the same for your custom file types.


• Search Use the new Query object model and Query Web service to retrieve search results. Search in Windows SharePoint Services now shares the same SharePoint search technology used by Microsoft Office SharePoint Server 2007.

Also included is the Workflow Developer Starter Kit for Windows SharePoint Services 3.0, which helps solution providers, independent software vendors, value-added resellers, and other developers write custom workflows for Windows SharePoint Services 3.0. It contains the following:

Visual Studio Project Templates

• Sequential Workflow Library
• State Machine Workflow Library

Sample Custom Workflow

• Simple Collect Feedback using ASPX forms

You can also view the SDK documentation online http://msdn2.microsoft.com/en-us/library/bb264594.aspx

Adding web.config settings to you WSS or MOSS site

This article describes how to add web.config settings automatically to your new web applications under WSS V3 and SharePoint 2007.

You need to create a file in the format of webconfig.[name].xml, copy the file to C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\CONFIG folder and the settings in the file will be merged with the web.config file on any new web application. Unfortunately this only works for new web applications, if you put the file in the config folder no changes will be applied on existing web applications.

The example below adds a key to the appSettings and a database connection string to the connectionStrings section.

<?xml version="1.0" encoding="utf-8" ?>
<actions>
  <add path="configuration/appSettings">
    <add key="MyFilePath" value="C:\temp\path\" />
  </add>
  <add path="configuration">
    <connectionStrings />
  </add>
  <add path="configuration/connectionStrings">
    <remove name="MySqlServerConnection" />
    <add name="MySqlServerConnection" connectionString="server=[server];database=[db];Integrated Security=SSIP;" providerName="System.Data.SqlClient" />
  </add>
</actions>

Blog tools - Colour code you C#, HTML or XML code

I found this great tool for formatting your code ready for your blog. http://www.manoli.net/csharpformat/.

Turns this:

<Elements xmlns="http://schemas.microsoft.com/sharepoint/">
<FeatureSiteTemplateAssociation Id="4DEFA336-EDC4-43cb-9560-FE2E27E76DFB" TemplateName="SPSPERS#0"/></Elements>

Into this:

<Elements xmlns="http://schemas.microsoft.com/sharepoint/">


<FeatureSiteTemplateAssociation Id="4DEFA336-EDC4-43cb-9560-FE2E27E76DFB" TemplateName="SPSPERS#0"/></Elements>

In just a couple of seconds.  The styling is achieved using CSS.

SPS Site Template - Is it really obsolete?

Venkat Varkala discusses in his post whether the SPS site template is infact obsolete. In the webtempsps.xml you have the following:

<Template Name="SPS" ID="20">
<Configuration ID="0" Title="SharePoint Portal Server Site" Type="0" Hidden="TRUE" ImageUrl="../images/spshome.gif" Description="This template is obsolete."></Configuration>
</Template>

When Microsoft refer to this template being obselete they mean it's obselete from the create site template picker page and shouldn't be set to visible. The "SPS" folder is still an integral part of portal site creation.

The SPSPORTAL site template (declaration below) doesn't have a folder in the 12 Hive (under 12\template\sitetemplates). This could be classed as a virtual site definition.

<Template Name="SPSPORTAL" ID="47">
<Configuration ID="0" Title="Collaboration Portal" Type="0" Hidden="FALSE" ImageUrl="/_layouts/1033/images/template_corp_intranet.png" Description="A starter site hierarchy for an intranet divisional portal. It includes a home page, a News site, a Site Directory, a Document Center, and a Search Center with Tabs. Typically, this site has nearly as many contributors as readers and is used to host team sites." ProvisionAssembly="Microsoft.SharePoint.Publishing, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" ProvisionClass="Microsoft.SharePoint.Publishing.PortalProvisioningProvider" ProvisionData="SiteTemplates\\WebManifest\\PortalWebManifest.xml" RootWebOnly="TRUE" DisplayCategory="Publishing" VisibilityFeatureDependency="97A2485F-EF4B-401f-9167-FA4FE177C6F6">
</Configuration>
</Template>

This template uses the files from the "SPS" folder when the site is created. The definition and structure of the site is defined by ther webmanifest.xml. The webmanifest.xml defines the Site Definition the virtual Site Template should be based on and what sub sites should be created.

<portal xmlns="PortalTemplate.xsd"><web name="Home" siteDefinition="SPS" displayName="$Resources:spscore,PortalManifest_Home_DisplayName;" description="$Resources:spscore,PortalManifest_Home_Description;">
<webs>
<web name="News" siteDefinition="SPSNHOME" displayName="$Resources:spscore,PortalManifest_News_DisplayName;" description="$Resources:spscore,PortalManifest_News_Description;" />
<web name="SiteDirectory" siteDefinition="SPSSITES" displayName="$Resources:spscore,PortalManifest_SiteDirectory_DisplayName;" description="$Resources:spscore,PortalManifest_SiteDirectory_Description;" />
<web name="SearchCenter" siteDefinition="SRCHCEN" displayName="$Resources:spscore,PortalManifest_SearchCenter_DisplayName;" description="$Resources:spscore,PortalManifest_SearchCenter_Description;" />
<web name="Docs" siteDefinition="BDR" displayName="$Resources:spscore,PortalManifest_DocumentCenter_DisplayName;" description="$Resources:spscore,PortalManifest_DocumentCenter_Description;" />
</webs>
</web>
</portal>

Sites are created this way so that they are built the "supported way". Microsoft also say that you shouldn't modify the MySite template on the file system, you should modify the template by using Feature Stapling (see the Microsoft post). Feature stapling involving creating:

• A Staplee - This feature does the work. For example it could provision files in the MySite.
• A Stapler - This feature activates the Staplee feature when a site of a particular site is created.

The following xml is an example of the feature.xml for a Stapler

<Elements xmlns="http://schemas.microsoft.com/sharepoint/">
<FeatureSiteTemplateAssociation Id="4DEFA336-EDC4-43cb-9560-FE2E27E76DFB" TemplateName="SPSPERS#0"/></Elements>

So when customising a portal template you should use feature stapling and site provisioning using the webmanifest.xml.

Visual Studio .NET 2005 - Code Snippets Demo

The above Code snippets demostrates the following snippet types

• Simple expansion
• Template expansion (with variables)
• Surround
  

Open the snippet manager
Ctrl+K, Ctrl+B

To activate a snippet ... start typing the name of the snippet
Tab,Tab (in C#)
?,Tab (in VB.NET)

.. and the snippet will appear. If it's a templated snippet:
Tab advances to the next field
Shift+Tab moves to the previous field
Enter completes the snippet and resumes editing at your previous cursor position

If you want to enclose code in a surrounding snippet (eg, you have code highlighted for a region), you must manually invoke snippet intellisense by pressing: Ctrl+K, Ctrl+X

Information from Jeff Atwood

Hosting UserControls vs Delegate Control

There are two main approaches for adding user controls to your site:

1. Deploying them to the "wpresources" folder
2. Using the DelegateControl

Many people have blogged about each technique, but which is the best or the recommended approach?

Tony Rahbun has posted an article called "WebParticles: Developing and Using Web User Controls as WebParts in Microsoft Office SharePoint Server 2007" http://www.codeproject.com/spoint/WebParticles.asp.

Microsoft's recommended approach is to use the DelegateControl. http://msdn2.microsoft.com/en-us/library/ms463169.aspx.

Advantages of using the DelegateControl over hosting UserControls in the wpresources folder

• Using Solution deployment in SharePoint 2007 you can create a WSP to automate the deployment of your UserControls (stored in the ControlTemplates folder) and Features (used to activate a DelegateControl).
• You can control the scope of the feature.
• More closely integrated with SharePoint.
• If the feature isn't activated the DelegateControl will fall over gracefully. This would enable the component to be hidden if no longer needed.

SharePoint 2007 Supported Browsers and Languages

Supported Web Browsers

• Internet Explorer 6 and 7 are recommended for site administration.
• Firefox 1.5, Mozilla 1.7 Netscape 8.1, Safari 2.0 (Mac) are supported for the front-end.

For more information please see http://technet2.microsoft.com/Office/en-us/library/ff6c5b8c-59bd-4079-8f0b-de4f8b4e0a861033.mspx?mfr=true

Multi-lingual Languages Supported on the front end through variations

• Arabic
• Bulgarian
• Catalan
• Chinese (Hong Kong)
• Chinese (Simplified)
• Chinese (Traditional)
• Croatian
• Czech
• Danish
• Dutch
• English
• Estonian
• Finnish
• French
• German
• Greek
• Hebrew
• Hindi
• Hungarian
• Italian
• Japanese
• Korean
• Latvian
• Lithuanian
• Norwegian (Bokmål)
• Polish
• Portuguese (Brazil)
• Portuguese (Portugal)
• Romanian
• Russian
• Serbian (Latin)
• Slovak
• Slovenian
• Spanish
• Swedish
• Thai
• Turkish
• Ukrainian

The SharePoint Search only fully supports a sub set of the above listed languages.

Multi-lingual languages supported on the back end

• Arabic
• Catalan
• Chinese (Simplified)
• Chinese (Traditional)
• Czech
• Danish
• Dutch
• English
• Finnish
• French
• German
• Greek
• Hebrew
• Hindi
• Hungarian
• Italian
• Japanese
• Korean
• Norwegian (Bokmål)
• Polish
• Portuguese (Brazil)
• Portuguese (Portugal)
• Romanian
• Russian
• Slovak
• Slovenian
• Spanish
• Swedish
• Thai

Download the language pack here http://www.microsoft.com/downloads/details.aspx?FamilyID=2447426b-8689-4768-bff0-cbb511599a45&displaylang=en.

TechNet article about deploying language packs http://technet2.microsoft.com/Office/en-us/library/26c07867-0150-463d-b21a-a6d42aecf05a1033.mspx?mfr=true.

SharePoint 2007 Backup Failed - Cannot open backup device

You may have seen this error Error: Object SharePoint_Config failed in event OnBackup. For more information, see the error log located in the backup directory. SqlException: Cannot open backup device '\\servername\backup\spbr0001\0000001.bak'. Operating system error 5(error not found).

After reading this article http://technet2.microsoft.com/Office/en-us/library/b4dfe06a-40a5-4826-8d4b-1d758a9e621a1033.mspx?mfr=true I resolved the issue. The steps I took were:

• Set the SQL Server (MSSQLSERVER) Windows service to run as a domain account. Will require a restart of the service and IIS.
• Setup sharing on the backup folder. Grant access for the identity that the Central Administration Application Pool runs under, the database SQL account, the identity that the Timer service runs under, to change and read rights.
• On each of the SharePoint servers check you can access the share.
• On each of the database servers check you can access the share.
• Set the folder security, grant privledges for the identity that the Central Administration Application Pool runs under, the database SQL account, the identity that the Timer service runs under to all rights apart from Full Control.

This will fix backups that are performed using SharePoint 2007 Central Administration.

If you are running backups from STSADM you will need to grant access to the share and write access to the folder security for the user that runs the STSADM -o backup command.

Use Cases vs Requirements

I'm about a quarter of the way through MCPD 70-547 Designing and Developing Web-Based Applications using Microsoft .NET Framework, I have already picked up some good tips. One that comes to mind is about Use Cases and Requirements.

Mike Snell talks about why you need both use cases and requirements. His mentions a real world example, in which he takes two projects. One project captures the requirements in the form of use cases only and the other with solely requirements. Mike wrote the other half (in the use case project he wrote the requirements and in the requirements project he wrote the use cases), he found that:

• Requirements that were written using the use cases were open to interpretation. This often meant key requirements were missed.
• A project containing use cases can be quickly translated into test cases.

Requirements serve one purpose and use cases serve another. To fully capture the requirements you need both.

I would recommend reading this book, even if you don't want to take the exam.

SharePoint 2007 Virtual Labs

Here's a list of SharePoint 2007 Virtual Labs

• Building InfoPath Forms that Run as Both Rich Client and Browser Applications Virtual Lab - become familiar with browser-based scenarios for Office InfoPath 2007 forms.
• Creating Workflows for Microsoft Windows SharePoint Services 3.0 Virtual Lab - learn how to create workflows for Office SharePoint Server 2007
• Getting Started with the Business Data Catalog in Microsoft Office SharePoint Server 2007 Virtual Lab - learn to build the metadata file that will connect SharePoint Server 2007 to the SQL Server 2005 AdventureWorksDW database and to register the AdventureWorksDW metadata file with SharePoint Server 2007
• Introducing Content Types for Microsoft Windows SharePoint Services 3.0 Virtual Lab - the objective of this lab is to provide a walkthrough of content types and new property editing functionality in Windows SharePoint Services 3.0.
• Microsoft Office SharePoint Server 2007 Enterprise Features Administration Virtual Lab - learn about the administration of InfoPath Forms Services and Excel Services, components of the Enterprise edition of Office SharePoint Server 2007.
• Microsoft Office SharePoint Server 2007 Records Management Deployment and Configuration Virtual Lab - learn about the Record Management capabilities included in Microsoft Office SharePoint Server 2007. Topics include creating content types for categorizing documents, configuring a central records repository, setting up records management policies, and available options for automation.
• Microsoft Windows SharePoint Services Installation and Configuration Virtual Lab - learn about the enhanced backup and restore options for Windows SharePoint Services 3.0. Topics include the multi-level Recycle Bin, the new browser-based user interface, and new options for the command line (stsadm.exe) interface.
• Microsoft Office SharePoint Server 2007 Installation and Configuration Virtual Lab - Learn about the installation and configuration options available in Microsoft Office SharePoint Server 2007, such as installing a new farm, configuring global workflow settings, configuring incoming e-mail, administrative tasks, farm topology, provisioning new web applications and configuring alternate forms based authentication.
• What’s New in Microsoft Office SharePoint Server 2007 Feature Walkthrough Virtual Lab - learn about the new features in Microsoft Office SharePoint Server 2007 including integration points with Microsoft Office 2007 programs.
• What’s New in Microsoft Windows SharePoint Services 3.0 Feature Walkthrough Virtual Lab - learn about the new and enhanced features in Windows SharePoint Services 3.0 such as site creation, site administration, adding Web Parts, the permissions trimmed UI, list settings, navigation, list and library security, notifications, and email integration.
• Enterprise Search: Protocol Handlers Virtual Lab
• Business Intelligence: Building Integrated BI Solutions Leveraging SQL 2005 and Office 2007 Servers Virtual Lab - learn how to: Successfully created a SharePoint site, Add it as a trusted site in Excel Services, Created a Report in Excel, Populated it with data from a cube, Store your connection and your workbook in SharePoint Libraries, Publish a chart and a workbook, Create a dashboard and populated it with your chart and KPI’s based of the data in your report.
• Forefront Security for SharePoint Virtual Lab - learn about scanning documents for viruses, running a Manual Scan Job using Forefront Secuirty for SharePoint.
• Synchronizing data between SharePoint 2007 and Groove 2007 Labcast - Understand the benefits of using Groove and SharePoint together. Learn how to create a Groove account, and a Groove workspace. Learn how to add the SharePoint Files tool to the workspace. Learn how to bring data from SharePoint into the workspace. Learn how to edit and save data within a workspace. Learn how to synchronize data back to SharePoint from Groove. Learn how to work with the Groove Issue Tracker forms template in a workspace.

TechEd IT Forum 2007 - Powered by SharePoint 2007

Microsoft's website for TechEd IT Forum 2007 (12-16 November 2007 Barcelona, Spain) is built upon SharePoint 2007. It's also a nice example of a usable flash / html mix site which doesn't look like a typical SharePoint 2007 site.

http://www.mseventseurope.com/teched/07/itforum/pages/default.aspx

Removing hidden and damaged webparts from a page

You can remove hidden or damaged webparts from a page by appending "?contents=1" to the url (if the url already contains a querystring parameter replace "?" with "&"). This will bring up a screen listing all the webparts on the page (both visible and hidden). You can then select any web part and remove it.

If a webpart is causing significant damaged to a page (ie throwing an exception which isn't handled in the webpart) then you should see a SharePoint error page with a link to the remove webparts from the current page.

Devil wears Prada featuring Microsoft Exchange Unified Messaging

Not sure how geniune this is, but worth taking 5 minutes out to watch :)

Are your labels getting out of hand?

If you use http://www.blogger.com/ and the label widget you may find that you have too many links displayed under the labels section ... I did.

There aren't any properties to restrict how many links appear. After looking through the html of the template, you can add an if clause to only show labels if they appear more than once. You will need to find the label widget with the HTML of the template and add the lines hightlighted.

<b:widget id="'Label1'" locked="'false'" title="'Labels'" type="'Label'">
<b:includable id="'main'">
<b:if cond="'data:title'"> <h2><data:title/></h2></b:if>
<div class="'widget-content'">
<ul>
<b:loop values="'data:labels'" var="'label'">
<b:if cond="'data:label.count > 1">
<li>
<b:if cond="'data:blog.url">
<data:label.name/>
<b:else/>
<a href="'data:label.url'"><data:label.name/></a>
</b:if> (<data:label.count/>) </li>
</b:if>
</b:loop>
</ul>
<b:include name="'quickedit'/"> </div>
</b:includable>
</b:widget>

You will need to replace ">" within the if statement with the HTML character code. Also increase 1 if you want to show labels with more than 3, 4, 5, 6 ... for example.

Complete list of STSADM operations (with parameters) in SharePoint 2007

Jose Barreto wrote a great reference article on the STSADM operations and the parameters.

http://blogs.technet.com/josebda/archive/2007/03/22/complete-reference-of-all-stsadm-commands-with-options-in-moss-2007.aspx

STSADM Import / Export

STSADM has two operations called "import" and "export".

Export allows you to backup a copy of a site to the file system. This will generate one or more .CMP files (based on the size of the site, this will distribute the contents over many .CMP files).

Import allows you to take the files generated by an export and import over a blank SharePoint Site.

Please note: Both Import and Export operations for STSADM deal with an entire site. You can not export or import individual items such as lists or items.

I used Import / Export during a migration to restructure the sites. Basically I had a collection of WSS sites for active projects and a collection of WSS sites for archive projects which weren't logically organised. I wanted to introduce a level for the active projects and another level for the archive projects. I created these levels (active and archive) in SharePoint through the standard create site function. I then need to move the archived sites under archive and active under the active site. This process is often referred to a re-parenting. I did this using STSADM and the Export operation and the Import operation (see below).

STSADM -o export -url http://localhost/ProjectSite1 -filename c:\export\ProjectSite1 -includeusersecurity
STSADM -o createweb -url http://localhost/Archive/ProjectSite1
STSADM -o import -url http://localhost/Archive/ProjectSite1 -filename c:\export\ProjectSite1.cmp -includeusersecurity

Please note: By using the parameter "includeusersecurity" it preserves the current user, rights for the site. This is an optional parameter, but very useful.

The createweb operation creates a blank site for the import to write the contents of the export over. You shouldn't specify a sitetemplate as you just need a blank container (the template is defined in the export .CMP files).

STSADM is a command line tool, so you could wrap these commands in a batch file.

Please see my post about errors when using the Import / Export commands here.

Microsoft Demo: Configure a SharePoint Server 2007 Site to Receive E-Mail

Overview - By configuring your Office SharePoint Server 2007 site to receive e-mail messages, you can enable team members to use e-mail to send information, messages, and files directly to different areas of the site.

http://www.microsoft.com/downloads/details.aspx?FamilyID=c910a323-164d-4fad-8646-64872ffe4c46&DisplayLang=en

MOSS & WSS Management Packs

MOSS and WSS V3 Management packs for Operations Manager 2007 (MOM)

• WSS V3 download
  http://www.microsoft.com/downloads/info.aspx?na=22&p=8&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3d6803aa1d-0578-4d7d-bc2f-9600f0440d92%26DisplayLang%3den

• MOSS 2007 download
  http://www.microsoft.com/downloads/info.aspx?na=22&p=9&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3de7bfee42-2d3c-4810-97f8-4d89d7428a5f%26DisplayLang%3den

For more information on MOM http://www.microsoft.com/mom/default.mspx

Guidelines to Design and Develop Acessible Websites

Microsoft whitepaper - Guidelines to Design and Developer Accessible websites using MOSS 2007, MCMS and SharePoint 2003

http://www.microsoft.com/downloads/info.aspx?na=22&p=12&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3d35487ef8-8e92-4f3b-96bf-2dfd7f4602d2%26DisplayLang%3den

Hands on labs for Windows Workflow Foundation (WF)

http://www.microsoft.com/downloads/details.aspx?familyid=2e575633-e357-4ee7-aaff-34138f00e830&displaylang=en

Windows Workflow Foundation gives you the building blocks (model, engine and tools) to enable you to create workflow enabled applications on the Windows platform. The download contains 10 hands-on labs in C# and VB.NET. MSDN has more information about Windows Workflow Foundation.

Labs include:

• Getting started with Windows Workflow Foundation
• Creating Custom Activities
• Hosting Workflows
• Creating State Machine Workflows
• Communicating with the Host Application
• Workflow and Web Services
• Creating Rules Driven Workflows
• Transactional Behavior in Workflow
• Modifying Workflow Models at Runtime with Workflow Change
• Embedding the Workflow Designer