SharePoint 2007 How To List

After several projects implementing MOSS 2007 and WSS 3.0 I’ve collected a large list of “How to …” type links.  I’d like to share these with you, feel free to send me comments to add to this list:

• Access document libraries from File Explorer
• Add a link to the portal from a MySite
• Add presence-pawn to SharePoint contacts list
• Adjusting the top level navigation on all My Sites
• Build Employee Directory Web Part
• Conditional Formatting in SharePoint Lists
• Configure Alternate Access Mappings (AAM)
• More About Alternate Access Mappings (AAM)
• Create a Create Custom Site Theme
• Customize application pages in the Layouts folder
• Customizing Alert Notifications and Alert Templates
• Customizing Content Query Web Parts by Using Custom Properties
• Customizing Search Results with Custom XSLTs
• Customizing simple.master
• Debugging HTTP Web – Fiddler
• Deleted Site Link
• Design SharePoint Taxonomy
• Display an AD group in a SharePoint DataView
• Display Custom Fields in Content Query Web Parts
• Display PDF Icons and apply PDF ifilter
• Enable Email to List of Document Library
• Exclude a site collection from being indexed for a global search
• Extend Wildcard People Search
• Filter Profile Import via LDAP query
• Filtered Lookup Lists in SharePoint
• Hide a Site Template
• Import User pictures from Active Directory
• Install and configure MOSS 2007 successfully
• Migrate Documents from SharePoint 2003 to SharePoint 2007
• Personalize Data in Excel Services
• Renaming a MOSS Server
• Rollup Content from multiple Site Collections
• Setting Hyperlink Field in List
• Setup Cross-forest Active Directory deployments
• Slide Libraries Let You Reuse Content and Design
• Use ASP.NET 2.0 Code Behind Files in SharePoint 2007 Sites
• Use MySitesCreate to apply Intranet Branding

Configure MOSS 2007 Site Usage Reports

SharePoint 2007 has built in usage reports that can easily be enabled to allow site administrators and site collection administrators to monitor statistics about the use of their sites. These reports are NOT turned on by default when install MOSS 2007.

Three Quick Steps to Configure Site Usage Reporting

1. Enable Usage Logging in Central Administration
   

   A. On the Central Administration home page, click Operations.

   B. On the Operations page, in the Logging and Reporting section, click Usage analysis processing.

   C. On the Usage Analysis Processing page, in the Logging Settings section, select Enable logging.

   D. Type a log file location and number of log files to create.

   E. In the Processing Settings section, select Enable usage analysis processing, and then select a time to run usage processing.

2. Enable Usage Reporting on SSP Admin Page 
   

   A. On the SSP home page, in the Portal Usage Reporting section, click Usage reporting.

   B. On the Configure Advanced Usage Analysis Processing page, in the Processing Settings section, click Enable advanced usage analysis processing.

   C. In the Search Query Logging section, select Enable search query logging.

3. Activate the Reporting Feature for the Site Collection
   

   A. On the Site Actions menu, click Site Settings.

   B. On the Site Settings page, in the Site Collection Administration section, click Site collection features.

   C. On the Site Collection Features page, click the Activate button for the Reporting feature.

After site usage reporting is enabled the site administrators and site collection administrators will be able to view reports detailing:

• Requests and queries in the last day and the last 30 days
• Average number of requests per day over the last 30 days
• Requests per day over the last 30 days
• Top page requests over the last 30 days
• Top users over the last 30 days
• Top referring hosts over the last 30 days
• Top referring pages over the last 30 days
• Top destination pages over the last 30 days
• Top search queries for the last 30 days
• Search results top destination pages
• Number of search queries per day over the previous 30 days
• Number of search queries per month over the previous 12 months
• Top search queries over the previous 30 days
• Search Queries per search scope over the previous 30 days

Site collection administrators will be able to view reports detailing:

• Total amount of storage used by the site collection
• Percent of storage space used by Web Discussions
• Maximum storage space allowed
• Number of users for all sites in the hierarchy
• Total hits and recent bandwidth usage across all sites

Using the Source Query String Parameter in SharePoint 2007

Have you ever wanted to direct users back to where they came from after submitting a form.  On most SharePoint 2007 forms you can simply add an element to the query string for SOURCE and SharePoint will automatically redirect the user to a specified page when the form is submitted.  For example:

A form named: http://myintranet/site1/Form1.aspx can automatically redirect the user to the homepage http://myintranet/default.aspx by changing the link to the form to be:

http://myintranet/site1/Form1.aspx?source=http://myintranet/default.aspx

This can be a handy feature when you want to create a special confirmation page.  InfoPath forms can take advantage of the same technique by adding values to the query string source parameter, read more.

More information on this topic can be found at:

Using the current page URL in the urlaction of a SharePoint feature by Jan Tielens

InfoPath Forms Services – What happens after a form is closed by Itay Sharkury

Other SharePoint querystring parameters by Daniel McPherson

SharePoint 2007 Visio Stencil

Have you ever wanted to create beautiful SharePoint site diagrams using Microsoft Visio?  I recently created a stencil for Visio that includes all the important objects when creating diagrams for SharePoint 2007 projects.

The stencil includes unique SharePoint 2007 shapes for; Site, Subsite, Portal subsite, Search Center, Site Directory, Meeting Workspace, BDC Data, Calendar, Check List, Contacts, Discussion, Document Library, Event, Form Library, Gantt Chart, Issues list, KPI, Links, Locked Document Library, News, Survey, Task list, Approval, Form, and Farm.

It also includes shapes for; Firewall, User, Active Directory, Server, SQL, Folder, Document, and others.

Download the Visio Stencil

(Please note: You may need to right-click and save this file as a .vss file, Windows may try to rename this file as a .vsd but Visio stencils must be named .vss to work properly.  You can also rename the file after downloading)