SharePoint surveys and the order of the questions during export to Excel

I noticed some interesting, and in my case not desirable behaviour when I was exporting the results from a SharePoint survey to Excel: the order of the questions in Excel differed from the order in SharePoint. Some further analysis showed the following: When you export to Excel, the order is determined by the creation time of a question, so the questions that were create first appear before the others. This Details

Displaying the total number of postings by users in a SharePoint discussion board

Recently, I wanted to display some small statistics about how often people participated in the discussions in a SharePoint discussion board. I wanted to show the total number of postings in a small web part. The solution for this requires SharePoint Designer, as it makes use of the Data View Web Part. I’ll show the steps to display the list of people who participated in a discussion board and their Details

Displaying a preview of a wiki's contents in SharePoint

Update 14 December 2009: Improved slightly, first the tags are stripped, then content shortened.  Displaying a textual preview of an wiki’s article in SharePoint is quite easy. All one needs to do is create a data view web part with SharePoint Designer (free since April 1) and have it display the field ‘Wiki Contents’ from the wiki’s pages library. Now the contents of this field contain all the HTML markup of the Details

Showing only this week's events of a SharePoint calendar

Update: There was a mistake in the IsInCurrentWeek formula (ignored the year….), the updated version is now here.  Recently a colleague asked me for some modifications on one of her calendars. Basically, she wanted to display only the events of the current week in the corresponding web part. In order to get the default web part to do this, I had to find out whether a calendar entry is in the current week Details