Tuesday, February 1, 2011

PowerShell for SharePoint on Steroids!

I created this script as an effort to quickly deploy an entire site structure into a DEV and QA (and potentially PROD) environment. I also wanted something I could easily edit on the fly. You can copy and paste the source code and save it as a ps1 file or download the code. You must run it on a SharePoint server with farm administrator privileges.

This script includes the following functions:

- Creating Web Application
- Creating Site Collections
- Creating Subsites
- Setting Master Pages recursively.
- Adding Features
- Adding Site Columns
- Creating Lists
- Adding folders to Lists
- Adding Site Column to Lists
- Creating Views
- Enabling/Disabling Publishing, Checkin, and Approvals
- Creating Sample Items for Links, Announcements, and Calendar lists with permissions.
- Creating Publishing Pages
- Creating Groups with default owners
- Set Group permissions for subsites
- Add Content Query Web Parts (CQWP) for site and subsite lists.

Tools
You can easily use Notepad to edit this file, but I highly recommend PowerGUI.
It it is free and has a great interface and provides things like debugging, Intellisense, formatting,
and plug-ins. Power GUI: http://www.powergui.org

Developer Notes: I am not a PowerShell pro by any stretch of imagination and am still learning the intricacies of the language. There is no use of classes, collections, and exception handling is sparse. Some of this is due to my ignorance on the subject. That being said, I have no doubt there are areas that can be written more efficiently.

CreateSamplePublishingPortal Function

Description
This function will use all of the scripts functions and create an entire web application and site collection with subsites, site columns, lists, sample list items, and permissions. You can easily comment out or change

Parameters
If you choose false for either, ensure that all of the variables in the function are correct.
$createWebApplication - Boolean to determine if Web Application is created.
$createSiteCollection - Boolean to determine if Site Collection is created.
$env - Determines the environment. Valid values are: "dev", "qa", or "prod".
Variables within the function must be updated to use this functionality.

Global Variables
Before running the script, you will want to make sure and update all Global Variabes in this script
to ensure they will work with your environment. You can also comment out parts of the script that you don't want to run.

Lists
The multichoice "Site Visibility" site column is added to all lists. It include the values
"Private Team", "Public Team", and "Intranet".
- Corresponding views are created for each "Site Visibility" value.
- A "public" folder added to each list and read permissions added to allow users outside of the private site.
- Sample items are also added to the lists and every combination of "Site Visibility" is used. If the
value for the item has a "Site Visibility" that contains "Public Team" or "Intranet" it is moved into the "public" folder.
This allows permissions to stay at the folder level and not the item level.
- Note: A workflow still needs to be created to ensure that when items are created or changed they go to the public folder.

Permissions
All departmental private team sites disinherit the top level permissions so that unique permissions can be created. For example, Human Resources would include the following groups:

Group Name Permission
HR Owners Full Control
HR Members Contribue
HR Visitors Read

The script also applies a default owner for all groups. This is an array variable that can be updated before running the script.

Aggregate Views
Aggregate views using Content Query Web Parts (CQWP) are added to the Intranet and Public departmental team sites.

Extras
The script also does a few extra things like disabling publishing and approval, changing master page to v4.master, enabling Team Collaboration Features. I did this for a little more flexibility, especially for DEV and QA mode. These can all be easily disabled or changed back by using one of the functions in this file. For example, if you already have a web application, you can comment out "CreateWebApplication".

Execution Time
My notebook is not virtual, has an Intel i7 an 8 GB RAM. It takes around 8 minutes to run the entire script. Of that 8 minutes. Rough creation times (in seconds): Web Applicatoin: 110 s. / Site collection: 75 s. / Site: 30 s.

Site Hierarchy
The following site hierarchy is created with this function. You can easily change this hierarchy by updating the variables in the function.

Intranet (Web Application)
Intranet Site Collection *(See notes below)
Departments (Publishing Site)
Private (Publishing Site)
Finance (Publishing Site)
Announcements (Announcements List)
News (News List)
Team (Calendar Calendar)
I Want To (Links List)
Staff Roles (Publishing Page)
Training (Publishing Page)
New Hires (Publishing Page)
Human Resources (Publishing Site)
Announcements (Announcements List)
News (News List)
Team (Calendar Calendar)
I Want To (Links List)
Staff Roles (Publishing Page)
Training (Publishing Page)
New Hires (Publishing Page)
Information Technology Publishing Site
Announcements (Announcements List)
News (News List)
Team (Calendar Calendar)
I Want To (Links List)
Staff Roles (Publishing Page)
Training (Publishing Page)
New Hires (Publishing Page)
Marketing (Publishing Site)
Announcements (Announcements List)
News (News List)
Team (Calendar Calendar)
I Want To (Links List)
Staff Roles (Publishing Page)
Training (Publishing Page)
New Hires (Publishing Page)
Public Publishing Site
Finance (Publishing Site) **(See notes below)
Human Resources (Publishing Site) **(See notes below)
Information Technology (Publishing Site) **(See notes below)
Marketing (Publishing Site) **(See notes below)

* Intranet Home page includes CQWPs that point to Lists from all departmental Private departmental sites. These are filtered by "Site Visibility" column where the value contains "Intranet".

** TODO: Departmental Public Home page includes CQWPs that aggregate Lists from corresponding Private departmental site.
These are filtered by "Site Visibility" column where the value contains "Public Team".

Download Link
SharePoint 2010 Portal Builder.ps1

Source Code
(Unfortunately, blogspot destroyed any decent formatting I had, so I recommend downloading the file.)

#--------------------------------Sharepoint 2010 Portal Builder-------------------------------------------------------
#
# Description: I created this script as an effort to deploy an entire site structure
# into a DEV and QA (and potentially PROD) environment up and running quick.
# I also wanted something I could easily edit on the fly.
#
# This script includes the following functions:
#
# - Creating Web Application
# - Creating Site Collections
# - Creating Subsites
# - Setting Master Pages recursively.
# - Adding Features
# - Adding Site Columns
# - Creating Lists
# - Adding folders to Lists
# - Adding Site Column to Lists
# - Creating Views
# - Enabling/Disabling Publishing, Checkin, and Approvals
# - Creating Sample Items for Links, Announcements, and Calendar lists with permissions.
# - Creating Publishing Pages
# - Creating Groups with default owners
# - Set Group permissions for subsites
# - Add Content Query Web Parts (CQWP) for site and subsite lists.
#
# Tools: You can easily use Notepad to edit this file, but I highly recommend PowerGUI.
# It it is free and has a great interface and provides things like debugging, Intellisense, formatting,
# and plug-ins. Power GUI: http://www.powergui.org
#
# Developer Notes: I am not a PowerShell pro by any stretch of imagination and am still learning the intricacies of the language.
# There is no use of classes, collections, and exception handling is sparse. Some of this is due to my ingorance
# on the subject. That being said, I have no doubt there are areas that can be written more efficiently.
#
# Author: John Livingston
# Website: http://johnlivingstontech.blogspot.com
# Created Date: 2/1/2011
# Updated Date: 2/1/2011
#
#--------------------------------CreateSamplePublishingPortal Function-------------------------------------------------------
#
# Description: This function will use all of the scripts functions and create an entire web application and site collection
# with subsites, site columns, lists, sample list items, and permissions. You can easily comment out or change
#
# Parameters: If you choose false for either, ensure that all of the variables in the function are correct.
# $createWebApplication - Boolean to determine if Web Application is created.
# $createSiteCollection - Boolean to determine if Site Collection is created.
# $env - Determines the environment. Valid values are: "dev", "qa", or "prod".
# Variables within the function must be updated to use this functionality.
#
# Global Variables: Before running the script, you will want to make sure and update all Global Variabes in this script
# to ensure they will work with your environment. You can also comment out parts of the script that you don't want to run.
#
# Lists: - The multichoice "Site Visibility" site column is added to all lists. It include the values
# "Private Team", "Public Team", and "Intranet".
# - Corresponding views are created for each "Site Visibility" value.
# - A "public" folder added to each list and read permissions added to allow users outside of the private site.
# - Sample items are also added to the lists and every combination of "Site Visibility" is used. If the
# value for the item has a "Site Visibility" that contains "Public Team" or "Intranet" it is moved into the "public" folder.
# This allows permissions to stay at the folder level and not the item level.
# - Note: A workflow still needs to be created
# to ensure that when items are created or changed they go to the public folder.
#
# Permissions: All departmental private team sites disinherit the top level permissions so that unique permissions can be created.
# For example, Human Resources would include the following groups:
#
# Group Name Permission
# HR Owners Full Control
# HR Members Contribue
# HR Visitors Read
#
# The script also applies a default owner for all groups. This is an array variable that can be updated before running the script.
#
# Aggregate Views: Aggregate views using Content Query Web Parts (CQWP) are added to the Intranet and Public departmental team sites.
# and aggregate views CQWP that use list views
# created from the private team sites.
# It also does a few extra things like disabling publishing and approval, changing master page to v4.master,
# enabling Team Collaboration Features.
#
# Extras: The script also does a few extra things like disabling publishing and approval, changing master page to v4.master,
# enabling Team Collaboration Features. I did this for a little more flexibility, especially for DEV and QA mode.
# These can all be easily disabled or changed back by using one of the functions in this file. For example, if you already
# have a web application, you can comment out "CreateWebApplication".
#
# Execution Time: My notebook is not virtual, has an Intel i7 an 8 GB RAM. It takes around 8 minutes to run the entire script. Of that 8 minutes.
# Rough creation times (in seconds): Web Applicatoin: 110 s. / Site collection: 75 s. / Site: 30 s.
#
#
# Site Hierarchy: The following site hierarchy is created with this function.
# You can easily change this hierarchy by updating the variables in the function.
#
# Intranet Web Application
# Intranet Site Collection *(See notes below)
# Departments Publishing Site
# Private Publishing Site
# Finance Publishing Site
# Announcements Announcements List
# News News List
# Team Calendar Calendar
# I Want To Links List
# Staff Roles Publishing Page
# Training Publishing Page
# New Hires Publishing Page
# Human Resources Publishing Site
# Announcements Announcements List
# News News List
# Team Calendar Calendar
# I Want To Links List
# Staff Roles Publishing Page
# Training Publishing Page
# New Hires Publishing Page
# Information Technology Publishing Site
# Announcements Announcements List
# News News List
# Team Calendar Calendar
# I Want To Links List
# Staff Roles Publishing Page
# Training Publishing Page
# New Hires Publishing Page
# Marketing Publishing Site
# Announcements Announcements List
# News News List
# Team Calendar Calendar
# I Want To Links List
# Staff Roles Publishing Page
# Training Publishing Page
# New Hires Publishing Page
# Public Publishing Site
# Finance Publishing Site **(See notes below)
# Human Resources Publishing Site **(See notes below)
# Information Technology Publishing Site **(See notes below)
# Marketing Publishing Site **(See notes below)
#
# * Intranet Home page includes CQWPs that point to Lists from all departmental Private departmental sites.
# These are filtered by "Site Visibility" column where the value contains "Intranet".
#
# ** TODO: Departmental Public Home page includes CQWPs that aggregate Lists from corresponding Private departmental site.
# These are filtered by "Site Visibility" column where the value contains "Public Team".

function CreateWebApplication ($webApplicationName, $appPoolUserName, $appPoolPassword, $portNumber, $serverName, $timeZoneId)
{
#--------------CONCATENATED VARIABLES (UPDATE FORMAT IF NECESSARY)-----------------
$appPoolName = $webApplicationName + "_AppPool" ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
$databaseServer = $webApplicationName + "_ContentDB" ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
$rootDirectory = "C:\Inetpub\wwwroot\wss\VirtualDirectories\" + $portNumber ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
#--------------CREATING WEB APP-----------------
Write-Host "Creating Web Application - "$webApplicationName
$farm = [microsoft.sharepoint.administration.spfarm]::local
$WebAppBuilder = new-object microsoft.sharepoint.administration.SPWebApplicationBuilder($farm)
$WebAppBuilder.ApplicationPoolId = $appPoolName
$WebAppBuilder.ApplicationPoolUsername = $appPoolUserName
$WebAppBuilder.ApplicationPoolPassword = $appPoolPassword
$WebAppBuilder.IdentityType = [Microsoft.SharePoint.Administration.IdentityType]::SpecificUser
$WebAppBuilder.Port = $portNumber
$WebAppBuilder.ServerComment = $webApplicationName
$WebAppBuilder.CreateNewDatabase = $true
$WebAppBuilder.DatabaseServer = $serverName
$WebAppBuilder.DatabaseName = $databaseServer
$WebAppBuilder.RootDirectory = $rootDirectory
$WebAppBuilder.UseSecureSocketsLayer = $false
$WebAppBuilder.AllowAnonymousAccess = $false
$webapp = $WebAppBuilder.Create()
$webapp.ProvisionGlobally()
$webapp.DefaultTimeZone = $timeZoneId
$webapp.Update()
Write-Host "Finished Creating Web Application - "$webApplicationName
}

function CreateSiteCollection($siteName, $siteUrl, $siteOwner, $siteTemplate, $removeLibraryApprovalWorkflow, $disableCheckoutModeration, $addTeamCollaborationFeature)
{
Write-Host "Creating Site Collection - "$siteName
New-SPSite -Name $siteName -Url $siteUrl -OwnerAlias $siteOwner -Template $siteTemplate
Write-Host "Finished Creating Site Collection - "$siteName
if($disableCheckoutModeration)
{
EnableMasterPageModerationCheckout $siteUrl $disableCheckoutModeration
}
if($removeLibraryApprovalWorkflow)
{
$listNames = @("Pages", "Documents", "Images") #Publishing Site Default Lists
RemoveApprovalWorkflows $siteUrl "" $listNames "Page Approval"
}
if($addTeamCollaborationFeature)
{
$teamCollaborationGuid = New-Object System.Guid("00bfea71-4ea5-48d4-a4ad-7ea5c011abe5") #Team Collaboration Feature (Allows for more content types)
AddWebFeature $siteUrl "" $teamCollaborationGuid
}
}

function CreateWeb($siteUrl, $webUrl, $mappedPath, $webName, $webOwner, $webTemplate, $removeLibraryApprovalWorkflow, $addTeamCollaborationFeature)
{
Write-Host "Creating Web - "$webName
New-SPWeb -Name $webName -Url ($siteUrl+$webUrl) -Template $webTemplate
if($removeLibraryApprovalWorkflow)
{
$listNames = @("Pages", "Documents", "Images") #Publishing Site Default Lists
if($removeLibraryApprovalWorkflow)
{
RemoveApprovalWorkflows $siteUrl $webRelativeUrl $listNames "Page Approval"
}
if($addTeamCollaborationFeature)
{
$teamCollaborationGuid = New-Object System.Guid("00bfea71-4ea5-48d4-a4ad-7ea5c011abe5") #Team Collaboration Feature (Allows for more content types)
AddWebFeature $siteUrl ($mappedPath+$webUrl) $teamCollaborationGuid
}
}
Write-Host "Finished Creating Web - "$webName
}

function AddWebFeature($siteUrl, $webUrl, $featureGuid)
{
$site = Get-SPSite $siteUrl
try
{
$web = $site.OpenWeb($webUrl)
try
{
$web.Features.Add($featureGuid)
Write-Host "Finished Adding Feature - ("+$featureGuid+") "+$siteUrl$webUrl
}
finally
{
$web.Dispose()
}
}
finally
{
$site.Dispose()
}
Write-Host "Finished Creating List - "$listName "for" $webUrl
}

function AddContentByQueryWebPart($siteUrl, $webPartSourceWebUrl, $webPartWebUrl, $queryListWebUrl, $webPartPageUrl, $queryListName, $webPartTitle, $filterField, $filterValue, $filterDisplayValue, $itemLimit, $zoneId, $zoneIndex)
{
$listId = ""
try
{
$site = Get-SPSite $siteUrl
try
{
$web = $site.OpenWeb($queryListWebUrl)
$list = $web.Lists[$queryListName]
$listId = $list.ID
}
finally
{
$web.Dispose()
}
try
{
$web = $site.OpenWeb($webPartSourceWebUrl)
$web.AllowUnsafeUpdates = $true
$file = $web.GetFile($webPartPageUrl)
try
{
$list = $web.Lists["Pages"]
if($list.ForceCheckout -eq $true)
{
$file.CheckOut()
$file.Update()
}
$mgr = $file.GetLimitedWebPartManager([System.Web.UI.WebControls.WebParts.PersonalizationScope]::Shared)
$cqwp = New-Object Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart
$cqwp.DisplayColumns = 1
$cqwp.FeedEnabled = $false
$cqwp.Filter1ChainingOperator = 0#Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart.FilterChainingOperator.And
$cqwp.Filter1IsCustomValue = $false
$cqwp.FilterByAudience = $false
$cqwp.FilterDisplayValue1 = $filterDisplayValue
$cqwp.FilterField1 = $filterField
$cqwp.FilterIncludeChildren1 = $false
$cqwp.FilterOperator1 = "Contains"#1#Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart.FilterFieldQueryOperator.Contains
$cqwp.FilterType1 = "MultiChoice"
$cqwp.FilterValue1 = $filterValue
$cqwp.GroupByDirection = 1#Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart.SortDirection.Desc
$cqwp.GroupStyle = "DefaultHeader"
$cqwp.ItemLimit = $itemLimit
$cqwp.ItemStyle = "Default"
$cqwp.ListGuid = $listId
$cqwp.ListName = $queryListName
$cqwp.PlayMediaInBrowser = $true
$cqwp.ServerTemplate = "104"
$cqwp.ShowUntargetedItems = $false
$cqwp.SortBy = "Created"
$cqwp.SortByDirection = 1#Microsoft.SharePoint.Publishing.WebControls.ContentByQueryWebPart.SortDirection.Desc
$cqwp.SortByFieldType = "DateTime"
$cqwp.Title = $webPartTitle
$cqwp.UseCache = $true
$cqwp.UseCopyUtil = $true
$cqwp.WebUrl = $webPartWebUrl
$mgr.AddWebPart($cqwp, $zoneId, $zoneIndex)
if($list.ForceCheckout -eq $true)
{
$file.Update()
$file.CheckIn("")
$file.Publish("")
$file.Approve("")
}
$web.Update()
Write-Host "Finished Adding Content Query Web Part - "$siteUrl$webPartWebUrl" from "$queryListWebUrl "("$queryListName")"
}
finally
{
$mgr.Dispose()
}
}
finally
{
$web.Dispose()
}
}
finally
{
$site.Dispose()
}
}

function CreateList($siteUrl, $webUrl, $listName, $listDescription, $listTemplate)
{
$site = Get-SPSite $siteUrl
try
{
$web = $site.OpenWeb($webUrl)
try
{
$web.Lists.Add($listName, $listDescription, $listTemplate)
$web.Update()
Write-Host "Finished Creating List - "$webUrl"/"$listName
}
finally
{
$web.Dispose()
}
}
finally
{
$site.Dispose()
}
Write-Host "Finished Creating List - "$listName "for" $webUrl
}

function AddListFolder($siteUrl, $webUrl, $listName, $folderName, $isList)
{
$site = Get-SPSite $siteUrl
try
{
$web = $site.OpenWeb($webUrl)
try
{
$list = $web.Lists[$listName]
if($isList)
{
$folder = $list.Items.Add($list.RootFolder.ServerRelativeUrl, [Microsoft.SharePoint.SPFileSystemObjectType]::Folder, $folderName)
}
else
{
$folder = $list.RootFolder.SubFolders.Add($folderName).Item
}
if(!($folder.ModerationInformation -eq $null))
{
$folder.ModerationInformation.Status = [Microsoft.SharePoint.SPModerationStatusType]::Approved
}
$folder.Update()
Write-Host "Finished Creating Folder - "$folderName" on "$siteUrl$webUrl"/"$listName"/"
}
finally
{
$web.Dispose()
}
}
finally
{
$site.Dispose()
}
}

function AddListSiteColumn($siteUrl, $webUrl, $listName, $fieldName)
{
$site = Get-SPSite $siteUrl
try
{
$web = $site.OpenWeb($webUrl)
try
{
$list = $web.Lists[$listName]
$field = $site.RootWeb.Fields[$fieldName]
$list.Fields.Add($field)
$list.Update()
$view = $list.DefaultView
$view.ViewFields.Add($fieldName)
$view.Update()
Write-Host "Finished Adding Site Column - "$fieldName" to "$siteUrl$webUrl"/"$listName"/"
}
finally
{
$web.Dispose()
}
}
finally
{
$site.Dispose()
}
}

function AddListView($siteUrl, $webUrl, $listName, $viewName, $fieldNames, $camlQuery, $rowLimit, $paged, $defaultView, $showFolders)
{
$site = Get-SPSite $siteUrl
try
{
$web = $site.OpenWeb($webUrl)
try
{
$list = $web.Lists[$listName]
$colViews = $list.Views
$collViewFields = New-Object System.Collections.Specialized.StringCollection
foreach($fieldName in $fieldNames)
{
$collViewFields.Add($fieldName)
}
$strQuery = ($camlQuery)
$colViews.Add($viewName, $collViewFields, $strQuery, $rowLimit, $paged, $defaultView)
if($showFolders -eq $false)
{
$view = $list.Views[$viewName]
$view.Scope = [Microsoft.SharePoint.SPViewScope]::Recursive
$view.Update()
}
Write-Host "Finished Adding List View - "$viewName" to "$siteUrl$webUrl"/"$listName"/"
}
finally
{
$web.Dispose()
}
}
finally
{
$site.Dispose()
}
}

function SetListFolderPermissions($siteUrl, $webUrl, $listName, $folderName, $groupName, $roleDefinition)
{
$site = Get-SPSite $siteUrl
try
{
$web = $site.OpenWeb($webUrl)
try
{
$list = $web.Lists[$listName]
$folder = $list.RootFolder.SubFolders[$folderName].Item
$folder.BreakRoleInheritance($true)
$web.AllowUnsafeUpdates = $true
$group = $web.SiteGroups[$groupName]
$roleAssignment = New-Object Microsoft.SharePoint.SPRoleAssignment($group)
$roleAssignment.RoleDefinitionBindings.Add($web.RoleDefinitions[$roleDefinition])
$folder.RoleAssignments.Add($roleAssignment)
$folder.Update()
Write-Host "Finished Adding Permissions to folder "$folderName" on "$siteUrl$webUrl"/"$listName" ("$groupName" - "$roleDefinition")"
}
finally
{
$web.Dispose()
}
}
finally
{
$site.Dispose()
}
}

function CreateSiteColumnMultiChoice($siteUrl, $fieldName, $fieldChoices, $defaultValue, $group, $required)
{
$site = Get-SPSite $siteUrl
try
{
$web = $site.OpenWeb()
try
{
$web.Fields.Add($fieldName, [Microsoft.SharePoint.SPFieldType]::MultiChoice, $required)
$field = $web.Fields[$fieldName]
foreach($fieldChoice in $fieldChoices)
{
$field.Choices.Add($fieldChoice)
}
$field.DefaultValue = $defaultValue
$field.Group = $group
$field.Update()
Write-Host "Finished Adding Site Column ("$fieldName") to web "$siteUrl
}
finally
{
$web.Dispose()
}
}
finally
{
$site.Dispose()
}
}

function SetRoleInheritance($siteUrl, $webUrl, $breakInheritance)
{
$site = Get-SPSite $siteUrl
try
{
$web = $site.OpenWeb($webUrl)
try
{
if($breakInheritance)
{
$web.BreakRoleInheritance($breakInheritance)
}
else
{
$web.ResetRoleInheritance()
}
}
finally
{
$web.Dispose()
}
}
finally
{
$site.Dispose()
}
Write-Host "Finished Setting Inheritance - "$siteUrl$webUrl " (Break Inheritance - "$breakInheritance")"
}

function AddSiteGroup($siteUrl, $groupName, $defaultUser, $ownerGroup, $description)
{
$site = Get-SPSite $siteUrl
try
{
$web = $site.OpenWeb()
try
{
$web.SiteGroups.Add($groupName, $web.SiteGroups[$ownerGroup], $web.SiteUsers[$defaultUser], $description)
}
finally
{
$web.Dispose()
}
}
finally
{
$site.Dispose()
}
Write-Host "Finished Adding Site Group - "$groupName" to "$siteUrl
}

function AddGroupPermission($siteUrl, $webUrl, $groupName, $roleDefinitionName)
{
$site = Get-SPSite $siteUrl
try
{
$web = $site.OpenWeb($webUrl)
try
{
$web.AllowUnsafeUpdates = $true
$group = $site.RootWeb.SiteGroups[$groupName]
$roleAssignment = New-Object Microsoft.SharePoint.SPRoleAssignment($group)
$roleDefinition = $site.RootWeb.RoleDefinitions[$roleDefinitionName]
$roleAssignment.RoleDefinitionBindings.Add($roleDefinition)
$web.RoleAssignments.Add($roleAssignment)
$web.Update()
}
finally
{
$web.Dispose()
}
}
finally
{
$site.Dispose()
}
Write-Host "Finished Adding Group Permission - "$groupName "("$roleDefinitionName") to "$siteUrl$webUrl
}

function RemoveGroupPermission($siteUrl, $webUrl, $groupName)
{
$site = Get-SPSite $siteUrl
try
{
$web = $site.OpenWeb($webUrl)
try
{
$web.AllowUnsafeUpdates = $true
$group = $site.RootWeb.SiteGroups[$groupName]
$web.RoleAssignments.Remove($group)
$web.Update()
}
finally
{
$web.Dispose()
}
}
finally
{
$site.Dispose()
}
Write-Host "Finished Removing Group Permission - "$groupName "from" $siteUrl$webUrl
}

function CreatePublishingPage($siteUrl, $webUrl, $pageFileName, $pageName)
{
$site = Get-SPSite $siteUrl
try
{
$web = $site.OpenWeb($webUrl)
try
{
$publishingWeb = [Microsoft.SharePoint.Publishing.PublishingWeb]::GetPublishingWeb($web)
$pageLayouts = $publishingWeb.GetAvailablePageLayouts()
$currPageLayout = $pageLayouts[0]
$pages = $publishingWeb.GetPublishingPages()
$newPage = $pages.Add($pageFileName, $currPageLayout)
$newPage.Title = $pageName
$newPage.Update()
$newPage.CheckIn("")
$newPage.ListItem.File.Approve("")
Write-Host "Finished Creating Page - "$pageName "for" $webUrl
}
finally
{
$web.Dispose()
}
}
finally
{
$site.Dispose()
}
}

function RemoveApprovalWorkflows($siteUrl, $webUrl, $listNames, $workFlowName)
{
foreach($listName in $listNames)
{
RemoveApprovalWorkflow $siteUrl $webUrl $listName $workFlowName
}
}

function RemoveApprovalWorkflow($siteUrl, $webUrl, $listName, $workFlowName)
{
$site = Get-SPSite $siteUrl
try
{
$web = $site.OpenWeb($webUrl)
try
{
$list = $web.Lists[$listName]
if(!($list -eq $null))
{
$wa = $list.WorkflowAssociations.GetAssociationByName($workFlowName, [System.Globalization.CultureInfo]::CurrentCulture)
if(!($wa -eq $null))
{
Write-Host "Removing" $wa.Name "from" $listName
$list.WorkflowAssociations.Remove($wa)
Write-Host "Finished Removing Workflow "$workFlowName" from "$siteUrl$webUrl"/"$listName
}
}
}
finally
{
$web.Dispose()
}
}
finally
{
$site.Dispose()
}
}

function AddApprovalWorkflow($siteUrl, $webUrl, $listName, $workflowTemplateName, $workflowName, $workflowTaskName, $workflowHistoryName)
{
$site = Get-SPSite $siteUrl
try
{
$web = $site.OpenWeb($webUrl)
try
{
$list = $web.Lists[$listName]
if(!($list -eq $null))
{
$wfTemp = $web.WorkflowTemplates.GetTemplateByName($workflowTemplateName, [System.Globalization.CultureInfo]::CurrentCulture);
$wf = [Microsoft.SharePoint.Workflow.SPWorkflowAssociation]::CreateListAssociation($wfTemp, $workflowName, $web.Lists[$workflowTaskName], $web.Lists[$workflowHistoryName]);
$list.WorkflowAssociations.Add($wf)
$list.DefaultContentApprovalWorkflowId = $wf.Id
$list.Update()
Write-Host "Finished Adding Workflow "$workflowTemplateName" to "$siteUrl$webUrl"/"$listName
}
}
finally
{
$web.Dispose()
}
}
finally
{
$site.Dispose()
}
}

function EnableMasterPageModerationCheckout($siteUrl, $enable)
{
$site = Get-SPSite $siteUrl
try
{
$list = $site.GetCatalog([Microsoft.SharePoint.SPListTemplateType]::MasterPageCatalog)
$list.EnableModeration = $enable
$list.ForceCheckout = $enable
$list.Update()
Write-Host "MasterPage Moderation and Checkout on "$siteUrl" set to "$enable
}
finally
{
$site.Dispose()
}
}

function UpdateMasterPageUrl($siteUrl, $webUrl, $masterPageUrl, $inheritMasterPage)
{
$site = Get-SPSite $siteUrl
try
{
$web = $site.OpenWeb($webUrl)
try
{
$web.CustomMasterUrl = $masterPageUrl
if(!($web -eq $null))
{
if($inheritMasterPage)
{
$web.AllProperties["__InheritsCustomMasterUrl"] = "True";
}
else
{
$web.AllProperties["__InheritsCustomMasterUrl"] = "False";
}
}
Write-Host "MasterPage Updated for "$siteUrl"/"$webUrl" (Custom URL:"$masterPageUrl" / Inheritance:"$inheritMasterPage")"
$web.Update()
}
finally
{
$web.Dispose()
}
}
finally
{
$site.Dispose()
}
}

function AddSampleAnnouncements($siteUrl, $webUrl, $webName, $listName)
{
$title = "Announcement"
$site = Get-SPSite $siteUrl
try
{
$web = $site.OpenWeb($webUrl)
try
{
$list = $web.Lists[$listName]
$listItems = $list.Items
$itemCount = ($listItems.Count - 1)
for($i=0; $i -lt $itemCount; $i++)
{
if(!($item.FileSystemObjectType -eq [Microsoft.SharePoint.SPFileSystemObjectType]::Folder))
{
$listItems.Delete($i)
}
}
#Private Team Item
$item = $list.Items.Add()
$item["Title"] = ($webName + " " + $title + " - 1")
$item["Body"] = "Lorem ipsum dolor sit amet, consectetur adipiscing elit."
$siteVisValue = New-Object Microsoft.SharePoint.SPFieldMultiChoiceValue
$siteVisValue.Add("Private Team")
$item["Site Visibility"] = $siteVisValue
$item.Update()
#Public Team Item
$folder = $list.RootFolder.SubFolders["public"]
$item = $list.Items.Add($folder.ServerRelativeUrl, [Microsoft.SharePoint.SPFileSystemObjectType]::File)
$item["Title"] = ($webName + " " + $title + " - 2")
$item["Body"] = "Lorem ipsum dolor sit amet, consectetur adipiscing elit."
$siteVisValue = New-Object Microsoft.SharePoint.SPFieldMultiChoiceValue
$siteVisValue.Add("Public Team")
$item["Site Visibility"] = $siteVisValue
$item.Update()
#Intranet Item
$folder = $list.RootFolder.SubFolders["public"]
$item = $list.Items.Add($folder.ServerRelativeUrl, [Microsoft.SharePoint.SPFileSystemObjectType]::File)
$item["Title"] = ($webName + " " + $title + " - 3")
$item["Body"] = "Lorem ipsum dolor sit amet, consectetur adipiscing elit."
$siteVisValue = New-Object Microsoft.SharePoint.SPFieldMultiChoiceValue
$siteVisValue.Add("Intranet")
$item["Site Visibility"] = $siteVisValue
$item.Update()
#Private Team and Public Team
$folder = $list.RootFolder.SubFolders["public"]
$item = $list.Items.Add($folder.ServerRelativeUrl, [Microsoft.SharePoint.SPFileSystemObjectType]::File)
$item["Title"] = ($webName + " " + $title + " - 4")
$item["Body"] = "Lorem ipsum dolor sit amet, consectetur adipiscing elit."
$siteVisValue = New-Object Microsoft.SharePoint.SPFieldMultiChoiceValue
$siteVisValue.Add("Private Team")
$siteVisValue.Add("Public Team")
$item["Site Visibility"] = $siteVisValue
$item.Update()
#Private Team, Public Team, and Intranet Item
$folder = $list.RootFolder.SubFolders["public"]
$item = $list.Items.Add($folder.ServerRelativeUrl, [Microsoft.SharePoint.SPFileSystemObjectType]::File)
$item["Title"] = ($webName + " " + $title + " - 5")
$item["Body"] = "Lorem ipsum dolor sit amet, consectetur adipiscing elit."
$siteVisValue = New-Object Microsoft.SharePoint.SPFieldMultiChoiceValue
$siteVisValue.Add("Private Team")
$siteVisValue.Add("Public Team")
$siteVisValue.Add("Intranet")
$item["Site Visibility"] = $siteVisValue
$item.Update()
#Public Team and Itranet Item
$folder = $list.RootFolder.SubFolders["public"]
$item = $list.Items.Add($folder.ServerRelativeUrl, [Microsoft.SharePoint.SPFileSystemObjectType]::File)
$item["Title"] = ($webName + " " + $title + " - 6")
$item["Body"] = "Lorem ipsum dolor sit amet, consectetur adipiscing elit."
$siteVisValue = New-Object Microsoft.SharePoint.SPFieldMultiChoiceValue
$siteVisValue.Add("Public Team")
$siteVisValue.Add("Intranet")
$item["Site Visibility"] = $siteVisValue
$item.Update()
#Private Team and Intranet Iteam
$folder = $list.RootFolder.SubFolders["public"]
$item = $list.Items.Add($folder.ServerRelativeUrl, [Microsoft.SharePoint.SPFileSystemObjectType]::File)
$item["Title"] = ($webName + " " + $title + " - 7")
$item["Body"] = "Lorem ipsum dolor sit amet, consectetur adipiscing elit."
$siteVisValue = New-Object Microsoft.SharePoint.SPFieldMultiChoiceValue
$siteVisValue.Add("Private Team")
$siteVisValue.Add("Intranet")
$item["Site Visibility"] = $siteVisValue
$item.Update()
Write-Host "Finished Adding Sample Announcements to "$siteUrl$webUrl" ("$listName")"
}
finally
{
$web.Dispose()
}
}
finally
{
$site.Dispose()
}
}

function AddSampleLinks($siteUrl, $webUrl, $webName, $listName)
{
$title = "Link"
$site = Get-SPSite $siteUrl
try
{
$web = $site.OpenWeb($webUrl)
try
{
#Private Team Item
$list = $web.Lists[$listName]
$item = $list.Items.Add()
$item["Title"] = ($webName + " " + $title + " - 1")
$urlValue = New-Object Microsoft.SharePoint.SPFieldUrlValue
$urlValue.Description = $webName + " - " + $title + " 1"
$urlValue.Url = "http://www.google.com"
$item["URL"] = $urlValue
$siteVisValue = New-Object Microsoft.SharePoint.SPFieldMultiChoiceValue
$siteVisValue.Add("Private Team")
$item["Site Visibility"] = $siteVisValue
$item.Update()
#Public Team Item
$folder = $list.RootFolder.SubFolders["public"]
$item = $list.Items.Add($folder.ServerRelativeUrl, [Microsoft.SharePoint.SPFileSystemObjectType]::File)
$item["Title"] = ($webName + " " + $title + " - 2")
$urlValue = New-Object Microsoft.SharePoint.SPFieldUrlValue
$urlValue.Description = $webName + " - " + $title + " 2"
$urlValue.Url = "http://www.google.com"
$item["URL"] = $urlValue
$siteVisValue = New-Object Microsoft.SharePoint.SPFieldMultiChoiceValue
$siteVisValue.Add("Public Team")
$item["Site Visibility"] = $siteVisValue
$item.Update()
#Intranet Item
$folder = $list.RootFolder.SubFolders["public"]
$item = $list.Items.Add($folder.ServerRelativeUrl, [Microsoft.SharePoint.SPFileSystemObjectType]::File)
$item["Title"] = ($webName + " " + $title + " - 3")
$urlValue = New-Object Microsoft.SharePoint.SPFieldUrlValue
$urlValue.Description = $webName + " - " + $title + " 3"
$urlValue.Url = "http://www.google.com"
$item["URL"] = $urlValue
$siteVisValue = New-Object Microsoft.SharePoint.SPFieldMultiChoiceValue
$siteVisValue.Add("Intranet")
$item["Site Visibility"] = $siteVisValue
$item.Update()
#Private Team and Public Team
$folder = $list.RootFolder.SubFolders["public"]
$item = $list.Items.Add($folder.ServerRelativeUrl, [Microsoft.SharePoint.SPFileSystemObjectType]::File)
$item["Title"] = ($webName + " " + $title + " - 4")
$urlValue = New-Object Microsoft.SharePoint.SPFieldUrlValue
$urlValue.Description = $webName + " - " + $title + " 4"
$urlValue.Url = "http://www.google.com"
$item["URL"] = $urlValue
$siteVisValue = New-Object Microsoft.SharePoint.SPFieldMultiChoiceValue
$siteVisValue.Add("Private Team")
$siteVisValue.Add("Public Team")
$item["Site Visibility"] = $siteVisValue
$item.Update()
#Private Team, Public Team, and Intranet Team
$folder = $list.RootFolder.SubFolders["public"]
$item = $list.Items.Add($folder.ServerRelativeUrl, [Microsoft.SharePoint.SPFileSystemObjectType]::File)
$item["Title"] = ($webName + " " + $title + " - 5")
$urlValue = New-Object Microsoft.SharePoint.SPFieldUrlValue
$urlValue.Description = $webName + " - " + $title + " 5"
$urlValue.Url = "http://www.google.com"
$item["URL"] = $urlValue
$siteVisValue = New-Object Microsoft.SharePoint.SPFieldMultiChoiceValue
$siteVisValue.Add("Private Team")
$siteVisValue.Add("Public Team")
$siteVisValue.Add("Intranet")
$item["Site Visibility"] = $siteVisValue
$item.Update()
#Public Team and Intranet Item
$folder = $list.RootFolder.SubFolders["public"]
$item = $list.Items.Add($folder.ServerRelativeUrl, [Microsoft.SharePoint.SPFileSystemObjectType]::File)
$item["Title"] = ($webName + " " + $title + " - 6")
$urlValue = New-Object Microsoft.SharePoint.SPFieldUrlValue
$urlValue.Description = $webName + " - " + $title + " 6"
$urlValue.Url = "http://www.google.com"
$item["URL"] = $urlValue
$siteVisValue = New-Object Microsoft.SharePoint.SPFieldMultiChoiceValue
$siteVisValue.Add("Public Team")
$siteVisValue.Add("Intranet")
$item["Site Visibility"] = $siteVisValue
$item.Update()
#Private Team and Intranet Item
$folder = $list.RootFolder.SubFolders["public"]
$item = $list.Items.Add($folder.ServerRelativeUrl, [Microsoft.SharePoint.SPFileSystemObjectType]::File)
$item["Title"] = ($webName + " " + $title + " - 7")
$urlValue = New-Object Microsoft.SharePoint.SPFieldUrlValue
$urlValue.Description = $webName + " - " + $title + " 7"
$urlValue.Url = "http://www.google.com"
$item["URL"] = $urlValue
$siteVisValue = New-Object Microsoft.SharePoint.SPFieldMultiChoiceValue
$siteVisValue.Add("Private Team")
$siteVisValue.Add("Intranet")
$item["Site Visibility"] = $siteVisValue
$item.Update()
Write-Host "Finished Adding Sample Links to "$siteUrl$webUrl" ("$listName")"
}
finally
{
$web.Dispose()
}
}
finally
{
$site.Dispose()
}
}

function AddSampleCalendarEvents($siteUrl, $webUrl, $webName, $listName)
{
$title = "Event"
$site = Get-SPSite $siteUrl
try
{
$web = $site.OpenWeb($webUrl)
try
{
#Private Team Site Item
$list = $web.Lists[$listName]
$item = $list.Items.Add()
$item["Title"] = ($webName + " " + $title + " - 1")
$item["Description"] = "Lorem ipsum dolor sit amet, consectetur adipiscing elit."
$siteVisValue = New-Object Microsoft.SharePoint.SPFieldMultiChoiceValue
$siteVisValue.Add("Private Team")
$item["Site Visibility"] = $siteVisValue
$item.Update()
#Public Team Site Item
$folder = $list.RootFolder.SubFolders["public"]
$item = $list.Items.Add($folder.ServerRelativeUrl, [Microsoft.SharePoint.SPFileSystemObjectType]::File)
$item["Title"] = ($webName + " " + $title + " - 2")
$item["Description"] = "Lorem ipsum dolor sit amet, consectetur adipiscing elit."
$siteVisValue = New-Object Microsoft.SharePoint.SPFieldMultiChoiceValue
$siteVisValue.Add("Public Team")
$item["Site Visibility"] = $siteVisValue
$item.Update()
#Intranet Item
$folder = $list.RootFolder.SubFolders["public"]
$item = $list.Items.Add($folder.ServerRelativeUrl, [Microsoft.SharePoint.SPFileSystemObjectType]::File)
$item["Title"] = ($webName + " " + $title + " - 3")
$item["Description"] = "Lorem ipsum dolor sit amet, consectetur adipiscing elit."
$siteVisValue = New-Object Microsoft.SharePoint.SPFieldMultiChoiceValue
$siteVisValue.Add("Intranet")
$item["Site Visibility"] = $siteVisValue
$item.Update()
#Private Team and Public Team Item
$folder = $list.RootFolder.SubFolders["public"]
$item = $list.Items.Add($folder.ServerRelativeUrl, [Microsoft.SharePoint.SPFileSystemObjectType]::File)
$item["Title"] = ($webName + " " + $title + " - 4")
$item["Description"] = "Lorem ipsum dolor sit amet, consectetur adipiscing elit."
$siteVisValue = New-Object Microsoft.SharePoint.SPFieldMultiChoiceValue
$siteVisValue.Add("Private Team")
$siteVisValue.Add("Public Team")
$item["Site Visibility"] = $siteVisValue
$item.Update()
#Private Team, Public Team, and Intranet Item
$folder = $list.RootFolder.SubFolders["public"]
$item = $list.Items.Add($folder.ServerRelativeUrl, [Microsoft.SharePoint.SPFileSystemObjectType]::File)
$item["Title"] = ($webName + " " + $title + " - 5")
$item["Description"] = "Lorem ipsum dolor sit amet, consectetur adipiscing elit."
$siteVisValue = New-Object Microsoft.SharePoint.SPFieldMultiChoiceValue
$siteVisValue.Add("Private Team")
$siteVisValue.Add("Public Team")
$siteVisValue.Add("Intranet")
$item["Site Visibility"] = $siteVisValue
$item.Update()
#Public Team and Intranet Item
$folder = $list.RootFolder.SubFolders["public"]
$item = $list.Items.Add($folder.ServerRelativeUrl, [Microsoft.SharePoint.SPFileSystemObjectType]::File)
$item["Title"] = ($webName + " " + $title + " - 6")
$item["Description"] = "Lorem ipsum dolor sit amet, consectetur adipiscing elit."
$siteVisValue = New-Object Microsoft.SharePoint.SPFieldMultiChoiceValue
$siteVisValue.Add("Public Team")
$siteVisValue.Add("Intranet")
$item["Site Visibility"] = $siteVisValue
$item.Update()
#Private Team and Intranet Item
$folder = $list.RootFolder.SubFolders["public"]
$item = $list.Items.Add($folder.ServerRelativeUrl, [Microsoft.SharePoint.SPFileSystemObjectType]::File)
$item["Title"] = ($webName + " " + $title + " - 7")
$item["Description"] = "Lorem ipsum dolor sit amet, consectetur adipiscing elit."
$siteVisValue = New-Object Microsoft.SharePoint.SPFieldMultiChoiceValue
$siteVisValue.Add("Private Team")
$siteVisValue.Add("Intranet")
$item["Site Visibility"] = $siteVisValue
$item.Update()
Write-Host "Finished Adding Sample Events to "$siteUrl$webUrl" ("$listName")"
}
finally
{
$web.Dispose()
}
}
finally
{
$site.Dispose()
}
}

function CreateSamplePublishingPortal($createWebApplication, $createSiteCollection, $env)
{
#--------------Web App Variables-----------------
$webApplicationName = "Intranet"
$appPoolUserName = "CORP\Administrator" ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
$appPoolPassword = ConvertTo-securestring "pass@word1" -asplaintext -force ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
$portNumber = "80" ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
$serverName = "SPSERVER" ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
$timeZoneId = 13 #Pacific Time (US and Canada) ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
#--------------Site Collection Variables-----------------
$siteName = "Intranet"
$siteManagedPath = "/sites/Intranet" #"" if root level. Otherwise, something like "/sites/PortalName"
$siteUrl = "http://" + $serverName + ":" + $portNumber + $siteManagedPath
$siteOwner = "CORP\Administrator" ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
$siteTemplate = Get-SPWebTemplate "BLANKINTERNETCONTAINER#0" #BLANKINTERNETCONTAINER#0 - Publishing Portal STS#0 Team Site
$siteColumnName = "Site Visibility"
$siteColumnDefaultValue = "Private Team"
$siteColumnGroup = "CompanyX Columns"
#--------------Web Variables-----------------
$webOwner = "CORP\Administrator" ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
$webTemplate = Get-SPWebTemplate "BLANKINTERNETCONTAINER#0"
$disableCheckoutModeration = $true
$removeLibraryApprovalWorkflow = $true
$addTeamCollaborationFeature = $true
$webTitles = @(
"Departments",
"Private",
"Finance",
"Human Resources",
"Information Systems",
"Marketing"
"Public",
"Finance",
"Human Resources",
"Information Systems",
"Marketing"
)
$webUrls = @(
("/dep"),
("/dep/private"),
("/dep/private/fi"),
("/dep/private/hr"),
("/dep/private/is"),
("/dep/private/mkt"),
("/dep/public"),
("/dep/public/fi"),
("/dep/public/hr"),
("/dep/public/is"),
("/dep/public/mkt")
)
$teamUrls = @(
($siteManagedPath + "/dep/private/fi"),
($siteManagedPath + "/dep/private/hr"),
($siteManagedPath + "/dep/private/is"),
($siteManagedPath + "/dep/private/mkt"),
($siteManagedPath + "/dep/public/fi"),
($siteManagedPath + "/dep/public/hr"),
($siteManagedPath + "/dep/public/is"),
($siteManagedPath + "/dep/public/mkt")
)
$privateTeamUrls = @(
($siteManagedPath + "/dep/private/fi"),
($siteManagedPath + "/dep/private/hr"),
($siteManagedPath + "/dep/private/is"),
($siteManagedPath + "/dep/private/mkt")
)
$privateTeamRelativeUrls = @(
("~sitecollection/dep/private/fi"),
("~sitecollection/dep/private/hr"),
("~sitecollection/dep/private/is"),
("~sitecollection/dep/private/mkt")
)
$privateTeamNames = @(
"Finance",
"HR",
"IS",
"Marketing"
)
$publicTeamUrls = @(
($siteManagedPath + "/dep/public/fi"),
($siteManagedPath + "/dep/public/hr"),
($siteManagedPath + "/dep/public/is"),
($siteManagedPath + "/dep/public/mkt")
)
$siteGroups = @(
"Finance Owners",
"Finance Members",
"Finance Visitors",
"HR Owners",
"HR Members",
"HR Visitors",
"IS Owners",
"IS Members",
"IS Visitors",
"Marketing Owners",
"Marketing Members",
"Marketing Visitors"
)
$siteGroupOwners = @(
($siteName + " Owners"),
"Finance Owners",
"Finance Owners",
($siteName + " Owners"),
"HR Owners",
"HR Owners",
($siteName + " Owners"),
"IS Owners",
"IS Owners",
($siteName + " Owners"),
"Marketing Owners",
"Marketing Owners"
)
#NOTE: THIS ASSUMES YOU HAVE THESE USERS - MAKE ARRAY EMPTY IF NOT ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
$siteGroupDefaultUsers = @(
"FIOwner",
"FIMember",
"FIVisitor",
"HROwner",
"HRMember",
"HRVisitor",
"ISOwner",
"ISMember",
"ISVisitor",
"MTKOwner",
"MTKMember",
"MTKVisitor"
)
#--------------MasterPage Variables-----------------
$masterPageUrl = $siteManagedPath + "/" + "_catalogs/masterpage/v4.master" #nightandday.master is default. v4.master is more minimalist
#--------------List Variables-----------------
$linksTemplate = [Microsoft.SharePoint.SPListTemplateType]::Links
$announcementsTemplate = [Microsoft.SharePoint.SPListTemplateType]::Announcements
$calendarTemplate = [Microsoft.SharePoint.SPListTemplateType]::Events
$listNameTemplates = @($announcementsTemplate, $linksTemplate, $announcementsTemplate, $calendarTemplate)
$listNames = @("Announcements", "I Want To", "News", "Team Calendar")
$pageUrl = "/pages/default.aspx"
#--------------List View Variables-----------------
$fieldNames = @("Name", "Site Visibility")
$privateCamlQuery = "Private Team"
$publicCamlQuery = "Public Team"
$intranetCamlQuery = "Intranet"
$listSiteVisibilityTitle = ""
$listSiteVisibilityChoices = @("Private Team", "Public Team", "Intranet")
$listViewColumnFilterName = "Site_x0020_Visibility"
$listViewColumnPublicFilterValue = "Public Team"
$listViewColumnIntranetFilterValue = "Intranet"
$listViewItemLimit = 10;
$listViewZoneId = "TopZone"
#--------------List Folder Variables-----------------
$listFolderName = "public"
$listFolderPermissionGroup = ($siteName + " Visitors")
$listFolderPermission = "Read"
#--------------Publishing Page Variables-----------------
$publishingPages = @("NewHires.aspx", "StaffRoles.aspx", "Training.aspx")
#--------------Permissions Variables-----------------
$permissionPermissionNames = @(
"Finance",
"HR",
"IS",
"Marketing"
)
#--------------UPDATE VARIABLES DEPENDING ON ENVIRONMENT-----------------
#You can add more variables from above down here. I only included common ones that would likely change between environments.
#Expected Values: dev, qa, or prod
switch($env)
{
"dev"
{
#--------------Web App Variables-----------------
$webApplicationName = "DEVIntranet"
$appPoolUserName = "CORP\DEVAdministrator" ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
$appPoolPassword = ConvertTo-securestring "pass@word1" -asplaintext -force ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
$portNumber = "80" ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
$serverName = "DEVSPSERVER" ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
#--------------Site Collection Variables-----------------
$siteName = "DEVIntranet"
$siteManagedPath = "/sites/Intranet" #"" if root level. Otherwise, something like "/sites/PortalName"
$siteUrl = "http://" + $serverName + ":" + $portNumber + $siteManagedPath
$siteOwner = "CORP\DEVAdministrator" ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
#--------------Web Variables-----------------
$webOwner = "CORP\DEVAdministrator" ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
}
"qa"
{
#--------------Web App Variables-----------------
$webApplicationName = "QAIntranet"
$appPoolUserName = "CORP\QAAdministrator" ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
$appPoolPassword = ConvertTo-securestring "pass@word1" -asplaintext -force ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
$portNumber = "80" ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
$serverName = "QASPSERVER" ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
#--------------Site Collection Variables-----------------
$siteName = "QAIntranet"
$siteManagedPath = "/sites/Intranet" #"" if root level. Otherwise, something like "/sites/PortalName"
$siteUrl = "http://" + $serverName + ":" + $portNumber + $siteManagedPath
$siteOwner = "CORP\QAAdministrator" ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
#--------------Web Variables-----------------
$webOwner = "CORP\QAAdministrator" ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
}
"prod"
{
#--------------Web App Variables-----------------
$webApplicationName = "Intranet"
$appPoolUserName = "CORP\Administrator" ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
$appPoolPassword = ConvertTo-securestring "pass@word1" -asplaintext -force ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
$portNumber = "80" ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
$serverName = "SPSERVER" ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
#--------------Site Collection Variables-----------------
$siteName = "Intranet"
$siteManagedPath = "/sites/Intranet" #"" if root level. Otherwise, something like "/sites/PortalName"
$siteUrl = "http://" + $serverName + ":" + $portNumber + $siteManagedPath
$siteOwner = "CORP\Administrator" ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
#--------------Web Variables-----------------
$webOwner = "CORP\Administrator" ##########GLOBAL VARIABLE (UPDATE IF NECESSARY)
}
}
#--------------CREATE WEB APP AND SITE COLLECTION-----------------
if($createWebApplication)
{
CreateWebApplication $webApplicationName $appPoolUserName $appPoolPassword $portNumber $serverName $timeZoneId
}
if($createSiteCollection)
{
CreateSiteCollection $siteName $siteUrl $siteOwner $siteTemplate $removeLibraryApprovalWorkflow $disableCheckoutModeration $addTeamCollaborationFeature
}
UpdateMasterPageUrl $siteUrl "" $masterPageUrl $false
#--------------ADD SITE VISIBILITY SITE COLUMN-----------------
CreateSiteColumnMultiChoice $siteUrl $siteColumnName $listSiteVisibilityChoices $siteColumnDefaultValue $siteColumnGroup $true
#--------------CREATE SUB SITES-----------------
for($i=0; $i -lt $webTitles.Length; $i++)
{
$webUrl = ($siteUrl + $webUrls[$i])
CreateWeb $siteUrl $webUrls[$i] $siteManagedPath $webTitles[$i] $webOwner $webTemplate $removeLibraryApprovalWorkflow $addTeamCollaborationFeature
UpdateMasterPageUrl $siteUrl ($siteManagedPath + $webUrls[$i]) $masterPageUrl $false
}
#--------------ADD SITE GROUPS-----------------
for($i=0; $i -lt $siteGroups.Length; $i++)
{
AddSiteGroup $siteUrl $siteGroups[$i] $siteGroupDefaultUsers[$i] $siteGroupOwners[$i] ""
}
#--------------ADD PRIVATE WEB PAGES AND LISTS / SET PERMISSIONS-----------------
for($i=0; $i -lt $privateTeamUrls.Length; $i++)
{
$webUrl = ($siteUrl + $privateTeamUrls[$i])
for($j=0; $j -lt $publishingPages.Length; $j++)
{
CreatePublishingPage $siteUrl $privateTeamUrls[$i] $publishingPages[$j] $publishingPages[$j].Replace(".aspx", "")
}
for($j=0; $j -lt $listNames.Length; $j++)
{
CreateList $siteUrl $privateTeamUrls[$i] $listNames[$j] "" $listNameTemplates[$j]
AddListSiteColumn $siteUrl $privateTeamUrls[$i] $listNames[$j] "Site Visibility"
}
SetRoleInheritance $siteUrl $privateTeamUrls[$i] $true
}
#--------------SET PRIVATE WEB GROUP PERMISSIONS-----------------
for($i=0; $i -lt $privateTeamUrls.Length; $i++)
{
RemoveGroupPermission $siteUrl $privateTeamUrls[$i] ($siteName + " Visitors")
AddGroupPermission $siteUrl $privateTeamUrls[$i] ($permissionPermissionNames[$i] + " Visitors") "Read"
AddGroupPermission $siteUrl $privateTeamUrls[$i] ($permissionPermissionNames[$i] + " Members") "Contribute"
AddGroupPermission $siteUrl $privateTeamUrls[$i] ($permissionPermissionNames[$i] + " Owners") "Full Control"
}
#--------------CREATE LIST FOLDERS, PERMISSIONS, AND VIEWS-----------------
for($i=0; $i -lt $privateTeamUrls.Length; $i++)
{
for($l=0; $l -lt $listNames.Length; $l++)
{
AddListFolder $siteUrl $privateTeamUrls[$i] $listNames[$l] $listFolderName $true
SetListFolderPermissions $siteUrl $privateTeamUrls[$i] $listNames[$l] $listFolderName $listFolderPermissionGroup $listFolderPermission
for($m=0; $m -lt $listSiteVisibilityChoices.Length; $m++)
{
AddListView $siteUrl $privateTeamUrls[$i] $listNames[$l] $listSiteVisibilityChoices[$m] $fieldNames $privateCamlQuery 10 $false $false $false
}
#ADD Content Query Web Part to Public Page
AddContentByQueryWebPart $siteUrl $publicTeamUrls[$i] $privateTeamRelativeUrls[$i] $privateTeamUrls[$i] ($publicTeamUrls[$i] + $pageUrl) $listNames[$l] $listNames[$l] $listViewColumnFilterName $listViewColumnPublicFilterValue $listViewColumnPublicFilterValue $listViewItemLimit $listViewZoneId 0
#ADD Content Query Web Part to Intranet Home Page #TODO: FIGURE OUT WHY THIS HAS TO BE RUN SEPARATELY
#AddContentByQueryWebPart $siteUrl "" $privateTeamRelativeUrls[$i] $privateTeamUrls[$i] ($siteUrl + $pageUrl) $listNames[$l] ($privateTeamNames[$i]+" - "+$listNames[$l]) $listViewColumnFilterName $listViewColumnIntranetFilterValue $listViewColumnIntranetFilterValue $listViewItemLimit $listViewZoneId 0
}
}
#--------------ADDING SAMPLE DATA TO LISTS-----------------
for($i=0; $i -lt $privateTeamUrls.Length; $i++)
{
AddSampleAnnouncements $siteUrl $privateTeamUrls[$i] $privateTeamNames[$i] "Announcements"
AddSampleAnnouncements $siteUrl $privateTeamUrls[$i] $privateTeamNames[$i] "News"
AddSampleCalendarEvents $siteUrl $privateTeamUrls[$i] $privateTeamNames[$i] "Team Calendar"
AddSampleLinks $siteUrl $privateTeamUrls[$i] $privateTeamNames[$i] "I Want To"
}
Write-Host "--------------FINISHED CREATING PUBLISHING PORTAL-----------------"
}
#--------------START HERE---------------------------------------------------------------------------------------------------
Clear-Host
$env = "dev" #"dev", "qa", or "prod" Make sure to update variables within the function.
$createWebApplication = $false
$createSiteCollection = $true
CreateSamplePublishingPortal $createWebApplication $createSiteCollection $env
[System.Console]::Read()

Tuesday, January 25, 2011

Recursively set SharePoint MasterPages and CSS

Here is a quick sample of how to set master pages and CSS recursively and make sure that they are inherited from the parent site. This would be used within a SharePoint project’s FeatureEventReceiver class.

using System;
using System.Runtime.InteropServices;
using Microsoft.SharePoint;
namespace Acme.Intranet.Ui.Features.Feature1
{
[Guid("0a7b9817-012b-4210-b4b9-a27913eb9598")]
public class Feature1EventReceiver : SPFeatureReceiver
{
public override void FeatureActivated(SPFeatureReceiverProperties properties)
{
using (SPSite site = (SPSite)properties.Feature.Parent)
{
using (SPWeb web = site.RootWeb)
{
string masterPageUrl = new Uri(web.Url + "/_catalogs/masterpage/Custom.master").AbsolutePath;
web.MasterUrl = masterPageUrl;
web.CustomMasterUrl = masterPageUrl;
web.Update();
foreach (SPWeb childWeb in web.Webs)
{
SetMasterPagesAndCss(site.Url, childWeb.ServerRelativeUrl, masterPageUrl, true);
}
}
}
}

public override void FeatureDeactivating(SPFeatureReceiverProperties properties)
{
using (SPSite site = (SPSite)properties.Feature.Parent)
{
using (SPWeb web = site.RootWeb)
{
string masterPageUrl = new Uri(web.Url + "/_catalogs/masterpage/v4.master").AbsolutePath;
web.MasterUrl = masterPageUrl;
web.CustomMasterUrl = masterPageUrl;
web.Update();
foreach (SPWeb childWeb in web.Webs)
{
SetMasterPagesAndCss(site.Url, childWeb.ServerRelativeUrl, masterPageUrl, false);
}
}
}
}

public void SetMasterPagesAndCss(string siteUrl, string webUrl, string masterPageUrl, bool inheritsMasterAndCss)
{
string boolVal = "False";
if (inheritsMasterAndCss)
{
boolVal = "True";
}
using (SPSite site = new SPSite(siteUrl))
{
using (SPWeb web = site.OpenWeb(webUrl))
{
web.Navigation.UseShared = true;
web.MasterUrl = masterPageUrl;
web.AllProperties["__InheritsMasterUrl"] = boolVal;
web.CustomMasterUrl = masterPageUrl;
web.AllProperties["__InheritsCustomMasterUrl"] = boolVal;
web.AlternateCssUrl = web.ParentWeb.AlternateCssUrl;
web.AllProperties["__InheritsAlternateCssUrl"] = boolVal;
web.Update();
foreach (SPWeb childWeb in web.Webs)
{
SetMasterPagesAndCss(siteUrl, childWeb.ServerRelativeUrl, masterPageUrl, inheritsMasterAndCss);
}
}
}
}
}
}

Friday, January 21, 2011

Create AD Users in bulk with PowerShell

This code snippet allows you to easily create multiple users. This is helpful when you need a bunch of test accounts on your DEV environment.

function CreateUser($userName, $password)
{
try
{
$adObject = "WinNT://" + [System.Environment]::MachineName + ",computer" #Assumes computer name
$AD = New-Object System.DirectoryServices.DirectoryEntry($adObject)
$NewUser = $AD.Children.Add($userName, "user")
$NewUser.Invoke("SetPassword", $password)
$NewUser.CommitChanges()
Write-Host "User " + $username" + created successfully."
}
finally
{

}
}

CreateUser "IntranetOwner" "pass@word1"
CreateUser "IntranetMember" "pass@word1"
CreateUser "IntranetVisitor" "pass@word1"

CreateUser "FIOwner" "pass@word1"
CreateUser "FIMember" "pass@word1"
CreateUser "FIVisitor" "pass@word1"

CreateUser "HROwner" "pass@word1"
CreateUser "HRMember" "pass@word1"
CreateUser "HRVisitor" "pass@word1"

CreateUser "ISOwner" "pass@word1"
CreateUser "ISMember" "pass@word1"
CreateUser "ISVisitor" "pass@word1"

CreateUser "MKTOwner" "pass@word1"
CreateUser "MKTMember" "pass@word1"
CreateUser "MKTVisitor" "pass@word1"

Use SharePoint Web Services to export all User Profile data to CSV

Here is a an easy way to get user profile data out of SharePoint. The solution uses web services so you don’t have to worry about having access to the server. It will work with SharePoint 2007 and SharePoint 2010.

Steps:
1. Create a Visual Studio Console Application.
2.
Make a web service reference to the following web services:

http://portalname/_vti_bin/usergroup.asmx (Name it UserGroupWs)
http://portalname/_vti_bin/userprofileservice.asmx (Name it UserProfileServiceWs)

3. Copy the following code and run it! It will save a file to your desktop called SharePointUserData.csv.

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Xml;
using System.Xml.Linq;
using ConsoleApplication1.UserGroupWs;
using ConsoleApplication1.UserProfileServiceWs;

namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
UserInfo ui = new UserInfo();
List<UserInfo> userInfo = ui.GetUserInfo();
StringBuilder sb = new StringBuilder();
sb.Append("AboutMe,");
sb.Append("AccountName,");
sb.Append("ADGuid,");
sb.Append("Assistant,");
sb.Append("CellPhone,");
sb.Append("Department,");
sb.Append("Fax,");
sb.Append("FirstName,");
sb.Append("HomePhone,");
sb.Append("LastName,");
sb.Append("Manager,");
sb.Append("Office,");
sb.Append("PersonalSpace,");
sb.Append("PictureURL,");
sb.Append("PreferredName,");
sb.Append("PublicSiteRedirect,");
sb.Append("QuickLinks,");
sb.Append("SID,");
sb.Append("SPS-AboutUs,");
sb.Append("SPS-Birthday,");
sb.Append("SPS-ClaimID,");
sb.Append("SPS-ClaimProviderID,");
sb.Append("SPS-ClaimProviderType,");
sb.Append("SPS-DataSource,");
sb.Append("SPS-DisplayOrder,");
sb.Append("SPS-DistinguishedName,");
sb.Append("SPS-DontSuggestList,");
sb.Append("SPS-Dotted-line,");
sb.Append("SPS-EmailOptin,");
sb.Append("SPS-FormerNames,");
sb.Append("SPS-HireDate,");
sb.Append("SPS-Interests,");
sb.Append("SPS-JobTitle,");
sb.Append("SPS-LastColleagueAdded,");
sb.Append("SPS-LastKeywordAdded,");
sb.Append("SPS-Location,");
sb.Append("SPS-LogoURL,");
sb.Append("SPS-MasterAccountName,");
sb.Append("SPS-MemberOf,");
sb.Append("SPS-MySiteUpgrade,");
sb.Append("SPS-ObjectExists,");
sb.Append("SPS-OWAUrl,");
sb.Append("SPS-Parent,");
sb.Append("SPS-ParentType,");
sb.Append("SPS-PastProjects,");
sb.Append("SPS-Peers,");
sb.Append("SPS-PhoneticDisplayName,");
sb.Append("SPS-PhoneticFirstName,");
sb.Append("SPS-PhoneticLastName,");
sb.Append("SPS-ProxyAddresses,");
sb.Append("SPS-ResourceAccountName,");
sb.Append("SPS-ResourceSID,");
sb.Append("SPS-Responsibility,");
sb.Append("SPS-SavedAccountName,");
sb.Append("SPS-SavedSID,");
sb.Append("SPS-School,");
sb.Append("SPS-Section-BasicInfo,");
sb.Append("SPS-Section-ContactInfo,");
sb.Append("SPS-Section-CustomProperties,");
sb.Append("SPS-Section-Delegation,");
sb.Append("SPS-Section-Details,");
sb.Append("SPS-Section-OrganizationMembers,");
sb.Append("SPS-Section-Preferences,");
sb.Append("SPS-SipAddress,");
sb.Append("SPS-Skills,");
sb.Append("SPS-SourceObjectDN,");
sb.Append("SPS-Statustes,");
sb.Append("SPS-Team-Site,");
sb.Append("SPS-TimeZone,");
sb.Append("Title,");
sb.Append("UserName,");
sb.Append("UserProfile_GUID,");
sb.Append("WebSite,");
sb.Append("WorkEmail,");
sb.Append("WorkPhone");
sb.Append("\r\n");
foreach (UserInfo u in userInfo)
{
sb.Append(u.AboutMe + ",");
sb.Append(u.AccountName + ",");
sb.Append(u.ADGuid + ",");
sb.Append(u.Assistant + ",");
sb.Append(u.CellPhone + ",");
sb.Append(u.Department + ",");
sb.Append(u.Fax + ",");
sb.Append(u.FirstName + ",");
sb.Append(u.HomePhone + ",");
sb.Append(u.LastName + ",");
sb.Append(u.Manager + ",");
sb.Append(u.Office + ",");
sb.Append(u.PersonalSpace + ",");
sb.Append(u.PictureURL + ",");
sb.Append(u.PreferredName + ",");
sb.Append(u.PublicSiteRedirect + ",");
sb.Append(u.QuickLinks + ",");
sb.Append(u.SID + ",");
sb.Append(u.SPSAboutUs + ",");
sb.Append(u.SPSBirthday + ",");
sb.Append(u.SPSClaimID + ",");
sb.Append(u.SPSClaimProviderID + ",");
sb.Append(u.SPSClaimProviderType + ",");
sb.Append(u.SPSDataSource + ",");
sb.Append(u.SPSDisplayOrder + ",");
sb.Append(u.SPSDistinguishedName + ",");
sb.Append(u.SPSDontSuggestList + ",");
sb.Append(u.SPSDottedline + ",");
sb.Append(u.SPSEmailOptin + ",");
sb.Append(u.SPSFormerNames + ",");
sb.Append(u.SPSHireDate + ",");
sb.Append(u.SPSInterests + ",");
sb.Append(u.SPSJobTitle + ",");
sb.Append(u.SPSLastColleagueAdded + ",");
sb.Append(u.SPSLastKeywordAdded + ",");
sb.Append(u.SPSLocation + ",");
sb.Append(u.SPSLogoURL + ",");
sb.Append(u.SPSMasterAccountName + ",");
sb.Append(u.SPSMemberOf + ",");
sb.Append(u.SPSMySiteUpgrade + ",");
sb.Append(u.SPSObjectExists + ",");
sb.Append(u.SPSOWAUrl + ",");
sb.Append(u.SPSParent + ",");
sb.Append(u.SPSParentType + ",");
sb.Append(u.SPSPastProjects + ",");
sb.Append(u.SPSPeers + ",");
sb.Append(u.SPSPhoneticDisplayName + ",");
sb.Append(u.SPSPhoneticFirstName + ",");
sb.Append(u.SPSPhoneticLastName + ",");
sb.Append(u.SPSProxyAddresses + ",");
sb.Append(u.SPSResourceAccountName + ",");
sb.Append(u.SPSResourceSID + ",");
sb.Append(u.SPSResponsibility + ",");
sb.Append(u.SPSSavedAccountName + ",");
sb.Append(u.SPSSavedSID + ",");
sb.Append(u.SPSSchool + ",");
sb.Append(u.SPSSectionBasicInfo + ",");
sb.Append(u.SPSSectionContactInfo + ",");
sb.Append(u.SPSSectionCustomProperties + ",");
sb.Append(u.SPSSectionDelegation + ",");
sb.Append(u.SPSSectionDetails + ",");
sb.Append(u.SPSSectionOrganizationMembers + ",");
sb.Append(u.SPSSectionPreferences + ",");
sb.Append(u.SPSSipAddress + ",");
sb.Append(u.SPSSkills + ",");
sb.Append(u.SPSSourceObjectDN + ",");
sb.Append(u.SPSStatustes + ",");
sb.Append(u.SPSTeamSite + ",");
sb.Append(u.SPSTimeZone + ",");
sb.Append(u.Title + ",");
sb.Append(u.UserName + ",");
sb.Append(u.UserProfile_GUID + ",");
sb.Append(u.WebSite + ",");
sb.Append(u.WorkEmail + ",");
sb.Append(u.WorkPhone);
sb.Append("\r\n");
}
TextWriter tw = new StreamWriter(Environment.GetFolderPath(Environment.SpecialFolder.Desktop) + "\\" + "SharePointUserData.csv");
tw.WriteLine(sb.ToString());
tw.Close();
}
}

public class UserInfo
{
public int counter { get; set; }
public string AboutMe {get;set;}
public string AccountName {get;set;}
public string ADGuid {get;set;}
public string Assistant {get;set;}
public string CellPhone {get;set;}
public string Department {get;set;}
public string Fax {get;set;}
public string FirstName {get;set;}
public string HomePhone {get;set;}
public string LastName {get;set;}
public string Manager {get;set;}
public string Office {get;set;}
public string PersonalSpace {get;set;}
public string PictureURL {get;set;}
public string PreferredName {get;set;}
public string PublicSiteRedirect {get;set;}
public string QuickLinks {get;set;}
public string SID {get;set;}
public string SPSAboutUs {get;set;}
public string SPSBirthday {get;set;}
public string SPSClaimID {get;set;}
public string SPSClaimProviderID {get;set;}
public string SPSClaimProviderType {get;set;}
public string SPSDataSource {get;set;}
public string SPSDisplayOrder {get;set;}
public string SPSDistinguishedName {get;set;}
public string SPSDontSuggestList {get;set;}
public string SPSDottedline {get;set;}
public string SPSEmailOptin {get;set;}
public string SPSFormerNames {get;set;}
public string SPSHireDate {get;set;}
public string SPSInterests {get;set;}
public string SPSJobTitle {get;set;}
public string SPSLastColleagueAdded {get;set;}
public string SPSLastKeywordAdded {get;set;}
public string SPSLocation {get;set;}
public string SPSLogoURL {get;set;}
public string SPSMasterAccountName {get;set;}
public string SPSMemberOf {get;set;}
public string SPSMySiteUpgrade {get;set;}
public string SPSObjectExists {get;set;}
public string SPSOWAUrl {get;set;}
public string SPSParent {get;set;}
public string SPSParentType {get;set;}
public string SPSPastProjects {get;set;}
public string SPSPeers {get;set;}
public string SPSPhoneticDisplayName {get;set;}
public string SPSPhoneticFirstName {get;set;}
public string SPSPhoneticLastName {get;set;}
public string SPSProxyAddresses {get;set;}
public string SPSResourceAccountName {get;set;}
public string SPSResourceSID {get;set;}
public string SPSResponsibility {get;set;}
public string SPSSavedAccountName {get;set;}
public string SPSSavedSID {get;set;}
public string SPSSchool {get;set;}
public string SPSSectionBasicInfo {get;set;}
public string SPSSectionContactInfo {get;set;}
public string SPSSectionCustomProperties {get;set;}
public string SPSSectionDelegation {get;set;}
public string SPSSectionDetails {get;set;}
public string SPSSectionOrganizationMembers {get;set;}
public string SPSSectionPreferences {get;set;}
public string SPSSipAddress {get;set;}
public string SPSSkills {get;set;}
public string SPSSourceObjectDN {get;set;}
public string SPSStatustes {get;set;}
public string SPSTeamSite {get;set;}
public string SPSTimeZone {get;set;}
public string Title {get;set;}
public string UserName {get;set;}
public string UserProfile_GUID {get;set;}
public string WebSite {get;set;}
public string WorkEmail {get;set;}
public string WorkPhone {get;set;}

public List<UserInfo> GetUserInfo()
{
UserGroup userGroup = new UserGroup();
userGroup.UseDefaultCredentials = true;
XmlNode allUsers = userGroup.GetAllUserCollectionFromWeb();
XNode xNode = XDocument.Parse(allUsers.OuterXml);
return (from root in xNode.Document.Elements()
from users in root.Elements()
from user in users.Elements()
let loginName = (string)user.Attribute("LoginName")
let userInfo = GetUserInfoDetails(loginName)
select new UserInfo()
{
AboutMe = userInfo.AboutMe,
AccountName = userInfo.AccountName,
ADGuid = userInfo.ADGuid,
Assistant = userInfo.Assistant,
CellPhone = userInfo.CellPhone,
Department = userInfo.Department,
Fax = userInfo.Fax,
FirstName = userInfo.FirstName,
HomePhone = userInfo.HomePhone,
LastName = userInfo.LastName,
Manager = userInfo.Manager,
Office = userInfo.Office,
PersonalSpace = userInfo.PersonalSpace,
PictureURL = userInfo.PictureURL,
PreferredName = userInfo.PreferredName,
PublicSiteRedirect = userInfo.PublicSiteRedirect,
QuickLinks = userInfo.QuickLinks,
SID = userInfo.SID,
SPSAboutUs = userInfo.SPSAboutUs,
SPSBirthday = userInfo.SPSBirthday,
SPSClaimID = userInfo.SPSClaimID,
SPSClaimProviderID = userInfo.SPSClaimProviderID,
SPSClaimProviderType = userInfo.SPSClaimProviderType,
SPSDataSource = userInfo.SPSDataSource,
SPSDisplayOrder = userInfo.SPSDisplayOrder,
SPSDistinguishedName = userInfo.SPSDistinguishedName,
SPSDontSuggestList = userInfo.SPSDontSuggestList,
SPSDottedline = userInfo.SPSDottedline,
SPSEmailOptin = userInfo.SPSEmailOptin,
SPSFormerNames = userInfo.SPSFormerNames,
SPSHireDate = userInfo.SPSHireDate,
SPSInterests = userInfo.SPSInterests,
SPSJobTitle = userInfo.SPSJobTitle,
SPSLastColleagueAdded = userInfo.SPSLastColleagueAdded,
SPSLastKeywordAdded = userInfo.SPSLastKeywordAdded,
SPSLocation = userInfo.SPSLocation,
SPSLogoURL = userInfo.SPSLogoURL,
SPSMasterAccountName = userInfo.SPSMasterAccountName,
SPSMemberOf = userInfo.SPSMemberOf,
SPSMySiteUpgrade = userInfo.SPSMySiteUpgrade,
SPSObjectExists = userInfo.SPSObjectExists,
SPSOWAUrl = userInfo.SPSOWAUrl,
SPSParent = userInfo.SPSParent,
SPSParentType = userInfo.SPSParentType,
SPSPastProjects = userInfo.SPSPastProjects,
SPSPeers = userInfo.SPSPeers,
SPSPhoneticDisplayName = userInfo.SPSPhoneticDisplayName,
SPSPhoneticFirstName = userInfo.SPSPhoneticFirstName,
SPSPhoneticLastName = userInfo.SPSPhoneticLastName,
SPSProxyAddresses = userInfo.SPSProxyAddresses,
SPSResourceAccountName = userInfo.SPSResourceAccountName,
SPSResourceSID = userInfo.SPSResourceSID,
SPSResponsibility = userInfo.SPSResponsibility,
SPSSavedAccountName = userInfo.SPSSavedAccountName,
SPSSavedSID = userInfo.SPSSavedSID,
SPSSchool = userInfo.SPSSchool,
SPSSectionBasicInfo = userInfo.SPSSectionBasicInfo,
SPSSectionContactInfo = userInfo.SPSSectionContactInfo,
SPSSectionCustomProperties = userInfo.SPSSectionCustomProperties,
SPSSectionDelegation = userInfo.SPSSectionDelegation,
SPSSectionDetails = userInfo.SPSSectionDetails,
SPSSectionOrganizationMembers = userInfo.SPSSectionOrganizationMembers,
SPSSectionPreferences = userInfo.SPSSectionPreferences,
SPSSipAddress = userInfo.SPSSipAddress,
SPSSkills = userInfo.SPSSkills,
SPSSourceObjectDN = userInfo.SPSSourceObjectDN,
SPSStatustes = userInfo.SPSStatustes,
SPSTeamSite = userInfo.SPSTeamSite,
SPSTimeZone = userInfo.SPSTimeZone,
Title = userInfo.Title,
UserName = userInfo.UserName,
UserProfile_GUID = userInfo.UserProfile_GUID,
WebSite = userInfo.WebSite,
WorkEmail = userInfo.WorkEmail,
WorkPhone = userInfo.WorkPhone

}).ToList();
}

private UserInfo GetUserInfoDetails(string loginName)
{
Console.WriteLine(counter++.ToString() + " - " + loginName);
UserInfo userInfo = new UserInfo();
try
{
UserProfileService userProfileService = new UserProfileService();
userProfileService.UseDefaultCredentials = true;
PropertyData[] data = userProfileService.GetUserProfileByName(loginName);
string pictureUrl = GetPropertyData(data, "PictureURL");
userInfo.AboutMe = GetPropertyData(data, "AboutMe");
userInfo.AccountName = GetPropertyData(data, "AccountName");
userInfo.ADGuid = GetPropertyData(data, "ADGuid");
userInfo.Assistant = GetPropertyData(data, "Assistant");
userInfo.CellPhone = GetPropertyData(data, "CellPhone");
userInfo.Department = GetPropertyData(data, "Department");
userInfo.Fax = GetPropertyData(data, "Fax");
userInfo.FirstName = GetPropertyData(data, "FirstName");
userInfo.HomePhone = GetPropertyData(data, "HomePhone");
userInfo.LastName = GetPropertyData(data, "LastName");
userInfo.Manager = GetPropertyData(data, "Manager");
userInfo.Office = GetPropertyData(data, "Office");
userInfo.PersonalSpace = GetPropertyData(data, "PersonalSpace");
userInfo.PictureURL = GetPropertyData(data, "PictureURL");
userInfo.PreferredName = GetPropertyData(data, "PreferredName");
userInfo.PublicSiteRedirect = GetPropertyData(data, "PublicSiteRedirect");
userInfo.QuickLinks = GetPropertyData(data, "QuickLinks");
userInfo.SID = GetPropertyData(data, "SID");
userInfo.SPSAboutUs = GetPropertyData(data, "SPS-AboutUs");
userInfo.SPSBirthday = GetPropertyData(data, "SPS-Birthday");
userInfo.SPSClaimID = GetPropertyData(data, "SPS-ClaimID");
userInfo.SPSClaimProviderID = GetPropertyData(data, "SPS-ClaimProviderID");
userInfo.SPSClaimProviderType = GetPropertyData(data, "SPS-ClaimProviderType");
userInfo.SPSDataSource = GetPropertyData(data, "SPS-DataSource");
userInfo.SPSDisplayOrder = GetPropertyData(data, "SPS-DisplayOrder");
userInfo.SPSDistinguishedName = GetPropertyData(data, "SPS-DistinguishedName");
userInfo.SPSDontSuggestList = GetPropertyData(data, "SPS-DontSuggestList");
userInfo.SPSDottedline = GetPropertyData(data, "SPS-Dotted-line");
userInfo.SPSEmailOptin = GetPropertyData(data, "SPS-EmailOptin");
userInfo.SPSFormerNames = GetPropertyData(data, "SPS-FormerNames");
userInfo.SPSHireDate = GetPropertyData(data, "SPS-HireDate");
userInfo.SPSInterests = GetPropertyData(data, "SPS-Interests");
userInfo.SPSJobTitle = GetPropertyData(data, "SPS-JobTitle");
userInfo.SPSLastColleagueAdded = GetPropertyData(data, "SPS-LastColleagueAdded");
userInfo.SPSLastKeywordAdded = GetPropertyData(data, "SPS-LastKeywordAdded");
userInfo.SPSLocation = GetPropertyData(data, "SPS-Location");
userInfo.SPSLogoURL = GetPropertyData(data, "SPS-LogoURL");
userInfo.SPSMasterAccountName = GetPropertyData(data, "SPS-MasterAccountName");
userInfo.SPSMemberOf = GetPropertyData(data, "SPS-MemberOf");
userInfo.SPSMySiteUpgrade = GetPropertyData(data, "SPS-MySiteUpgrade");
userInfo.SPSObjectExists = GetPropertyData(data, "SPS-ObjectExists");
userInfo.SPSOWAUrl = GetPropertyData(data, "SPS-OWAUrl");
userInfo.SPSParent = GetPropertyData(data, "SPS-Parent");
userInfo.SPSParentType = GetPropertyData(data, "SPS-ParentType");
userInfo.SPSPastProjects = GetPropertyData(data, "SPS-PastProjects");
userInfo.SPSPeers = GetPropertyData(data, "SPS-Peers");
userInfo.SPSPhoneticDisplayName = GetPropertyData(data, "SPS-PhoneticDisplayName");
userInfo.SPSPhoneticFirstName = GetPropertyData(data, "SPS-PhoneticFirstName");
userInfo.SPSPhoneticLastName = GetPropertyData(data, "SPS-PhoneticLastName");
userInfo.SPSProxyAddresses = GetPropertyData(data, "SPS-ProxyAddresses");
userInfo.SPSResourceAccountName = GetPropertyData(data, "SPS-ResourceAccountName");
userInfo.SPSResourceSID = GetPropertyData(data, "SPS-ResourceSID");
userInfo.SPSResponsibility = GetPropertyData(data, "SPS-Responsibility");
userInfo.SPSSavedAccountName = GetPropertyData(data, "SPS-SavedAccountName");
userInfo.SPSSavedSID = GetPropertyData(data, "SPS-SavedSID");
userInfo.SPSSchool = GetPropertyData(data, "SPS-School");
userInfo.SPSSectionBasicInfo = GetPropertyData(data, "SPS-Section-BasicInfo");
userInfo.SPSSectionContactInfo = GetPropertyData(data, "SPS-Section-ContactInfo");
userInfo.SPSSectionCustomProperties = GetPropertyData(data, "SPS-Section-CustomProperties");
userInfo.SPSSectionDelegation = GetPropertyData(data, "SPS-Section-Delegation");
userInfo.SPSSectionDetails = GetPropertyData(data, "SPS-Section-Details");
userInfo.SPSSectionOrganizationMembers = GetPropertyData(data, "SPS-Section-OrganizationMembers");
userInfo.SPSSectionPreferences = GetPropertyData(data, "SPS-Section-Preferences");
userInfo.SPSSipAddress = GetPropertyData(data, "SPS-SipAddress");
userInfo.SPSSkills = GetPropertyData(data, "SPS-Skills");
userInfo.SPSSourceObjectDN = GetPropertyData(data, "SPS-SourceObjectDN");
userInfo.SPSStatustes = GetPropertyData(data, "SPS-Statustes");
userInfo.SPSTeamSite = GetPropertyData(data, "SPS-Team-Site");
userInfo.SPSTimeZone = GetPropertyData(data, "SPS-TimeZone");
userInfo.Title = GetPropertyData(data, "Title");
userInfo.UserName = GetPropertyData(data, "UserName");
userInfo.UserProfile_GUID = GetPropertyData(data, "UserProfile_GUID");
userInfo.WebSite = GetPropertyData(data, "WebSite");
userInfo.WorkEmail = GetPropertyData(data, "WorkEmail");
userInfo.WorkPhone = GetPropertyData(data, "WorkPhone");

}
catch (System.Web.Services.Protocols.SoapException ex)
{
//It appears that an exception gets generated for users
//that have not logged into SharePoint yet.
//They must logon for a profile to be created.
if (!ex.Message.Contains("A user with the account name"))
{
throw;
}
}
return userInfo;
}

private string GetPropertyData(PropertyData[] data, string columnName)
{
//Delimit properties with a semi-colon or comma.
string returnValue = string.Empty;
try
{
returnValue = string.Join("; ",
(from v in
((PropertyData)data.Where(x => x.Name == columnName).Single()).Values
select v.Value.ToString()).ToArray());
}
catch (Exception ex)
{

}
return returnValue;
}
}
}

Monday, January 17, 2011

Use PowerShell to easily disable or enable SharePoint Publishing site workflows, moderation, and checkout

SharePoint Publishing Sites are strict by their very nature and have a number of security controls enabled by default such as approval workflows, moderation, and checkout. Obviously these features are important and are there for good reason, but they also have the potential to slow down the development and even the deployment process. Oftentimes you need to be able easily edit a masterpage or add a bunch of sample documents for testing. While you can disable workflows, moderation, and checkout through the user interface, it’s not something you can do very quickly, especially if you need it done recursively. The following script makes this much easier and allows you to disable or re-enable all of these features.

Steps

  1. Copy the following in Notepad.
  2. Update the last function $siteUrl and $webUrls variables.
    • $siteUrl – This is the site collection URL. For example, http://portalname
    • $webUrls – This is an array that you can use target subsites. For example, in the case of a Departments subsite with HR, IT, and Marketing subsites: "/dep", "/dep/hr","/dep/it","/dep/mkt"
  3. Toggle between $true and $false statements at the bottom of the script to disable or enable. You could also create two separate scripts.
  4. Save the file as a “.ps1” file.
  5. Run as an Administrator on your SharePoint environment.

Source Code

function RemoveApprovalWorkflow($siteUrl, $webUrl, $listName, $workFlowName)
{
$site = Get-SPSite $siteUrl
try
{
$web = $site.OpenWeb($webUrl)
try
{
$list = $web.Lists[$listName]
if(!($list -eq $null))
{
$wa = $list.WorkflowAssociations.GetAssociationByName($workFlowName, [System.Globalization.CultureInfo]::CurrentCulture)
if(!($wa -eq $null))
{
Write-Host "Removing " $wa.Name " from " $listName
$list.WorkflowAssociations.Remove($wa)
}
}
}
finally
{
$web.Dispose()
}
}
finally
{
$site.Dispose()
}
Write-Host "Finished Removing Workflow "$workFlowName" from "$siteUrl$webUrl"/"$listName
}

function AddApprovalWorkflow($siteUrl, $webUrl, $listName, $workflowTemplateName, $workflowName, $workflowTaskName, $workflowHistoryName)
{
$site = Get-SPSite $siteUrl
try
{
$web = $site.OpenWeb($webUrl)
try
{
$list = $web.Lists[$listName]
if(!($list -eq $null))
{
$wfTemp = $web.WorkflowTemplates.GetTemplateByName($workflowTemplateName, [System.Globalization.CultureInfo]::CurrentCulture);
$wf = [Microsoft.SharePoint.Workflow.SPWorkflowAssociation]::CreateListAssociation($wfTemp, $workflowName, $web.Lists[$workflowTaskName], $web.Lists[$workflowHistoryName]);
$list.WorkflowAssociations.Add($wf)
$list.DefaultContentApprovalWorkflowId = $wf.Id
$list.Update()
}
}
finally
{
$web.Dispose()
}
}
finally
{
$site.Dispose()
}
Write-Host "Finished Adding Workflow "$workflowTemplateName" to "$siteUrl$webUrl"/"$listName
}

function EnableMasterPageModerationCheckout($siteUrl, $enable)
{
$site = Get-SPSite $siteUrl
try
{
$list = $site.GetCatalog([Microsoft.SharePoint.SPListTemplateType]::MasterPageCatalog)
$list.EnableModeration = $enable
$list.ForceCheckout = $enable
$list.Update()
Write-Host "MasterPage Moderation and Checkout on "$siteUrl" set to "$enable
}
finally
{
$site.Dispose()
}
}

function EnablePublishingWorkflowsModeration($enable)
{
$siteUrl = http://portalurl #CHANGE VARIABLE
$webUrls = @("/dep", "/dep/hr","/dep/it","/dep/mkt") #CHANGE VARIABLE
$listNames = @("Pages", "Documents", "Images") #Publishing Site Default Lists
EnableMasterPageModerationCheckout $siteUrl $enable
foreach($webUrl in $webUrls)
{
EnableMasterPageModerationCheckout $siteUrl $enable
foreach($listName in $listNames)
{
if($enable)
{
AddApprovalWorkflow $siteUrl $webUrl $listName "Publishing Approval" "Page Approval" "Workflow Tasks" "Workflow History"
}
else
{
RemoveApprovalWorkflow $siteUrl $webUrl $listName "Page Approval"
}
}
}
}

EnablePublishingWorkflowsModeration $false
#EnablePublishingWorkflowsModeration $true #Comment / UnComment



 

Tuesday, January 11, 2011

SharePoint SPRegionalSettings.GlobalTimeZones ID List

I couldn't find a reference for this anywhere, so decided to create my own.

IDDescription
2(UTC) Greenwich Mean Time : Dublin, Edinburgh, Lisbon, London
3(UTC+01:00) Brussels, Copenhagen, Madrid, Paris
4(UTC+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna
5(UTC+02:00) Athens, Bucharest, Istanbul
6(UTC+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague
7(UTC+02:00) Minsk
8(UTC-03:00) Brasilia
9(UTC-04:00) Atlantic Time (Canada)
10(UTC-05:00) Eastern Time (US and Canada)
11(UTC-06:00) Central Time (US and Canada)
12(UTC-07:00) Mountain Time (US and Canada)
13(UTC-08:00) Pacific Time (US and Canada)
14(UTC-09:00) Alaska
15(UTC-10:00) Hawaii
16(UTC-11:00) Midway Island, Samoa
17(UTC+12:00) Auckland, Wellington
18(UTC+10:00) Brisbane
19(UTC+09:30) Adelaide
20(UTC+09:00) Osaka, Sapporo, Tokyo
21(UTC+08:00) Kuala Lumpur, Singapore
22(UTC+07:00) Bangkok, Hanoi, Jakarta
23(UTC+05:30) Chennai, Kolkata, Mumbai, New Delhi
24(UTC+04:00) Abu Dhabi, Muscat
25(UTC+03:30) Tehran
26(UTC+03:00) Baghdad
27(UTC+02:00) Jerusalem
28(UTC-03:30) Newfoundland and Labrador
29(UTC-01:00) Azores
30(UTC-02:00) Mid-Atlantic
31(UTC) Monrovia, Reykjavik
32(UTC-03:00) Cayenne
33(UTC-04:00) Georgetown, La Paz, San Juan
34(UTC-05:00) Indiana (East)
35(UTC-05:00) Bogota, Lima, Quito
36(UTC-06:00) Saskatchewan
37(UTC-06:00) Guadalajara, Mexico City, Monterrey
38(UTC-07:00) Arizona
39(UTC-12:00) International Date Line West
40(UTC+12:00) Fiji Is., Marshall Is.
41(UTC+11:00) Magadan, Solomon Is., New Caledonia
42(UTC+10:00) Hobart
43(UTC+10:00) Guam, Port Moresby
44(UTC+09:30) Darwin
45(UTC+08:00) Beijing, Chongqing, Hong Kong S.A.R., Urumqi
46(UTC+06:00) Novosibirsk
47(UTC+05:00) Tashkent
48(UTC+04:30) Kabul
49(UTC+02:00) Cairo
50(UTC+02:00) Harare, Pretoria
51(UTC+03:00) Moscow, St. Petersburg, Volgograd
53(UTC-01:00) Cape Verde Is.
54(UTC+04:00) Baku
55(UTC-06:00) Central America
56(UTC+03:00) Nairobi
57(UTC+01:00) Sarajevo, Skopje, Warsaw, Zagreb
58(UTC+05:00) Ekaterinburg
59(UTC+02:00) Helsinki, Kyiv, Riga, Sofia, Tallinn, Vilnius
60(UTC-03:00) Greenland
61(UTC+06:30) Yangon (Rangoon)
62(UTC+05:45) Kathmandu
63(UTC+08:00) Irkutsk
64(UTC+07:00) Krasnoyarsk
65(UTC-04:00) Santiago
66(UTC+05:30) Sri Jayawardenepura
67(UTC+13:00) Nuku'alofa
68(UTC+10:00) Vladivostok
69(UTC+01:00) West Central Africa
70(UTC+09:00) Yakutsk
71(UTC+06:00) Astana, Dhaka
72(UTC+09:00) Seoul
73(UTC+08:00) Perth
74(UTC+03:00) Kuwait, Riyadh
75(UTC+08:00) Taipei
76(UTC+10:00) Canberra, Melbourne, Sydney
77(UTC-07:00) Chihuahua, La Paz, Mazatlan
78(UTC-08:00) Tijuana, Baja California
79(UTC+02:00) Amman
80(UTC+02:00) Beirut
81(UTC-04:00) Manaus
82(UTC+04:00) Tbilisi
83(UTC+02:00) Windhoek
84(UTC+04:00) Yerevan
85(UTC-03:00) Buenos Aires
86(UTC) Casablanca
87(UTC+05:00) Islamabad, Karachi
88(UTC-04:30) Caracas
89(UTC+04:00) Port Louis
90(UTC-03:00) Montevideo
91(UTC-04:00) Asuncion
92(UTC+12:00) Petropavlovsk-Kamchatsky
93(UTC) Coordinated Universal Time
94(UTC+08:00) Ulaanbaatar

Source Code
using System;
using System.Collections.Generic;
using System.Linq;
using Microsoft.SharePoint;

namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
SPTimeZoneCollection timeZones = SPRegionalSettings.GlobalTimeZones;
Dictionary timeZoneList = new Dictionary();
Console.WriteLine("\r\nSharePoint Global Time Zones");
foreach (SPTimeZone timeZone in timeZones)
{
timeZoneList.Add(timeZone.ID, timeZone.Description);
}
foreach (KeyValuePair time in timeZoneList.OrderBy(x => x.Key))
{
Console.WriteLine(time.Key.ToString() + "\t" + time.Value);
}
Console.WriteLine("\r\nHTML Format");
foreach (KeyValuePair time in timeZoneList.OrderBy(x => x.Key))
{
Console.WriteLine("" + time.Key.ToString() + "" + time.Value + "");
}
Console.Read();
}
}
}

References

Saturday, January 8, 2011

Learn Japanese Kanji 常用漢字 with Microsoft Pivot Viewer

As a lifetime student of Japanese, I have always been interested in different ways to study and learn Japanese Kanji. Through the years the Japanese Ministry of Education has maintained a list of "jōyō kanji" or standard Chinese characters that were expected for students to learn through the years. Since 1981 this list was 1,945 characters, but in 2009 they added more characters and they now total a whopping 2,136.

Needless to say, learning these is is a huge undertaking and is especially daunting to non-native speakers. Although some characters can be easily identified as more ideographical in nature and contain concrete meanings (木 for tree), most characters are not and contain more abstract ideas or are only used in names. Unlike Chinese character readings, Japanese characters can also have multiple readings and maintain a separate reading called "on" (音) for the Chinese historical reading and "kun" (訓) for the Japanese reading . These readings can also change based on where they are used within a character compound or historical context. In fact, there are some characters that are not Chinese and were invented natively by the Japanese. One interesting example is the word "work" (働く). Besides all of this, there is also number of strokes and stroke order to worry about. Characters are written in a particular way and there are things like trailing strokes that must adhere to specific tools.

The beauty of the PivotViewer tool is that it allows you to slice and dice these characters in different ways. From an academic perspective it can be interesting to see things like how many characters contain a certain amount of strokes or how many are learned in the 3rd grade. Keep in mind takes a little time to load the tool the first time. Once you start using it, it will speed up.

Glossary
  • 学年 - Scholastic year or year that the character is learned in school. 中高 means that the character is learned in middle or high school.
  • 画 - Number of strokes
  • 英語 - English description
  • 音読み - Onyomi or Chinese reading.
  • 訓読み - Kunyomi or Japanese reading.
  • 音読みローマ字 - Romanized onyomi rendering.
  • 訓読みローマ字 - Romanized kunyomi rendering
  • 音読み印引き - Onyomi index
  • 訓読み印引き - Kunyomi index



References
Pivot Viewer

Jōyō Kanji
- All of the information was taken from Wikipedia. I had to do some serious formatting to create a Pivot Collection.
http://en.wikipedia.org/wiki/J%C5%8Dy%C5%8D_kanji

Epson Fonts - I used EPSON太行書体B

Fun Fact
I use Microsoft, Google, and Amazon technologies for this page. Microsoft for PivotViewer, Google for Blogspot, and Amazon for hosting the xap and cxml files (DropBox uses Amazon cloud services).

Screenshot