TimeSheet in RTC 3
I pretty much like the time sheet function in RTC 3, available in the formal project template. But I have trouble getting hold of the data. In exporting it via CSV-export I get nowhere. Is there any way to get this data?
|
One answer
It appears that the Timesheet Entries are stored as links. So when you
export , in the "Choose Attributes to Export" dialog -> Add Columns -> Check "Show Links" and choose the 'Time Sheet Entry' link attribute. On export the entries are created as links in the CSV like : Defect 26 New Unassigned Normal A new defect Unassigned clmuser "https://clmwb:9443/ccm/resource/itemOid/com.ibm.team.workitem.TimeSheetEntry/_Nae8cbpBEd-5kdyN6jC40w https://clmwb:9443/ccm/resource/itemOid/com.ibm.team.workitem.TimeSheetEntry/_Nae8cLpBEd-5kdyN6jC40w" Defect 28 New Unassigned Normal a new defect again Unassigned clmuser "https://clmwb:9443/ccm/resource/itemOid/com.ibm.team.workitem.TimeSheetEntry/_YcNnsLpFEd-5kdyN6jC40w https://clmwb:9443/ccm/resource/itemOid/com.ibm.team.workitem.TimeSheetEntry/_uc2CwLpEEd-5kdyN6jC40w https://clmwb:9443/ccm/resource/itemOid/com.ibm.team.workitem.TimeSheetEntry/_oY0gQLpDEd-IobFi4qSUBA" And navigating to one of those links gives you: <rtc_cm> <rtc_cm> <dc> <rtc_cm>2010-09-06T02:00:00.000Z</rtc_cm> <rtc_cm>2</rtc_cm> <rtc_cm>Coding</rtc_cm> </rtc_cm> Not sure if it helps:-) Freddy On 19/08/2010 7:38 PM, MarcoB wrote: I pretty much like the time sheet function in RTC 3, available in the |
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.