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

Import Workitems with mention link in discussion to another RTC server using CSV import function

We would like to import Workitems with mention link in discussion to another RTC server using CSV import function, but it doesn't work as we imagine.

For example, we would like to import the following Workitems from Server A to Server B.

 Server A
  There are two Workitems. The Workitem numbers are 90 and 100.
  Workitem 100 has mention link in discussion field to Workitem 90.

However, the result to import is as belows:

 Server B
  There are two Workitems. The Workitem numbers are 1 and 2 which are automatically assinged from Server B.
  Workitem 1 on Server B is originally Workitem 90 on Server A.
  Workitem 2 on Server B is originally Workitem 100 on Server A.
  Workitem 2 on Server B has still mention link in discussion field to Workitem 90 on Server B. <- This is an issue.

We hope to change the mention link from Workitem 90 to Workitem 1 because Workitem 90 doesn't exist on Server B and Workitem 1 on Server B is originally Workitem 90 on Server A, but we can't adjust workitem number in discussion when importing because we can't know what number will be assigned.

I think it is root cause that we can't assign specific workitem number when importing workitems, and we can't change the discussion filed after import.

Any workarounds?

Thanks.

0 votes

Comments

I am not aware of any mechanism to have the comments for linked items updated on import when the related workitem ids change.

when we had to do this earlier in the year we ended up writing a utility to correctly import all the comments separately from the standard CSV import.


Accepted answer

Permanent link
 Hi Nozomu,
I think Sam is correct. Currently this is working as designed and no solution available. Please see the comments in https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=267065
Nozomu Matsushita selected this answer as the correct answer

0 votes

Comments

Hi Sam and Lily,

Thank you for your answer!
I understand it is working as designed and we can't do any workarounds.

Off course, we can import workitems without discussion to determine Workitem number on new server, and change workitem number from old server to new server in discussion in CSV file manually, and import discussion additionally.
However, it is difficult to change them due to tremendous Workitem.

Umm...

yes, we had over 8000 workitems to fix links in. can't do that manually.

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.

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
× 12,025

Question asked: Sep 18 '14, 3:16 a.m.

Question was seen: 3,401 times

Last updated: Sep 19 '14, 8:08 a.m.

Confirmation Cancel Confirm