wiki:TimingAndEstimationPlugin

Version 105 (modified by Russ Tyndall, 13 years ago) (diff)

added a note about a patch for mylyn

Estimation and Time Tracking

Demo Site | User Manual | Open Tickets | new ticket

Description

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].
  • [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 filename.zip 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?)

Documents

  • [TimeEstimationAndQuotingNewFeaturesSpecification New Features Specification ]

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

Components

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 Hook

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 not a lot here, but ticket:995 is the best source of information for people uninstalling the plugin.

Patches

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, reportmanager.py, that should make interacting with its reports easier.

Recent Changes

Full Change Log

17249 by bobbysmith007 on 2018-07-30 16:26:11
Change db backend import stuff to allow running without all backends installed re #13462
17107 by bobbysmith007 on 2018-04-09 17:22:27
1.5.9(b) - fixed Decimal cast in ticket_daemon re #13405
17096 by bobbysmith007 on 2018-04-05 15:41:39
Fix hour summing in reports to not round partial hours

version 1.5.8(b)

re #13405

17028 by bobbysmith007 on 2018-02-01 17:24:41
Fixing bug relating to <none> status in billing.html 1.5.7
(more)

Author/Contributors

Author: bobbysmith007
Contributors:

  • 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