What is the best way to import work items to RTC
We want to migrate items from ClearQuest to RTC. Unfortunately it's not simple mapping. In some cases for one record in CQ, we will have 3 records in RTC which are linked.
Ex: Defect in CQ will be mapped to "Issue, Defect, Task" which are linked by "Resolves/Resolved by"
I am wondering what would be the best way create/import these records in RTC?
I can think of the following:
-> Perl script which can talk to CQ as well create WI in RTC via OSLC
-> Perl script which can export file a format and use Java with RTC Plain Java API to create WI in RTC
-> Use Eclipse to export CQ records in XML format and use Perl / Java to create WI
-> Use Eclipse to export CQ records in XML format and use Eclipse to create Items in RTC, but I don't know if thi can create the way i need, for 1 CQ record create 3 WI and link them
I am looking for most effective solution as well as less effort
Accepted answer
Hello Karthik,
please review https://jazz.net/library/article/69
You may want to use the CQ Importer and a customized mapping file.
Thanks,
Eric
Comments
Thanks. One of my main requirement is to while importing a Workitem, created a "Related" work item and link with this. How can this be done? any pointers?
The excel importer can do some of the link types. Don't know about the CQ importer.
1 vote
Right.
Based on https://jazz.net/wiki/bin/view/Main/CQImportWizardTips
CQ Importer can handle the following links:
com.ibm.team.workitem.rcp.core.blocks
com.ibm.team.workitem.rcp.core.dependson
com.ibm.team.workitem.rcp.core.parent
com.ibm.team.workitem.rcp.core.children
com.ibm.team.workitem.rcp.core.related
Thanks,
Eric
1 vote
Thank you both. After reading the wiki articles & Forum posts I found out that It doesn't suit our needs since we have to add "approvals" in work items (based on status of CQ records)
I guess I have to resort to programming the importer using Java / Perl as I read even with OSLC we cannot set the Approvals
Many thanks for your suggestions
Accepting this answer as this is the more generic solution just that I cannot use it my case.
Or you may want to try the CQ Gateway (as the effort / workload to import CQ records might be identical to developing an in-house Java / Perl based solution)
The idea I have in mind is:
- setup incoming (CQ to RTC) synchronization
- implement mapping rules (so as to have approvals synchronized)
- let the gateway import CQ records
- once all records imported, shutdown the gateway, stop synchronization for resulting RTC work items
showing 5 of 6
show 1 more comments
Comments
sam detweiler
May 27 '14, 11:10 a.m.if you look at the bugzilla importer, it takes xml input. you will probably have to convert a little.
2 votes