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

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


Accepted answer

Permanent link
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

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

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

Thank You, Erwin and Ralph.

It worked.

@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?

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"

Note, I used RTC 5.0.1

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) 

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.

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