How do I Import RTC work items via csv with parent relationships that are referenced intrinsicly to the file
Hello,
I would to take an export of our RTC Safe 3 PA and import items into our empty test environment (identical process template) but I want to do tasks and Stories at the same time and have the parent relationships on the tasks come in automatically. is there a way to reference a parent that is in the same csv file? I.e. story on row 79 is a parent of task on row 156?
Thanks, for any assistance.
Homer
One answer
I am not sure why no help or documentation I can find mentions that the CSV import can recreate relationships between work items.
You can export relationships if you select them in the export step. If you import and provide the column, add a # in front of the work item number and a work item of that number exists, the import recreates the relationship as far as I know.
You can export relationships if you select them in the export step. If you import and provide the column, add a # in front of the work item number and a work item of that number exists, the import recreates the relationship as far as I know.
Comments
Yes true, but I was looking to import multiple types at once.
I can do the highest level WI first (PI Objective, then work down to tasks) but wouild involve some work (dont mind it) of matching up parent relationships. was looking to do exports out of prod, do the linking in the CSV, then import into test. Guess they havent thought about this. Thanks for your response. Hopefully someone from the RTC team can chime in...
I played around with import here: https://rsjazz.wordpress.com/2015/11/03/a-rtc-workitem-command-line-version-3-0/ but it might not be what you want. You could at least modify the code for your purposes.