How to Link bug ids on Excel to TFS using Import Tool ?

Question

Hi there,

  Need help to get bugs related to test cases imported\linked properly in Test Manager VS2012.

  Here is the xml configuration file I have been using :

<?xml version="1.0" ?>

- <WorkItemMigrator>

- <FieldMapping>

<FieldMappingRow DataSourceField="Test Name" WorkItemField="Title" />

<FieldMappingRow DataSourceField="Test
Description" WorkItemField="Description"
/>

<FieldMappingRow DataSourceField="Test Folder
Hierarchy" WorkItemField="Area Path"
/>

<FieldMappingRow DataSourceField="Assigned To" WorkItemField="Assigned To"
/>

<FieldMappingRow DataSourceField="Status" WorkItemField="State" />

<FieldMappingRow DataSourceField="Priority" WorkItemField="Priority"
/>

<FieldMappingRow DataSourceField="Step Name" WorkItemField="Test Step Title"
/>

<FieldMappingRow DataSourceField="Expected Result" WorkItemField="Test Step Expected Result" />

<FieldMappingRow DataSourceField="Date" WorkItemField="Changed Date"
/>

</FieldMapping>

- <Relationships>

<SourceIdField>Test Case Source ID</SourceIdField>

<TestSuiteField>Suites Hierarchy (test belongs to these
suites)</TestSuiteField>

- <LinkTypes>

<LinkType SourceField="Linked Requirement Source
IDs" LinkTypeName="Tests"
LinkedWorkItemType="User Story" Description="" />

<LinkType SourceField="Related Test Case Source
IDs" LinkTypeName="Related"
LinkedWorkItemType="Test Case" Description="" />

<LinkType SourceField="Linked Bugs IDs" LinkTypeName="Tests"
LinkedWorkItemType="Bug" Description="" />

</LinkTypes>

</Relationships>

-<DataMapping> ....

Here the spreadsheet header\column names :

Test Case Source ID, Test Name, Test Description,Test Folder Hierarchy,Assigned To,Status,Priority,Suites Hierarchy (test belongs   to these suites),Related Test Case Source IDs,Linked Requirement Source IDs,Linked Bugs IDs,Step Name,Expected Result,Date

<...

 After using the "TestCaseMigratorPlus", I get the test cases imported however the bugs are not linked.

 I am pretty sure I am close to get it to work, could someone point it out what am I doing wrong in this case ?

   Thanks in advance !

Answer 1

Hi Alpha,

Thank you for your post.

According to your description of the issue, hope you can provide following information to help narrow down the issue:
What configuration file you mentioned in the post, TFS and MS project field mapping file or other file?

I am trying to involve someone to further look at this issue. There might be some time delay. Appreciate your patience.

Thank you for your understanding and support.

Regards,

---

Lily Wu [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Alpha,

TestCaseMigratorPlus is an open source CodePlex project that is not supported by Microsoft customer support, but rather on the project site itself. This question would be better posed in the Discussion and\or Issue Tracker sections of that project page.

---

Trevor Hancock (Microsoft)
Please remember to "Mark As Answer" the replies that help.

Answer 3

Oh sorry ! Will do. Thanks !

---

maria