Category Archives: Planning

The Future of InfoPath Forms

Posted by on February 2, 2014 at 6:19 pm.

It’s been a long time speculation Microsoft would be phasing out InfoPath support in SharePoint. Rightfully so, the experience is awful: it’s bugging, hard to maintain, they don’t migrate well, and generally cause more harm than good.

Officially, Microsoft has recently admitted InfoPath forms are finally being retired and a new forms method (TBD) will be investigated. In a January 31st, 2014 post, the office team declared:

“We are looking to make investments that allow you to easily design, deploy, and use intelligent, integrated forms across Office clients, servers, and services—forms that everyone can use on their PC, tablet, or phone.”

Finally. Heavily relying on InfoPath forms today? The InfoPath 2013 desktop client and InfoPath Forms Services for SharePoint Server 2013 will continue to be supported through 2023 as part of Microsoft’s Lifecycle support policy. You’ve got until April 2023 to figure that one out; however, I wouldn’t bank on a smooth migration solution to whatever comes next. 🙂

SharePoint On-Premises vs. Cloud

Posted by on April 27, 2013 at 7:45 am.

I saw this and thought it was too funny not to post. Credit for this one goes to my colleague Mr. Jody Finch (I’d recommend checking out his awesome blog series on SharePoint Search).

photo

Balsamiq Wireframes Quickstart Guide

Posted by on October 29, 2012 at 12:21 pm.

One of my favorite tools for making design and UI/UX wire frames is Balsamiq mockups. I know I’ve mentioned this tool many times before and referred to it in presentations, but it really is an awesome tool. I made a simple template in another post for making SharePoint mockups you can download here.

Packt Publishing just released a pretty slick book titled Balsamiq Wireframes Quickstart Guide by Scott Faranello. I’ve been reviewing the book and it’s a great reference for everything from installing the software to file formats, custom objects, design best practices, and more! It’s definitely worth checking out if you need to make wire frame mockups for user interface design or custom look and feel, in SharePoint and other applications.

You can get the book as an eBook or in hard copy online, as well as book reviews and topics covered on the Packt Publishing book page here.

Book Approach (from Packt Publishing):
“This book is a step-by-step guide to learning Balsamiq Mockups and wireframing in general. Written in an engaging, easy to follow style and flow, readers can utilize free, downloadable templates that teach by building upon previous chapters until each lesson is learned and applied, ensuring true learning, not just memorization.” 

Who This Book is For:
“If you are serious about wireframing, designing and communicating your ideas clearly and quickly, then this book is for you.” 

Add Column to Default View Using PowerShell

Posted by on September 10, 2012 at 8:49 am.

Recently I had a request from a client to add a custom site collection column to all document libraries. This is pretty easy though the SharePoint UI of course, by creating a custom Site Column in the collection and adding it to the ‘Document’ content type.

However, in doing this the column is not added to the default view for any document libraries. This can be easily done using PowerShell using the script below. This adds the column to the default view in every document library throughout the entire site collection (referenced here).

$site = Get-SPSite “http://sharepoint.com”
$column = “Column”

$site | Get-SPWeb -limit all | ForEach-Object {

# Get all document libraries
$lists = $_.Lists | where  {$_.BaseType -eq “DocumentLibrary”}

# Loop libraries
for ($i = 0; $i -lt $lists.Count; $i++)
{

try
{

# Get current view
$view = $lists[$i].DefaultView

if($view)
{

# Delete if already exist
while($view.ViewFields.ToStringCollection().Contains($column))
{

$view.ViewFields.delete($column)
$view.Update()

}

# Add column
if(!$view.ViewFields.ToStringCollection().Contains($column))
{

$view.ViewFields.add($column)
$view.Update()

}

}

}
catch [Exception]
{

write-output (”  Error: ” + $_.Exception.ToString())

}

}

}

$site.Dispose()

You can also add views to a view by URL and view name for one specific view or list (a nice tip I found here). Here is another option by using GetViewFromUrl:

$spWeb = Get-SPWeb -Identity "http://mySharePoint"
$spView = $spWeb.GetViewFromUrl("/Lists/MyList/AllItems.aspx")
$spField = $spList.Fields["MyField"]
$spView.ViewFields.Add($spField)
$spView.Update()

You can also try to use SPList object as below:

$spList = Get-SPList -Url "http://mySharePoint/Lists/MyList"
$spView = $spList.Views["All Items"]
$spField = $spList.Fields["MyField"]
$spView.ViewFields.Add($spField)
$spView.Update()

Adding multiple columns to a view can also be done with PowerShell, and even create a new view and set it as the default view. This is really awesome if you want to leave the default ‘All Items’ view in tact, but create a new custom view and set it as default (found here):

Add-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue
$siteURL = "http://dev1share"
 $site = Get-SPSite($siteURL)
foreach($web in $site.AllWebs) {
$listCounter = $web.Lists.Count
 for($i=0;$i -le $listCounter;$i++) {
    $list = $web.Lists[$i]
     if($list.BaseType -eq "DocumentLibrary") {
     $newList = $web.Lists.item($list.ID);
  $viewfields = New-Object System.Collections.Specialized.StringCollection
   $viewfields.Add("DocIcon")
   $viewfields.Add("LinkFilename")
   $viewfields.Add("_UIVersionString")
   $viewfields.Add("Modified")
   $viewfields.Add("Created")
   $viewfields.Add("Editor")
   $viewfields.Add("FileSizeDisplay")
  [void]$newList.Views.Add("Detailed", $viewfields, "", 100, $true, $true)
   $newList.Update();
  $view=$newList.Views["Detailed"]
   $view.DefaultView = $true
   $view.Update()
 }
 }
$web.Dispose();
 }
 $site.Dispose();

SharePoint Versions and Updates

Posted by on August 8, 2012 at 3:19 pm.

One of the things I need to constantly reference in my day to day interactions with SharePoint are the various versions of the platform. This is especially helpful when performing upgrades or debugging content database versions and such during migrations.

Thus far I haven’t found a simple official chart by Microsoft on TechNet or otherwise that shows not only the version number for each SP version (although the latest versions are posted here). Even more, the few resources I’ve found only cover 2010 individually, and certainly not WSS/MOSS. However, Todd Carter has a brilliant blog post on all major SP versions for 2007 and 2010 I’ve referred to so many times I copied here below. I refer to it so much in fact that when he recently moved his blog and the page was unavailable for a day or so I was completely lost.

A big thanks to Todd for collecting this! I’ll try and keep it up to date with new releases as I hear about them. On a side note, at the time of this post (8/8/2012) I’ve been installing/recommending the February 2012 CU with SP1 for SharePoint 2010 although I’ve heard April refresh is great, I just have yet to try it.

SharePoint Versions:

SharePoint Foundation 2010
Release Version KB Download
RTM 14.0.4762.1000 n/a n/a
June 2010 CU 14.0.5114.5003 n/a n/a
Aug 2010 CU 14.0.5123.5000 2352346 download
Oct 2010 CU 14.0.5128.5000 2394323 download
Dec 2010 CU 14.0.5130.5002 2459125 download
Feb 2011 CU 14.0.5136.5002 2475880 download
April 2011 CU 14.0.5138.5001 2512804 download
Service Pack 1 14.0.6029.1000 2460058 download
June 2011 CU 14.0.6106.5000 2536601 n/a
June 2011 CU (Refresh) 14.0.6106.5002 2536601 download
Aug 2011 CU 14.0.6109.5002 2553117 download
Oct 2011 CU 14.0.6112.5000 2596508 download
Dec 2011 CU 14.0.6114.5000 2596998 download
Feb 2012 CU 14.0.6117.5002 2597132 download
April 2012 CU 14.0.6120.5000 2598321 n/a
April 2012 CU (Refresh) 14.0.6120.5006 2598321 download
June 2012 CU 14.0.6123.5002 2598373 download
August 2012 CU 14.0.6126.5000 2687355 download
October 2012 CU 14.0.6129.5000 2687566 download
December 2012 CU 14.0.6131.5001 2596957 download

Back to top

Microsoft SharePoint Server 2010
Release Version KB Download
RTM 14.0.4762.1000 n/a n/a
June 2010 CU 14.0.5114.5003 n/a n/a
Aug 2010 CU 14.0.5123.5000 2352342 download
Oct 2010 CU 14.0.5128.2003 2394320 download
Dec 2010 CU 14.0.5130.5002 2459257 download
Feb 2011 CU 14.0.5136.5002 2475878 download
April 2011 CU 14.0.5138.5001 2512800 download
Service Pack 1 14.0.6029.1000 2460045 download
June 2011 CU 14.0.6106.5000 2536599 n/a
June 2011 CU (Refresh) 14.0.6106.5002 2536599 download
Aug 2011 CU 14.0.6109.5002 2553048 download
Oct 2011 CU 14.0.6112.5000 2596505 download
Dec 2011 CU 14.0.6114.5000 2597014 download
Feb 2012 CU 14.0.6117.5002 2597150 download
April 2012 CU 14.0.6120.5000 2598151 n/a
April 2012 CU (Refresh) 14.0.6120.5006 2598151 download
June 2012 CU 14.0.6123.5002 2598354 download
August 2012 CU 14.0.6126.5000 2687353 download
October 2012 CU 14.0.6129.5003 2687564 download

Back to top

WSS 3.0
Release Version KB Download
RTM 12.0.4518.1016 n/a n/a
Public DST 12.0.6039.5000 934525 n/a
SP1 12.0.6219.1000 936988 n/a
Post SP1 (Jan) (Global) 12.0.6300.5000 941422 download
Post SP1 (Jan) 12.0.6300.5000 941653 download
Post SP1 (Feb) 12.0.6303.5000 948945 download
Post SP1 (Feb) (Global) 12.0.6304.5000 949399 download
Post SP1 (Mar) (Global) 12.0.6305.5000 949749 download
Post SP1 (Mar) (Global) 12.0.6306.5000 949956 download
Post SP1 (Mar) (Global) 12.0.6307.5000 950279 download
Post SP1 (Mar) (Global) 12.0.6308.5000 950484 download
Post SP1 (May) (Global) 12.0.6314.5000 952288 download
Post SP1 (May) 12.0.6314.5000 952292 download
Post SP1 (May) (Global) 12.0.6315.5000 952698 download
Post SP1 (May) (Global) 12.0.6316.5000 953137 download
Post SP1 (June) (Global) 12.0.6317.5000 953473 download
Post SP1 (June) 12.0.6317.5000 953484 download
Infra Update (Global) 12.0.6318.5000 951695 download
Post SP1 (July) 12.0.6324.5000 955594 download
Post SP1 (AAM) 12.0.6324.5001 956248 download
Aug CU (Global) 12.0.6327.5000 956057 download
Aug CU 12.0.6327.5000 957109 download
Oct CU (Global) 12.0.6332.5000 957691 download
Dec COD (Global) 12.0.6335.5000 959644 download
Dec CU 12.0.6335.5000 960010 download
Dec COD (Global) 12.0.6336.5001 961175 download
Feb 2009 CU 12.0.6341.5000 961755 download
SP2 12.0.6421.1000 953338 n/a
April 2009 CU 12.0.6504.5000 968850 download
Jun 2009 CU 12.0.6510.5001 971538 download
Aug 2009 CU 12.0.6514.5004 973400 download
Oct 2009 CU 12.0.6520.5000 974989 download
Dec 2009 CU 12.0.6524.5000 977027 download
Feb 2010 CU 12.0.6529.5000 978396 download
April 2010 CU 12.0.6535.5002 981043 download
Jun 2010 CU 12.0.6539.5000 983311 download
Aug 2010 CU 12.0.6545.5001 2276474 download
Oct 2010 CU 12.0.6548.5000 2412268 download
Dec 2010 CU 12.0.6550.5002 2458606 download
Feb 2011 CU 12.0.6554.5000 2475886 download
April 2011 CU 12.0.6557.5000 2512783 download
June 2011 CU 12.0.6562.5000 2544399 download
Aug 2011 CU 12.0.6565.5001 2553022 download
SP3 12.0.6608.1000 2526305 download
Oct 2011 CU 12.0.6654.5000 2596541 download
Dec 2011 CU 12.0.6656.5000 2596987 download
Feb 2012 CU 12.0.6658.5000 2597959 download
April 2012 CU 12.0.6661.5000 2598130 download
June 2012 CU 12.0.6662.5000 2687257 download
August 2012 CU 12.0.6665.5000 2687331 download

Back to top

MOSS 2007
Release Version KB Download
RTM 12.0.4518.1016 n/a n/a
Public DST 12.0.6034.5000 937832 n/a
SP1 12.0.6219.1000 936984 n/a
Post SP1 (Jan) (Global) 12.0.6300.5000 942819 download
Post SP1 (Jan) (Global) 12.0.6301.5000 945089 download
Post SP1 (Jan) (Global) 12.0.6301.5000 941274 download
Post SP1 (Feb) (Global) 12.0.6303.5000 948947 download
Post SP1 (Feb) (Global) 12.0.6304.5000 949402 download
Post SP1 (Mar) (Global) 12.0.6306.5000 949955 download
Post SP1 (Mar) (Global) 12.0.6307.5000 950280 download
Post SP1 (Mar) (Global) 12.0.6307.5000 950292 download
Post SP1 (Mar) (Global) 12.0.6308.5000 950487 download
Post SP1 (May) (Global) 12.0.6314.5000 952294 download
Post SP1 (May) (Global) 12.0.6315.5000 952704 download
Post SP1 (May) (Global) 12.0.6316.5000 953138 download
Post SP1 (June) (Global) 12.0.6317.5000 953471 download
Infra Update (Global) 12.0.6318.5000 951297 download
Post SP1 (July) (Global) 12.0.6324.5000 955593 download
Post SP1 (July) 12.0.6324.5000 955586 download
Exel Security fix (Global) 12.0.6317.5000 953397 download
Aug CU (Global) 12.0.6327.5000 956056 download
Oct CU 12.0.6331.5000 957693 download
Oct CU 12.0.6331.5000 958569 download
Dec COD (Global) 12.0.6335.5000 959637 download
Dec CU 12.0.6335.5000 960011 download
Dec COD 12.0.6336.5001 961176 download
Dec COD 12.0.6336.5002 963022 download
Feb 2009 CU 12.0.6341.5001 961756 download
SP2 12.0.6421.1000 953334 n/a
April 2009 CU 12.0.6504.5000 968851 download
Jun 2009 CU 12.0.6510.5003 971537 download
Aug 2009 CU 12.0.6514.5002 973399 download
Oct 2009 CU 12.0.6520.5000 974988 download
Dec 2009 CU 12.0.6524.5001 977026 download
Feb 2010 CU 12.0.6529.5000 978395 download
April 2010 CU 12.0.6535.5002 981042 download
Jun 2010 CU 12.0.6539.5000 983310 download
Aug 2010 CU 12.0.6545.5001 2276472 download
Oct 2010 CU 12.0.6548.5000 2412267 download
Dec 2010 CU 12.0.6550.5000 2458605 download
Feb 2011 CU 12.0.6554.5000 2475885 download
April 2011 CU 12.0.6557.5000 2512782 download
June 2011 CU 12.0.6562.5000 2544398 download
Aug 2011 CU 12.0.6565.5000 2553020 download
SP3 12.0.6608.1000 2526299 download
Oct 2011 CU 12.0.6654.5002 2596540 download
Dec 2011 CU 12.0.6656.5001 2596986 download
Feb 2012 CU 12.0.6658.5000 2597958 download
April 2012 CU 12.0.6661.5000 2598129 download
June 2012 CU 12.0.6662.5000 2687256 download
August 2012 CU 12.0.6645.5001 2276472 download

Back to top