Exploring SharePoint Export

I’m currently working with a client for whom I’m upgrading their mixed 2007 and 2010 farm to SharePoint 2013.  Unfortunately, a site collection on a SharePoint 2007 farm they no longer have access to was exported instead of backed up.  What makes matters worse, whoever performed the export, expanded the .cmp file.  My client wanted the files from export.

While there are a few sites that give instructions on how to perform imports (like, here, here and here), as anyone who has worked with SharePoint 2007, it can be very finicky – everything, including the stars, must line up.  I also tried “re-compressing” the export file since the .cmp file is nothing more than a .cab file.  However, I had additional issues with the resulting .cab file since we were dealing with a 7GB file on a Windows 2003 machine (they don’t play nicely together).  I also tried using a tool from Mike Smith to convert the files from the export file.  But, being that Mike hadn’t worked on the solution since many years ago, of course, the application was giving me cryptic exception errors.

After all failed attempts, I was finally required to write a PowerShell script that reads the Manifest.xml and converts all of the .dat files to their original filenames in the original SharePoint 2007 file structure.  I’ve posted the PowerShell script on GitHub.

Have fun!


Windows Server 2012 WDS Capture Image - winload.exe corrupt or missing

The other day I was setting up a new Windows Deployment Services image for a TFS/SharePoint Hyper-V environment.  The host machine was running Windows Server 2012 R2.  Per the normal process, I imported the Install.wim and Boot.wim images from the Windows Server 2012 media to my Install Images and Boot Images folders, respectively, in WDS.  This process operated as expected and were imported successfully.

I, then, needed to create a capture image in order to capture my Windows Server 2012 images for redeployment.  Therefore, I right-clicked on the Boot.wim image in Windows Deployment Services and clicked on “Create Capture Image…” to create my capture image.  The capture image was created successfully, or so I thought…Read more


AjaxOnly Attribute for MVC Actions

Ever wanted to restrict actions to only responding to Ajax requests?  How about restricting them through the use of a custom attribute?

Read more


'Hello World' with Node.js and Visual Studio Code

As I’ve shared in other posts, I like trying new things. One new thing I’ve been working with over the past couple of weeks is Visual Studio Code (VSC) – a lightweight editor from Microsoft that recognizes and offers IntelliSense for many different file formats. Unlike the commercial or even community editions of Visual Studio, VSC is not solution- or project-based. Instead, VSC is based on directory structures.

For those of you interested in building native JavaScript applications using Node.js, I wanted to provide a demo in how to accomplish this using Visual Studio Code. While full versions of Visual Studio do support Node.js applications, it can sometimes be overkill, especially if you’re not needing pre-compiled libraries based on the .NET Framework (VSC does support referencing external libraries and compilation with MSBuild, but then we get into the discussion of should we use VSC vs. Visual Studio, which is not the point of this blog post). Again, the demonstration below is to assist you as you look to build native JavaScript applications.
Read more


R with Visual Studio Code

I always love to learn new things. Right now, I’m experimenting with R and statistical computing. Additionally, I’m playing around with the new lightweight development environment from Microsoft, Visual Studio Code.  So, this is a post that demonstrates setting up Visual Studio Code to run R applications.Read more


Automation Testing with SeleniumHQ

In an earlier post, I provided step-by-step instructions in how to perform Behavior Driven Development using Visual Studio, SpecFlow, WatiN and DryRunner.  However, I’ve had a lot of students and blog readers ask me about Selenium, a more-common browser automation tool.  So, I’m writing this post to show how to accomplish BDD and automated test driven development (ATDD) using Selenium.Read more


Behavior Driven Development with SpecFlow + WatiN + DryRunner

In the previous post, we examined some of the principles behind BDD.  If you read it, I’m sure you’re thinking, “Wow! That’s great! But, how do I accomplish this in Visual Studio?”  There are a myriad of posts on the Internet that demonstrate different components.  However, there’s not really a single post with all of the information compiled.  For that reason, I’m going to provide a step-by-step tutorial on how to perform BDD with Visual Studio. Additionally, I will show you how to perform automated testing using your Gherkin scripts.

Read more


Behavior Driven Development Principles

According to AgileAlliance.org:

BDD (Behavior Driven Development) is a synthesis and refinement of practices stemming from TDD (Test Driven Development) and ATDD (Acceptance Test Driven Development).

That’s great, but what does that really mean?

BDD has its roots in TDD, but supersedes TDD in the agile development process.  BDD recognizes that User Stories are the framework for the development process and that these stories determine the necessary tasks required to satisfy given business requirements.  Read more


Moving Hyper-V to Azure

This past week I needed to move a client’s Hyper-V machine to a Windows Azure VM.  If you haven’t figured it out already, the process isn’t as straightforward as one may hope – especially, since there’s a rather large chasm between the new and old Azure management portals as neither offer an entire end-to-end solution.  As with most things Microsoft nowadays, PowerShell seems to be the best solution for truly accomplishing your needs.

Below, you’ll find a resource for tackling all of the different components of moving a Hyper-V VM to Azure.  There are some ways to do parts of this through the various GUI’s, but, again, none of the GUI’s offer a complete solution.

Read more


Using OLEDB with SQL Native Client

This week, while moving a client’s VM to Windows Azure, I was also required to upgrade their database from SQL 2005 to SQL Azure.  While not extremely difficult, there were a few gotcha’s along the way.  These “gotacha’s” were primarily features that had been deprecated.  Those deprecated features aren’t the purpose of blog post, however.  This post is addressing a connection string issue.

Read more