by spjeff

NEW CodePlex project – SPUpgradeHelper

October 28, 2014 by spjeff

Today I am happy to announce https://spupgradehelper.codeplex.com/ is available for download.   This project aims to smooth the “double hop” upgrade from MOSS 2007 to SP2010 to SP 2013 by reading a CSV of database targets and automating the Cmdlets needed for a consistency, repeatable, high quality, and fast process.   Please leave a comment here or on CodePlex if you found this helpful.  Cheers!  shades_smile

 

Project Description

Migrating MOSS 2007 to SP 2013? This script takes a CSV of databases and runs upgrade Cmdlets in bulk (DB version/Mount/Dismount/Upgrade-SPSite/Claims auth)

Upgrading MOSS to SP2013 is a tedious process with many Cmdlets, especially if you have many databases. This script aims to help automate that process.

Given a CSV with SQL instance and content database names, this script offers Cmdlets to run upgrade steps across many databases all at once. No more TXT or XLS copy and paste madness. Simply populate the CSV, get familiar with UH* Cmdlets and upgrade with ease.

Key Features

  • Read CSV of databases
  • Load helper functions into memory
  • Enable admin to more easily run Cmdlets in bulk
  • Measure time duration for each step (# minutes)
  • Provide detailed LOG file of actions, result, and duration

Quick Start Guide

  • Extract “SPUpgradeHelper.ZIP” to any SharePoint machine in your farm
  • Run “SPUpgradeHelper.ps1″ to load helper functions
  • Type in full path to your CSV file (i.e. “C:\TEMP\COLLAB.CSV”)

Function Names

  • UHCIaims – execute SPWebApplication function to upgrade Classic to Claims auth
  • UHCompatibiIity – execute Get-SPSite for “set” of databases to show GUI version (14/15)
  • UHDBVersion – execute TSQL for “set” of databases to show build number (12.0, 14.0, 15.0)
  • UHDismount – execute DisMount-SPContentDatabase for “set” of databases
  • UHMount – execute Mount-SPContentDatabase for “set” of databases
  • UHReadCSV – load CSV file into memory with upgrade “set”, SQL instance, and database names
  • UHUpgrade – execute Upgrade-SPSite for “set” of databases

Microsoft Upgrade Process

by spjeff

WebAPI OData – 10 min video introduction (Visual Studio 2013)

October 14, 2014 by spjeff

I’ve been learning about OData and wanted to record a quick getting started video with how to create a new WebAPI project, add OData Controller, and send HTTP CRUD operations.  Below is an example using Adventure Works Departments with sample code, screenshots, and a 10 minute video introduction.   Please leave a comment if you found this helpful.  Thanks!  shades_smile

Video Content

  • Create MVC 4 web application
  • SQL Express – Adventure Works Departments
  • Add “AdventureWorks.edmx
    • Wizard driven
    • F4 set namespace
  • Add “DepartmentsController.cs
    • Create from EDMX class
    • Implements ODataController
    • Replace ID with KEY
  • Edit “WebApiConfig.cs
    • Comment out default route
    • Add OData route builder
  • Test with HTTP manually
  • Test with Chrome REST Postman
  • SQL Express – see changed data

Watch Video

WebAPI OData – 10 min video introduction (Visual Studio 2013) from Jeff Jones on Vimeo.

Sample Code

[WebApiConfig.cs]

 

[DepartmentsController.cs]

Downloads

Screenshots

image

image

image

image

image

by spjeff

PowerMap – 6 min video introduction (Excel 2013)

October 11, 2014 by spjeff

I heard a lot about PowerMap and wanted to record a quick getting started video with how to download, screenshots, and play a sample XLSX workbook.  

Background

The “Power” family of Business Intelligence features is getting a lot of attention at conferences, SharePoint Saturday, Channel 9, and social media.   Personally I hadn’t worked hands-on with the features before.   The idea is simple and practical – everyone uses Excel for data, so why not leverage that as the BI design surface?

Video Content

  • PowerMap screenshots
  • Download PowerMap EXE for Excel 2013
  • Download sample XLS PowerMap workbooks
  • How to play the Chicago sample XLSX

If you found it helpful please leave a comment below.  Enjoy!  shades_smile

Downloads

 

Watch Video

PowerMap – 6 min video introduction (Excel 2013) from Jeff Jones on Vimeo.

Screenshots

image

image

image

image

image

image

image

image

Return to Top ▲Return to Top ▲