exporting the plan to excel

Naveen Chandani (48●1●20●22) | asked Jul 12 '12, 6:07 a.m.

Hi,

I created a project area using Formal template. I planned for few workitems and took a planned snapshot. The planned start and end dates were updated in the workitems. Now I want to export this plan in excel or CSV for those who cannot access RTC.Is it possible. I tried creating a query as well but I couldn't find Planned start and end date in the displayed column section.

One answer

Most liked answers ↑|Newest answers|Oldest answers

permanent link

Aradhya K (1.4k●4●43●45) | answered Jul 16 '12, 4:25 a.m.
JAZZ DEVELOPER
edited Jul 16 '12, 4:26 a.m.

RTC Plan does not have a feature to export the plan into a CSV. But you can export the content to a Microsoft Project XML.

Below is the current mapping.

Rational Team Concert	Microsoft Project XML
Plan name	Project name
Plan's iteration start date	Project start date
Plan's iteration end date	Project finish date
Parent work items	Summary Task
Leaf work items	Task
Work item summary	Task name
Work item parent-child hierarchy	Outline number / Outline level
Work item description	Task Notes
Work item estimate / corrected estimate if set	Task Duration/Work
If timespent less than estimate; difference between timespent and estimate else zero	Remaining Duration
Timespent on the work item	Actual Work / Actual Duration
First state transition to in progress state group	Actual start
Timespent >= estimate	Percentage Complete is 100% else 0%
Constraint Type	Constraint Type
Constraint Date	Constraint Date
Due date of the work item	Deadline
Owner of the work item	Used to generate the Resource and Task assignment information

It's all about the answers!

Related questions

exporting the plan to excel

One answer

Your answer