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

How to link multiple work items automatically in RTC - Parent/Child Relationship

Questions
Tags
Users
Badges
R Z
(127●34●53) edited
Aug 20 '14, 12:08 p.m.

Hello,

I have multiple workitems to upload and most of the work items are child work items, I need to know if there is any way to automatically link these while uploading to new project area.

Thanks in advance

0 votes

1 answer
6,582 views
0 votes

Accepted answer

Permanent link
Erwin Kunz
(946●8●70●86) Aug 12 '14, 4:03 a.m.
If you are talking about import, then yes it is possible

You need to have a column with the link name e.g. Parent and have the id of the parent as value.
If you are importing parent and child in the same csv, you need to have a column ID and in the link column #id

The # indicates that he should look at the ID column to find the corresponding object.
The ID has just to be an integer, it don't need to be adapted to the ID already used in RTC

hope this helps
erwin
R Z selected this answer as the correct answer

0 votes

Comments
R Z
Aug 13 '14, 5:46 a.m.

Hello Ervin,

No, I have tried every possible combination, But i am unable to link any.

Is there any official documentation? Please share.

I now have parent and child work items created, I just need to link them automatically.

Here is the format i am using, Please correct me if i am wrong.

Type Id Status Priority Severity Summary Owned By Created By Parent Child

Type Id Status Priority Severity Summary Owned By Created By Parent Id Child Id

Thank You

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Aug 13 '14, 7:23 a.m.

As Erwin mentions, you have to put a hash # in front of the ID in the parent/child column of the work item that you want to make a parent/child of the one you are import.

A good idea to understand the import format is to create an export. That gives you the required headers. there are also many other questions around this topic you might want to explore. https://www.google.com/search?q=CSV+import+site%3Ajazz.net

The ones to link might have to exist, not sure. So you might have to run the import for all items first and then create the links afterwards. This is the current documentation: https://jazz.net/help-dev/clm/topic/com.ibm.team.workitem.doc/topics/t_importing_work_items_csv_file.html

R Z
Aug 14 '14, 6:33 a.m.

Thank You, Erwin and Ralph.

It worked.

Tojan John
Nov 11 '14, 4:02 a.m.

@rschoon ,

I am using RTC 4.0.2. What is the format that I should use to link multiple work items to  one work item? Say, I wanted to link three Task to one parent Story work item. In my CSV, I have Story(Parent) as Id and Tasks (Children) with "#'. Issue is only last item in the csv is getting linked.

Sample format:-

Id ..... Children
123..... #456
123..... #567
123..... #678 --> After importing Story 123 is linked to 678. Other items are not linked. Where am I making the mistake?

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Nov 11 '14, 4:28 a.m.

I would suggest to use the parent column with a # and import the children. Then you have no line break issue.

If you export a child link column, you get line breaks behind each links - which I would consider as defect. If you remove the line breaks and have the item ID's in one line, it works as described.

After I fixed this, I could add a child and the linkage worked for me.

"Story";"86";"New";"High";"8 pts";"Allocate Dividends to Nearby Charities";"Marco";"Bob";"#87 #88 #1"

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Nov 11 '14, 4:29 a.m.

Note, I used RTC 5.0.1

Tojan John
Nov 11 '14, 6:50 a.m.

Hi Ralph,

Now I am facing different issue. It showed importing work items and finally got hung with status "Resolving unresolved links: Importing from CSV(Line x) 

Ralph Schoon
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER Nov 11 '14, 6:57 a.m.

I would suggest to create a new question on the forum, as this is already answered.

showing 5 of 8 show 3 more comments

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
× 6,117
× 1,381

Question asked: Aug 12 '14, 2:42 a.m.

Question was seen: 6,582 times

Last updated: Nov 11 '14, 6:57 a.m.

Confirmation Cancel Confirm