Export as .csv ranked backlog plan in RTC 4.0.6
Hello,
is there a nice way of getting a csv file from a ranked backlog plan where the rank is retained.
What I am currently doing (and it seems to work):
1. Do the manual ranking in the plan (almost all items have been ranked for the first time)
2. Create a query that contains the same work items as the plan.
3. In the query definition set the sort criteria to the archived attribute "rank"
This way the exported query content seems to be equivalent to the plan. But if this is the right way to do, why is the attribute archived and not easily usable?
PS. The export to xml feature in the plan would also be enough but it hangs (,never returns a result) in my backlog that contains ~330 work items.
Thank you
is there a nice way of getting a csv file from a ranked backlog plan where the rank is retained.
What I am currently doing (and it seems to work):
1. Do the manual ranking in the plan (almost all items have been ranked for the first time)
2. Create a query that contains the same work items as the plan.
3. In the query definition set the sort criteria to the archived attribute "rank"
This way the exported query content seems to be equivalent to the plan. But if this is the right way to do, why is the attribute archived and not easily usable?
PS. The export to xml feature in the plan would also be enough but it hangs (,never returns a result) in my backlog that contains ~330 work items.
Thank you
Accepted answer
You can only export queries as CSV. You can however create a query for the data the plan shows.
WRT how the XML export works see: https://jazz.net/library/article/1150 (Google rocks).
WRT how the XML export works see: https://jazz.net/library/article/1150 (Google rocks).
Comments
I know that already, see my above statement :)
The question is how to the get rank into the exported csv file.
Is the above mentioned approach the only way? Is it even creating a correct result wrt the ranked items in the plan?
As far as I know you can't. See https://jazz.net/forum/questions/64370/export-rank-value-in-rtc-301
All the comments above won't get the question answered btw. Hence it can't be completed and it will sit unanswered and uncompleted forever in the forum.
So I answered it......
Comments
Marko Tomljenovic
Sep 11 '14, 9:50 a.m.The xml export now finished. It took ~10 minutes to finish for ~330 items!!!
Greg Pflaum
Sep 11 '14, 11:22 p.m.Performance of exporting large plans is a known problem: 219824: Performance issue: exporting a plan to xml since it uses DOM parser for XML
We've seen export of large plans run for days on the server, and the client times out long before the export finishes.
Marko Tomljenovic
Sep 12 '14, 3:54 a.m.Ok, fine. Thanks for the hint.
BTW is there somewhere an explanation what information is contained in the exported XML file? Schema-Description?
What about the initial question how to export the plan? :)