It's all about the answers!

Ask a question

TimeSheet in RTC 3


Marco Bormann (1611810) | asked Aug 19 '10, 5:31 a.m.
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



permanent link
Sudhakar Frederick (80113531) | answered Sep 07 '10, 2:15 a.m.
JAZZ DEVELOPER
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
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?

Your answer


Register or to post your answer.