How to link multiple work items automatically in RTC - Parent/Child Relationship
Accepted answer
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
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 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,
I would suggest to create a new question on the forum, as this is already answered.