2010-04-30

ULS Log Viewer application available for SharePoint 2007 og SharePoint 2010

I haven't seen this before today, but Microsoft released a great tool October last year: The ULS Log Viewer. A lot of features - inclduing real-time viewing of the logs => See the events as the occure! It works for both SharePoint 2007 and SharePoint 2010.

You'll find it here: http://code.msdn.microsoft.com/ULSViewer

2010-04-27

Upgrading Content Types in SharePoint 2010

When you created Content Types solution in Visual Studio 2008 / SharePoint 2007 you very soon run into trouble when you were going to upgrade these content types with new fields. Code had to be writte :-)

This has now changed, and you will be able to to the same by adding the changes to the feature manifest:


The PushDown attribute on the AddContentTypeField action in the UpgradeActions element does the trick.

Setting up SmarterMail as a mailserver on a SharePoint 2010 demo machine

I basically followed Reza Alirezai's blog post, but remember the following:

  • Make sure you don't have domain/server name conflicts. I usually set up a mailserver on the address sharepointmail.local, and set this name to point to IP 127.0.0.1 in the hosts file
  • Remember to set sharepointmail.local as the outgoing mailserver in Central Administration
  • Reporting Services use the Reporting Server config file and the SMTP server name has to be set to sharepointmail.local here as well. The correct config file is rsreportserver.config and is located in the folder C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer
  • Define all the useres you need in SmarterMail setup and add the e-mail addresses to the your users in the User Profile store in SharePoint.

SharePoint 2010 and "There are no activities in your newsfeed" issue

These are the reasons I've found for why you don't get any activities displayed on the My Site page:


  • You have to start the "User Profile Service Application - Activity Feed Job", and schedule it to run periodically; Central Administration -> Check Job status -> Job Definitions. In my demo environment I set it to run often to make sure I can demonstrate it well.
  • Add some colleagues on your My Site
  • Make sure some activities have been performed by any of your colleagues

I don't think that the "Activity Feed Job" is turned on by default.

2010-04-22

SharePoint 2010 RTM is finally here!

Downloaded it from msdn and installed it without any problems at all. Great work Microsoft. Before there always where issues to run into (especially when you run the "whole package" from one server), but this time it went a lot smoother althoug I got problems with the add-ons. I installed it on Microsoft SQL Server 2008 R2 CTP.

Services installed:
  • SharePoint base with all features
  • Excel Services
  • Reporting Services
  • Personalization services with my site and profile syncronization
  • Search
  • Visio Service
  • Secure Store Service
  • Managed Metadata Services
Complete SQL Server 2008 R2:
  • Database Engine
  • Reporting Services in SharePoint Integrated Mode
  • Analysis Services with the Adcenture Works databases (from Codeplex)

I'm currently struggling with the PowerPivot and the Reporting Services display:

  • Cannot add the PowerPivot package to the SQL Server .... several errors ... Gave it up for the time being! :-(
  • Cannot display reports created in the Report Builder and added to a document library... question asked in forum ... a strange url encoding error .... rsUrlRemapError :-(

2010-04-20

Using a filter with a Excel Services and a Pivot parameter

I was going to create a BI dashboard containing a Pivot table from Analysis Services and some KPIs. The Pivot table sholud be rendered by Excel Services and the content should be filtered on the current user's country (region he/she was responsible for). The conuntry information was stored in the user profile. Straightforward - I thought, but oh no that was wrong ...

Everything was simple and easy until I was going to connect the Current User Filter web part to the Excel Services Web part and filter the pivot on the curent user's country. What I discovered after quite a lot of googling and reading different blog posts, was that a Analysis Services Pivot table parameter expect a value that is not a "simple" value as e.g. "Canada", but rather "[Geography].[Country].&[Canada]".

In my case then the Current User Filter Web part that comes OOB with SharePoint was not suitable, and I had to write my own. This filter wraps the user profile value into the correct Analysis Service Pivot parameter syntax.