Creating Parent Child relationships on file import for work item creation
Years ago it seems I was able to successfully create a parent child relationship on work items from a .csv file. I could create the Epic in the spreadsheet, along with the Story and have the newly created Epic become the Parent. I had a format similar to:
We are now on CLM 6.0.3 - the team members love the new web UI for import of .csv files but have not been able to create the relationships and work items all from one spreadsheet. The format above, links the Story's to the existing work item 1 in their project area.
Does this capability to create the Epic and Story from one spreadsheet and have the links automatically create exist? I certain can see where you could create the Epic, then supply the Epic number in the Parent column and make the association that way but curious if it could be done in one step.
Accepted answer
It has existed for years and still exists. I believe it is also explained in the documentation.
Please see https://www.google.com/search?q=parent+child+csv+import+site%3Ajazz.net and let me know if you found your answer how to.
You would have to make sure the new work items are created and know their ID's to do it in one step, I don't think that is realistic.
Comments
I'm sorry - my screen snip on my original post did not come through.
So the format I'm using is:
ID, Type, Summary, Filed Against, Parent
1, Epic, Some Epic, Some Category,
2, Story, Some Story, Some Category, 1
3, Story, Another Story, Some Category, 1
Import is creating the Epic and two Stories however the Stories are showing a Parent link to existing work item #1 from when we first implemented Rational...not the ID of the newly created Epic as expected.
I tested in RTC 6.0.3 environment and I don't have any issue. If the csv file contains ID as your sample, the Story will be linked to the Epic created during the csv importing.
If you still have the issue, you can try to using your csv file generate a custom mapping file and test if the issue happens using the mapping file.
The point I was trying to make after realizing the 1 step question was:
Thank you Ralph. That is the confirmation that I was looking for. I struggled to make the key point on 'one step' very clear.
Comments
Donald Nong
Mar 08 '17, 7:04 p.m.