Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

exporting the plan to excel

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.

0 votes



One answer

Permanent link
 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

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,019

Question asked: Jul 12 '12, 6:07 a.m.

Question was seen: 6,209 times

Last updated: Jul 16 '12, 4:26 a.m.

Confirmation Cancel Confirm