Mapping ClearQuest / Jazz RTC work items
![]()
Hi,
I'm using the ClearQuest Importer to migrate my ClearQuest activities to RTC work items. In the .xml file I get from the CQ importer, I can see RTC State id's, but not their "name" so I do not know how to customize the file poperly. Where can I find the correspondence between the id's and the "names" of the RTC Status? *attribute sourceId="State" targetId="com.ibm.team.workitem.attribute.state"* *value sourceId="Submitted" targetId="1"* "Submitted" is my CQ status and "1" is for ... what status in RTC? (same question for other fields like Resolution) BR. |
11 answers
![]()
I found the matching by doing an import with all the possible states... but still don't know where to find the documentation.
I've now an issue due to the import of the CQ Notes_log (which is done automatically by selecting this field in the CQ query: you do not need to specify it in the mapping .xml file) Each time I got this error: Error Importing ClearQuest Records com.ibm.team.interop.service.managers.clearquest.common.InteropException: java.text.ParseException: Unparseable date: "13/04/2005 15:20:56" I cannot export my CQ results to the .zip proposed by the ClearQuest import proposed in RTC for the same reason. Any idea for a work around / solution? |
![]()
The correspondence between the id's and the display names is in the process specification. The ClearQuest Importer uses the same mapping infrastructure as the Bugzilla Importer. Please look at the Generate and customize the mapping file section in http://jazz.net/library/techtip/69.
What version of RTC are you using? There was a fix related to the unparseable date problem in RTC 2.0.0.1. Lorelei |
![]()
I've upgrated RTC to 2.0.0.2 and it works now.
Other link to documentation: http://jazz.net/library/article/391 Thanks a lot for your help! |
![]()
Glad to hear that it is working for you.
|
![]()
I am using the latest versions of CQ and RTC and I am trying to import records from a stateless record to an RTC record type. When I run the importer to generate an xml file using a query that clearly selects 100's of records in ClearQuest only one record is created in the xml file. Any ideas ? No error messages at all.
|
![]() I am using the latest versions of CQ and RTC and I am trying to import records from a stateless record to an RTC record type. When I run the importer to generate an xml file using a query that clearly selects 100's of records in ClearQuest only one record is created in the xml file. Any ideas ? No error messages at all. Oops sorry - posted in the wrong place. Please ignore. |
![]() The correspondence between the id's and the display names is in the process specification. The ClearQuest Importer uses the same mapping infrastructure as the Bugzilla Importer. Please look at the Generate and customize the mapping file section in http://jazz.net/library/techtip/69. We tried this State mapping in RTC 3.0. In our process configuration source the attribute is define as... attributeDefinition id="com.ibm.team.workitem.attribute.state" name="Status" readOnly="true" type="smallString" with state sections like this... state group="open" icon="processattachment:/workflow/open.gif" id="s1" name="New" showResolution="false" So our mapping xml looks like ... attribute sourceId="State" targetId="com.ibm.team.workitem.attribute.state with values like value sourceId="New" targetId="1" ...... When we run the import the Status field ends up with the numeric values. Why is that? |
![]()
If it can't find a matching state value for the work item type, then it will return the numeric value.
Verify that the work item type is being set properly, then verify that the state id exists for the work item type in the process specification. |
![]() If it can't find a matching state value for the work item type, then it will return the numeric value. This is how our state mapping is currently looking for RTC v3. It's a mixture of the "short" form of the state literal, plus the long form that other typical CQ->RTC mappings would use: <attribute sourceId="State" targetId="com.ibm.team.workitem.attribute.state"> Prior to doing this, we used all 'targetID="#"' without the preceeding 's', but Closed records would end up with '7' in the state field. At least now they show up as Closed. Can anyone verify if this is the correct way the mapping should look in RTC v3? This custom data mapping is really turning out to be quite cumbersome for our conversion from CQ to RTC. There seems to be a lot of "trial and error" with the tool to figure out how to get it to work, at least in our experience. In addition, you have to manually enter the values from CQ along with the literal string identifiers from RTC in order to get them know about each other. It would be really nice to see this task converted into some sort of a mapping wizard or something that you can drag-n-drop values for. CQ won't let you copy-n-paste values from the Maintenance Tool, so you have to manually enter those. A mapping wizard could do a query from CQ of your schema to see which fields you would like to map. It could then populate the possible CQ values for those fields. Then the wizard could allow you to select the corresponding RTC type / attribute / value the CQ field should be mapped to and allow you to make the connections between them. The output of this would be the custom data mapping file. Even providing better insight into what is being mapped via some sort of logging would be helpful. I can tell you that without the forums and having access to the developers, we would never have gotten as far as we have with the mapping, and we still have a ways to go! Just a thought... :-) |
![]()
Here's a couple of links with more information about the importer just in case you don't have them:
http://jazz.net/library/article/69 https://jazz.net/wiki/bin/view/Main/CQImportWizardTips http://jazz.net/library/article/391 This mixture of state mappings seems suspicious to me. The first link that I listed above has the following info on state and resolution mappings:
If the state ids defined in your process specification are not of the form "s#", then use the full value of the state id as you have for the closed state mapping. Or, do you have a mixture of state id's defined in your process spec? I agree that manually editing the mapping file can be cumbersome and error prone. We apologize for your painful experience and would like to have a front end, but haven't had time to implement that feature. Please enter an enhancement request with what you would like to see. |
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.