It's all about the answers!

Ask a question

Import WorkItems from CSV including parent/child links (RTC 4.0.2 and later)


0
1
Thorsten Gau (8611112) | asked Jan 25 '14, 2:58 a.m.
retagged Jan 31 '14, 2:15 p.m. by Dejan Custic (2855)
In this video a CSV file is imported and as a result the work items have parent/child links.
How was this done?

import-work-item-and-the-links-from-csv-file points out to use
id,parent
1234,#1233

I understand how to use this to link new work items to existing work items (id attribute known), but was wondering how to use this when the ID of the parent is not known (RTC sets it to a unique number during import)

Accepted answer


permanent link
Thorsten Gau (8611112) | answered Jan 25 '14, 3:00 a.m.
The answer is simple: RTC is smart
RTC is able to use any ID in the import file to determine the link to set, but use actual/real (new) IDs during import.
So here is a demo.csv:

Id,Type,Summary,Filed Against,Parent
1233,Task,aParent,aCategory
1234,Task,aChild,aCategory,#1233

Millard Ellingsworth selected this answer as the correct answer

One other answer



permanent link
Dejan Custic (2855) | answered Jan 31 '14, 2:15 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
edited Jan 31 '14, 5:17 p.m.
The related Help topic is also here http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m3/topic/com.ibm.team.workitem.doc/topics/t_importing_work_items_csv_file.html

Comments
Alan Sampson commented Oct 01 '15, 9:29 p.m.
JAZZ DEVELOPER

 Oh, if only that were true.  I can't find anything in the doc. that mentions how to set up a CSV file to create links as Thorsten describes above.

Your answer


Register or to post your answer.