I’ll be AT SPC2012, See you there ?

November 9, 2012 Leave a comment

Hi everyone,

Just a little note to say that I will be next week at the SharePoint Conference in Las Vegas.

Stay tuned for realtime info and tweets on @kerseub.



See you there

Categories: Uncategorized

ASAOW : Demystifying SharePoint Performance Management

August 10, 2012 Leave a comment

Once A week, I try to post a link to an « Amazing SharePoint Article Of The Week » (ASAOW).

From several weeks, Paul Culmsee is writing an amazing series of articles (10 so far, eleventh and last to come) about ways to manage performance of a SharePoint 2010 farm. He explains impact of RPS, SQL, IOPS within this kind of complex architecture.

It’ a great summary of bunch of great tools we all heard about (well… most of them), and about the way to use it to optimize, or make works a Farm . So here is my advice, before killing your developers, read this articles first !!

  1. Demystifying SharePoint Performance Management Part 1 – How to stop developers blaming the infrastructure
  2. Demystifying SharePoint Performance Management Part 2 – So what is RPS anyway?
  3. Demystifying SharePoint Performance Management Part 3 – Getting at RPS
  4. Demystifying SharePoint Performance Management Part 4 – Making use of RPS
  5. Demystifying SharePoint Performance Management Part 5 – So what is latency anyway?
  6. Demystifying SharePoint Performance Management Part 6 – The unholy trinity of Latency, IOPS and MBPS
  7. Demystifying SharePoint Performance Management Part 7 – Getting at Latency, IOPS and MBPS
  8. Demystifying SharePoint Performance Management Part 8 – More on SQL and SQLIO
  9. Demystifying SharePoint Performance Management Part 9 – Don’t believe everything you R/W
  10. Demystifying SharePoint Performance Management Part 10 – More tools of the trade…

Bing Federated Search for SharePoint 2010

August 7, 2012 Leave a comment

SharePoint search offer federated search to external Search engines. There even a gallery where you can download a Federated search connector to Bing.

Unfortunately, this connector do not works: the query template target a http://api.bing.com/rss.aspx page, that do not exist anymore :

To make it work, you have to update this location to a funtionnal URL, http://www.bing.com:

Go to Central Administration/Manage Service Applications/<Your Search Service Application>

Then open Federated Locations and Edit the Bing Location :

Go to “Location Information Section” and set “Query Template” to http://www.bing.com/search?q={searchTerms}&format=rss&market={language}&web.count={count}&web.offset={startIndex}

Then go to “Display Information” and use Default Formatting for Federated Search Results, Core Search Results, and Top Federated Results

If you feel lazy, you can download a corrected connector (OSDX) on my skydrive: http://sdrv.ms/Qcuu9B

I don’t know when Bing Updated it’s RSS endpoint, but this federated connector really needs an update….

Add new file type in SharePoint

April 23, 2012 14 comments

Out of the box, SharePoint can manage lot of file type. This management include the capability to show an Icon, to index, to open from browser and finally to Index. But what if you need to manage another file type?

There are 2 steps to complete:

  • Specify Icon File and activeX control to use for extraction/archiving
  • Allow Content Type to open from Internet Explorer

In this example I’ll use keepass, a pretty useful password manager, file format to enable to SharePoint

Before :

I added a KDBX file into a SharePoint Library (my Preciious.kdbx), there is no icon, Internet Explorer only allow saving, no opening… Poorly integrated.

Image Icon and Opening

First step is to add a File icon in 14/Template/Images folder. My recommendation is to use a .PNG 16×16 pixel PNG picture with transparency.

Now next step consist in register this picture. To do this edit file 14\TEMPLATE\XML\DOCICON.XML, and add this line somewhere in the <ByExtension> section:
<Mapping Key=kdbx Value=KeePass_icon.png EditText=Keepass Password Manager  />

This associate the file extension .kdbx to the KeePass_Icon.png image. Optionally you can specify the text to add to contextual menu (what we did here) and even specify an ActiveX Control to fire when opening document. But in our case, we don’t have any ActiveX to call. (More info Here ).

Well this what we have so far (mind the EditText value):

Allow Content type opening

So, our file type now have an Icon. That’s great, but you still can’t open file directly from SharePoint: Internet Explorer do not allow open file :

That’s because SharePoint by default, send specific HTTP Header when transmitting file that have not recognized Mime type. The get rid of this, there is two option:

The best you can declare document mime type as “downloadable“. That’s easy when you are working with specific content type but .kbdx file do not have specific mime type. No problem, let’s create a custom Mime type on IIS server ! Here is how to do:

Open IIS console, select server node and open “MIME Types” menu

Then click “add…” button to declare de specific Mime type. Custom mime type should begin with application/vnd. OK, it’s time to be creative:

Now, last step is to declare this Mime type as “Downloadable” this can be done via a PowerShell cmdlet:

$web=Get-SPWebApplication -Identity <WebApplication>
$web.AllowedInlineDownloadedMimeTypes.Add(“<Custom Mime Type>”)

Declaring custom MIME type and set it as downloadable is not mandatory, another solution is to set the “Browser file Handling” option to “permissive” in Web Application general settings (Central Admin/Manage Web Applications/<Web application>/ General Settings application)

This is quick, but not really secure, I really suggest that you choose first option.

And voila! You are now able to open file directly from SharePoint. Of course it support Extraction/Archiving


Categories: SharePoint 2010

Move-SPUser common errors

April 19, 2012 Leave a comment

There is something great with ladies: they change their name when get married .There is something SharePoint do not like: when people change their Name…

When user change their AccountName, SharePoint do not “see” it very well. You have to use the Move-SPUser cmdlet (or stsadm –o migrateuser for Moss 2007)

Technet documentation (Here) give this example:

Move-SPUser –Identity “DOMAIN\JaneDoe” –NewAlias “Domain\JaneSmith”

But if you try it, this command fails. Because the identity parameter shall not be a String, but an SPUser object. Instead try this:

$user= Get-SPUser -Identity <LoginName> -Web <A WebSite in your Farm>
Move-SPUser –Identity $user –NewAlias “Domain\newLogin” -IgnoreSID

And if this command fails in a “User unknown” error, you should try to launch it under Identity Account.

To sum-up:

  1. Log as Identiy Account
  2. Do a get-SPUser first

Thanks to http://social.technet.microsoft.com/Forums/en-US/sharepoint2010setup/thread/92e515a0-7b4f-4597-95ba-ec640810ac0c

Categories: SharePoint 2010

Profile Sync and Claims Authentication

April 17, 2012 Leave a comment

This article is a re-post from my previous blog… This is something that is not well documented, but you can have a profile synchronization for federated-based authentication. Follow this steps. First, create de connection sync, specifying an Active Directory type, and Claims-Based authentication provider,

Once this is done, you have to map a specific profile property Claim User Identifier (SPS-ClaimID) to the claims that is used as identity claims. This claims is visible using this small powershell cmdlet:



Commonly, the Identity Claims used is emailadress. Go in “Manage User Properties” , find the “Claims User Identifier” and edit it. Go in “Add new Mapping” section, and add an Import connection to the mail Attribute (or the property you used as identifier) of the source data connection you previously created. Now start a full sync and voilaaa! All your AD Accounts are no synchronized with a claims-based account, not the basic DOMAIN\Account.

What if you want to use profile sync using both Claims-based and integrated authentication? Well even if the profile would be match to 2 different account name (the DOMAIN\Account and the i:bar-foo), they are consider as a duplicate account by FIM, and there will be just one account sync. For instance, my AD account is in a OU that is sync by a n integrated authentication provider and a claims-based one. So when I query the FIM meta verse, I appear twice :

Once with the Windows Claims providers

And once with the adfs-fedrated claims provider:

But if I try to see the preview, my account appears as twice:

So the only way to achieve a domain sync against claims-based authentication AND Integrated-based authentication is to sync different OU of the AD domain.

ASAOW : SharePoint Tag Cloud using Deep refiners in Fast Search by Amit Kumawat

April 13, 2012 Leave a comment

Once A week, I try to post a link to an « Amazing SharePoint Article Of The Week » (ASAOW).

This is common request from customer that is poorly documented (from my point of view): How to create a Search Refine for Fast? Amit Kumawat wrote a really great article, explaining how integrate such a refiner and even how to calculate the size of a term in a tag Cloud.

Amazing job, article is here: http://extreme-sharepoint.com/2012/04/10/sharepoint-tag-cloud-deep-refiners-fast-search/

For more information about custom search refiner with SharePoint 2010 search, I suggest this article: http://www.itidea.nl/index.php/search-refiners-part-1-expanding-the-ootb-search-refinement-panel/