Extracting Test Case Steps in Excel RRS feed

  • Question

  • Using TFS 2010, if I run a query based on Test Cases, EG. 'My Test Cases' using the MSF for Agile Software Development v5.0

    Then add 'Steps' as a column and refresh.

    The steps are shown in xml; all good so far.

    However, when this is opened in Excel the xml tags are striped out and all the steps shown in one column, hence losing differentiation between them.

    This seem like a bug to me.

    I would like to avoid going direct to the database, though with just a quick glance across the schema and I've not located where they are stored even.

    My questions:

    1/ Is there any way to keep the steps separate in an excel export so the data can be parsed for use?

    2/ Where are the steps stored in the database?

    Any help is much appreciated.


    Wednesday, November 10, 2010 2:58 AM


All replies