Tag Archives: rational-team-concert

Getting at the RTC timesheet data in 3.0 and 3.0.1

Lots of questions about how to pull your time back out once you go ahead and add all your time tracking data into RTC. Working on tracking down more details but at first glance it looks like this is fairly straight forward. Unfortunately at GA this was not included in the ETLs for CLM DW so you need to use BIRT.

Try the LIVE_SNAPSHOT create a data set using the Jazz Simple Data Set and select the table com.ibm.team.workitems.TimeSheetEntry. Not the most comprehensive bit of advice but if you take a look at that columns of the table you will see that this gives all you need to query by project, code, user, and date so should be good for reporting on where you time is being spent if you are using time tracking today.

Example of adding the Formal Process Template to the Scrum in Team Concert 3.0

The process is documented in the CLM Help Information Center well enough for someone familar with the process ;)

http://publib.boulder.ibm.com/infocenter/clmhelp/v3r0/topic/com.ibm.team.platform.doc/topics/t_customize_template_formal_features.html

For those of you who have not dabbled with the process configuration source directly this is a new experience so I took some time preparing this for a particular client of mine and thought it would be useful to share.

Following the Information Center I have gone through Step 8, I am holding off on Step 9 because that is really a cop-out, I’ll continue the implementation to completely add the other work item types from the Formal Process Template directly rather than make them anew.

Here is the current zip files, Scrum Process Configuration Source XMLs v1.0, more to come…

Update: 4-Apr-2011

Posted the current template to github, watch it there if you are interested.

https://github.com/sgwilbur/rtc-process-templates