Version 110 (modified by Russ Tyndall, 7 years ago) (diff)

more docs about post-commit

Estimation and Time Tracking

Demo Site | User Manual | Open Tickets | new ticket


This is a plugin that adds (aspires to add) estimation and time tracking to Trac.

This basically adds CustomFields and CustomReports and an interface for filling the dynamic variables for the report. (requires javascript).

Supported Versions

Currently this has been tested on:

  • Python >=2.3
  • Trac >= .10
  • DB, should support all three major free backends
    • sqlite3 >= 3.2.3
    • MySql
    • PostgreSQL
  • Genshi
    • for trac 11 you need a Genshi >= 5
    • for trac 12 you need a Genshi >= 6 (Trac installs this automatically)

Getting the Plugin

Download the source using Svn at:

Download the zipped source :

  • [download:timingandestimationplugin/branches/trac0.12 Zipped source for plugin for Trac0.12].
  • [download:timingandestimationplugin/branches/trac0.12-Permissions Zipped source for plugin for Trac0.12 with permissions].
  • [download:timingandestimationplugin/branches/trac0.11 Zipped source for plugin for Trac0.11].
    • Trac 11 has inconsistent database and transaction management that has been fixed in trac 12 see #8363
  • [download:timingandestimationplugin/branches/trac0.11-Permissions Zipped source for plugin for Trac0.11 with permissions].
  • [download:timingandestimationplugin/branches/trac0.10 Zipped source for plugin for Trac0.10]. - no longer maintained
When downloading these files the extention is lost, or the filename corrupted. 
  a simple rename to seems to resolve it the contents are intact

Browse the source using Trac:

In the repository there is a script folder 0.12/0.11 that contains some various python files that I have written to perform billing queries across an entire directory of tracs and email the results to a specified address. As is these are written to work in my setup and some paths at the top of each file will probably need to be changed. These are mostly included because I wrote them for myself and thought others might want to perform similar tasks. (See: script help?)


Installation Help

  1. Install the plugin (either for a single project, or globally). See the details on how to install a trac plugin at: TracPlugins
  2. Be sure that the plugin is enabled. Add "timingandestimationplugin.* = enabled" to trac.ini (in the [components] subheading).
    • Alternatively, this can be enabled in the Web Admin section of the website as well
  3. Run $ trac-admin /path/to/projenv upgrade
    • You should get a message like this:
      Timing and Estimation needs an upgrade
      Upgrading Database
      Creating bill_date table
      Upgrading fields
      Upgrading reports
      Upgrading usermanual
      Done Upgrading
      Upgrade done.
  4. Reload/restart your HTTPD / other webserver / Tracd. That's it.

Post Installation Configuration Options


By default, the TimingAndEstimationPlugin's four components will all be active. However, you can disable some of the components if you want to. (The easiest way to do this is to ensure you have the trac:WebAdmin plugin installed.)

The plugin's components are:

  1. TimeTrackingSetupParticipant
    Required component.
  2. TimeTrackingTicketObserver
    Ensures that the "Total Hours" values are updated when a user edits a ticket's "Add Hours to Ticket" field. You would not normally want to disable this component.
  3. TicketWebUiAddon
  4. TimingEstimationAndBillingPage

Permissions (Trac>=11 only)

Post Commit Hooks

The scripts folder contains various post-commit scripts. The svn and git post receive/commit hooks call the script with the correct command line arguments (see #8737 for more information and an alternative single file git-post-receive). There are a simple, a simple git-post-receive, and a more complex that tries to ensure that each commit is sent to trac only once (by default moving a commit from one branch to another will cause the comment (and time) to be reposted to trac again(resulting in unintentional extra time on tickets).

Bugs/Feature Requests

Existing bugs and feature requests for TimingAndEstimationPlugin are here.

If you have any issues, create a new ticket.

Uninstall Help

  • There is an uninstall script in the scripts folder that tries to make uninstall easy. I dont promise it will get everything, but it should get you most of the way there.
  • see #995 - old uninstall ticket, which might provide some insight.


Related Plugins

Interacting with T&E

If you want a plugin that you are writing to add reports to the management page, there is a file,, that should make interacting with its reports easier.

Recent Changes

Full Change Log

17028 by bobbysmith007 on 2018-02-01 17:24:41
Fixing bug relating to <none> status in billing.html 1.5.7
17019 by bobbysmith007 on 2018-01-08 16:47:41
Fix extra footer TD by waiting a little before totalling. re #13270
17012 by bobbysmith007 on 2017-12-01 18:36:29
Try again to fix report linkink 1.5.5
17011 by bobbysmith007 on 2017-12-01 18:11:32
Try again to fix status <none>


Author: bobbysmith007

  • Aquafold has provided a license to their excellent Aqua Data Studio application to help further development
  • Obsidian Software sponsored the work to create a permission enabled branch
  • Alessio Massaro: wiki:masariello
    • Helped Get Reports working in postgres and started moving toward generic work rather than hours
  • kkurzweil@…
    • helped postegresql db backend compatiblity
  • Jonas Borgstrom : t:wiki:JonasBorgstrom
    • made it so that base_url was unnecessary
  • Colin Guthrie
    • Refactored custom reports stuff into a single class/module that can be copied to other plugins, to make interaction with T&E easier.
  • David Abrahams
    • Trac.11 - Stream filters to prettify the Reports Screen and make TotalHours not editable
  • Tay Ray Chuan
    • Added a stopwatch to the ticket pages
  • Josh Godsiff, for Oxide Interactive
    • added props table client reformatting to remove extra whitespace