john.livingston.tech

Parsing XML and databinding using jsRender and jsViews (RIP jQuery Templates)

2011-11-23T15:12:00.001-08:00

I have always been a huge fan of the very flexible ASP.NET ListView control for creating templates and databinding nested data collections. Recently though I have been making a stronger effort to work with client side technologies like jQuery and client friendly data formats like JSON and JSONP. Thanks to the hard work of Microsoft’s Boris Moore, a new technology called jQuery Templates was put into beta as an official plugin and a CDN was created in jQuery and Microsoft. Unfortunately after spending some time studying the framework, I learned that it had been deprecated, “rebranded” as jsRender and jsViews, and a tentative schedule to add it to the jQuery UI framework (at least the jsRender portion). Fortunately, the new framework still has support, has improved performance, and a syntax that hasn’t changed too much. This is really a useful technology, so hopefully it will get adopted soon as a first class jQuery plugin or independent framework.
jsRender Databinding SyntaxThe first line initializes the template object. The object is then rendered with the data and appended to an html element.
$("#tblTemplate").template("tblTemplate");
$("#tblBod").append($.render(obj, "tblTemplate"));

jsViews Template SyntaxThis first table element sets up the html part of the template which will be used to append the data to. Conceptually this is the same as the ASP.NET ListView’s LayoutTemplate element. You then create a script element of type “text/x-jquery-tmpl” and use jsViews markup syntax to create the template. You can then render the object directly or by using conditional statements. For nested objects you can use “each” statements. This is conceptually like the ASP.NET ListView control’s ItemLayout element. See Dan Wahlin’s article for more information on using this syntax.

<table id="tbl">
   <thead>
      <tr>
         <th>Name</th>
         <th>Example</th>
      </tr>
   </thead>
   <tbody id="tblBod" />
</table>
<script id="tblTemplate" type="text/x-jquery-tmpl">    <tr>
      <td><div class='name-value'>{{=name}}</div>
         {{#if $data.returnVal}}
            <div class='info-value'>Return: {{=returnVal}}</div>
         {{else}}
            <div class='info-value'>Return: N/A</div>
         {{/if}}
         {{#if $data.category}}
            <div class='info-value'>Category: {{=category}}</div>
         {{/if}}
      </td>
      <td>
         <div class='desc-value'>{{=desc}}</div>
         <pre>{{=example}}</pre>
      </td>
   </tr>
</script>In my example below, I decided to use a good sized XML file (1 MB) which represents the jQuery API and is found on jQuery.com. Parsing, sorting, and rendering the XML only took about 2 seconds. Generally you would use AJAX to return some data from a web service or REST service instead, but I wanted to see how easy it was to parse XML with jQuery.

Instructions:1. Copy and paste the following an html file.
2. Save the xml from http://api.jquery.com/api as jqueryapi.xml.
3. Save the jsrender.js from https://github.com/BorisMoore/jsrender
4. Save the jquery.views.js from https://github.com/BorisMoore/jsviews
5. Run the code!

Screenshot

Source Code:

<!DOCTYPE html>
<html>
<head>
    <title>jQuery: Parsing XML / jsrender and jsviews</title>
    <style>
       body
       {
            font-family: Verdana;
            font-size: 12px;
        }
        #tbl
       {
            border: solid 1px silver;
            border-collapse: collapse;
        }
        #tbl th
       {
            font-size:14px;
        }
        .name-value
       {
            font-size: 14px;
            font-weight:bold;
            padding-bottom: 10px;
        }
        .info-value
       {
            padding-left:10px;
            font-style:italic;
        }
        th, td
       {
            border: solid 1px silver;
            text-align: left;
            padding: 6px;
            vertical-align: top;
        }
        pre
       {
            white-space: pre-wrap;
        }
    </style>
    <scriptsrc="http://code.jquery.com/jquery.min.js"></script>
    <scriptsrc="jsrender.js"></script>
   <scriptsrc="jquery.views.js"></script>
   <script>
       $(function($) {
            //XML comes from: http://api.jquery.com/api/
           $.get('jqueryapi.xml', 'xml').done(function(data) {
                var $foods = $(data).find("entry");
                var obj = [];
                var keys = newArray();
                keys[0] = newArray("attribute", "name", "name");
                keys[1] = newArray("attribute", "returnVal", "return");
                keys[2] = newArray("childtext", "desc", "desc:first");
                keys[3] = newArray("childtext", "example", "example > code");
                keys[4] = newArray("childattribute", "category", "category:first", "name");
                $foods.each(function(idx, elem) {
                    var $this = $(this), data = {};
                    keys.forEach(function(key) {
                        switch(key[0]) {
                            case'attribute':
                                data[key[1]] = $this.attr(key[2]);
                                break;
                            case'childtext':
                                data[key[1]] = $this.find(key[2]).text();
                                break;
                            case'childattribute':
                                data[key[1]] = $this.find(key[2]).attr(key[3]);
                                break;
                        }
                    });
                    obj.push(data);
                });
                obj.sort(sort_by('category', 'name'));
                $("#tblTemplate").template("tblTemplate");
                $("#tblBod").append($.render(obj, "tblTemplate"));
            }).error(function(data) {
                console.log('fail', data);
            });
        });

        //Sorting algorithm courtesy of Felix Kling: http://stackoverflow.com/questions/6913512/how-to-sort-an-array-of-objects-by-multiple-fields
       var sort_by;
        (function() {
            var default_cmp = function(a, b) {
                if(a == b) return0;
                returna < b ? -1 : 1;
            },
                getCmpFunc = function(primer, reverse) {
                    var dfc = default_cmp,
                        cmp = default_cmp;
                    if(primer) {
                        cmp = function(a, b) {
                            returndfc(primer(a), primer(b));
                        };
                    }
                    if(reverse) {
                        return function(a, b) {
                            return-1 * cmp(a, b);
                        };
                    }
                    returncmp;
                };
            sort_by = function() {
                var fields = [],
                    n_fields = arguments.length,
                    field, name, reverse, cmp;
                for(var i = 0; i < n_fields; i++) {
                    field = arguments[i];
                    if(typeof field === 'string') {
                        name = field;
                        cmp = default_cmp;
                    }
                    else{
                        name = field.name;
                        cmp = getCmpFunc(field.primer, field.reverse);
                    }
                    fields.push({
                        name: name,
                        cmp: cmp
                    });
                }
                return function(A, B) {
                    var a, b, name, result;
                    for(var i = 0, l = n_fields; i < l; i++) {
                        result = 0;
                        field = fields[i];
                        name = field.name;
                        result = field.cmp(A[name], B[name]);
                        if(result !== 0) break;
                    }
                    returnresult;
                }
            }
        } ());
    </script>
</head>
<body>
    <tableid="tbl">
        <thead>
            <tr>
                <th>Name</th>
                <th>Example</th>
            </tr>
        </thead>
        <tbody id="tblBod" />
    </table>
    <scriptid="tblTemplate"type="text/x-jquery-tmpl">
       <tr>
            <td><div class='name-value'>{{=name}}</div>
               {{#if $data.returnVal}}
                    <div class='info-value'>Return: {{=returnVal}}</div>
               {{else}}
                    <div class='info-value'>Return: N/A</div>
               {{/if}}
               {{#if $data.category}}
                    <div class='info-value'>Category: {{=category}}</div>
               {{/if}}
            </td>
            <td>
                <div class='desc-value'>{{=desc}}</div>
                <pre>{{=example}}</pre>
            </td>
        </tr>
    </script>
</body>
</html>

Resources

github – jsrenderhttps://github.com/BorisMoore/jsrender

github – jsviewshttps://github.com/BorisMoore/jsviews
jQuery Templates and JsViews: The Roadmaphttp://www.borismoore.com/2011/10/jquery-templates-and-jsviews-roadmap.html
Reducing JavaScript Code Using jsRender Templates in HTML5 Applicationshttp://weblogs.asp.net/dwahlin/archive/2011/11/23/reducing-javascript-code-by-using-jsrender-templates-in-html5-applications.aspx

Installing SharePoint 2010 on Windows 8

2011-09-17T17:12:00.000-07:00

Just for kicks I got Windows 8 Preview installed today and thought I'd see if I could get SharePoint 2010 installed as well. Fortunately, the setup instructions are pretty much identical to the ones used for Windows 7. The important thing to remember is that you need to make sure IIS uses .NET 2.0 instead of 4.0.

Install SQL Server 2008. I used R2, but you can use any version listed in the requirements.
Ensure all of the required IIS features are installed through Programs and Features. The easiest way to do this is to use the script that Microsoft provides. You can do this by copying the following into a Command Prompt.

start /w pkgmgr /iu:IIS-WebServerRole;IIS-WebServer;IIS-CommonHttpFeatures;^
IIS-StaticContent;IIS-DefaultDocument;IIS-DirectoryBrowsing;IIS-HttpErrors;^
IIS-ApplicationDevelopment;IIS-ASPNET;IIS-NetFxExtensibility;^
IIS-ISAPIExtensions;IIS-ISAPIFilter;IIS-HealthAndDiagnostics;^
IIS-HttpLogging;IIS-LoggingLibraries;IIS-RequestMonitor;IIS-HttpTracing;IIS-CustomLogging;IIS-ManagementScriptingTools;^
IIS-Security;IIS-BasicAuthentication;IIS-WindowsAuthentication;IIS-DigestAuthentication;^
IIS-RequestFiltering;IIS-Performance;IIS-HttpCompressionStatic;IIS-HttpCompressionDynamic;^
IIS-WebServerManagementTools;IIS-ManagementConsole;IIS-IIS6ManagementCompatibility;^
IIS-Metabase;IIS-WMICompatibility;WAS-WindowsActivationService;WAS-ProcessModel;^
WAS-NetFxEnvironment;WAS-ConfigurationAPI;WCF-HTTP-Activation;^
WCF-NonHTTP-Activation

Update IIS and Microsoft .NET Framework 3.5.1 to use .NET Framework Version 2.0 instead of 4.0. You can do this by opening IIS, clicking the root host and then clicking Change .NET Framework Version in the right Actions pane.
Install SharePoint 2010 prerequisites for Windows 7. The only ones I needed to install were the following:

Per the setup instructions, before running SharePoint setup, update the SharePoint 2010 config.xml found under [SharePointSetupFiles]\Files\Setup. You will need to change the Setting Value in AllowWindowsClientInstall to True.

Setting Up the Development Environment for SharePoint 2010 on Windows Vista, Windows 7, and Windows Server 2008

http://msdn.microsoft.com/en-us/library/ee554869.aspx

Hardware and software requirements (SharePoint Server 2010)

http://technet.microsoft.com/en-us/library/cc262485.aspx

Add every installed web part to a single SharePoint page

2011-06-06T20:41:00.001-07:00

Here is a code snippet that won't be used for normal day usage, but something is very helpful for testing web part UI and branding. This could also be used for performance benchmarking and exploring or demonstrating different web parts in a development environment. By default, the code will alphabetize the web parts by title and then adds them to the top web part zone.You can easily update the code to filter out specific web parts, update web part properties, populate specific web part zones.

InstructionsThe first thing you’ll want to do is increase the maximum web parts per zone. The default is set to 50, but you can increase it by editing your web.config.
<WebPartLimits MaxZoneParts="100" PropertySize="1048576" />
You can then create a C# Console Application in Visual Studio, add a reference to Microsoft.SharePoint, and then add the following code to Program.cs. This will work with SharePoint 2007 and 2010 as long as you reference the correct assembly. Don’t forget to make sure your Visual Studio project’s Platform Target is Any CPU or x64.
Updated 6/7/2010

Better exception handling.
Option to delete existing web parts before adding.
Link to Web Part Page Maintenance.

Notes:
The Web Analytics Web Part and Date Filter web parts can be added manually, but have bugs that won’t allow them to be added programmatically. See comments in source code. The Excel Web Access web part is also the only one that did not have a Web Part Title by default. This is why I ended up using the Web Parts gallery list title instead. Hopefully these will be addressed with an later update.
One other thing I noticed is that sometimes the code will not add all web parts. This usually happens when I have run the code too many times in a row and my guess is a timer job is getting caught up or something is being cached. If you are on a slower environment, you may want to consider adding a few sleep statements between each web part added.
As far as results are concerned, when I create a site collection using the Publishing Portal site template and enable every site collection and site feature, I see 75 web parts total. Other than the Web Analytics and Date Filter web parts, I have seen everything else successfully added to the page.
Screenshots
Console Application – Note: I did find errors with the Web Analytics and Date Filter web parts

SharePoint Page – Notice how large that vertical scrollbar is.

Keep in mind that you can easily delete any web parts, by going to the Web Part Page Maintenance page. Simply append the query string ?contents=1 to the page URL.

Source Code:

using System;
using System.Collections.Generic;
using System.IO;
using System.Web.UI.WebControls.WebParts;
using System.Xml;
using Microsoft.SharePoint;
using Microsoft.SharePoint.WebPartPages;

namespace AddAllWebParts
{
    class Program
    {
        static void Main(string[] args)
        {
            AddAllWebParts("http://spdev/sites/publishingportal/SitePages/Home.aspx", true);
        }

        public static void AddAllWebParts(string pageUrl, bool deleteExisting)
        {
            int wpInstalledTotal = 0;
            int wpTotal = 0;
            string webPartTag = "<WebPartPages:WebPartZone";
            try
            {
                using (SPSite site = new SPSite(pageUrl))
                {
                    using (SPWeb web = site.OpenWeb())
                    {
                        using (SPLimitedWebPartManager wpMgr =
                            web.GetLimitedWebPartManager(pageUrl, PersonalizationScope.Shared))
                        {
                            if (deleteExisting)
                            {
                                try
                                {
                                    List<System.Web.UI.WebControls.WebParts.WebPart> pageWps = 
                                        new List<System.Web.UI.WebControls.WebParts.WebPart>();
                                    foreach (System.Web.UI.WebControls.WebParts.WebPart wp in wpMgr.WebParts)
                                    {
                                        pageWps.Add(wp);
                                    }
                                    foreach (System.Web.UI.WebControls.WebParts.WebPart wp in pageWps)
                                    {
                                        Console.WriteLine(string.Format("Deleting Web Part: {0}", wp.Title));
                                        wpMgr.DeleteWebPart(wp);
                                        web.Update();
                                    }
                                }
                                catch (Exception ex)
                                {
                                    Console.WriteLine("Error Deleting Existing Web Parts" + ex.Message);
                                }
                            }
                            web.GetCatalog(SPListTemplateType.WebPartCatalog);
                            SPList wpList = web.GetCatalog(SPListTemplateType.WebPartCatalog);
                            SPFile file = web.GetFile(pageUrl);
                            string zoneId = string.Empty;
                            string sourceCode = System.Text.Encoding.UTF8.GetString(file.OpenBinary());
                            if (sourceCode.IndexOf(webPartTag) > -1)
                            {
                                zoneId = sourceCode.Substring(sourceCode.IndexOf(webPartTag));
                                if (zoneId.IndexOf("ID=") > -1)
                                {
                                    zoneId = zoneId.Substring(zoneId.IndexOf("ID=")).Replace("ID=\"", "");
                                    zoneId = zoneId.Substring(0, zoneId.IndexOf("\""));
                                }
                            }
                            if (!string.IsNullOrEmpty(zoneId))
                            {
                                List<SPListItem> wpItems = new List<SPListItem>();
                                wpTotal = wpList.Items.Count;
                                foreach (SPListItem item in wpList.Items)
                                {
                                    wpItems.Add(item);
                                }
                                wpItems.Sort((x1, x2) => x1.Title.CompareTo(x2.Title));
                                wpItems.Reverse();
                                foreach (SPListItem item in wpItems)
                                {
                                    try
                                    {
                                        string fileName = string.Format("{0}/{1}", item.Web.Url, item.File.Url);
                                        XmlTextReader reader = 
                                            new XmlTextReader(new StringReader(item.Web.GetFileAsString(fileName)));
                                        string error;
                                        System.Web.UI.WebControls.WebParts.WebPart wp = wpMgr.ImportWebPart(reader, out error);
                                        if (string.IsNullOrEmpty(error))
                                        {
                                            Console.WriteLine(string.Format("Adding Web Part: {0}", item.Title));
                                            switch (item.Title)
                                            {
                                                case "Date Filter":
                                                    //TODO: Date Filter has a TargetInvocationException. Not sure why this fails.
                                                    break;
                                                case "Web Analytics Web Part":
                                                    //TODO: Web Analytics Web Part fails with an XML. 
                                                    //I have validated the dwp and even removed comments to no avail.
                                                    //http://social.technet.microsoft.com/Forums/en-CA/sharepoint2010programming/thread/f2f7684d-58a7-4fb4-94a4-199ba4132a53
                                                    break;
                                            }
                                            wpMgr.AddWebPart(wp, zoneId, Convert.ToInt32(0));
                                            wpMgr.SaveChanges(wp);
                                            web.Update();
                                            wpInstalledTotal++;
                                        }
                                        else
                                        {
                                            Console.WriteLine(string.Format("Error Adding Web Part: {0} {1})", item.Title, error));
                                        }
                                    }
                                    catch (Exception ex)
                                    {
                                        Console.WriteLine(string.Format("Error Adding Web Part: {0} {1})",
                                            item.Title, ex.Message));
                                    }
                                }
                                Console.WriteLine("Adding Content Editor Web Part with Web Part Page Maintenance Link");
                                ContentEditorWebPart contentEditor = new ContentEditorWebPart();
                                contentEditor.ZoneID = zoneId;
                                contentEditor.ChromeType = PartChromeType.None;
                                XmlDocument xmlDoc = new XmlDocument();
                                XmlElement xmlElement = xmlDoc.CreateElement("p");
                                xmlElement.InnerText = "<h3><a href='" + pageUrl + "?contents=1'>Web Part Page Maintenance</a></h3>";
                                contentEditor.Content = xmlElement;
                                contentEditor.Content.InnerText = xmlElement.InnerText;
                                wpMgr.AddWebPart(contentEditor, contentEditor.ZoneID, 0);
                                wpMgr.SaveChanges(contentEditor);
                                web.Update();
                            }
                            else
                            {
                                Console.WriteLine("The page contains no web part zones.");
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
            }
            Console.WriteLine(string.Format("Total Web Parts Added: {0} of {1}", wpInstalledTotal.ToString(), wpTotal.ToString()));
            Console.Read();
        }
    }
}

Create a favorites icon (favicon) for your SharePoint 2010 site

2011-06-03T14:31:00.001-07:00

With SharePoint 2010, Microsoft has provided a new control called SPShortcutIcon. Sadly, if you are trying to use this within a feature deployment and would like to use relative paths using $SPUrl variables, you will run into some issues. This is because the SPShortcut.IconUrl is of type URI and the $SPUrl variable cannot be cast properly. Fortunately, there is a work around. It’s a bit ugly, but instead of using the control, you can use Literal controls to render the proper html link control.
SPShortcut usage– This is hardcoded, so won’t work with feature deployments.
<SharePoint:SPShortcutIcon runat="server" IconUrl="/Style Library/Waffles/favicon.ico"/>
SPShortcut usage with $SPUrl – This will result in the following error: Unable to cast object of type 'System.String' to type 'System.Uri'.
<SharePoint:SPShortcutIcon runat="server" IconUrl="<% $SPUrl:~sitecollection/Style Library/Acme/favicon.ico %>" />
Solution

<asp:Literal runat="server" Text="<link rel='shortcut icon' href='" /><asp:Literal runat="server" Text="<% $SPUrl:~sitecollection/Style Library/Acme/favicon.ico %>" /><asp:Literal runat="server" Text="' type='image/vnd.microsoft.icon' />" />
Google.com’s favorite icon

SharePoint 2010, Favorites Icons (FavIcons) and SPUrl (SPUrlExpressionBuilder)Credit goes to Joel for this tip. Unfortunately, I could only get to his post via Google cache.http://joelblogs.co.uk/2010/11/09/sharepoint-2010-favorites-icons-favicons-and-spurl-spurlexpressionbuilder/

Get SharePoint audit details across the farm for specific users

2011-06-01T16:30:00.001-07:00

This code snippet gets all audit details for specific users across an entire SharePoint 2007/2010 farm and saves them to a CSV file. I have also added a method to include a file extension column. This comes in handy as you will likely want to filter out web extensions like aspx, html, css, etc., picture formats, and folders. In order to get any data, auditing will have to have been enabled at the Site Collection level through site settings or programmatically at the item level. Keep in mind that this will take some time if your AuditData tables are very large, so in this case you will want to make further refinements by filtering by site collection, list, or list item. Site collections can be filtered out by tweaking the loop statements below, while you can filter out list or list items by updating the RestrictToList or RestrictToListItem methods of the SPAuditQuery object.
Helpful Links
Configure audit settings for a site collectionshttp://office.microsoft.com/en-us/sharepoint-server-help/configure-audit-settings-for-a-site-collection-HA010099726.aspx
Custom Auditing in SharePoint
http://msdn.microsoft.com/en-us/magazine/cc794261.aspx

InstructionsCreate a c# Console Application in Visual Studio, add a reference to Microsoft.SharePoint, and then add the following code to Program.cs. This will work with SharePoint 2007 and 2010 as long as you reference the correct assembly. Don’t forget to make sure your Visual Studio project’s Platform Target is Any CPU or x64.

using System;
using System.IO;
using System.Text;
using System.Windows.Forms;
using Microsoft.SharePoint;
using Microsoft.SharePoint.Administration;

namespace SPCheckAudit
{
    class Program
    {
        [STAThread]
        static void Main(string[] args)
        {
            GetUserAuditEntries(new string[] { "corp\\jdoe", "corp\bsmith" });

        }

        public static void GetUserAuditEntries(string[] userLogins)
        {
            StringBuilder sb = new StringBuilder();
            sb.Append("User,FullUrl,DocLocation,Event,EventData,EventName,EventSource,ItemId,ItemType," +
                "LocationType,MachineIP,MachineName,Occurred,SiteId,SourceName,UserId\r\n");
            try
            {
                SPSecurity.RunWithElevatedPrivileges(delegate()
                {
                    SPServiceCollection services = SPFarm.Local.Services;
                    foreach (SPService curService in services)
                    {
                        if (curService is SPWebService)
                        {

                            SPWebService webService = (SPWebService)curService;
                            foreach (SPWebApplication spWebApplication in webService.WebApplications)
                            {
                                foreach (SPSite site in spWebApplication.Sites)
                                {
                                    Console.WriteLine("Checking Site: " + site.ID + " " + site.PortalName);

                                    foreach (string userLogin in userLogins)
                                    {
                                        try
                                        {
                                            SPUser user = site.RootWeb.AllUsers[userLogin];
                                            SPAuditQuery auditQuery = new SPAuditQuery(site);
                                            SPAuditEntryCollection auditItems = site.Audit.GetEntries(auditQuery);
                                            foreach (SPAuditEntry auditItem in auditItems)
                                            {
                                                sb.Append(string.Format("\"{0}\",\"{1}\",\"{2}\",\"{3}\",\"{4}\",\"{5}\",\"{6}\",\"{7}\"" +
                                                    ",\"{8}\",\"{9}\",\"{10}\",\"{11}\",\"{12}\",\"{13}\",\"{14}\"\r\n",
                                                    userLogin, GetExtension(auditItem.DocLocation), auditItem.DocLocation, auditItem.Event, 
                                                    auditItem.EventData, auditItem.EventName, auditItem.EventSource, auditItem.ItemId, 
                                                    auditItem.ItemType, auditItem.LocationType, auditItem.MachineIP, auditItem.MachineName, 
                                                    auditItem.Occurred, auditItem.SiteId, auditItem.SourceName, auditItem.UserId));
                                            }
                                        }
                                        catch (SPException spex)
                                        {
                                            if (!spex.Message.Contains("User cannot be found."))
                                            {
                                                throw (spex);
                                            }
                                        }
                                        catch (Exception ex)
                                        {
                                            Console.WriteLine(ex.ToString());
                                        }
                                    }
                                }
                            }
                        }
                    }
                });
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
            }
            SaveFileDialog sfd = new SaveFileDialog();
            sfd.Filter = "CSV File|*.csv";
            sfd.Title = "Save File";
            if (sfd.ShowDialog() == DialogResult.OK)
            {
                using (var writer = new StreamWriter(sfd.FileName, true))
                {
                    writer.WriteLine(sb.ToString());
                }
            }
        }

        public static string GetExtension(string docLocation)
        {
            string extension = string.Empty;
            if (docLocation.Substring(docLocation.Length - 4, 1) == ".")
            {
                extension = docLocation.Substring(docLocation.Length - 3, 3);
            }
            else if (docLocation.Substring(docLocation.Length - 5, 1) == ".")
            {
                extension = docLocation.Substring(docLocation.Length - 4, 4);
            }
            else
            {
                extension = "folder";
            }
            return extension;
        }
    }
}

Determine auditing configuration details for all of your SharePoint site collections

2011-05-25T10:05:00.001-07:00

I recently had a customer whose SharePoint audit tables had getting very large. They wanted to know which site collections had auditing enabled so they could meet with their end users to determine if auditing was really necessary. Here is a code snippet for finding out which SharePoint sites have auditing enabled. The code will loop through all site collections in the farm and then create a CSV file with auditing configuration details.
InstructionsCreate a c# Console Application in Visual Studio, add a reference to Microsoft.SharePoint, and then add the following code to Program.cs. This will work with SharePoint 2007 and 2010 as long as you reference the correct assembly. Don’t forget to make sure your Visual Studio project’s Platform Target is Any CPU or x64.

using System;
using System.IO;
using System.Text;
using System.Windows.Forms;
using Microsoft.SharePoint;
using Microsoft.SharePoint.Administration;

namespace SPCheckAudit
{
   class Program
   {
       [STAThread]
       static void Main(string[] args)
       {
           StringBuilder sb = new StringBuilder();
           sb.Append("SiteID,SiteURL,ContentDB,");
           foreach (int value in System.Enum.GetValues(typeof(SPAuditMaskType)))
           {
               sb.Append(System.Enum.GetName(typeof(SPAuditMaskType), value) + ",");
           }
           sb.Append("\r\n");
           try
           {
               SPServiceCollection services = SPFarm.Local.Services;
               foreach (SPService curService in services)
               {
                   if (curService is SPWebService)
                   {
                       SPWebService webService = (SPWebService)curService;
                       foreach (SPWebApplication spWebApplication in webService.WebApplications)
                       {
                           foreach (SPSite site in spWebApplication.Sites)
                           {
                               if (site.Audit.AuditFlags != SPAuditMaskType.None)
                               {
                                   sb.Append(site.ID + "," + site.Url + "," + site.ContentDatabase.Name + ",");
                                   int enumLength = System.Enum.GetValues(typeof(SPAuditMaskType)).Length - 1;
                                   int counter = 0;
                                   foreach (int value in System.Enum.GetValues(typeof(SPAuditMaskType)))
                                   {
                                       sb.Append(((site.Audit.AuditFlags & (SPAuditMaskType)value) == (SPAuditMaskType)value).ToString());
                                       if (enumLength != counter)
                                       {
                                           sb.Append(",");
                                       }
                                       counter++;
                                   }
                                   sb.Append("\r\n");
                               }
                           }
                       }
                   }
               }
           }
           catch (Exception ex)
           {
               sb.Append(ex.ToString());
           }
           SaveFileDialog sfd = new SaveFileDialog();
           sfd.Filter = "CSV File|*.csv";
           sfd.Title = "Save File";
           if (sfd.ShowDialog() == DialogResult.OK)
           {
               using (var writer = new StreamWriter(sfd.FileName, true))
               {
                   writer.WriteLine(sb.ToString());
               }
           }
       }
   }
}

Create Rounded Corners And Gradient Images On The Fly!

2011-04-13T10:00:00.001-07:00

I am often tasked with taking a mockup and branding a site. This usually involves a custom master page with tweaks to the CSS for the layout and color scheme. It also involves the creation of images used to compliment the UI, the holy grail for some being gradient images and rounded corners. For the amateur graphic designer like myself, this often becomes a tedious task that involves repetitive tweaks to an image. I once had a client tell me that I had the wrong shade of “pumpkin”. (Depending on your disposition, this could result in an act of either running full speed into a brick wall or rocking yourself to sleep every night.)
Enter the poorly named Web Designer Tool! After some experimentation with the System.Drawing and System.Drawing.Drawing2D .NET 2.0 classes, I figured out a way to generate these images on the fly. Now I can rapidly create rounded corners and gradients and don't have to sweat it if a client needs a color or hue adjusted. The rounded corners include many options, including width, height, gradient and solid colors, radius corner size, and border. I also provide a preview feature that integrates the images into a sample html page and launches it in your default browser. I have successfully tested this in IE 6.0 ~ 8.0, Chrome 10.0, and Firefox 4.0.
Note: Although this will fly in the face of CSS purists, I have decided to use a simple table based layout for the preview html. I do make an effort to use DIV based layouts for web design, but in this case I have yet to find approach that works flawlessly across browsers types and versions or that integrates nicely with SharePoint. If you are that CSS guru, I welcome you to take these images and come up with a better approach. If you are successful, I would love to try out your code. You are also welcome to use my Shapes.cs class below and build your own tool. Life will be much easier once CSS 3 has reached enough market penetration and we can simply use the border-radius property.

Download Here
Screenshots
Rounded Corner Generator

Rounded Corner Generator (Fit To Screen)

Gradient Generator

Sample Generated Images using Default Settings:(Note: A folder is created using the top gradient color.)

Rounded Corners with Default Colors:

Rounded Corners with Border Only

Rounded Corners with Header, Footer, and Content using the same background color. Header and Content with the same text color.

Rounded Corners with Footer using the same color as content

Rounded Corners only on the Top Left and Bottom Right

Gradient using default colors. Example uses the following html: <html><body style="background-image:url('gradient.png');background-repeat:x"></body></html>

Shapes Source Code:This is the Shapes class I created to generate the rounded corners and gradient.

using System.Drawing;
using System.Drawing.Drawing2D;

namespace WebDesignerTool
{
    public class Shapes
    {
        public enum CornerType { TopLeft, TopRight, BottomLeft, BottomRight }
        public enum MiddleType { Top, Bottom }

        public static Bitmap GetRectangleCorner(int width, int height, Color startColor, Color endColor, 
            int radius, Color outlineColor, int outlineThickness, CornerType cornerType)
        {
            Bitmap bitmap = GetRectangle(width * 2, height * 2, startColor, endColor, radius, 
                outlineColor, outlineThickness);
            switch (cornerType)
            {
                case CornerType.TopLeft:
                    bitmap = bitmap.Clone(new Rectangle(0, 0, width, height), bitmap.PixelFormat);
                    break;
                case CornerType.TopRight:
                    bitmap = bitmap.Clone(new Rectangle(width, 0, width, height), bitmap.PixelFormat);
                    break;
                case CornerType.BottomLeft:
                    bitmap = bitmap.Clone(new Rectangle(0, height, width, height), bitmap.PixelFormat);
                    break;
                case CornerType.BottomRight:
                    bitmap = bitmap.Clone(new Rectangle(width, height, width, height), bitmap.PixelFormat);
                    break;
            }
            return bitmap;
        }

        public static Bitmap GetRectangleMiddle(int width, int height, Color startColor, Color endColor, 
            int radius, Color outlineColor, int outlineThickness, MiddleType middleType)
        {
            Bitmap bitmap = GetRectangle((width + outlineThickness + radius) * 4, height * 2, 
                startColor, endColor, 20, outlineColor, outlineThickness);
            int z = width + outlineThickness;
            switch (middleType)
            {
                case MiddleType.Top:
                    bitmap = bitmap.Clone(new Rectangle(bitmap.Width / 2 - width / 2, 0, width, height),
                        bitmap.PixelFormat);
                    break;
                case MiddleType.Bottom:
                    bitmap = bitmap.Clone(new Rectangle(bitmap.Width / 2 - width / 2, height, width, height), 
                        bitmap.PixelFormat);
                    break;
            }
            return bitmap;
        }

        public static Bitmap GetRectangle(int width, int height, Color startColor, Color endColor, int radius, 
            Color outlineColor, int outlineThickness)
        {
            Pen pen = new System.Drawing.Pen(outlineColor, outlineThickness);
            Rectangle originalRectangle = new System.Drawing.Rectangle(0, 0, width, height);
            Rectangle rectangle = new System.Drawing.Rectangle(0, 0, width, height);
            Bitmap bitmap = new Bitmap(width, height);
            using (Graphics graphics = Graphics.FromImage(bitmap))
            {
                if (radius > 0)
                {
                    graphics.SmoothingMode = SmoothingMode.HighQuality;
                    rectangle = new Rectangle(0, 0, width - (int)pen.Width, height - (int)pen.Width);

                    if (rectangle.Width < 1)
                        rectangle.Width = 1;
                    if (rectangle.Height < 1)
                        rectangle.Height = 1;
                    if (rectangle.Width / 2 < radius)
                        radius = rectangle.Width / 2;
                    if (rectangle.Height / 2 < radius)
                        radius = rectangle.Height / 2;
                    pen.EndCap = pen.StartCap = LineCap.Round;
                    LinearGradientBrush brush = new LinearGradientBrush(new Rectangle(0, 0, rectangle.Width, 
                        rectangle.Height + (int)pen.Width), startColor, endColor, LinearGradientMode.Vertical);
                    GraphicsPath graphicsPath = new GraphicsPath();
                    graphicsPath.AddArc(rectangle.X, rectangle.Y, radius, radius, 180, 90);
                    graphicsPath.AddArc(rectangle.X + rectangle.Width - radius, rectangle.Y, radius, radius, 270, 90);
                    graphicsPath.AddArc(rectangle.X + rectangle.Width - radius, 
                        rectangle.Y + rectangle.Height - radius, radius, radius, 0, 90);
                    graphicsPath.AddArc(rectangle.X, rectangle.Y + rectangle.Height - radius, radius, radius, 90, 90);
                    graphicsPath.CloseAllFigures();
                    graphics.FillPath(brush, graphicsPath);
                    if (outlineThickness > 0)
                    {
                        graphics.DrawPath(pen, graphicsPath);
                    }
                }
                else
                {
                    LinearGradientBrush brush = new LinearGradientBrush(new Rectangle(0, 0, rectangle.Width, 
                        rectangle.Height + (int)pen.Width), startColor, endColor, LinearGradientMode.Vertical);
                    graphics.FillRectangle(brush, new Rectangle(0, 0, width, height));
                    if (outlineThickness > 0)
                    {
                        graphics.DrawRectangle(pen, rectangle);
                    }
                }
            }
            return bitmap;
        }
    }
}

Custom Control with Connecting Lines using WPF / Silverlight

2011-02-11T15:58:00.001-08:00

Recently I was developing a migration tool that incorporates two TreeView controls and allows a user to draw lines between controls. After a bit of a struggle, I finally came up with a solution that works pretty well. The control inherits from the Grid control and uses drag and drop event handlers to draw connecting lines between controls of the same type. Because it is a Grid control, it also gives you the ability to add multiple controls and style it as you wish. In this example, I simply embedded a border control with some rounded corners and line gradients. Within the Border control, I simply added a TextBlock with the necessary text. A random color algorithm (courtesy of Philosophil Blog) determines what color is used.

Custom Properties
ConnectedControl – When two controls are connected, they are able to reference each other through this property.
ConnectedLine – This contains a reference to the line that is added.
AllowMultipleConnections – This determines if the control to connect to multiple items.
ConnectionType – This is an enum that determines whether a control can connect to other controls based on their connection type. The values Both, Source, and Target. Both is the default and says that the control can connect to any other control. Source controls can only connect to Target controls and vice versa.
LineThickness – This determines how thick the connecting line is.

Steps
In order to use this control, you simply need to create a class called ConnectingControl.cs and copy and paste the code below your WPF project. (Of course, you will need to update your namespace.) In order to add the control to your page, simply add a reference to your local assembly and then add the control. At the very least, you will also need to nest another control like a TextBlock or Image. I have included the source code for my MainWindow.xaml below.

Screenshot

MainWindow.xaml

<Window x:Class="ConnectingLines.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        xmlns:local="clr-namespace:ConnectingLines"
        Title="Connecting Lines" Height="350" Width="525">
    <Window.Resources>
        <Style x:Key="ConnectingGridBorderSource" TargetType="Border">
            <Setter Property="Background" Value="{DynamicResource BoxBrushSource}" />
            <Setter Property="CornerRadius" Value="0,35,0,35" />
            <Setter Property="Margin" Value="0" />
        </Style>
        <Style x:Key="ConnectingGridBorderTarget" TargetType="Border">
            <Setter Property="Background" Value="{DynamicResource BoxBrushTarget}" />
            <Setter Property="CornerRadius" Value="0,35,0,35" />
            <Setter Property="Margin" Value="0" />
        </Style>        
        <Style x:Key="ConnectingGridSource" TargetType="local:ConnectingControl">
            <Setter Property="Margin" Value="10" />
            <Setter Property="AllowMultipleConnections" Value="False" />
            <Setter Property="ConnectionType" Value="Source" />
            <Setter Property="LineThickness" Value="3" />
        </Style>
        <Style x:Key="ConnectingGridTarget" TargetType="local:ConnectingControl">
            <Setter Property="Margin" Value="10" />
            <Setter Property="AllowMultipleConnections" Value="False" />
            <Setter Property="ConnectionType" Value="Target" />
            <Setter Property="LineThickness" Value="3" />
        </Style>        
        <Style x:Key="ConnectingGridTextBlock" TargetType="TextBlock">
            <Setter Property="Foreground" Value="AliceBlue" />
            <Setter Property="FontSize" Value="24" />
            <Setter Property="FontWeight" Value="Bold" />
            <Setter Property="VerticalAlignment" Value="Center" />
            <Setter Property="HorizontalAlignment" Value="Center" />
        </Style>
        <LinearGradientBrush x:Key="BoxBrushSource" StartPoint="0,0" EndPoint="0,1">
            <LinearGradientBrush.GradientStops>
                <GradientStop Color="AliceBlue" Offset="0.0" />
                <GradientStop Color="Green" Offset="0.4" />
            </LinearGradientBrush.GradientStops>
        </LinearGradientBrush>
        <LinearGradientBrush x:Key="BoxBrushTarget" StartPoint="0,0" EndPoint="0,1">
            <LinearGradientBrush.GradientStops>
                <GradientStop Color="AliceBlue" Offset="0" />
                <GradientStop Color="DarkBlue" Offset=".4" />
            </LinearGradientBrush.GradientStops>
        </LinearGradientBrush>        
    </Window.Resources>
    <Grid>
        <Grid.ColumnDefinitions>
            <ColumnDefinition />
            <ColumnDefinition />
            <ColumnDefinition />
        </Grid.ColumnDefinitions>
        <Grid.RowDefinitions>
            <RowDefinition />
            <RowDefinition />
            <RowDefinition />
        </Grid.RowDefinitions>
        <local:ConnectingControl  Style="{StaticResource ConnectingGridSource}" Grid.Row="0" Grid.Column="0">
            <Border Style="{StaticResource ConnectingGridBorderSource}">
                <TextBlock Text="Banana" Style="{StaticResource ConnectingGridTextBlock}" />
            </Border>
        </local:ConnectingControl>
        <local:ConnectingControl  Style="{StaticResource ConnectingGridSource}" Grid.Row="1" Grid.Column="0">
            <Border Style="{StaticResource ConnectingGridBorderSource}">
                <TextBlock Text="Spinach" Style="{StaticResource ConnectingGridTextBlock}" />
            </Border>
        </local:ConnectingControl>
        <local:ConnectingControl  Style="{StaticResource ConnectingGridSource}" Grid.Row="2" Grid.Column="0">
            <Border Style="{StaticResource ConnectingGridBorderSource}">
                <TextBlock Text="Feta" Style="{StaticResource ConnectingGridTextBlock}" />
            </Border>
        </local:ConnectingControl>
        <local:ConnectingControl  Style="{StaticResource ConnectingGridTarget}" Grid.Row="0" Grid.Column="2">
            <Border Style="{StaticResource ConnectingGridBorderTarget}">
                <TextBlock Text="Cheese" Style="{StaticResource ConnectingGridTextBlock}" />
            </Border>
        </local:ConnectingControl>
        <local:ConnectingControl  Style="{StaticResource ConnectingGridTarget}" Grid.Row="1" Grid.Column="2">
            <Border Style="{StaticResource ConnectingGridBorderTarget}">
                <TextBlock Text="Fruit" Style="{StaticResource ConnectingGridTextBlock}" />
            </Border>
        </local:ConnectingControl>
        <local:ConnectingControl  Style="{StaticResource ConnectingGridTarget}" Grid.Row="2" Grid.Column="2">
            <Border Style="{StaticResource ConnectingGridBorderTarget}">
                <TextBlock Text="Vegetable" Style="{StaticResource ConnectingGridTextBlock}" />
            </Border>
        </local:ConnectingControl>
    </Grid>
</Window>

ConnectingControl.cs

using System;
using System.ComponentModel;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Shapes;

namespace ConnectingLines
{
    public class ConnectingControl : Grid
    {
        #region PROPERTIES
        public enum Connection { Both, Source, Target };
        private ConnectingControl ConnectedControl { get; set; }
        private Line ConnectedLine { get; set; }

        new private bool AllowDrop { get; set; }

        #region DEPENDENCY PROPERTIES
        public event PropertyChangedEventHandler PropertyChanged;

        private void NotifyPropertyChanged(String info)
        {
            if (PropertyChanged != null)
            {
                PropertyChanged(this, new PropertyChangedEventArgs(info));
            }
        }

        public static readonly DependencyProperty AllowMultipleConnectionsProperty = DependencyProperty.Register("AllowMultipleConnections", typeof(bool), typeof(ConnectingControl));
        public static readonly DependencyProperty ConnectionTypeProperty = DependencyProperty.Register("ConnectionType", typeof(Connection), typeof(ConnectingControl));
        public static readonly DependencyProperty LineThicknessProperty = DependencyProperty.Register("LineThickness", typeof(double), typeof(ConnectingControl));

        public bool AllowMultipleConnections
        {
            get 
            { 
                return (bool)GetValue(AllowMultipleConnectionsProperty); }
            set
            {
                SetValue(AllowMultipleConnectionsProperty, value);
                NotifyPropertyChanged("AllowMultipleConnections");
            }
        }

        public Connection ConnectionType
        {
            get { return (Connection)GetValue(ConnectionTypeProperty); }
            set
            {
                SetValue(ConnectionTypeProperty, value);
                NotifyPropertyChanged("ConnectionType");
            }
        }

        public double LineThickness
        {
            get 
            {
                double thickness = (double)GetValue(LineThicknessProperty);
                if (thickness == 0)
                {
                    thickness = 3;
                }
                return thickness; 
            }
            set
            {
                SetValue(LineThicknessProperty, value);
                NotifyPropertyChanged("LineThickness");
            }
        }
        #endregion
        #endregion

        #region CONSTRUCTOR AND INITIALIZER
        public ConnectingControl()
        {
            this.DragEnter += new DragEventHandler(CustomButton_DragEnter);
            this.Drop += new DragEventHandler(CustomButton_Drop);
            this.PreviewMouseLeftButtonDown += new MouseButtonEventHandler(CustomButton_PreviewMouseLeftButtonDown);
        }
        
        protected override void OnInitialized(System.EventArgs e)
        {
            base.AllowDrop = true;
            base.OnInitialized(e);            
            PreviewMouseLeftButtonDown += new MouseButtonEventHandler(CustomButton_PreviewMouseLeftButtonDown);
            Drop += new System.Windows.DragEventHandler(CustomButton_Drop);
            DragEnter += new System.Windows.DragEventHandler(CustomButton_DragEnter);
        }
        #endregion

        #region EVENT HANDLERS AND METHODS
        protected void CustomButton_PreviewMouseLeftButtonDown(object sender, System.Windows.Input.MouseButtonEventArgs e)
        {
            ConnectingControl item = (ConnectingControl)sender;
            DataObject dragData = new DataObject("source", (ConnectingControl)sender);
            DragDrop.DoDragDrop((ConnectingControl)sender, dragData, DragDropEffects.Move);
        }

        protected void CustomButton_DragEnter(object sender, System.Windows.DragEventArgs e)
        {
            if (!e.Data.GetDataPresent("source") || sender == e.Source)
            {
                e.Effects = DragDropEffects.None;
            }
        }

        protected void CustomButton_Drop(object sender, System.Windows.DragEventArgs e)
        {
            if (e.Data.GetDataPresent("source"))
            {
                ConnectingControl source = e.Data.GetData("source") as ConnectingControl;
                ConnectedControl = source;
                ConnectControls();
            }
        }
        
        private void ConnectControls()
        {
            bool connect = false;
            if (this.ConnectionType == Connection.Both)
            {
                connect = true;
            }
            else
            {
                if (this.ConnectionType == ConnectedControl.ConnectionType)
                {
                    connect = false;
                }
                else
                {
                    connect = true;
                }
            }
            if (connect)
            {
                Panel parent = GetRoot(this);
                Line line = new Line() { StrokeThickness = LineThickness, Stroke = GetRandomBrush() };
                GeneralTransform sourceTransform = ConnectedControl.TransformToVisual(parent);
                Point sourcePoint = sourceTransform.Transform(new Point(0, 0));
                GeneralTransform targetTransform = this.TransformToVisual(parent);
                Point targetPoint = targetTransform.Transform(new Point(0, 0));
                if (sourcePoint.X < targetPoint.X)
                {
                    line.X1 = sourcePoint.X + ConnectedControl.ActualWidth;
                    line.Y1 = sourcePoint.Y + ConnectedControl.ActualHeight / 2;
                    line.X2 = targetPoint.X;
                    line.Y2 = targetPoint.Y + this.ActualHeight / 2;
                }
                else
                {
                    line.X1 = targetPoint.X + this.ActualWidth;
                    line.Y1 = targetPoint.Y + this.ActualHeight / 2;
                    line.X2 = sourcePoint.X;
                    line.Y2 = sourcePoint.Y + ConnectedControl.ActualHeight / 2;
                }
                if (parent.GetType() == typeof(Grid))
                {
                    line.SetValue(Grid.ColumnSpanProperty, ((Grid)parent).ColumnDefinitions.Count);
                    line.SetValue(Grid.RowSpanProperty, ((Grid)parent).RowDefinitions.Count);
                }
                if (!AllowMultipleConnections)
                {
                    if (ConnectedLine != null)
                    {
                        parent.Children.Remove(ConnectedLine);
                    }
                    if (ConnectedControl != null)
                    {
                        if (ConnectedControl.ConnectedLine != null)
                        {
                            GetRoot(this).Children.Remove(ConnectedControl.ConnectedLine);
                        }
                    }
                }
                ConnectedLine = line;
                ConnectedControl.ConnectedLine = line;
                parent.Children.Add(line);
            }
        }
        #endregion

        #region MISC METHODS
        private Panel GetRoot(FrameworkElement child)
        {
            var parent = child.Parent as FrameworkElement;
            if (parent == null)
            {
                if (child is Window)
                {
                    if (((Window)child).Content.GetType().BaseType == typeof(Panel))
                    {
                        return ((Window)child).Content as Panel;
                    }
                    else
                    {
                        throw new Exception("The root content element is an unexpected type. It should be a Panel instead of a " +
                            ((Window)child).Content.GetType().BaseType.ToString() + ".");
                    }
                }
                else
                {
                    throw new Exception("The root element is an unexpected type. It should be a Window instead of a" +
                        child.GetType().ToString() + ".");
                }
            }
            return GetRoot(parent);
        }

        //COLOR GENERATOR CODE Courtesy of: http://philosophil.spaces.live.com/blog/cns!7E55D8EFA2AEE5D6!201.entry
        private Brush GetRandomBrush()
        {
            Random randomColor = new Random();
            SolidColorBrush brush = new SolidColorBrush();
            double r, g, b;
            double lightness = randomColor.NextDouble() * 0.5 + 0.4; // not too dark nor too light
            double hue = randomColor.NextDouble() * 360.0; // full hue spectrum
            double saturation = randomColor.NextDouble() * 0.8 + 0.2; // not too grayish
            HSLtoRGB(hue, saturation, lightness, out r, out g, out b);
            brush.Color = System.Windows.Media.Color.FromRgb((byte)(r * 255.0), (byte)(g * 255.0), (byte)(b * 255.0));
            return brush;
        }

        public static void HSLtoRGB(double hue, double saturation, double luminance, out double red, out double green, out double blue)
        {
            double q;
            double p;
            if (luminance < 0.5)
            {
                q = luminance * (1.0 + saturation);
            }
            else
            {
                q = luminance + saturation - (luminance * saturation);
            }
            p = 2 * luminance - q;
            double hk = hue / 360.0;
            double tr = hk + 1.0 / 3.0;
            double tg = hk;
            double tb = hk - 1.0 / 3.0;
            tr = Normalize(tr);
            tg = Normalize(tg);
            tb = Normalize(tb);
            red = ComputeColor(q, p, tr);
            green = ComputeColor(q, p, tg);
            blue = ComputeColor(q, p, tb);
        }

        private static double ComputeColor(double q, double p, double tc)
        {
            if (tc < 1.0 / 6.0)
            {
                return p + ((q - p) * 6.0 * tc);
            }
            if (tc < 0.5)
            {
                return q;
            }
            if (tc < 2.0 / 3.0)
            {
                return p + ((q - p) * 6.0 * (2.0 / 3.0 - tc));
            }
            return p;
        }

        private static double Normalize(double tr)
        {
            if (tr < 0)
            {
                return tr + 1.0;
            }
            if (tr > 1.0)
            {
                return tr - 1.0;
            }
            return tr;
        }
        #endregion
    }
}

A simple WPF fading popup control

2011-02-11T11:44:00.001-08:00

Steps:

1.) Create a WPF Project in Visual Studio. I named mine FadingPopup. (Note: You can use 3.5 or 4.0, but you will need to use 4.0 if you want to take advantage of the animation EasingFunctions.)
2.) Add a User Control with the following code:

FadingPopupControl.xaml

<UserControl x:Class="FadingPopup.FadingPopupControl"
             xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
             xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
             xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" 
             xmlns:d="http://schemas.microsoft.com/expression/blend/2008" 
             mc:Ignorable="d" BorderThickness="0" Margin="0">
    <UserControl.Resources>
        <Storyboard x:Name="StatusFader" x:Key="StatusFader" Completed="StatusFader_Completed">
            <DoubleAnimation Storyboard.TargetName="popupBackground" Storyboard.TargetProperty="Opacity" From="0.7" To="0" BeginTime="0:0:0"  Duration="0:0:1.5">
                <DoubleAnimation.EasingFunction>
                    <ExponentialEase Exponent="10" EasingMode="EaseIn" />
                </DoubleAnimation.EasingFunction>
            </DoubleAnimation>
        </Storyboard>
    </UserControl.Resources>
    <Popup Name="popup" Placement="Center" PopupAnimation="Fade" AllowsTransparency="True">
        <Grid Background="Transparent">
            <Grid Name="popupBackground" Background="Black" Grid.Column="0" Grid.Row="0" />
            <Label Name="popupLabel" DockPanel.Dock="Bottom" HorizontalAlignment="Center" Foreground="White" VerticalAlignment="Center" Background="Transparent" Grid.Column="0" Grid.Row="0"/>
        </Grid>
    </Popup>
</UserControl>

FadingPopupControl.xaml.cs

using System;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Media.Animation;

namespace FadingPopup
{
    public partial class FadingPopupControl : UserControl
    {
        Window ParentWindow { get; set; }
        public FadingPopupControl()
        {
            InitializeComponent();
        }

        protected override void OnInitialized(EventArgs e)
        {
            base.OnInitialized(e);            
        }

        public void ShowDialogBox(Window parentWindow, string message)
        {
            ParentWindow = parentWindow;
            popupLabel.Content = message;
            Storyboard StatusFader = (Storyboard)Resources["StatusFader"];
            ParentWindow.IsEnabled = false;
            FrameworkElement root = (FrameworkElement)ParentWindow.Content;
            this.Height = root.ActualHeight;
            this.Width = root.ActualWidth;
            //TODO: Determine why there is 1 pixel extra whitespace.
            //Tried playing with Margins and Alignment to no avail.
            popup.Height = root.ActualHeight + 1; 
            popup.Width = root.ActualWidth + 1;            
            popup.IsOpen = true;
            StatusFader.Begin(popupBackground);
        }

        void StatusFader_Completed(object sender, EventArgs e)
        {
            popup.IsOpen = false;
            ParentWindow.IsEnabled = true;            
        }
    }
}

3.) In the MainWindow.xaml, add a Button with a PreviewMouseLeftButtonDown event handler.
4.) Add a local reference and then your popup control.
5.) In your button event handler, initiate the popup.

MainWindow.xaml

<Window x:Class="FadingPopup.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        xmlns:local="clr-namespace:FadingPopup"
        xmlns:controls="clr-namespace:System.Windows.Controls;assembly=PresentationFramework"
        Title="MainWindow" Height="350" Width="525">
    <Grid>
        <Button x:Name="Test1" Height="40" Width="80" Content="Test1" Grid.Column="0" AllowDrop="False" PreviewMouseLeftButtonDown="Test1_PreviewMouseLeftButtonDown" />
        <local:FadingPopupControl x:Name="popup" />
    </Grid>
</Window>

MainWindow.xaml.cs

using System.Windows;
using System.Windows.Input;

namespace FadingPopup
{
    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();
        }

        private void Test1_PreviewMouseLeftButtonDown(object sender, MouseButtonEventArgs e)
        {
            popup.ShowDialogBox(Test1, "The is a sample message...");
        }
    }
}

Screenshots

This fades out in 1.2 seconds

PowerShell for SharePoint on Steroids!

2011-02-01T15:15:00.000-08:00

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",

($siteName + " Owners"),

"HR Owners",

($siteName + " 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()

Recursively set SharePoint MasterPages and CSS

2011-01-25T12:39:00.001-08:00

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);
                    }
                }
            }
        }
    }
}

Create AD Users in bulk with PowerShell

2011-01-21T14:19:00.001-08:00

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

2011-01-21T13:19:00.001-08:00

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;
        }
    }
}

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

2011-01-17T12:47:00.001-08:00

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

Copy the following in Notepad.
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"

Toggle between $true and $false statements at the bottom of the script to disable or enable. You could also create two separate scripts.
Save the file as a “.ps1” file.
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

SharePoint SPRegionalSettings.GlobalTimeZones ID List

2011-01-11T15:19:00.000-08:00

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

ID	Description
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

SPRegionalSettings.GlobalTimeZones Property

Learn Japanese Kanji 常用漢字 with Microsoft Pivot Viewer

2011-01-08T07:47:00.001-08:00

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

http://www.silverlight.net/learn/pivotviewer/

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

http://www.i-love-epson.co.jp/download2/printer/driver/win/page/ttf30.htm

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

SharePoint 2007 / 2010 - Silverlight Slide Show Web Part for Images and Videos

2011-01-04T17:15:00.001-08:00

For those familiar with SharePoint 2007, you know that a slide show web part is nonexistent and in order to get this functionality you would either have to resort to a 3rd party web part or do some custom web part development. SharePoint 2010 does provide some out of the box web parts like the Picture Library Slide Show Web Part and the Media Web Part, however these do have limitations. Neither provide the ability for albums, the ability to mix video and images, or full screen functionality. The Media Web Part also only allows a single video to be embedded. Furthermore, getting the web part’s width and heights properties to render properly can be challenging. This web part mitigates all of these issues and provides the following functionality:

Web Part Configuration – Using out of the box SharePoint functionality, you can simply add this web part to a web part zone. The web part properties are context sensitive and will display appropriate SharePoint webs and Picture Libraries and Asset Libraries that can be used for the slide show.
Mixed Media – This slide show web part allows video and/or images within slide shows.
Album View– An album view allows you to create multiple albums within the slide show. Albums are based on the SharePoint library’s root level folders.
SharePoint 2007 and 2010 Compatible – I have created two projects since each platform has different deployment requirements and other subtle differences.
Embed Slide Show – If you have non SharePoint web pages, the slide show has a feature that allows you to easily copy and paste HTML code to be used for embedding in other web sites.
Full Screen Mode – Any slide show can be viewed in full screen mode simply by clicking a button on the web part.
Other – For a full list of slide show features, see the Slide.Show link in References below.

Acknowledgements

This web part was based on the popular and open source Vertigo Slide.Show project in CodePlex, which also has an XML and Flickr data provider. All images used within the screenshots below can be found within the CodePlex source code. For the SharePoint data provider code, I made just a few changes to the code provided in Mathew McDermott’s blog post on the subject. See References below for more details.

Installation Overview

I am not going to provide complete instructions here as both projects will use standard deployment steps, but I have outlined a few things that you should probably know.

Visual Studio Solution and Projects

When you open either solution, you will see that there are three projects: Samples, SlideShow, and SharePoint20xx.CustomControls. The Samples and SlideShow projects are a customized versions of Vertigo’s Slide.Show CodePlex source code. The SlideShow project is the Silverlight project and has been changed to add the SPDataProvider code, remove some of the out of the box branding, and a few other minor changes. I have also created post build events that copy the XAP file to the SharePoint20xx.CustomControls project since this is used by the web part. In this project, the most important file is the SPDataProvider.cs file. If Vertigo provides an update to the CodePlex project, you could copy this over and rebuild the project. Just make sure that the XAP file makes it way into the Web Part project. The SharePoint20xx.CustomControls contains all of the Web Part specific information and deploys the XAP and a png file to the SharePoint hive within CONTROLTEMPLATES\SharePoint20xx.CustomControls directory. The XAP file contains all of the Silverlight code and the png file is used for video thumbnails. (SharePoint actually has one, but since it is a GIF file and thus unsupported by Silverlight.) You may also want to change things like the elements.xml file as I kept the name and group of the web part generic.

Debugging

The best way to debug is to set the Samples project as your StartUp project and the default.html page in the SharePoint folder as your Start Page in Visual Studio. Be sure to open the default.html file first and change the Web and List parameters appropriately. In order to play with the XML data providers, you are also going to need to download the original CodePlex project and add the Samples project’s Assets folder. This has an excellent collection of Silverlight compatible images and videos, but I have removed them from the download as they took up too much space.

Deployment

For either 2008 or 2010 projects, you can simply use STSADM and the WSP file. If you are a development machine, you can use WSPBuilder for 2008 or for 2010, Visual Studio 2010. The SharePoint 2008 source code utilizes Visual Studio 2008, WSPBuilder extensions, and Silverlight 2.0 development tools. You are welcome to use Silverlight 3.0 or 4.0 development tools as well, but will be prompted to upgrade the project. The SharePoint 2010 source code was developed in Visual Studio 2010 and Silverlight 4.0 development tools. Once you have deployed the feature, you will need to make sure it is activated on the site it has been deployed at. Once the feature has been activated, it can be added as a web part, by default under Custom Controls –> Silverlight Slide Show.

Silverlight / SharePoint Cross Domain Requirements – IMPORTANT!

In order for Silverlight to access SharePoint web services (“Lists.asmx” in this case), you will need to create a file called clientaccesspolicy.xml and save it to the SharePoint wwwroot directory (C:\inetpub\wwwroot\wss\VirtualDirectories\80). You can find a copy of this in the Slide.Show Sample project or use the text below. See References below for more details.

<?xml version="1.0" encoding="utf-8"?>
<access-policy>
<cross-domain-access>
    <policy>
      <allow-from http-request-headers="*">
        <domain uri="*"/>
      </allow-from>
      <grant-to>
        <resource path="/" include-subpaths="true"/>
      </grant-to>
    </policy>
</cross-domain-access>
</access-policy>

Configuration

In order to use the web part, you will first need to create a SharePoint Picture Library where you will be storing your images and/or videos. If you are using SharePoint 2010, you can alternatively create an Asset Library. You can then add images and videos (wmv format) to the library. In order to create albums, you can create folders at the root level. The name of the folder will be the name of the web album respectively. You can also set the Title and Description as these will be used when you mouse over a slide. If you do not provide a Title and Description, the image path will be used. One other minor thing I noticed is that the Title and Description change as soon as the transition starts, so depending on how you set up your Wait Times and Transition durations, it may appear that the these values are wrong. Also, keep in mind that the web part will resize pictures based on the height and width you provide in the web part properties, so it is recommended that you use images of equal size and aspect ratio. In order to configure the web part, open the page in edit mode, click on Modify Shared Web Part from the Web Part Edit drop down.

Supported Formats

Silverlight only accepts JPG and PNG for image formats and WMV for video formats. See MSDN References below for more details.

Web Part Configuration Properties

Web – This is used to filter the lists.
List – This is the Picture Library that will be used in the slide show.
Width – Image / Video width. Pictures and videos will be resized to fit this.
Height – Image / video height. Pictures and videos will be resized to fit this.
Transition Duration – Time in milliseconds that it takes to transition between slides.
Wait Time – Time in milliseconds that the slide stays in one place.
Theme – Theme to be used. Dark and Light are the only two themes.
Transition Type – These are the types of transitions that can be used between slides.
Start In Album View – This indicates whether or not you want the web part to default to album view.

Web Part Properties

Based on the web you pick, the list will be populated with Picture Libraries and/or Asset Libraries.

Screenshots (SharePoint 2010)

Slide Show View

Slide Show View – On Mouse Over
Slide Show View – Mouse Hover

Album View

Source Code

SkyDrive – SharePoint 2008 / SharePoint 2010
http://cid-a2379f7b2ea6f936.office.live.com/browse.aspx/Public/Projects/SharePoint/SharePoint%20SlideShow

References

CodePlex – Vertigo Slide.Show – Original Source Code for Samples and SlideShow projects. This is a great place for understanding the features and troubleshooting issues.
http://slideshow.codeplex.com

Building Blocks #1: Silverlight Slideshow Viewer for SharePoint - Matthew provided the original SPDataProvider class that I borrowed from heavily.
http://www.ableblue.com/blog/archive/2010/03/08/building-blocks-1-silverlight-slideshow-viewer-for-sharepoint.aspx

Supported Media Formats, Protocols, and Log Fields – Silverlight compatible video formats
http://msdn.microsoft.com/en-us/library/cc189080(VS.95).aspx

BitMap Image Class – Silverlight compatible image formats
http://msdn.microsoft.com/en-us/library/system.windows.media.imaging.bitmapimage(v=vs.95).aspx

Making a Service Available Across Domain Boundaries – Information on clientaccesspolicy.xml. I also recommend Jesse Liberty and Tim Heuer’s blogs.
http://msdn.microsoft.com/en-us/library/cc197955(v=vs.95).aspx

WSPBuilder – Visual Studio Extension required by the SharePoint 2007 project.
http://wspbuilder.codeplex.com