none
Can't view description as Description, must use Description HTML and can't edit via Excel

    Question

  • I'm trying to display the description associated with a Test Case.  I select Description, but I get Test Case 470: Title of test case rather than the field Description which has the text "Description of test case."

    How do I display the field entitled Description associated with at Test Case instead of this formatted description?

    • Edited by BABRC Friday, July 23, 2010 3:56 PM
    Wednesday, July 21, 2010 5:14 PM

Answers

  • HTML fields are only editable in excel when the Work item is created.

     

    After saving it, it can no longer be edited in excel.

     

    As a workaround you can open the WI in web access to edit the description (there is a button on the toolbar to do this without having to open browser manually and navigating to the work item)


    Team System MVP -- http://www.agilior.pt/blogs/tiago.pascoal
    • Marked as answer by BABRC Wednesday, August 25, 2010 5:02 PM
    Wednesday, August 25, 2010 4:51 PM

All replies

  • Interesting note - I've discovered that if I open the list of Test Cases in Excel, I can add the Description column and I'm able to modify it.  But, I still can't see it in Visual Studio 2010 Test Cases listing.  Interesting ;)
    Wednesday, July 21, 2010 5:22 PM
  • Hi BABRC,

    What do you mean by Visual Studio 2010 Test Cases listing? Where did you get the list? Team Query? What is the Process Tempalte of the Team Project?


    Best regards,
    Ruiz
    MSDN Subscriber Support in Forum
    If you have any feedback on our support, please contact msdnmg @ microsoft.com
    Thursday, July 22, 2010 7:24 AM
    Moderator
  • Hello Ruiz,

    Here are some more details.

    I'm using the Microsoft Scrum Template Beta 1

    I'm viewing the Product Backlog via the Product Backlog query.

    When I add the Description Column nothing shows up.

    When I ad the Description HTML Column the description information appears there.

    I open the Query in Excel. I see the description in the Description HTML column, but nothing in the description column.

    When I attempt to modify the Description HTML data, I can' because it says it is read-only.

    How do I modify the description in Excel?

    I can modify the title and the acceptance criteria, but I can't modify the description of a Product Backlog Item.

    Friday, July 23, 2010 3:45 PM
  • I've got the same problem here. I can't update the DescriptionHTML field via Excel (I'm trying to migrate work items from another template via Excel). How can I update this field in Excel? Thanks.
    Wednesday, August 25, 2010 12:00 AM
  • HTML fields are only editable in excel when the Work item is created.

     

    After saving it, it can no longer be edited in excel.

     

    As a workaround you can open the WI in web access to edit the description (there is a button on the toolbar to do this without having to open browser manually and navigating to the work item)


    Team System MVP -- http://www.agilior.pt/blogs/tiago.pascoal
    • Marked as answer by BABRC Wednesday, August 25, 2010 5:02 PM
    Wednesday, August 25, 2010 4:51 PM
  • are you updating the items or creating them?

     

    If creating them you can use excel.

     

    other options migrate the work items via custom code written by you

    or migrate them with TFS Integration Platform which was written specifically for this purpose http://tfsintegration.codeplex.com/


    Team System MVP -- http://www.agilior.pt/blogs/tiago.pascoal
    Thursday, August 26, 2010 7:39 AM
  • are you updating the items or creating them?

     

    If creating them you can use excel.

     

    other options migrate the work items via custom code written by you

    or migrate them with TFS Integration Platform which was written specifically for this purpose http://tfsintegration.codeplex.com/


    Team System MVP -- http://www.agilior.pt/blogs/tiago.pascoal

    I had to log in basically just to say how terrible it is that you can't update these fields using excel. I encountered this myself for the first time today and spent twenty minutes or so trying to figure out how to unlock the fields etc before finally discovering that it's a "feature".

    I'm going to catch a lot of heat once people get wise to this as it is a few extra steps to right click then choose open in web access, then sit around and wait for web access to open, just to change the description.

    What is the limiting factor and are there plans to fix it?

    Monday, November 15, 2010 9:20 PM
  • are you updating the items or creating them?

     

    If creating them you can use excel.

     

    other options migrate the work items via custom code written by you

    or migrate them with TFS Integration Platform which was written specifically for this purpose http://tfsintegration.codeplex.com/


    Team System MVP -- http://www.agilior.pt/blogs/tiago.pascoal

    I had to log in basically just to say how terrible it is that you can't update these fields using excel. I encountered this myself for the first time today and spent twenty minutes or so trying to figure out how to unlock the fields etc before finally discovering that it's a "feature".

    I'm going to catch a lot of heat once people get wise to this as it is a few extra steps to right click then choose open in web access, then sit around and wait for web access to open, just to change the description.

    What is the limiting factor and are there plans to fix it?


    I agree - we use Excel to update these things on a regular basis, and not being able to update the Desciption HTML field is cumbersome. Instead, we're going to move to using the Description Field and customizing the work item to display that instead (since we don't really use the "html" features of the description field anyway)

     

    Wednesday, February 02, 2011 5:08 PM
  • In case anyone else wants to do this, the way we did it is outlined here:

    http://neofight.wordpress.com/2011/02/02/tfs-description-html-field-is-read-only-in-excel/

    Hope this helps,
    Shaun McCarthy

    Wednesday, February 02, 2011 6:16 PM