It's all about the answers!

Ask a question

Import work item attachments from Clearquest to RTC


Logan Torres (1710) | asked Mar 25 '21, 5:03 p.m.
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??

Accepted answer


permanent link
Davyd Norris (2.8k217) | answered 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

Comments
Logan Torres commented 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?


1
Davyd Norris commented 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

Logan Torres commented 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 commented 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 commented 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 commented 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 commented 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 commented Mar 31 '21, 10:23 p.m.

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


Logan Torres commented 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 (63.5k33646) | answered Mar 26 '21, 3:29 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
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.


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

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


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

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

Your answer


Register or 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.