Import work item attachments from Clearquest to RTC
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
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
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
Ralph Schoon (63.5k●3●36●46)
| 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
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.