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

RTC work item import with no prior knowledge of own Id and Parent Id

Questions
Tags
Users
Badges
Why Tea
(25●2) Mar 30 '13, 9:59 p.m.
 While performing csv file import to RTC, is there a way to tie the relationship between two work items as parent and child? This is often needed when we create a user story and its associated tasks in Excel, export as csv and then import to RTC. I believe this can be done through the "Id" and "Parent" fields, but couldn't find any info of how to do it. Could anyone help?

/Why Tea

0 votes

3 answers
262 views
0 votes

Accepted answer

Permanent link
Clement Liu (Nationwide)
(788●10) edited
Apr 01 '13, 12:25 p.m.
 ยท        This is an example to link new work items in CSV itself

Note: The ids (1, 2 and 3) are relative in the CSV itself. RTC automatically creates absolution ids once the work items were imported.
Why Tea selected this answer as the correct answer

2 votes

2 other answers

Permanent link
Why Tea
(25●2) Apr 01 '13, 10:39 p.m.
 Hi Clement,

Thanks! I tried and it worked as you suggested.

I have a few more questions though.

1) How does RTC distinguish Ids "1, 2, 3" to the real Id (e.g. from an existing User Story)?
2) Must the Ids start with "1" and are continuous in the CSV file?
3) In your screenshot, I suppose it'll also work as below:
    Id  Parent
   1   
   2   #1
   3   #2
That means "myEpic" is the parent of "my Story card", and "my Story card" is the parent of "my Task"

Regards,
/Why Tea

0 votes

Comments
Clement Liu (Nationwide)
Apr 04 '13, 9:57 a.m.
1) This is an example of how to link a new work item in CSV to an existing work item on RTC Basically you don't provide any value to the "Id" column when you link to an existing work item 2) Yes 3) Yes Can you mark my answer above as the accepted answer if that did help you out? Thanks. 

Why Tea
Apr 07 '13, 9:24 p.m.
Sorry, just tried a bit more on 2) and the two answers in 2) are both negative!  That is: 2) Must the Ids start with "1" and are continuous in the CSV file? Answer: No it doesn't have to start with "1", and NO the numbers don't have to be continuous in the CSV.

Permanent link
Why Tea
(25●2) Apr 06 '13, 11:11 p.m.
 Hi Clement,

I tried out 2) and it wasn't true that the Id must start from "1" as you said. I tried from "11" as well as from "111" and they still worked. I thought I'd just clarify it. It still puzzles me how RTC distinguish them from a real Id.

Anyway, I still marked your answers as accepted :) 

/WT 

0 votes

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
× 192
× 36

Question asked: Mar 30 '13, 9:59 p.m.

Question was seen: 262 times

Last updated: Apr 07 '13, 9:24 p.m.

Confirmation Cancel Confirm