Project management and time tracking

How much time is it sensible to track? Who needs this information?

At work we use Trac to look after our projects. It’s very useful for what we do because a) it’s free b) it has tight Subversion integration c) it has a wiki d) it has a customisable issue tracker. It does also have downsides like its atrociously unfriendly wiki-syntax, but seeing as we weren’t using anything at all before, it’s a step in the right direction.

By default, Trac doesn’t do any kind of time management, so in a couple of projects we’ve added in a time_estimate field to issues and a bit of javascript for totalling up time estimates for milestones (in fact, it’s this Greasemonkey script), which is very handy indeed.

Trac is also useful to us because it generates iCalendar files for project roadmaps and RSS files for just about everything else.

So here’s the problem:

  • I have multiple projects
  • each project has its own Trac install
  • each Trac install has a list of the issues assigned to me and the time estimate for each one
  • I can retrieve and aggregate this data in order to find out how busy I’m going to be (we don’t store dates at the moment, but that could be done)

So, what about work I do that isn’t on a project?

  • investigating technology X
  • mentoring John
  • a day at a conference

Where do these days go?

Some suggested solutions:

  • We use calendaring software; should I put completed items in there, and then use that as another data source to compile with my Trac data?
  • should we use “proper” project management software (OpenWorkbench, Basecamp), dropping the Trac time_estimate field?
    • if so, how do we keep the PM software and our Trac issue list in sync?
  • should we switch to a mega-simple approach such as Joel Spolsky’s Painless Software Schedules using Excel?

At the moment I don’t really know what to do. I suspect that we should use something which imports Trac milestones and the corresponding issues and use that tool to schedule the tasks. This would also give us the option to add in custom, one-off tasks like the ones listed above. I suspect also, that we should do as Joel does and ignore dependencies and let the developers actually sort that out.

In fact, the more I think about it, the more I think that we should get the latest version of Jakarta POI and wire up Excel to Trac to keep track of all. It’s got to be the easiest solution, hasn’t it?

Published by

3 thoughts on “Project management and time tracking”

  1. I didn’t think of that.

    I’d only thought about one Trac instance per person for non-project time.

    Hmm, your idea could work you know.

  2. The way we’re trying to solve this is to enable multiple different “project extranets” in Trac, or whatever, and then using the DBE peer-to-peer network to actually copy tasks and work reports to our centralized OpenPsa install.

    This isn’t quite ready yet, but the first implementation is promising.

    The good part about this is that if different orgs participate in the same Trac-managed development project, each can get their tasks to their own project management software. Assuming it supports DBE, of course 🙂

Comments are closed.