Balsamiq Wireframes Quickstart Guide

Posted by on October 29, 2012 at 12:21 pm. Comments Off on Balsamiq Wireframes Quickstart Guide

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. One comment

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 comment

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

Add Custom Words to SharePoint 2010 Spell Check

Posted by on June 7, 2012 at 8:50 am. Comments Off on Add Custom Words to SharePoint 2010 Spell Check

This was a unique one, I had a client recently who utilized SharePoint 2010 for their internal corporate intranet. In my mind one of the best uses for SharePoint, although every time they typed their company name SharePoint would say it was a misspelling!

Obviously it’s not ideal to see the red squiggly line every time you type your company name. Really, Microsoft should have build some kind of global dictionary term management system for adding words with an option to allow end users to add dictionary terms or admins only… but they didn’t. A quick hop around the community found me this great article by Kathryn Ciaralli which did the trick.

You in fact can add custom terms to your SharePoint dictionary! Unfortunately this solution is only per each site collection, but you can setup publishing jobs to keep everything in sync I suppose. To add custom terms to your SharePoint spell check dictionary, do the following for each site collection:

  1. Create a document library at the root site level for your site collection called ‘Spelling’.
    spelling
  2. Create a .txt file on your computer with the custom terms you’d like to add to the dictionary – add one term per line. When you’re done, save it as “Custom Dictionary.txt”.

    Custom Dictionary.txt

  3. Upload the Custom Dictionary.txt file to the new Spelling document library. Bing! Custom terms added to your site collection dictionary, one and done. Simple as that.