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

Import work item attachments from Clearquest to RTC

Questions
Tags
Users
Badges
Logan Torres
(17●1●10) edited
Mar 25 '21, 5:03 p.m.

I am importing a bunch of work items from clearquest version 8.0.0.15 to RTC version 6.0.6.1. I am using the web client for both.

I have created the work item in RTC with all of the attributes. I created a query in clearquest with all of the attributes and exported the work items to csv. I changed the headings in the csv to match the RTC attributes and also use some VBA code to change the names and dates to properly import into RTC. (was this neccasary???). Everything imported just fine except for the fact that I also need to import the attachments that are attached to the clearquest Work items.

How do I do this??

0 votes

2 answers
1,316 views
0 votes

Accepted answer

Permanent link
Davyd Norris
(3.0k●2●19) Mar 25 '21, 6:56 p.m.
By far the best way to do this is to use the ClearQuest Importer built into the RTC Eclipse client. It will manage the download, mapping and import for you and will bring in attachments and comment history too.

Logan Torres selected this answer as the correct answer

0 votes

Comments
Logan Torres
Mar 29 '21, 9:58 a.m.

Thanks for the response! I have already gotten my work items over with using the csv export/import. Is it possible to use Bugzilla to bring just the attachments over or is it best if I just go through the entire process with the ClearQuest Importer?

Davyd Norris
Mar 29 '21, 6:55 p.m.
The problem you have is that you won't have included the necessary information in your own import so the ClearQuest or Bugzilla import will struggle to work out what to attach to what.

I would either import everything using the built in capability, or I would use Ralph's Command Line tool to import attachments against the existing work items - you'll then need to build the mapping between the new work item IDs and the attachments

1 vote

Logan Torres
Mar 30 '21, 9:21 a.m.

Okay thank you. I am trying to use the Clearquest importer but it says I need the 32 bit version. I got that downloaded and installed the p2 repo but I don't see the Clearquest Importer in the import options? Any ideas?

Davyd Norris
Mar 30 '21, 5:49 p.m.
That's weird - my experience is that you always see the import wizard in the list but it will yell at you if you don't have the 32 bit version of the ClearQuest client installed.

This is what I see in my 6.0.6.1 client

CQ Import

Davyd Norris
Mar 30 '21, 5:50 p.m.

Note that I do not have CQ installed at all on my computer, but I still see this

Logan Torres
Mar 31 '21, 9:15 a.m.

Yeah I have 6.0.6.01 32 bit version as well and only see the Team Project Set option. I can see them all in the 64 bit version. But I only see Team Project set in the 32 bit.

Davyd Norris
Mar 31 '21, 5:23 p.m.
From my experience you can have either version of the Jazz EWM/RTC client installed - I have it integrated into Rational Software Architect in that screen shot so it's the 64 bit client.

You must have the 32-bit ClearQuest client installed on the same machine for it to work

Davyd Norris
Mar 31 '21, 10:23 p.m.

Actually I think you do have to have the 32 bit client of both, sorry

Logan Torres
Apr 01 '21, 8:33 a.m.

Yeah both 32 bit versions are required.

showing 5 of 9 show 4 more comments

One other answer

Permanent link
Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER (64.0k●3●36●48) edited
Mar 26 '21, 5:29 a.m.

I don't think the built in RTC/EWM CSV importer provides this capability. The Workitem Command Line https://github.com/jazz-community/work-item-command-line has several features built in to up and download attachments, including CSV import.

0 votes

Comments
Davyd Norris
Mar 26 '21, 4:45 a.m.

Can absolutely confirm that the CQ import tool built into Eclipse does migrate attachments

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Mar 26 '21, 5:29 a.m.

Sorry, Davyd, I will corrrect my statement I meant the built-in CSV importer, not the CQ import.

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.

Ask a question
Guidelines
FAQ
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: Mar 25 '21, 5:03 p.m.

Question was seen: 1,316 times

Last updated: Apr 01 '21, 8:33 a.m.

Confirmation Cancel Confirm