Migrating Items from one project area to another: Linking new items to the old ones
![]()
Hello,
we have an old project area and a new project area on the same server.
Now we want to migrate some items from the old one into the new one.
The basic concept is to export the wanted items via a query into a CSV file, and to import them into the new area by the help of a mapping file that translates between the different attribute names and some values.
To keep a better traceability, we want to automatically create a link from the new items to the old one. The concept was to export the Id and to map the Id attribute to a relation attribute like:
<attribute sourceId="Id" targetId="com.ibm.team.workitem.linktype.duplicateworkitem.duplicateOf"/>
The problem now is, that RTC exports the IDs without a leading # but expects a leading # for imported link-IDs. If I add the leading #'s by hand in the exported CSV file, everything works.
So, the question is: How can I tell RTC to either export the item IDs with a leading # or to accept the IDs of the link targets without a leading #?
Maybe there also exists a solution to do something like this in the mapping files. Is it - for example - possible, to do define RegExs to map the a value from the source to the target? (That would be a great feature anyway....)
Thanks and Regards,
Daniel
|
2 answers
![]()
Ralph Schoon (63.3k●3●36●46)
| answered Nov 18 '16, 6:52 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
As far as I can tell, there is no automation to add the #. You have to do that yourself.
Comments Hi Ralph,
thanks for the quick reply. Little bit sad that doesn't work. I could imagine that this is a standard use case for teams moving to another area.
BTW: I also tried to use "your" WCL to do the import but it stops to create any links to existing items when a mapping file is used. I just get something like
No matching attribute found: com.ibm.team.workitem.linktype.duplicateworkitem.duplicateOf
then. Without a mapping file, it works...
![]() FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
You can write an enhancement request. (For RTC) I am not sure if this is a standard use case, really. I think you might be able to use some automation to modify the file.
The WCL export, import lacks testing. It is really meant to be something that you can take and modify to your needs or to look up API examples.
If you use a mapping file it should still work. I used mapping files internally.
I haven't tested mapping the link types and maybe WCL does not look up the link type from the ID. I would try to specify the mapping of the link type to column name of the export.
|
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.