Integrating RequestTracker and flow.io

Image by petitshoo (http://www.flickr.com/photos/petitshoo/)For a year or 2 we have been using flow.io at the company I work at to track projects. About a year ago, we decided to use RequestTracker (RT) to track incoming helpdesk requests, and started incorporating tasks within projects. RT almost replaced flow.io, but it lacks in the visualization of the Kanban process. Rather than building a completely new Kanban board on top of RT, I decided to use flow.io as the visualization tool, and get some measurements thrown in as a bonus.

flow.io has a nice REST API interface, allowing you to get a lot of information about your boards, and create or update new tasks. Deleting tasks is done by updating a task to a status of Deleted, giving you the opportunity to undelete the task. I’ve worked with REST interfaces before, so I wasn’t expecting a whole lot of problems there.

The challenge was RT. RT is written in Perl, and uses something called Scrips to run little scripts when something changes on an RT ticket. Scrips are pieces of Perl code. And I’ve never done anything in Perl before… except for a few Mister House scripts.

Below are the steps I took to make this work. It is a work in progress, and I’ve put it on github as an Open Source project, so feel free to improve it, fork it, or whatever.

[Read more...]

Working on a little project

Picture by peneli

Hey guys, just wanted to let you know I’m still alive and hard at work…

I was planning on putting out some posts on how I integrated Request Tracker with Flow.io, but it takes a little longer than expected (my Perl knowledge is growing by the day though). It seems to work now, so keep your eyes on the blog, and I’ll post something next week or so.

Meanwhile, enjoy summer!

Office Tab brings tabbed documents to Word, Excel and Powerpoint

I’ve had this tool laying around in my to-do folder for a while now, and today seemed like a good day to take a look at it.

Office Tab brings the tabbed interface from IE, Firefox and Chrome to the Office suite. Instead of the user interface where each document is a separate window, you’re basically returning to the old interface from I think Office XP, where each application within the suite has one window, and there are multiple documents within that window.

The Free version allows you to include tabs in Word, Excel and PowerPoint. If you want tabs in Project or Visio, you’ll need the Professional or Enterprise version. A complete comparison of the versions is found here.

Office Tab 7 is available in 32-bit and 64-bit versions, and supports Office 2003, 2007 and 2010.

Forgotten password in Linux

It happens to me every so often, that I have to do maintenance on a Linux box, and I’ve changed my passwords around and can’t remember the password I used on that particular box (or even the user name…). I always have to hunt around the net, hoping I find something, so I thought I’d capture it on my own blog:

  1. Reboot the computer
  2. At the GRUB or LILO prompt, press escape.
  3. Go to the line that would normally boot, and press e to edit
  4. Go to the end of the command line, and add rw init=/bin/bash to it
  5. Press Enter, then press b to boot
  6. You should now be entered into a passwordless root shell
  7. Either set your password with passwd <username>, or see a list of users with cat /etc/passwd.
  8. Reboot again
  9. Happy times!

Hope this helps me (and maybe some else) in the future…

Progress Software Corporation’s first commercial..

As you may know, I do a lot of development in Progress OpenEdge 10, which used to be called Progress 4GL, which has been around for a few decades now. Here’s one of their first, if not _the_ first, commercial, from when the company was still called Data Language Corporation. 80′s style!