Jeroen Derde's Blog

My Software Engineering Universe

Microsoft Country Partner of the Year

clock April 21, 2011 19:58 by author Jeroen Derde

 At e-office we have been working hard at baking our Microsoft cake this year

Lets just say we are pretty serious about our baking skills.
To put the cherry on top we are submitting a great case to the anual Microsoft World Partner Conference in LA.

Check-LookupColumn PowerShell

clock April 14, 2011 01:08 by author Jeroen Derde

Today I had some issues with a Lookup Column in SP2010.

When using my Admin account I was able to edit an Item and select a value. When using my normal useraccount (with contribute rights on bot lookuplist an list) I wasn't able to select anything, and SP2010 showed an empty dropdown.
Looking at the column properties in SharePoint everything looked OK, but using SP Designer the properties where empty.
Figuring this just might be something other then a rights issue, I wrote a little PowerShell function to check the settings of my Column.


Function Check-LookupColumn($webURL, $listName, $columnName, $lookupListName)
 $web = Get-SPWeb $webURL
 $list = $web.Lists[$listName]
 $column = $list.Fields[$columnName]
 $lookupList = $web.Lists[$lookupListName]
 write-host "lookupweb              : " $column.LookupWebId.ToString() 
 write-host "should be equal to web : " $web.ID.ToString() 
 write-host "lookuplist             : " $column.LookupList.ToString() 
 write-host "should be equal to list: " $lookupList.ID.ToString()

Turned out that during the migration from one environment to the other, the references of the lookup column had not been updated.
The Admin account had sufficient rights on both environments, so it worked for that account. my user account on the other hand was not available in the source environment, so no sigar.
After updating the column with the right GUID's everything works again.

Wish I had seen this before writing my onw script Laughing, but the script to fix the lookup column can be found at:

New job at e-office

clock April 9, 2011 00:23 by author Jeroen Derde

April 1st I started my new job at e-office.  e-office focusses on Human software, and does this using Microsoft, IBM and Google technology.
Human sofware can be seen as 'messaging', 'collaboration', 'enterprise 2.0', 'unified communications', 'user experience' and 'mobile'.
It does however not stop at the technology, because at e-office we believe that people and organisations are an equal part of the equation.

I've joined the SharePoint team at e-office, and I'm already very excited about the upcoming projects that I have seen.

You can follow e-office on:





Sharepoint and the iPad

clock February 9, 2011 21:29 by author Jeroen Derde


I've been using the iPad for a while now, and regulary find myself accessing my companies SharePoint intranet.
First I just used the iPad's browser, but found that touch input is a bit cumbersome at times and the screen realestate is a bit small on the iPad.
The screen realestate issue could be fixed with some nice orientation enhancements for SP2010 (, but that would still leave me with my navigational issues.

To make my life a bit easier I did some research into the available iPad apps that make navigating and using SharePoint easier.

I currently use SharePlus lite. This is the free version of SharePlus.
The Pro version will currently set you back:
 - USD 14,99 or
 - EUR 11,99

SharePlus features I really like are:

  • Big buttons that make for easy navigation
  • Pro version is a 1 time buy for all your iOS devices
  • ISA and ForeFront authentication support
  • Add, edit & delete list items, such as: tasks, pictures, contacts, custom lists, discussion boards and documents while connected. Edit includes Check In, Check Out & Discard CheckIn support (pro only).
  • Send documents by email.
  • Browse data by view in online mode, respecting server defined list views, with ordering and filtering settings.
  • SSL Support
  • Connects to WSS 3.0, MOSS 2007, SP2010, and all editions of SharePoint Online (BPOS included), as long as they use windows based authentication and not forms based. Form based is now supported

Other iPad applications for SharePoint I found are:

Fillament (this is the next one I will be trying)

Haven't tried this yet, so no actual experience

  1. Also has a lite and a pro version
  2. Pro version is USD 12,99 or EUR 10,49
  3. Pro: bit cheaper, supports form based authentication, SSL self signed certificate support
  4. Con: irritating music in demo video :), data editting only in pro version
  5. Site:
  6. Video:



  1. Free
  2. Pro: Free, Dashboard function
  3. Con: version 1.0, not as advanced as the other two
  4. Site:
  5. Video:


QNH RAD Race 2011

clock December 2, 2010 02:31 by author Jeroen Derde

QNH helpt haar klanten met Business Integratie vraagstukken. Onder andere door slimme applicaties te ontwikkelen. Om te bewijzen dat we doen wat we zeggen te doen, organiseren we in januari weer een RAD Race®. Deze onafhankelijke programmeerwedstrijd verplicht je snelle, maar doordachte keuzes te maken en alles uit je  ontwikkel toolset te halen. Hierbij kan iedere software development tool gebruikt worden. Uiteindelijk gaat het niet om wat een tool beloofd te doen, maar wat het oplevert…

Dus. Ben jij de beste ontwikkelaar van ons land? Doe dan mee om dat te bewijzen!

Klik hier voor meer informatie

Microsoft tech-ed 2010 Sessions

clock December 1, 2010 00:23 by author Jeroen Derde

 Had a really great time at Tech-Ed europe this year. Thanks to Schuberg Philis for doing the Dutch "Back To The Future" County Drink, it rocked.

Some of the sessions I visited and liked, you should watch these videos at Tech-ed Online:


Great session by Dino Esposito about Design considerations when building ASP.Net MVC applications

Whats new in ASP.Net MVC 3 by Jonathan Carter @lostintangent

Nice OData session to get started

And one to deep dive into the previous session

Microsoft tech-ed 2010

clock October 29, 2010 21:07 by author Jeroen Derde

I'll be attending Tech-Ed this year. Keep an eye out on Twitter and this blog for all the nice new stuff.

Also look at the official hashtag #TEE2010







Official tech-ed2010 twitter:

RegEx Searching in Visual Studio

clock June 19, 2010 00:44 by author Jeroen Derde

This article lists the aliasses you can use in visual studio when searching with a regular expression.,ide).aspx

For example  if you want to find all guids in your solution

  • CTRL-SHFT-F (find in files)
  • Entire Solution
  • check the Use Regular Expressions box
  • type in the find box :h^8-:h^4-:h^4-:h^4-:h^12
  • go


Add Get PublicKeyToken to Visual Studio

clock June 2, 2010 21:18 by author Jeroen Derde

Article about how to add a "Get PublicKeyToken" menu item in Visual Studio

Basic steps:

  • Tools --> External tools..
  • Title: Get PublicKeyToken
  • Command: C:\Program Files\Microsoft SDKs\Windows\v6.0A\Bin\SN.exe
  • Arguments: -T $(TargetPath)
  • Check Options: Use Output window

Make sure you build your project before using this new tool.
I love this, and think it should be added on every developers machine.

UserControls in WSPBuilder Project

clock May 13, 2010 02:14 by author Jeroen Derde

WSPBuilder extensions for Visual Studio are great. If you use WSPBuilder to create webparts however, you might have run into the fact that by default Visual Studio does not allow you add Web User Controls to a WSPBuilder project.

At the project I'm currently working on, we use WSPBuilder and usercontrols for the visual part of the webparts we create. To make life a bit easier we altered the projectfile of our webparts project.

If you change:




Visual Studio wil think it is now a WebApplication, and will allow you to add usercontrols by using Add --> New Item on your WSPBuilder project.

Windows Search Advanced Query Syntax

clock April 14, 2010 01:04 by author Jeroen Derde

Today, I was looking for a song in my music collection. Because the collection has grown quite a bit lately I could really find the file I was looking for.
I did know it was a 192 kbps file, and the artist name. After a bit of searching the web, I found the following options for windows search that you can use in the search bar.
Using these features, I found the file instantly.

Property   Usage
bitrate      bitrate:>150kbps
artist        artist:U2
year         year:1977..1987
year         year:>1980<1990
album      album:"greatest hits"
genre       genre:rock
lyrics        lyrics:"one"
track        track:12
 These are just the music search options. The following page contains all the possible options.

VS2010 released

clock April 13, 2010 19:44 by author Jeroen Derde

I've been using the beta an RC version of Visual Studio 2010 for a while.
Yesterday VS2010 was offically released.

Take a look if there is a launchparty near your location.


MOSS .net Framework 3.5 SP1 upgrade issue

clock March 15, 2010 23:00 by author Jeroen Derde

Today at a client, we stumbled upon a problem when updating MOSS2007 SP2 with .Net Framework 3.5 SP1. Everything seemed to work fine, but Search & indexing was not working anymore. The error log showed the following: EventID 6482 - Application Server Administration job failed for service instance Microsoft.Office.Server.Search.Administration. SearchServiceInstance
Indexing and serving search queries is handled by diffetent servers in the clients environment.

After a bit of googling and bingging we foud this exelent post by Andera Glaser that decribes the problem and the solution to the problem.

More info about how to fix the problem:


First Sharepoint 2010 NEN 2082 certified project

clock March 5, 2010 00:50 by author Jeroen Derde


Together with 3 colleagues from QNH Business Integration I am currently finishing implementing a already NEN 2082 certified project based on SharePoint 2010.
When SharePoint 2010 hits RTM there will be another audit for this version of SharePoint, because currently the pre release version has been certified.

NEN 2082 is a Dutch standard which is similar the DoD5015 and MoReq standards.

This project was done for the Gemeente Nieuwegein, which is a Dutch local Government.

For this project we have also been nominated for the “Innovation of the year” award:

More information (Dutch)

My colleagues at QNH:

Rename feature fixed in VS2010 RC

clock March 5, 2010 00:43 by author Jeroen Derde

Last week, I removed my VS2010 beta installation and installed VS2010 RC. The RC is much more stable, and as a bonus renaming a feature in a SP2010 project now works.
We have been building lots of features lately, and I was very pleasantly surprised to see this bug already fixed.

Month List


<<  January 2023  >>

View posts in large calendar

Sign in