What is the best way to import work items to RTC

Karthik Krishnan

(909●19●130●170) May 27 '14, 10:26 a.m.

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

0 votes

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

1 answer

7,609 views

0 votes

Accepted answer

Permanent link

Eric Jodet

JAZZ DEVELOPER (6.3k●5●111●120) May 27 '14, 12:06 p.m.

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

Karthik Krishnan selected this answer as the correct answer

2 votes

Comments

Karthik Krishnan

Jun 02 '14, 12:00 p.m.

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?

sam detweiler

Jun 02 '14, 2:51 p.m.

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

Karthik Krishnan

Jun 04 '14, 3:49 a.m.

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

Karthik Krishnan

Jun 04 '14, 3:50 a.m.

Accepting this answer as this is the more generic solution just that I cannot use it my case.

Eric Jodet

JAZZ DEVELOPER Jun 04 '14, 4:33 a.m.

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) https://jazz.net/help-dev/clm/topic/com.ibm.team.connector.cq.doc/topics/c_configuring_and_using_the_clearquest_connector.html 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

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.

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

rational-team-concert

× 43,075

extending

× 11,104

Question asked: May 27 '14, 10:26 a.m.

Question was seen: 7,609 times

Last updated: Jun 04 '14, 4:33 a.m.

What is the best way to import work items to RTC

Comments

1 answer

7,609 views

0 votes

Accepted answer

Comments

Your answer

Follow this question

Question details

Related questions