Compartilhar via

How to bulk import Test Cases into Visual Studio Online

  • Artigo

A customer of mine didn’t want to renew their license with Quality Centre as all of their requirements were in TFS and the business were planning iterations there; but their test cases were not linked up with those requirements.

Here is a step-by-step guide on how to easily move your Test Cases from QC into TFS. This does not take attachments and is a one way migration.

Step 1: Go to your Team Project and click the ‘TEST’ tab at the far right. Please bear in mind that new features are added at the end, so by the time you read this it may not be the last item!

image

You will be presented with some guidance that you can only create test cases in a test plan.

Step 2: Here you will have to give the Test Plan a name to group these test cases with. You will notice that my area path is called ‘Scrum’, this is because this is test Team Project called scrum using the Scrum Process Template. You can change this to any existing team (area path) you require. You can also chose the iteration that these tests will be created in. The wizard will chose the current sprint for you. However, because I am migrating my regression test scripts in, I am going to create these at a Release level and not a sprint level.

image

Step 3: Look at your export from Quality Centre in your Excel file and tidy it up so that it is in a 3 column format, like so

image

Step 4: Go to the Grid View in Visual Studio Online. Change List to Grid

image

Step 5: You should now be able to paste your spread sheet into the grid – don’t copy the headings!

image

Any formatting in the columns, other than multiline, will not be copied into the worksheet. After you click the ‘Save’ icon, TFS will generate you some work item Id’s. Notice that TFS has greyed out some cells as these are not editable anymore in this context. You can add test step actions and you can do simple formatting of the cell like bold and italic.

Have a play!

Comments

  • Anonymous
    June 25, 2015
    Will the publish option from within excel work, e.g. Make a query with the proper columns, connect to TFS, then paste QC tests into Excel and publish?  I noticed in your image above you didn't have a TEAM tab which is required for this idea.

  • Anonymous
    October 22, 2015
    This doesn't work as of today.

  • Anonymous
    December 15, 2015
    Rows must be pasted one at a time. Bulk pasting opens a "The data you're pasting isn't the same size as your selection." alert message. Extremely disappointing.

    • Anonymous
      June 28, 2016
      I know this is late for the poster, but if you see the below error, you may be showing more columns in either the source or the target grid you are copying or pasting to! "The data you're pasting isn't the same size as your selection."

  • Anonymous
    January 10, 2016
    @rac5869 - Have you copied just the cells that you need or the whole worksheet? Also what browser are you using so I can try and replicate. You should be able to copy multiple rows

  • Anonymous
    September 20, 2016
    There seems to have a limit on the number of rows that can be pasted. I'm not able to paste 1000 rows at once.

  • Anonymous
    November 20, 2016
    Thaks for valubale informationCan I do it with TFS 2013?

  • Anonymous
    December 06, 2016
    Are you still able to do this, im having issues getting it to work in my VSTS instance?

  • Anonymous
    March 07, 2017
    This is not the desired outcome, as it creates a new test case for each step. All of the steps are to be part of 1 test case. I'm trying to figure out how to import steps from Excel into 1 test case, but no luck so far.

  • Anonymous
    June 01, 2017
    i am using MTM for Testing purpose, i have 1 question, while writing test cases in MTM, we have following headings( Columns Names) ==>Attachment, Step#, Action, Expected Result,but i need add 2 more Headings (columns) like, Actual Results & Comments column, how to add these 2 columns in MTM