SharePoint Sharpener

Obsessively Sharpening SharePoint

Archive for September 2011

SPC11 Survival Guide for International Attendees

with 3 comments

Going to your first SharePoint Conference next week in Anaheim? Or maybe you just can’t remember much of the last two SPCs in Las Vegas and Seattle?

Anaheim will be my fourth SPC – the one before Seattle was in Berlin – and every time I seem to forget a few vital things in preparation for the trip. Trust me, there’ll be plenty of things to keep you busy once you touch down in LAX so the more you can take care of in advance the better.



Social networking

Twitter is essential for staying on top of what’s happening at the conference. In most Twitter clients, like TweetDeck, you can create a column that continually displays tweets with the hashtag #SPC11. Alternatively, you can use the web version.

Also, find out if attendees from your country or user group are using a specific hashtag (like #SUGUK for SharePoint User Group UK or #SPC11DK for Danish attendees) – or you may even want to keep an eye on #SharePint.

Consider putting your twitter handle and avatar on your SPC badge. It’ll make it easier for your online friends to recognise you in person.

Of course, Facebook (or even Google+) is also a relevant source of up-to-the-minute information but Twitter tends to be more widely used during SPCs.

If you’re travelling with colleagues you can stay connected using Office Communicator, stating which session you’re in or where you’ll be during the next break.


Adding your sessions to Outlook is a no-brainer and it makes it easy for your colleagues to catch up with you.


Doing business remotely

Access to your workplace via VPN may be limited from whichever network connection you’re getting in the US. Some providers and hotels block access to the ports used by VPN. If you’re using Office 365 or BPOS this isn’t going to be an issue for you – if not, you may want to check that you’ve got access to web-based email. If there’s a chance you need specific documents during the conference, put them on your hard drive or in the cloud with SkyDrive or Dropbox.

Also consider using GoToMyPC or unattended sessions in GoToAssist as these programs tend to find ways through the thickest firewalls.



Most laptop power supplies these days are universal, i.e. they accept 100-240 volts, so you only need to bring a power plug adaptor.

Use your laptop as a charging station for your phone/tablet etc. and do bring a spare battery for your iPhone phone.

Speaking of phones: Make sure you don’t incur horrendous roaming charges on your normal contract. Instead, you should purchase a prepaid SIM card from a US carrier on arrival.


Air conditioning

If you’re from the northern hemisphere it is probably warmer in California than in your country. Don’t be fooled, though, you’ll be spending most of your time indoors at the convention centre. And let’s get one thing straight: Americans like love air condition and they don’t mind cranking it up to 11. So don’t expect tropical temperatures in the breakout sessions.


Papers, passport

By now, you’ve probably applied for your ESTA. If not, you really need to hurry up. When you’ve completed the form make sure you check the details on the print view – I found that more details are shown here than on the form itself, especially if you’re only updating flight or hotel information.

Don’t forget your passport. Silly, I know, but I’ve been on group trips before where one or two people showed up in the airport without the most obvious item needed for the trip.



We’ve all heard stories about unlucky individuals ending up with astronomical medical bills when going abroad. Medical treatment in the US can be very expensive, so make sure that you (or your company on your behalf) have adequate travel and medical insurance for the trip.



Don’t bring much cash – but do bring your Visa, Master or Amex card. If you have two different cards it’s even better as some places may accept Visa but not Master, or vice-versa. And do bring the phone number of your bank/issuer’s card cancellation service, in case your card gets stolen.


International drivers’ license

If you’re planning a road trip to an NFL game in San Diego while at SPC you should check if you need an international license, apart from your country’s standard license. In most cases you don’t but it’s worth checking out. More info here, and be aware of the scammers who want to sell you fake international licenses.


And finally: Drinking

Yes, drinking and partying is part of the SPC experience! SharePoint Conference is a very social event where many different types of SharePoint people attend. This mixed bag of individuals is a great basis for some serious partying but instead of listing all the tips here, I’ll refer you to this and this post from some of the seasoned SharePint drinkers in the community.

Peter Anker and Anders Dissing @ SharePint

In the above picture: Experienced SharePint drinkers Peter Anker and Anders Dissing partying in Copenhagen.

Make sure you check out my post about the social activities at SPC11 and bookmark the SPC11 Event Map.


Don’t forget to read some of the traditional travel advice from e.g. Lonely Planet or Rough Guides.

That’s it. Safe travels – hope to see you in Anaheim. If you see me, come and say hello.


Written by Thomas Sondergaard

September 29, 2011 at 5:09 pm

Quick Fix: Remove Libraries, Lists From ToC

with 8 comments


I usually strive to first and foremost use SharePoint’s out of the box functionality to fulfil clients’ needs. Custom solutions with managed code, controlled deployment etc. are all well and good but sometimes you can get by with some simple frontend-configuration. This approach, if done right, enables clients to easier maintain and further enhance their SharePoint site once it’s up and running and the expensive SharePoint consultants have left the building.

Small adjustments can often be done with CSS or JavaScript/jQuery without remote desktop access to the server park. I know some hard core devs out there will oppose to making more or less unmanaged changes using something that hasn’t been pushed through a compiler. But like it or not, we need to get used to working within the constraints of Office 365 and SharePoint in the cloud. More about that in a later article.

Anyway, let’s skip the politics and get to the point of this post.


The problem

When you insert a standard Table of Contents web part it looks something like this:


And if you’re like most of my clients, you want it to look like this:


I.e. more “site mappy” without links to lists, document libraries and discussions.


The solution

This is the quick fix and therefore we’ll use client-side JavaScript to hide the unwanted nodes in the ToC.

First, create a library in the site to hold custom scripts. Why not call it “scripts”?



For easy editing, open the the new library in explorer view and create a text file, like so:



Open the text file in your favourite editor and paste the following JavaScript:

   1: <script language="JavaScript" type="text/javascript">

   2: // This script removes lists, libraries and discussions from Table of Contents

   3: // PeopleNet,

   4: var links = document.body.getElementsByTagName("a");

   5: for(ii=0; ii<links.length; ii++)

   6: {

   7:     if(links[ii].outerHTML.indexOf("BaseType") != -1 && 

   8:       links[ii].parentNode.parentNode.parentNode.parentNode.className == "level-section")

   9:     {

  10:         links[ii] = "none";

  11:     }

  12: }

  13: </script>


Save the file and go back to the SharePoint page where you placed the ToC web part. Below the ToC insert a Content Editor Web Part.

Back in the old days (i.e. SharePoint 2007) you’d edit JavaScript directly in the web part. This is still possible but it’s really quirky to work with. Instead, in the web part’s properties, point to the text file you created earlier:



This approach makes it so much easier to edit the JavaScript in a proper editor instead of in a SharePoint pop-up.

Click OK and save the page. The unwanted nodes are now hidden.



I’m fully aware of the implications of the above approach with regards to solution management, client-side performance and so on, but every solution needs to be seen in the context of the need it fulfils. And sometimes the above approach hits the mark.

And remember, the Table of Contents web part is just one of site navigation options in SharePoint.

Written by Thomas Sondergaard

September 27, 2011 at 10:44 pm

Work Hard, Play Hard: SPC11 Event Map

with 3 comments

If you’re attending the SharePoint Conference you’re expecting to return home with valuable knowledge from the world’s leading SP experts. Knowledge that will inspire you to become more productive with SharePoint no matter which tier of SharePoint you’re working with.

However, you will certainly suffer from information overload during the week – but knowing this you can take proper precautions. You’ll need two things:

  1. OneNote
  2. SharePints

Using OneNote is worth a handful of blog posts of its own (I’ll write something soon) but for now you can take a look at this and this.

More importantly, you need to make sure that you focus on something which isn’t SharePoint-related at the end of each conference day. Cue the SPC11 Event Map which pinpoints the different parties, receptions and other social gatherings during SPC11. So, leave your hotel room behind and join your fellow SP enthusiasts for a few SharePints.

Click the screenshot to go to the map:


I’ve made the map public so please add your own events (use green pins). If you have suggestions for restaurants, sights and so on, please add them with appropriate pins – or drop a comment below and I’ll update the map. This is work in progress and I’ll update the map during the conference.

Thanks to Jeremy Thake and Robert Piddocke for contributing. Jeremy’s comprehensive SharePoint community calendar can be found here.

Written by Thomas Sondergaard

September 24, 2011 at 11:14 pm

Welcome Back! And See You in Anaheim For SPC11

leave a comment »

So, I’m taking the first baby steps towards breathing life back into my severely neglected blog. It would simply be too embarrassing to go to Anaheim in a week’s time without a least a few fresh posts under my belt.

It’s not like I don’t have plenty of useful SharePoint stuff to write about; my beloved OneNote is crammed with years of scribbling about bug-fixing, coding, server trouble-shooting and mostly – let’s face it – more or less elegant solutions to overcome SharePoint’s little quirks.


Let’s meet in Anaheim

Once again, PeopleNet will probably be the largest Danish contingent at the SharePoint Conference. Almost 40 of us are going this year, including some of our valued clients.

I’m looking forward to spending some time with like-minded SharePoint enthusiasts during the course of the week, either between sessions or at some of the many social events. SharePints anyone?


Live blogging?

Yes, I’m planning to do a few posts before SPC11 but whatever I write during the conference will surely be more interesting for you to read, especially if you can’t attend yourself.

If wifi coverage is acceptable I’ll attempt to live blog during the keynote. At SPC09, literally the second Steve Ballmer walked off the stage after the keynote, I posted an article and it was probably the first semi-comprehensive rundown of SharePoint 2010’s new features to hit the internet. It got a lot of traffic.

This time a new version of SharePoint will not be released but I’m confident a few juicy announcements will be made during the keynote, so tune into my blog for coverage.

I’m probably getting over-ambitious here but I’m toying with the idea of posting some video clips from the conference as well. Not promising anything, though.


Meanwhile, follow me on Twitter (@sondergaard) – and have a safe flight to Anaheim, if you’re going…

Written by Thomas Sondergaard

September 24, 2011 at 12:16 am