Author Archives: TC

Jira vs Google Doc importXML

If you ever need to import data – live – from Jira to a google spreadsheet, this might help you.

You’ll need:

  • The Url of your Jira server (I’ve only tested with ondemand)
  • Username and password to an account with rights to export xml
  • This list of jira fieldnames (not the same as jql)

 

Now open a spreadsheet or create a new one.

Now insert something like this.

=ImportXML(“https://yourserver.atlassian.net/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?

jqlQuery=project+in+%28%22Projectname%22%29+ORDER+BY+Rank+ASC&

tempMax=1000

&field=summary&field=timeoriginalestimate&field=timespent

&os_username=alice&os_password=bob“, “//item”)

You need to change the text in red to something that will work for you. And make it all one line – I just broke it down to make it easier to read.

As you can see I’ve listed the fields I need – you don’t need to do this if you don’t mind getting a lot of data. Remember to use the fieldliste above – not all fieldsnames match their jql names.

The last part of the statement – the xpath – tells google doc, which xml elements to extract. It’s actually a bit to simple her, as the timeoriginalestimate and timespent fields have a “seconds” attribute, that may be easier to work with the the text “2.54h” text returned by the field it self.

Change the xpath to something like “//item | //item/timespent/@seconds | //item/timeoriginalestimate/@seconds” to get the attributes (which is a bit useless for what I want as google places them on separate rows and only does it if there actually is an attribute – which makes it hard to know which value was returned if only one fo them exist in the xml – I’ll note it here what I end up with). The alternativ is something =if(C9<>””, value(left(C9,LEN(C9)-1)), “”) on the hour columns.

Have fun!

Native boot

I’ve been running my development enviroment in a Virtual Box for a while. Ubuntu in a box on top of Windows 7 (on dual 2.2GHz, 3Gb ram).

Best of both worlds right?

Well it isn’t exactly fast. Here’s a few rough timings:

Windows boot cold to online: 170 seconds

Boot virtuel ubuntu maskine to login: 53 seconds

Start Aptana (in virtual machine): 54 seconds

Start rails (in virtual machine): 35 seconds

So I found my old desktop, which I though had died, but fortunetly it hadden’t, cleaned it up and installed ubuntu(a bit old and slower CPU (dual 1.8GHz, 3Gb Ram)).

Boot ubuntu maskine to login: 50 seconds (about 15 of those are bios)

Start Aptana: 20 seconds

Start rails: 15 seconds

Quite a bit faster – and best of all, it doesn’t seem to lock up all the time, like the Virtual machine did..

 

Visual Impact Priority (VIP)

My job includes the weekly iteration kick off for a development team. We look at the tasks for the week and prioritize them. Some tasks are front-end and some are back-end. Some are look’n’feel and some are more technical. And the end of the week, we demo it for everybody in the company.

I’ve long had a feeling that, at the end of the week, the more visual aspects of the tasks at hand had had less “love” then they warrant. Lets say we add a new page – all the new fields will be there, the new needed functionality will be implemented, but the visual glue, that’s supposed to pull it all together is somehow missing. It gets pushed to next week, where the same thing happens.

Continue reading

Stop saying that: Everybody is a sales guy

I’ve heard this quite a few times in my twenty+ years in business. I’ve had different thought about it depending on time and place – but I think it’s safe to say that most of my thought weren’t that nice.

It’s mostly a question of missing context and having the wrong audience. Allow me to explain.

Continue reading

Frameshift by Robert J Sawyer.

I’ve waited a bit before I started on this review, in the hope that my feelings for this book would somehow clarify. But the truth is that I still don’t really know whether I like it or not. I’m not even sure that I can classify this book as science fiction (not that there’s anything wrong with that – but the blurb on the back cover calls it hard science fiction).

Continue reading

The Terminal Experiment by Robert J Sawyer.

After the bad experience with Frameshift, I didn’t really want to starting on a new story by Sawyer. But, everybody deserves a second chance and when a friend ruthlessly dumped The Terminal Experiment (TTE) on me, I decided to give it a go. Bad decision! TTE is even more annoying and error ridden than Frameshift and makes for a fairly bad experience that nobody should have forced on them. I’m not sure why I even finished it.

Continue reading

Preparing for recording a screencast

Stuff I do before I start recording a new screen-cast.

  • Something physical. 10-20 minutes before I start, I do twenty push-ups or similar. Something to get my blood pumping. Allow enough time for your breathing to become normal again.
  • Clear my nose. Make sure breathing is as unhindered as possible. Sometimes I use saltwater spray to help.
  • Close down software. Close down Skype, Outlook, etc, anything else that will popup and especially the ones making notifications sounds.
  • Mute phone, and put it away, so that it wont make speakers go woop-woop, when there’s an incoming call. Turn of your speakers if you can.
  • Prepare story. Make sure every step is planned. Make sure every stop works.
  • Drink a bit of water. Yeah, coffee is King, but water removes clears the mouth better.

That’s it. The last one is of cause a bit more involved, but that’s a topic for another post.