SharePoint, Office 365, Azure, and Front end JS geek. – Chicago IL
SharePoint, Office 365, Azure, and Front end JS geek. – Chicago IL


Renaming a View – Best Practice

When renaming SharePoint views users are often stuck with the unintended side effects of having both an internal file name and external display name.   If understood and managed properly this can be an advantage (not a bug).   A short simple internal name can provide a concise URL while longer display names can provide end user navigation and context.



ASPX file name

Shows in Designer, Explorer, URL bar, and other technical views


String display for navigation

Shows in navigation bar, HTML display title, MS Office clients, and other end user views


The Internal name is set at creation time and cannot be easily changed later.  So, the next time you make a new view try to use a short name first then come back and rename to something longer immediately after.   This way you get the best of both worlds:  a short URL and a longer more descriptive navigation link. 







Steve Ballmer and I at #SPC09

During the SharePoint 2010 conference I had the distinct honor of personally meeting and having photos taken with Microsoft CEO Steve Ballmer.  Wow!  I am still amazed.  Here’s the story.  Emily and I planned a reception for Saturday October 24.   I later learned of the conference and dates.  Since we were going to be in Las Vegas the week before it was fate  … we had to get married by Elvis at the Viva Las Vegas wedding chapel.   So we did.   When word of our plans got around Twitter and to the conference organizers they arranged for us to have a special backstage photo op after the opening keynote speech Monday October 19th.   We were even mentioned in the press in a Computer World article titled “SharePoint guru adds wedding, Elvis into conference schedule”.    I did a Google News search on my name and Steve Ballmer and got this one hit.   Never thought that would happen.

Really cool things that happened this week:

  • SharePoint 2010 was released
  • We met Steve Ballmer
  • Emily and I got married
  • … by Elvis
  • I met many new Twitter friends in person
  • I saw many old friends again
  • Our room was upgraded to a top floor honeymoon suite with flowers, chocolate, and champagne (awesome!)
  • Windows 7 and Server 2008 R2 were released

I’ve only been married for three days but can easily say it’s the coolest thing I’ve ever done. 


      Woohoo!!!   I’ll never forget this week.   For all you single extra geeky Twitter-tee wearing dudes out there I highly recommend finding an amazing, caring, fun woman to spend your life with and then climbing up on the roof top to shout it out.   Other geeks are very supportive, encouraging, and just downright fun when it comes to helping you celebrate.    The whole trip feels like a dream and was so much better than anything I could have imagined.


SPC 2009
SPC 2009
SPC 2009
SPC 2009
SPC 2009
SPC 2009

Extracting hyperlink destinations from Excel (Document Library item URLs)

I recently needed the destination URL for several hundred items across layers of nested folders in a giant SharePoint Document Library.    Right clicking with “copy link location” just wasn’t going to work here.   The datasheet view, Excel, and Access all came to mind as possible tools.   In then end a quick Excel UDF (User Defined Function) helped get the job done.   This is easily done against SharePoint Document Libraries because the default Title column links to the file item URL.

  1. Choose “Export to Spreadsheet” from your document library
  2. Open the .IQY file when prompted
  3. Press Alt+F11, then Insert > Module
  4. Paste in this code:
  5. Save the workbook.   Note:  You might be prompted to save as XLSM for a macro enabled workbook, change the file type, and save.
  6. Use the =getaddress(cell) function to see the URLs  (screenshots below)





Sources Cited

Function GetAddress(HyperlinkCell As Range)

    GetAddress = Replace _

    (HyperlinkCell.Hyperlinks(1).Address, "mailto:", "")

End Function

MS Virtualization Quick Reference

For myself and friends working with Microsoft virtualization technologies I decided to write a quick reference guide comparing and contrasting the tools available today.  This area is changing so quickly it’s hard to stay current.  Hope you find it helpful.

Virtual PC 2007

Key Features: Simple, easy, and abundant.   Friendly GUI interface, drag and drop files across Host–>VM desktops.   With so many Windows XP desktops out there there is a favorite for learning and labs.

Host O/S: Windows XP mostly.  Older systems.

Guest Capability: 32-bit only

Keyboard Shortcuts: [Right Alt] to release (if lacking VM additions).   [Ctrl+Alt+Break] will toggle to/from full screen.

Download Link:

Virtual Server 2005 R2 SP1

Key Features: Web based interface, easy remoting.  More features (VHDMOUNT, VMC editing).  Dominant in data centers.

Host O/S: Windows XP / Server 2003.   Older systems.   Can also run on Server 2008 for backward compatibility and access to VHDMOUNT utility.

Guest Capability: 32-bit only

Keyboard Shortcuts: [Right Alt] to release (if lacking VM additions).    Full keyboard shortcut listing here.

Download Link:

Hyper-V in Windows Server 2008

Key Features: FAST!!   Direct access to bare metal.   Latest in core VM tech from Microsoft.   Easy snapshots, rich settings editor, VHD compression tool.

Host O/S: Windows Server 2008 only

Guest Capability: 64-bit and FAST!

Keyboard Shortcuts: [Ctrl+Alt+Left Arrow] to release (if lacking Hyper-V Integration Services).

Download Link:

(comes with Windows Server 2008)

Windows Virtual PC RC

Key Features: Only option for Windows 7 that I’m aware of.   Still in Release Candidate status.

Host O/S: Windows 7 (all editions)

Guest Capability: More than even Hyper-V?  64-bit with “boot as VHD” feature too?

Keyboard Shortcuts: Not sure, haven’t run yet.

Download Link:

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲