This utility is a standalone html-page that fetches all stories from a Pivotal Tracker project and iterate over each story comment to find time spent records. Then it builds a spreadsheet with a summarized data.
- get this repository to your computer
- open
pivotal-report.htmlfile in your browser (Chrome, Firefox) - fill User API Token (you can find it in your profile page on the Pivotal site) and Project id
- press Update Data button and see the result
- tweak report dates, etc.
Any story comment is considered to be a time spent record if it starts with one of the following patterns:
spent 2h
Tells that 2 hours were spent by commenter for the story in the same day as the comment was added.
2016-03-29 spent 2h
Tells that 2 hours were spent by commenter for the story in the given date
spent 30m
The same as spent 0.5h. Also d is supported (for whatever reason).
spent 1.5h: reading the spec
Actually any stuff after time value is just ignored.