Home Contact

The Frog Pond of Technology

Ripples of Knowledge for SharePoint and Other .Net Technologies

News

 Subscribe to this blog


About Me

Name:
Brian T. Jackett
Location:
Columbus, OH
Company:
Microsoft

Find me on...

Tag Cloud


Archives

Post Categories

Syndication:

SharePoint


Slides and Scripts from DogFood Conference 2014

I was pleased to once again speak at the Dog Food Conference here in Columbus, OH. I believe this is the 3rd year that I have spoken and the 4th or 5th year that I have attended. The venue has moved to a more spacious location which definitely helped with giving attendees, speakers, and vendors more room to spread out, I was especially happy to meet up with dozens of previous customers and co-workers at the conference. This really is a great mix of audiences (developers, IT pros, and business users), ......

How I Use Azure IaaS for Lab VMs

Many years ago I posted How I Blog walking through my blogging process. Over the past few months many of my coworkers and customers have been talking or asking about how to use Azure IaaS for dev / test environments (especially for SharePoint). In this post I’ll walk through the configurations I use, tools that have helped me, and other tips. Note: This is not meant to be a post on best practices for rolling out your Azure IaaS infrastructure to support SharePoint. This is just my current setup as ......

I Contributed to the Office App Model Samples Project

<Update 2014-08-18> The Office App Model Samples project has been transitioned over to the Office 365 Developer Patterns & Practices GitHub repo. Please use that location going forward for any references.</Update 2014-08-18> During the SharePoint Conference 2014 I had the pleasure of meeting Vesa Juvonen (@vesajuvonen) and Steve Walker (Linked In) after their session “Real-world examples of FTC to CAM transformations” (video). This was a very valuable session to attend discussing ......

Slides and Scripts from SharePoint Cincy 2014

I was pleased to present at SharePoint Cincy again for the third year. Geoff and all the organizers do a great job. My presentation this year was “PowerShell for Your SharePoint Tool Belt”. Below are my slides and demo scripts. Thanks for all who attended, I hope you found something that will be useful for you in your work. Demo PowerShell Scripts Slidedeck -Frog Out ......

PowerShell Script to Workaround No Data in SharePoint 2013 Usage Reports

Over the past few months I’ve had 2 customers that have run into an scenario where the SharePoint 2013 web analytics usage reports have no data (all zeroes) in the reports. While working with some brilliant Microsoft escalation engineers (thanks Anthony and Jason) we were able to run some PowerShell scripts that added receivers to start data showing again on the following day. Since I haven’t seen any posts on this as of yet I thought I would post a version of the PowerShell scripts we used. Scenario ......

Slides from SPTechCon Boston 2013 Evolution of Social in SharePoint Presentation

Below are my slides for my SPTechCon Boston 2013 session for “The Evolution of Social in SharePoint 2013”. I made some last minute updates that will make their way over to the SPTechCon site as well, but for now here they are. If you attended thanks for coming and I’d love to hear any feedback. It was a great time presenting at SPTechCon again, sharing knowledge, and connecting with folks.. -Frog Out ......

PowerShell Script To Determine If SharePoint List Uses InfoPath Forms

Recently I had a request from a customer to find which SharePoint 2010 / 2013 lists are using InfoPath forms for their data entry (also known as enterprise forms for a SharePoint list). In this post I will show you a PowerShell script to determine if a SharePoint list is using InfoPath forms. Problem As you may have heard, InfoPath as a product will not be receiving any future releases (see InfoPath roadmap update blog post). Being able to find SharePoint lists using InfoPath forms may be useful ......

PowerShell Script to Limit SharePoint Site Templates Available

I had a customer request recently to limit the which site templates were available to end users to create subsites. Below is a short PowerShell script to do just that. Problem If you are using a Publishing Site you can restrict the available site templates by going to Site Settings –> Look & Feel and clicking on Page Layouts and Site Templates (see following screenshot). If you are not on a Publishing Site then there is not an easy (supported) way to accomplish this through out of the box ......

Guest Blog Post on Hey Scripting Guy Blog – STSADM Replacement

Quick blog post here to let you know that I wrote a guest blog post for Ed Wilson (The Microsoft Scripting Guy) over on the Hey Scripting Guy blog. The post is titled “Weekend Scripter: Using PowerShell to Replace STSADM” and covers some research I did into replacing the functionality of the “STSADM –o enumallwebs” command with PowerShell. Feel free to give it a read and let me know if you have any feedback or comments. Have a great end of this 2013 year. -Frog Out Links Weekend Scripter: Using PowerShell ......

Slides from Dog Food Conference 2013

Thanks to the organizers, attendees, and sponsors from Dog Food Conference 2013. It was a very packed conference but lots of great speakers and discussions going on. Thanks to the attendees for my session. Below is a link to my slides from my session on Social in SharePoint. I look forward to participating in future Dog Food Conferences. -Frog Out ......

Speaking at Dog Food Conference 2013

It has been a couple years since I last attended / spoke at Dog Food Conference, but on Nov 21-22, 2013 I’ll be speaking at Dog Food Conference 2013 here in Columbus, OH. For those of you confused by the name of the conference (no it’s not about dog food), read up on the concept of dogfooding . This conference has a history of great sessions from local and regional speakers and I look forward to being a part of it once again. Registration is now open (registration link) and is expected to sell out ......

Slides and Script Samples from SharePoint Saturday Columbus 2013

A big thanks to everyone who attended my “Integrating SharePoint 2013 and Office Web Apps Server” presentation this past weekend at SharePoint Saturday Columbus 2013. Below you can find a link with the slides and PowerShell script samples that I demoed. Also a big thanks to all of the organizers and other speakers who made it a great event. Always great to catch up with old friends and make new connections. For those of you interested in more SharePoint community in Columbus, OH feel free to join ......

Speaking at SharePoint Saturday Columbus 2013

It has been 2 years since the last SharePoint Saturday Columbus but thankfully a new group of organizers is taking up the mantel and putting on a new conference this year. I am honored to be speaking at this year’s event. Registration is already filled up but if you want to get on the waiting list please do so. If you’ll be attending feel free to join my session or track me down in the halls to say hi. Looking forward to a great event, speakers, and attendees. SharePoint Saturday Columbus 2013 Title: ......

Speaking at SPTechCon Boston 2013 and Call for Speakers SharePoint Saturday Columbus 2013

Dual purpose blog post this time. I wanted to announce a presentation I’m giving at SPTechCon Boston 2013 next week as well as pass along info on the call for speakers at the upcoming SharePoint Saturday Columbus 2013. SPTechCon Boston 2013 I have the honor of speaking at SPTechCon Boston for another year. This will make it 4 times now. The folks at BZ Media always put on a great show with high quality speakers and involvement from the community. There will even be two different user groups (SharePoint ......

PowerShell Script to Enumerate SharePoint 2010 or 2013 Permissions and Active Directory Group Membership

In this post I will present a script to enumerate SharePoint 2010 or 2013 permissions across the entire farm down to the site (SPWeb) level. As a bonus this script also recursively expands the membership of any Active Directory (AD) group including nested groups which you wouldn’t be able to find through the SharePoint UI. History Back in 2009 (over 4 years ago now) I published one my most read blog posts about enumerating SharePoint 2007 permissions. I finally got around to updating that script ......

PowerShell Script to Determine Number of Files in SharePoint 2010 or 2013 Document Libraries

Recently my fellow SharePoint PFE and teammate Jim Matson (@jamesmatson3) was looking for a way to display the number of documents inside each document library on a SharePoint 2010 / 2013 farm. Below is the script that we came up with. Problem It is not too difficult to find all of the document libraries and their item count in a given SharePoint 2010 or 2013 site collection, web application, or farm. What can be difficult is finding all of that along with the full URL of the site that contains the ......

Speaking at SharePoint Cincy 2013

I will be speaking at SharePoint Cincy 2013 on Friday Apr 19th. This will be my 2nd time speaking at SharePoint Cincy. I always enjoy getting to speak at local conferences as it is a great chance to connect with customers, meet new and old friends, and give back in a more intimate venue. I’ll be presenting one topic which I have delivered a similar presentation internally to Microsoft but this is slightly altered and for public consumption. Registration is still open. If you attend feel free to stop ......

PowerShell Script To Find Where SharePoint 2007 Features Are Activated

Recently I posted a script to find where SharePoint 2010 Features Are Activated. I built the original version to use SharePoint 2010 PowerShell commandlets as that saved me a number of steps for filtering and gathering features at each level. If there was ever demand for a 2007 version I could modify the script to handle that by using the object model instead of commandlets. Just the other week a fellow SharePoint PFE Jason Gallicchio had a customer asking about a version for SharePoint 2007. With ......

The Power of PowerShell and SharePoint: Enumerating SharePoint Permissions and Active Directory

<Update 2013-07-01> This script has been updated for SharePoint 2010 / 2013. Please see my updated script and blog post at PowerShell Script to Enumerate SharePoint 2010 or 2013 Permissions and Active Directory Group Membership. </Update 2013-07-01><Update> Posting code didn’t format as well as hoped. Download the below script here. </Update> For those of you who are SharePoint admins or developers but have never dug into the SharePoint API or PowerShell, I would recommend ......

SharePoint 2007 Content Deployment Job Error “Specified argument was out of the range of valid values”

This week I ran into an interesting error with a customer. The customer has defined a SharePoint 2007 content deployment path to push content from one SharePoint 2007 farm to another SharePoint 2007 farm. They can complete 1 full deploy and 1 incremental deploy, but then all incremental deploys error with the following message: “Specified argument was out of the range of valid values”. Cause In order to get more insight into the error I used ULSViewer to inspect the ULS logs on the server (ULSViewer ......

Speaking at SharePoint Cincy and SharePoint Saturday Twin Cities

I have a few conferences I’ll be speaking at in the next few weeks. The first is SharePoint Cincy in Cincinnati, OH on Friday March 16th. The other is SharePoint Saturday Twin Cities in Minneapolis, MN on April 14th. Below are the details for each. Assuming copies of my book arrive in time for either conference I’ll be giving away a book or two and signing them. Stop by and see me if you’ll be attending either conference. Sessions Where: SharePoint Cincy 2012 Title: PowerShell for the SharePoint ......

Speaking at SPS Cincinnati 2011

On Saturday Oct 29th, 2011 I’ll be speaking at SharePoint Saturday Cincinnati. My presentation is “PowerShell for the SharePoint 2010 Developer” which covers an introduction to PowerShell while focusing on integration with SharePoint and the .Net framework. This presentation has a fair amount of demonstrations and sample code. I’m excited to be attending SPSCincinnati as it is a short drive from Columbus and I also know a number of the other speakers and organizers. It’s looking to be a great conference. ......

PowerShell Script To Traverse All Sites In SharePoint 2010 (or 2007) Farm

Over the past few years I’ve written a number of blog posts on performing various actions against a site collection or web application (display site collection admins, find all SPShell admins with database, find closed web parts). Invariably with every post I get some comments along the lines of “this is great, how can I run this against every site in the farm”. Well today you get your wish (sort of). Below you will find a template script that traverses all sites within your local farm. Isn’t that ......

Exporting A SharePoint Site Into A Feature: Part 5 - Wrap Up

Part 1 – The Tools Part 2 - Exporting the Site Part 3 – Exporting the Lists Part 4 – Exporting the Site Columns and Content Types Part 5 – Wrap Up Before I begin with the wrap up portion of this post, I want to make a correction to this series. I was doing a bit of research today (quick comparisons, Joel Oleson’s take, deeper look at site definitions) on site templates, features, and site definitions and it struck me that the title of this series (Exporting a SharePoint Site into a Feature) isn’t ......

Exporting A SharePoint Site Into A Feature: Part 4 – Exporting Site Columns and Content Types

Part 1 – The Tools Part 2 - Exporting the Site Part 3 – Exporting the Lists Part 4 – Exporting the Site Columns and Content Types Part 5 – Wrap Up If nothing else, this blog post will win the award for longest title that I’ve written yet. Joking aside, It’s time to put one of the finishing stones in place for this series. So far we’ve exported the site and lists, now it’s time for the site columns and content types. The tool we’ll be using this go around is the Imtech Fields Explorer. The process ......

Exporting A SharePoint Site Into A Feature: Part 3 – Exporting the Lists

Part 1 – The Tools Part 2 - Exporting the Site Part 3 – Exporting the Lists Part 4 – Exporting the Site Columns and Content Types Part 5 – Wrap Up So let’s recap where we’re at with this series. Part 1 was about the tools I’ve been using to export a SharePoint site to a feature, part 2 exported the base (pages, web part settings on pages, etc) of the site template, and now part 3 will be exporting SharePoint lists into our feature. The tool we’ll be using time around is the MOSS Feature Generator ......

Exporting A SharePoint Site Into A Feature: Part 2 – Exporting the Site

Part 1 – The Tools Part 2 - Exporting the Site Part 3 – Exporting the Lists Part 4 – Exporting the Site Columns and Content Types Part 5 - Wrap Up Took a little longer to get to part 2 than expected with being gone last week on vacation and client work this week. Quick recap for everyone on what we’re trying to do here. Scenario would be that you’ve already built and customized a SharePoint site using the web UI (edit page, add web part, create list, create site columns, etc.) Now we want to be able ......

Exporting A SharePoint Site Into A Feature: Part 1 - The Tools

Part 1 – The Tools Part 2 - Exporting the Site Part 3 – Exporting the Lists Part 4 – Exporting the Site Columns and Content Types Part 5 – Wrap Up <Update>Please read the intro paragraph of part 5 for a correction relating to the title of this series. It should more appropriately be called something along the lines of “Exporting A SharePoint Site Definition and Features” but I’ll keep the original titling for now</Update> As I promised a blog post or two ago, I’ve been wanting to write ......

Implementing the AJAXControlToolkit AutoCompleteExtender inside SharePoint

<Foreword>For those looking for help integrating the AJAXControlToolkit with SharePoint check out this post: Integrating ASP.NET AJAX with SharePoint</Foreword> I’ve never been one to use JavaScript that much in my web development, partially because I haven’t had much training with it and partially because I usually work on heavy server side web applications. My current work project was well suited for some of the AJAXControlToolkit controls so I’ve been trying out other controls in the ......

“Cannot import this Web Part” Error with SharePoint Site Template

Generic error messages… SharePoint can sometimes be full of them. This morning I ran into the “Web Part Error:: Cannot import this Web Part” error (below) that I’ve seen many times before, but none of the usual fixes corrected it. The background story is that I’m developing a number of site templates that are pre-populated with security groups, lists, content types, and web parts for easy deployment of a custom application hosted on a SharePoint site. [As an aside, in the next week or so I’ll be ......

An Alternative for the Modal Popup in SharePoint 2007

This week I got to play with some of the controls in the AJAX Control Toolkit, specifically the Modal Popup Extender. I hadn’t gotten a chance to sink my teeth into anything AJAX so I was pretty excited to see what it offers. On my current project I’m building custom web parts for a SharePoint application being used on limited size screens (think 800x600). As such we need to be very resourceful with screen real estate and limit the number of page changes. The Modal Popup Extender sounded like a great ......

Presenting at COSPUG Show and Tell Event

On Friday, May 22nd the Central Ohio SharePoint User Group (COSPUG) is hosting a Show and Tell Event at the Microsoft office in Columbus. I’ll be presenting on combining PowerShell and SharePoint. This will be an introductory style presentation for those who have limited to medium experience with PowerShell and a few “laser show” type finale scripts to hopefully wow the crowd. With the current schedule I’ll be presenting during the last technical track session of the day. Shane Young from SharePoint911 ......

Deploy Files to SharePoint Web Application Virtual Directories At Feature Activation

Original: 2009/5/6 Updated: 2009/12/1 – see bottom Updated: 2009/12/31 – see bottom (Follow up post here) Have you ever had a need to deploy some files to all of the virtual directories (every IIS site folder corresponding to a zone in the web app) for a SharePoint web application feature? After searching the interwebs high and low I was unable to find any information relating to this topic, so this might very well be one of the first publicly available. I want to say that getting this to work yesterday ......

SharePoint Saturday Columbus 2011 Call for Speakers and Sponsors Is Open

Once again myself and a great group of individuals (Jennifer Mason, Sean McDonough, Nicola Young, and Michelle Caldwell) are organizing a SharePoint Saturday in Columbus, OH. The event will be on August 20, 2011 at the OCLC Conference Center, a fantastic venue that attendees (including speakers and sponsors) gave high praises on for last year’s event. Today we announced the opening of call for speakers and sponsors. If you are interested in speaking please fill out the speaker submission form (click ......

PowerShell Script To Display All SharePoint Site Collection Administrators In Web Application

In this post I present a script that will display all of the site collection administrators for a given web application. This script will work for SharePoint 2007 or 2010 as it uses the object model rather than the new SharePoint 2010 commandlets. Special thanks to Tasha Scott (Twitter) for posting a request for this script. It took less than 15 minutes to come up with and formalize. Solution The solution is fairly straight forward. First you grab a reference to a site collection. Get the web application ......

Guest Post: Instantiate SharePoint Workflow On Item Deleted

In this post, guest author Lucas Eduardo Silva will walk you through the steps of instantiating a workflow using an item event receiver from a custom list. The ItemDeleting event will require approval via the workflow. Foreword As you may have read recently, I injured my right hand and have had it in a cast for the past 3 weeks. Due to this I planned to reduce my blogging while my hand heals. As luck would have it, I was actually approached by someone who asked if they could be a guest author on ......

PowerShell Script To Find All Closed Web Parts On SharePoint Site

Are your SharePoint pages loading slowly because you have numerous closed web parts eating up valuable resources? Are you an admin tasked with tracking down those closed web parts? Recently my friend Brian Gough asked me a fairly simple question: “Is it possible to use PowerShell to find all ‘closed’ webparts in a site collection?” In this post I’ll show you a short PowerShell script that will identify all closed web parts on a site and it’s sub-sites. Solution The script below uses an advanced function ......

Slides, Scripts, and Photos from SPTechCon Boston 2010

A big thank you to everyone who attended my “Real-World Deployment of SharePoint 2010 Solutions” at SPTechCon Boston 2010 this week. I hope you learned some things and can take them back to improve your farms. This was my first time speaking at SPTechCon and second one attended. It was great to catch up with countless old friends I haven’t seen in awhile as well as meet new friends. I’m looking forward to speaking at SPTechCon San Francisco 2011 in Feb, so if you’re attending feel free to stop by ......

Announcing “Save PowerShell To SharePoint” CodePlex Project

In this post I will talk about a new script I wrote to save PowerShell ISE files to a versioned SharePoint document library as well as a side project I created on CodePlex to host this code and future releases. Background Recently I began listening to the PowerScripting Podcast and I’m slowly catching up on old podcasts. On episodes 121 and 122 (most recent ones I’ve listened to as of this writing) Hal and Jonathan talked about an idea that piqued my interest immediately: using SharePoint as a script ......

Slides and Scripts from BuckeyeSPUG August 2010 Presentation

This month I had the pleasure of presenting at the BuckeyeSPUG (formerly Central Ohio SPUG) meeting here in Columbus, OH. This is the first time I was the main presenter at our user group, having done small presentations along with other presenters in past meetings. The attendees had some great questions and hopefully learned some new tricks to use on their SharePoint 2007 farms. Thanks to everyone who came out. Below are the slides and demo scripts for those interested. Slides and Scripts: click ......

Speaking at SharePoint Saturday Columbus 2010 and User Group

This coming Saturday Aug 14th I will be speaking at SharePoint Saturday Columbus 2010 and next Thursday Aug 19th I will be speaking at the local Central Ohio SharePoint User Group (COSPUG) monthly meeting. If you’ve been following me lately you may have overheard that I’m the lead event coordinator for SharePoint Saturday Columbus. That alone has consumed almost all of my time for the past 3 months, even more so the last month. It has truly been a wild ride so far but the event is coming together ......

Central Ohio Day of .Net 2010 Slides and Files

This weekend I presented my “The Power of PowerShell + SharePoint 2007” session at the Central Ohio Day of .Net conference in Wilmington, OH. This is the second year I’ve attended this conference, first time as a presenter. For those unfamiliar Day of .Net conferences are a one-day conference on all things .NET organized by developers for developers. These events are usually offered at no cost to anyone interested in .NET development. The attendees of my session had some great questions and I hope ......

PowerShell Script To Find Instances Of Running SharePoint Workflow

This is a quick blog post for a fun PowerShell script I got to write today. My client asked me to make a listing of all instances of a particular workflow currently running on one of our SharePoint farms. Since we have dozens of SharePoint lists spread out across numerous sub-sites on this farm I decided to tackle the request with PowerShell. Here is a quick overview of what the scrip accomplishes. First I get a reference to the site collection in question. Next I get the workflow template from the ......

Speaking at SPTechCon Boston 2010

I’m happy to announce that I’ll be speaking at SPTechCon Boston 2010 this upcoming October 20-22. The presentation I will be giving is titled “Real World Deployment of SharePoint 2007 Solutions” and below is the session abstract. I’m very excited to be speaking at SPTechCon Boston as I attended and live blogged the recent SPTechCon San Francisco this past Feb (link here to recap of that event) and was impressed with all of the people and content I was exposed to. If you have a chance to attend SPTechCon ......

You Can’t Upload An Empty File To SharePoint 2007 Or SharePoint 2010

The title of this post is pretty self explanatory, but I thought it worth mentioning since I had never run across this rule until just recently. A few weeks ago I was testing out a new workflow attached to a SharePoint 2007 document library. I uploaded various file types to ensure all were handled properly. One of the files I happened to test with was an empty .txt file to which I got the following error. As you can see from the error message you aren’t allowed to upload a file that is empty. Fast ......

Error Using 32 vs. 64 bit SharePoint 2007 DLLs with PowerShell

Next time you fire up PowerShell to work with the SharePoint API make sure you launch the proper bit version of PowerShell. Last week I had an interesting error that led to this blog post. Travel back in time a little bit with me to see where this 32 vs. 64 bit debate started. History Ever since the first pre-beta bits of Office 2010 landed in my lap I have been questioning whether it’s better to run 32 or 64 bit applications on a 64 bit host operating system. In relation to Office 2010 I heard a ......

SharePoint Saturday DC 2010 Slides, Demo Scripts, and Pictures

Wow! This past weekend I attended SharePoint Saturday Washington DC (SPSDC) which was quite an event to say the least. For those unfamiliar, SharePoint Saturday is a community driven event where various speakers gather to present at a FREE conference on all topics related to SharePoint. This made my fifth SharePoint Saturday attended and fourth I’ve spoken at. SPSDC was a bit different than most SharePoint Saturdays mostly due to the scale of it. We had almost 950 attendees, over 80 speakers presenting ......

Enumerating SharePoint Site Templates for Site Collection with PowerShell

As part of my automated deployment post last week, one step of my deployment script called for creating a SharePoint site collection using the “STSADM –o createsite” command with the –sitetemplate option used for a specific site template. If you have never had to create a site collection from a template at the command line you may not know what to put (or know what is available to you) for the –sitetemplate option. To remedy this I created a very simple PowerShell script that opens a site collection ......

Lessons Learned from Automating a SharePoint Deployment

Now this is a topic that really excites me. It combines two things I love: automation and SharePoint. At my current client we are in the process of moving our custom SharePoint applications to the production environment. As we are moving to production, that means that we develops have less handle on the implementations be they databases, code migration, etc. To ease the load on the infrastructure team who is implementing our custom application I took the liberty of automating as much of the process ......

Be Careful When Referencing SPList.Items

Be very careful how you reference your SPListItem objects through the SharePoint API. I’ll say it again. Be very careful how you reference your SPListItem objects through the SharePoint API. Ok, now that you get the point that this will be a “learn from my mistakes and don’t do unsmart things like I did” post, let’s dig into what it was that I did poorly. Scenario For the past year I’ve been building custom .Net applications that are hosted through SharePoint. These application involve a number of ......

Full SharePoint Archive