Shai Raiten's Blog : Tools

Visual Source Safe Upgrade Tool for Team Foundation Server

shair — Sun, 11 Nov 2012 13:54:04 GMT

If for some reason you or your company is still using VSS it’s time to move forward!

Team Foundation server supports VSS Migration, until today there were a command line tool allowing you to migrate VSS repository to TFS Source Control – this tool is called – VSSConverter.

VSSConverter command line tool requires configuration file that need manual authoring, but no More!

Microsoft has announce a new wizard based UI tool for upgrading VSS repositories to Team Foundation Server 2012/2010.

Open the tool and start the upgrade, choose VSS local repository.

Specify TFS Team Project destination.

Upgrade type, some VSS are very old and sometimes you don’t want to upgrade the entire VSS history.

Result

Download - Visual Source Safe Upgrade Tool for Team Foundation Server

Enjoy

Copy Source As Html-Visual Studio 11

shair — Wed, 11 Apr 2012 01:21:00 GMT

TFS API Part 43–Delete Work Item Tool

shair — Fri, 06 Apr 2012 17:28:00 GMT

SharePoint API – Download \ Upload Documents (Tool)

shair — Thu, 27 Oct 2011 13:03:00 GMT

A long time ago I wrote about SharePoint 2007 Files Restore Tool, tool that allows you to connect to SharePoint content database (not need to have SharePoint installation) and extract documents.

The reason I wrote this tool was a customer that upgrade TFS and perform a new installation of SharePoint so he lost all his documents, this tool helped me to extract all documents and added them to the new SharePoint site.

SharePoint upgrade/migration can be unpleasant and sometimes I prefer to do a clean installation when upgrading or moving TFS and then just import the documents (without history).
Some customers wants to keep the history, so you can do small changes to download all file versions and then upload each version.

The big questions is how to extract all SharePoint documents from existing Site?

So, I’ve built another tool to help me do that, the below tool will connect to SharePoint using API and download all documents includes Folder structure to my computer.

Because I’m using SharePoint API you can write any Url of the SharePoint site, I’ll show the all documents folders includes files under each folder, and then you can click the download button to download all files or specific files to your machine.

How To Connect SharePoint Site:

* SharePoint API will only work on Machine with SharePoint installed *

public SPWeb _sp;
public void Connect()
{
    try
    {

        using (SPSite site = new SPSite(txtSPUrl.Text))
        {

            TreeFolders.Items.Clear();
            var webTree = new TreeViewItem();
            webTree.Header = _sp.Title;
            webTree.Tag = _sp;
 
            MapFolders(_sp.Folders, webTree);
        }
    }
    catch (Exception ex)
    {
        throw new ArgumentException("Connect", ex);
    }
}

Building Folder Structure

I’ve created a recursive method to get the total number of files under a specific folder include all sub folders.

private int GetFilesCount(SPFolder folder, int count)
{
    count += folder.Files.Count;
    return folder.SubFolders.Aggregate(count, (current, subfolder) => 
           GetFilesCount(subfolder, current));
}
 
private void MapFolders(SPFolderCollection folderList,
                                             TreeViewItem treeNode)
{
    for (var i = 0; i < folderList.Count; i++)
    {
        var item = new TreeViewItem();
        item.Header = string.Format("{0} ({1})", folderList[i].Name,
                                     GetFilesCount(folderList[i], 0));
        item.Tag = folderList[i];
 
        treeNode.Items.Add(item);
 
        if (folderList[i].SubFolders.Count > 0)
            MapFolders(folderList[i].SubFolders, item);
    }
}

Download Files From SharePoint Folder

The CreateDirectoryStructure will build the local folder structure based on the file path in SharePoint, this is important because once we want to upload those files to a new SharePoint site we need those folder names in order to create them in the new SharePoint site.

Each SPFolder object contains a SPFileCollection with all files under that folder – Not include SubFolder files.

DownloadFile – will run over all files, get each file binary data and save the stream to a local file.

private void DownloadFile(SPFileCollection files)
{
    foreach (SPFile file in files)
    {
        if (CreateDirectoryStructure(txtLocalPath.Text, file.Url))
        {
           var filepath = System.IO.Path.Combine(txtLocalPath.Text,
                                                 file.Url);
           byte[] binFile = file.OpenBinary();
           System.IO.FileStream fstream = System.IO.File.Create(filepath);
           fstream.Write(binFile, 0, binFile.Length);
           fstream.Close();
        }
        else
           throw new ArgumentException("Cannot Create Folders Structure");
    }
}
 
private bool CreateDirectoryStructure(string baseFolder, string filepath)
{
    if (!Directory.Exists(baseFolder)) return false;
 
    var paths = filepath.Split('/');
 
    for (var i = 0; i < paths.Length - 1; i++)
    {
        baseFolder = System.IO.Path.Combine(baseFolder, paths[i]);
        Directory.CreateDirectory(baseFolder);
    }
    return true;
}

Upload File To SharePoint Site

Once you got all files from the Old SharePoint site you can enter the new SharePoint site url and click the Upload button.

private void btnUpload_Click(object sender, RoutedEventArgs e)
{
    using (SPSite site = new SPSite(txtTargetSP.Text))
    {
        SPWeb targetSP = site.OpenWeb();
        foreach (var file in listLocalFolders.Items.Cast<string>().Select
                (folder => Directory.GetFiles(folder, "*.*", 
                 SearchOption.AllDirectories)).SelectMany(files => files))
        {
            UploadFile(file, file.Replace(txtLocalPath.Text, string.Empty)
                       , targetSP);
        }
    }
}

Removing the local path from the full file path will result with the destination file to the new SharePoint site.

The propose of EnsureParentFolder is to ensure the destination folder in the new SharePoint site exists, and if not create the folder in the new site.

UploadFile will stream out the file content and using SPWeb.Files.Add method include the destination path will add a new file to the SharePoint site.

public string EnsureParentFolder(SPWeb parentSite, string destinUrl)
{
    destinUrl = parentSite.GetFile(destinUrl).Url;
 
    var index = destinUrl.LastIndexOf("/");
    var parentFolderUrl = string.Empty;
 
    if (index > -1)
    {
        parentFolderUrl = destinUrl.Substring(0, index);
        SPFolder parentFolder
            = parentSite.GetFolder(parentFolderUrl);
 
        if (!parentFolder.Exists)
        {
            SPFolder currentFolder = parentFolderUrl.Split('/').
            Aggregate<string, SPFolder>(parentSite.RootFolder, 
           (current, folder) => current.SubFolders.Add(folder));
        }
    }
    return parentFolderUrl;
}
 
public void UploadFile(string srcUrl, string destUrl, SPWeb site)
{
    if (!File.Exists(srcUrl))
    {
        throw new ArgumentException(String.Format("{0} does not exist",
            srcUrl), "srcUrl");
    }
 
    var fStream = File.OpenRead(srcUrl);
    var contents = new byte[fStream.Length];
    fStream.Read(contents, 0, (int)fStream.Length);
    fStream.Close();
 
    if (destUrl.StartsWith("\\"))
        destUrl = destUrl.Substring(1);
 
    destUrl = destUrl.Replace("\\", "/");
 
 
    EnsureParentFolder(site, destUrl);
 
    try
    {
        site.Files.Add(destUrl, contents, true);
    }
    catch (Exception ex)
    {
    }
}

Enjoy

JavaScript YouTube Download Tool

shair — Sun, 23 Oct 2011 22:04:00 GMT

Sometimes I want to download a YouTube video, and yes there are plenty of tools on the web to help you doing that, but I really want something that doesn't require installation each time I want to download a YouTube video.

So, I’ve decided to write some pure (don’t want to download JQuery or any other library) JavaScript to help me do that, this script will work locally and you only need to open the html file on your machine.

Download YouTube Download Html (Right Click and Save)

I’ve add a Text input called “txtUrl” that gets a YouTube video Uri for example: http://www.youtube.com/watch?v=t4H_Zoh7G5A

Once you click the “Download Tube” button the GetTubeSource will be invoked and using a basic Ajax call to receive YouTube Uri html response.

function GetTubeSource() {            
    var uri = document.getElementById("txtUrl").value;
  
    var xmlhttp;
    if (window.XMLHttpRequest) {
        xmlhttp = new XMLHttpRequest();
    }
    else {// code for IE6, IE5
        xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
    }
    xmlhttp.onreadystatechange = function () {
        if (xmlhttp.readyState == 4 && xmlhttp.status == 200) {
            ParseResponse(xmlhttp.responseText);
        }
    }
    xmlhttp.open("GET", uri, true);
    xmlhttp.send();
}

After we get's the response we pass it to “ParseResponse” method that parse the response and extract the “url_encoded_fmt_stream_map” value and some other values needed in order to download the YouTube video.

I’ve also added the “window.clipboardData.setData” to copy the Download Uri to your Clip Board, you can remove this line if you don’t want too.

function ParseResponse(res) {
 try {
     response = res;
      var mp = "id=\"movie_player\"";
      var s1 = response.indexOf(mp);
      var s2;
      if (navigator.appVersion.match("MSIE") != null) {
          var paramflash = "name=\"flashvars\" value=\"";
          s2 = response.indexOf(paramflash, s1) + paramflash.length;
      }
      else {
          var flashvar = "flashvars=";
          s2 = response.indexOf(flashvar, s1) + flashvar.length;
      }
 
      var end = response.indexOf("\"", s2);
      var str = response.substring(s2, end);
 
      w = str.split("&amp;");
 
      for (i = 0; i <= w.length - 1; i++)
          if (w[i].split("=")[0] == "url_encoded_fmt_stream_map") {
              links = unescape(w[i].split("=")[1]);
              break;
          }
      abc = links.split(",url="); for (i = 0; i <= abc.length - 1; i++){
      fmt = abc[i].split("|")[0];
      if ((fmt.indexOf("flv") > 0) && (fmt.indexOf("large") <= 0) 
           && (fmt.indexOf("medium") <= 0)) {
           if (fmt.indexOf("rl=") > 0) {
              url = fmt.substring(4, fmt.indexOf("fallback_host") - 1);
              url = unescape(unescape(url));
              break;
            }
            else {
              url = fmt.substring(0, fmt.indexOf("fallback_host") - 1);
              url = unescape(unescape(url)); break;
            }
          }
        }
        combineurl = url + '&title=' + GetTubeTitle();
       window.clipboardData.setData('Text', combineurl);
        window.location.href = combineurl;
    }
    catch (ex) {
        alert(ex.Message);
    }
    finally {
        EnableForm();
    }
}

There are several simple methods to get data from the response like the video title

function GetTubeTitle() {
    try {
        var sT = "<meta name=\"title\" content=\"";
        var s = response.indexOf(sT) + sT.length;
        var e = response.indexOf("\"", s);
 
        var title = response.substring(s, e);
        if (title.match(".$"))
            title = title.substring(0, title.length - 1);
 
        return title;
    }
    catch (ex) {
        return "";
    }
}

Download YouTube Download Html (Right Click and Save)

Windows Azure Toolkit for Windows Phone 7/iOS/Android

shair — Tue, 10 May 2011 13:26:14 GMT

S. Somasegar just blog about Bringing Windows Azure to more devices

Windows Azure Toolkit for Windows Phone 7

The Windows Azure Toolkit for Windows Phone 7 is designed to make it easier for you to build mobile applications that leverage cloud services running in Windows Azure. The toolkit includes Visual Studio project templates for Windows Phone 7 and Windows Azure, class libraries optimized for use on the phone, sample applications, and documentation.

Windows Azure Toolkit for iOS

Released today, the Windows Azure Toolkit for iOS is designed to help developers targeting iOS to use Windows Azure services. It includes an open source Objective-C library to interface with Windows Azure services, documentation, and a sample application using the library. You can download the samples and documentation from github, along with the library and its source, or learn more about the details.

Windows Azure Toolkit for Android

Android developers will have their own version of the toolkit available in preview form later this summer.

Full Article

Metro Style Now Available For Download

shair — Fri, 29 Apr 2011 23:30:21 GMT

Metro Style Now Available For Download

Couple of weeks ago I post about a new tool I’ve built Test Case Migrator Between Projects – WPF Metro, I gave this tool couple of Design Hours based on Microsoft Metro Style (Not Out Yet…).

Since than I got lots of requests to publish this Style and also I got lots of compliments so here it is!

App.xaml

Full Project

Build folders for Team Explorer

shair — Sat, 02 Apr 2011 15:38:00 GMT

Build folders for Team Explorer

Terje Sandstrøm is a VS ALM MVP from Inmeta, couple of months ago his team built a cool extension for Team Explorer that creates Build Folders based on naming convention, all you need to do is change your Build Definition name to contain “.”, people who don’t have the tool installed just see build definitions with “.”s in the name and everything keeps working.

Brian Harry also wrote about this tool - http://blogs.msdn.com/b/bharry/archive/2011/04/01/build-folders.aspx

The binary is available through Code gallery now, at http://visualstudiogallery.msdn.microsoft.com/35daa606-4917-43c4-98ab-38632d9dbd45

Enjoy

VS Setup Project Will Not Ship With Future Versions of VS

shair — Sat, 19 Mar 2011 18:43:03 GMT

VS Setup Project Will Not Ship With Future Versions of VS

In the past I wrote about Visual Studio Setup Project and how you use it for your software deployment - Extending Visual Studio Setup Project

But now Microsoft decide to remove the support from VS Setup Project and invest more in WiX.

Buck Hodges
“Future versions of Visual Studio will not include the Visual Studio Installer project templates.
To preserve existing customer investments in Visual Studio Installer projects, Microsoft will continue to support the Visual Studio Installer projects that shipped with Visual Studio 2010 per the product life-cycle strategy.”

So if you are using VS Setup Project you still have couple of year to use it but start think about moving to WiX.

Power Tools for Microsoft VS 2010 users – Innovative software that saves time and money

shair — Mon, 14 Mar 2011 13:28:22 GMT

Power Tools for Microsoft VS 2010 users – Innovative software that saves time and money

Sela Technology Center is proud to announce the release of our unique software development productivity power tools for the Microsoft ALM environment:

SCRAT, WTM and WIMBI.
All products are well proven and based on our deep understanding of client requirements for Development and Testing activities using Microsoft VS 2010.

About SCRAT - MIGRATION: SCRAT tool enables the most time efficient and cost effective migration process from HP Quality Center to Microsoft TFS on the market today. Read More…

Download Trial Version

About WTM - TESTING: Web Test Manager (WTM) is the only tool that enables to test with TFS 2010 directly from the browser. Now, for the first time you can manage your tests without the need for any local installation. WTM is a web application integrated in VS 2010 Team Web Access™. Read More…

Download Trial Version

About WIMBI - CUSTOMIZATION: WIMBI is the only tool that enables you to manage versions using logical entities instead of physical files on VS 2010. Read More…

Information you need:

Testimonials for SCRAT

"If you are looking at adopting TFS and need to look at moving some or all of your QC assets into TFS, SCRAT is definitely worth a look." - Brian Harry / Technical Fellow, Team Foundation Server, Microsoft Corporation Read More…
"Working with the SCRAT tool really helped us a lot. It made my job as project manager of the migration project from HP QC to TFS 2010 a lot easier. Scrat migration has little risk, can be timed, budgeted and scoped well." - Benjamin De Leeuw / Project Manager, SdWorkx Read More…
"We are very satisfied with the tool and will be happy to use it in the future." - Ronen Ashkenazi / Services Director, Microsoft Israel

Windows Phone 7 – The First Fart Application

shair — Mon, 26 Jul 2010 20:27:00 GMT

Windows Phone 7 – The First Fart Application

Yes I know, Farting isn’t nice… But each and every mobile phone on the planet has a Fart Application (Don’t ask me why!), So as a Fan of Phone 7 (In theory, still waiting to actually feel it…) I decide there is no way Microsoft Phone 7 will be without a decent Fart Application. (Fartless… :-))

So I built a simple Phone 7 Application called – Fart With 7 or Fart7 (Picture from the right) –>

Just download the zip file, extract it and run it from Visual Studio 2010, if this your first time using Phone 7 application please read Tomer Shamam post Programming Windows Phone 7 LOB Applications – Part I, there is a very good guide on what you need to install in order to Run Phone 7 Emulator on your machine.

If you want to built your own Phone 7 Application:

Download Fart 7 Application

Enjoy

TFS API Part 28 - Test Suite Hierarchy Builder

shair — Mon, 26 Jul 2010 12:51:49 GMT

TFS API Part 28 -Test Suite Hierarchy Builder

In my previous post regarding TFS API TFS API Part 27 – Test Plans, Test Suites, Test Cases Mapping, I showed how to create and obtain Test Plans, Test Suite and Test Cases objects.

As part of Quality Center to TFS 2010 Migration Tool I’m translating Quality Center hierarchy into Areas in TFS 2010 -

as you can see from the following pictures the QC hierarchy(middle picture) looks the same as TFS Areas (left picture) but it’s not feels the same…
Feels the same? when using QC you can navigate using the Tree View and drill down to the Test Suite (Folder) you want, to accomplish those actions in TFS you will have to write a Query and each time change the query values, Ammm… it’s not a good solution –
But using Microsoft Test Manager you can create Test Suites and Requirements with the same hierarchy as QC. (right picture)

In order to create those hierarchies quickly in TFS I built a tool just for that, this tool is using the following articles to complete this task.

The tool is very simple – Connect to TFS 2010, Create or Select Test Plan, Select Areas (One or more) and click start.

This action will take couple of minutes and in the end you will have full hierarchy in MTM based on the structure of the Areas in you project and the Test Cases assigned under each Area.

The result will be inside the Test Plan you picked before and all the Test Suite will be based on the Area Paths in the current Team Project.

Under each Test Suite you should see the related Test Cases.

Download Tool

Code Example:

Download Source Code

/// <summary>
/// Get's a full path of Area, split it and for each part create Test Suite and apply the Test Cases beneath it.
/// </summary>
/// <param name="full_area">Area Path, for example - CMMI\First Area\Sub Area\Content Area</param>
void CreateTestSuite(string full_area)
{
    try
    {
        string[] areas = full_area.Split('\\');
        string full_path = string.Empty;
        IStaticTestSuite suite = null;
        string current_area = string.Empty;
 
        for (int i = 0; i < areas.Length; i++)
        {
            if (!string.IsNullOrEmpty(areas[i]))
            {
                string area = areas[i].RemoveBadChars();
                current_area += area;
 
                //The first item, find it and assigned to suite object.
                if (i == 1)
                {
                    ITestSuiteEntryCollection collection = _plan.RootSuite.Entries;
                    suite = TestHelper.FindSuite(collection, area);
                    if (suite.Id == 0)
                    {
                        suite.Title = area;
                        TestHelper.AddTests(suite, current_area);
                        _plan.RootSuite.Entries.Add(suite);
                    }
                }
                else
                {
                    ITestSuiteEntryCollection collection = suite.Entries;
                    //* collection - Perform search only under the suite.Entries  - Duplicate items allowed. 
                    IStaticTestSuite subSuite = TestHelper.FindSuite(collection, area);
 
                    if (subSuite.Id == 0)
                    {//Cannot find Test Suite
                        subSuite.Title = area;
                        suite.Entries.Add(subSuite);
                        //After creating the Test Suite - Add the related TestCases based on the Area Path.
                        TestHelper.AddTests(subSuite, current_area);
                    }
 
                    suite = subSuite;
                }
                current_area += "\\";
                _plan.Save();
            }
        }
        _plan.Save();
    }
    catch (TestSuiteInvalidOperationException testex)
    {
        if (!testex.Message.Contains("Duplicate suite name detected"))
            throw new ArgumentNullException(testex.Message);
    }
}

TestSuiteHelper contains couple of simple actions like AddTests - that perform a Query in TFS to find all Test Cases under specific area path, also FindSuite as a recursive search under each suite (Recursive search because Suite doesn't have unique names so this should be individual search for each Suite).

public class TestSuiteHelper
{
    private ITestManagementTeamProject _testproject;
    private Project _project;

    public TestSuiteHelper(ITestManagementTeamProject TestManagementTeamProject, Project project)
    {
        this._testproject = TestManagementTeamProject;
        this._project = project;
    }

    public void AddTests(IStaticTestSuite suite, string area)
    {
        IEnumerable<ITestCase> testcases = _testproject.TestCases.Query(string.Format("Select * from [WorkItems] where [System.AreaPath] = \"{0}\\{1}\"", _project.Name, area));

        foreach (ITestCase testcase in testcases)
        {
            suite.Entries.Add(testcase);
        }
    }

    public IStaticTestSuite FindSuite(ITestSuiteEntryCollection collection, string title)
    {
        foreach (ITestSuiteEntry entry in collection)
        {
            IStaticTestSuite suite = entry.TestSuite as IStaticTestSuite;

            if (suite != null)
            {
                if (suite.Title == title)
                    return suite;
                else if (suite.Entries.Count > 0)
                    FindSuite(suite.Entries, title);
            }
        }
        return _testproject.TestSuites.CreateStatic();
    }
}

Download Tool
Download Source Code

Test Scribe – Automatic Document Generating For Test Manager 2010

shair — Mon, 26 Jul 2010 12:07:22 GMT

Test Scribe – Automatic Document Generating For Test Manager 2010

I got this question from lots of customers – How can I export Test Cases, Test Plans to a word document?

As you know Test Manager 2010 allows you to manage the entire Test Suite in one Tool, but for some customer installing Test Manager on every computer isn’t possible – For example – performing Tests on Linux…

One more reason is the ability to send the tests to the customer, so he can perform in house testing.

I’ve already saw couple of consultants building their own tools to complete this task – There is No Need to write it your self!!!

Test Scribe is a tool created by VSTS Quality Tools for generating documentation about TCM (Test Case Management) artifacts.
Testers can use a stand-alone client to connect to a TFS 2010 server/project.
With a Test Plan selected, users are able to generate a Test Plan Document, including information about the plan, the suite hierarchy, and each test case contained in the suites.

First Download Test Scribe and open Microsoft Test Manager, click on the main tab (Where “Testing Center”) and click on “Tools”.

Than you can choose what type of Document you want to generate:

Test Plan Summary
Test Run Summary

In my example I choose “Test Plan Summary” and to generate the Word Document just click - Generate

And the result is: