views:

525

answers:

8

I'd like to download the Trac database so I can view its tickets offline. Is there anyway to achieve this? I.e. if I need to leave the office and bring my laptop with me, how can I bring the tickets with me without having to connect to the company network?

I know that Mylyn can download and sync tickets via it's trac connector but I'd like some stand-alone viewer.

A: 

you could install it on a local machine

solomongaby
A: 

You can host the trac locally and set up the connectionstring point to your dowloaded database.

codemeit
A: 

Sure. Install a web server locally, install trac, get it set up the same (or similar) way to the way it is on the live version and then script the server to publish db backups and write a local script to download those and restore them over your database.

It's not simple (installing Trac is a battle on its own from my experience of it) but every element is highly googleable =)

Oli
I've installed Trac on a server, but I'd rather not install web server and trac on my windows laptop. :) I'd like some nice stand-alone way to bring my tasks with me without having to print them out seperately.
Spoike
+2  A: 

Seeing as you don't want to install a server, how about using RSS? IIRC, Trac let lets you get RSS feeds for each person, so you can have a feed of things assigned to you.

All you need do then is get a nice client that will download these tickets. You should be able to access a plaintext version without internet connection.

If that's not flexible enough, you could write a script on the server to publish a feed using the database directly.

And if RSS isn't for you (and your email is available offline), you could mail reports home. Trac also has this built in.

Oli
+1  A: 

And if RSS or email isn't your notification of choice, there's a trac plugin that will let you receive task notifications on your Remember The Milk todo list.

See: http://1.www.rememberthemilk.com/forums/ideas/3580/?forum=ideas&hl=bs&topic=3580

Oli
+2  A: 

The default Trac installation uses a combination of SQLite to matintain all of the data. Attachements are stored on the file system.

In the folder containing the trac site, find \db\trac.db

This file can be viewed using the SQLite manager Firefox Addon

Happy hunting.

Babak Naffas
+1 I didn't know about the firefox addon
Spoike
+1  A: 

If your objective is simply to view the tickets offline, how about

  1. Run a report with all the tickets (or all those you're interested in).
  2. Select either the comma-delimited or tab-delimited download link at the bottom of the page.
  3. Import the downloaded file into Excel.
Richard Dunlap
+2  A: 

See SD: http://syncwith.us

Or the presentation:

http://fsck.com/~jesse/tmp/2009-07-15/Ed%2BUAP05So4=/sd-intro.pdf

I particularly like the "One-tweet install" idea.

I’m installing #SD (http://syncwith.us) 
after reading about it on #StackOverflow
curl fsck.com/sd|perl; 
export $PATH=~/sd/bin:$PATH; sd
rjmunro