TimeSheet in RTC 3
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:
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?