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? |
11 answers
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.
|
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 |
|
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.
|
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. |
|
Good, just wanted to make sure.
|
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.
|
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 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
|
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? |
|
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.
|
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.