Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Can imported CQ defects be linked as duplicates

ClearQuest defects can be associated (Parent to Child) when transitioned to the Duplicate state in ClearQuest. How does one maintain those "Duplicate Of" relationships when being imported as JAZZ RTC Work Items.
This document https://www.ibm.com/support/docview.wss?uid=swg21152264 explains how write a query to determine those relationships in ClearQuest (which was difficult to find to begin with).
After importing these defects as Jazz Work Items, and knowing the parent/child relationships from ClearQuest (we are also importing the ClearQuest IDs as one of the Work Item attributes) how can we now establish those types of links in the work items?

0 votes



11 answers

Permanent link
The CQ Importer does support the duplicate of relationships. See the Work Item Relationships Mapping section in the https://jazz.net/wiki/bin/view/Main/CQImportWizardTips for more information.

0 votes


Permanent link
The CQ Importer does support the duplicate of relationships. See the Work Item Relationships Mapping section in the https://jazz.net/wiki/bin/view/Main/CQImportWizardTips for more information.

Thanks for your response. Does this mean it will only work on the imports done by the CQ importer, or can this also be done by a CSV import to update existing imported Jazz Work Items

0 votes


Permanent link
I'll asked the work item team to answer your question about the CSV importer, but you can't update work items using the CQ importer.

0 votes


Permanent link
I'll asked the work item team to answer your question about the CSV importer, but you can't update work items using the CQ importer.

Yes I know work items cannot be updated using the CQ Importer.

0 votes


Permanent link
Good, just wanted to make sure.

0 votes


Permanent link
Yes you can use the CSV importer to add links afterwards (= update existing work items). The importer uses a column named "Id" to identify work items in the repository. During import, choose to update work items instead of creating them.

0 votes


Permanent link
The CQ Importer does support the duplicate of relationships. See the Work Item Relationships Mapping section in the https://jazz.net/wiki/bin/view/Main/CQImportWizardTips for more information.

Loreli - Your referenced document in the wiki pages on CQ Import Wizard Tips says this relationship can be handled by adding the following to the mapping file.

<attribute>
<attribute>

The export query then has to contain the Duplicate_Of and Duplicated_By values in the resultset for each CQ record being exported. Because this is an export I assume these values would have to be the CQ Defect Record numbers (IDs), correct?
The reason I ask is that when I export two work items from RTC that are linked as duplicates and include the Duplicated By and Duplicate Of values, these contain the work item ids. Since the CQ Importer doesn't know what the resulting imported work item ids will be until after the import, does the CQ importer do some post processing to link the relationships?

0 votes


Permanent link
The CQ Importer does support the duplicate of relationships. See the Work Item Relationships Mapping section in the https://jazz.net/wiki/bin/view/Main/CQImportWizardTips for more information.

Loreli - Your referenced document in the wiki pages on CQ Import Wizard Tips says this relationship can be handled by adding the following to the mapping file.

<attribute>
<attribute>

The export query then has to contain the Duplicate_Of and Duplicated_By values in the resultset for each CQ record being exported. Because this is an export I assume these values would have to be the CQ Defect Record numbers (IDs), correct?
The reason I ask is that when I export two work items from RTC that are linked as duplicates and include the Duplicated By and Duplicate Of values, these contain the work item ids. Since the CQ Importer doesn't know what the resulting imported work item ids will be until after the import, does the CQ importer do some post processing to link the relationships?

The snippet of xml didn't post correctly

<attribute>
<attribute>
[/code}

0 votes


Permanent link
Yes you can use the CSV importer to add links afterwards (= update existing work items). The importer uses a column named "Id" to identify work items in the repository. During import, choose to update work items instead of creating them.


I tried this type of CSV update to create the Duplicate_Of and Duplicated_By relationship between two work items using these lines in the import csv file.
"Id","Duplicated_By","Duplicate_Of"
"13959","#4621",""
"4621","","#13959"

I also used the attribute mapping file with the proper mapping as described here https://jazz.net/wiki/bin/view/Main/CQImportWizardTips in the Relationships mapping section. This did not work. So what else needs to be done to get this to work?

0 votes


Permanent link
The info I gave you was for the CQ Importer. I think you'll have to wait to hear from Ben about the CSV Importer.

0 votes

1–15 items
page 1of 1 pagesof 2 pages

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Jul 27 '11, 3:02 p.m.

Question was seen: 8,874 times

Last updated: Jul 27 '11, 3:02 p.m.

Confirmation Cancel Confirm