If you ever need to import data – live – from Jira to a google spreadsheet, this might help you.
- 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.
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.
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..
I was really excited when I found CrashPlan – The idea of being able to backup to both a local server, a friends server and to the cloud with the same tool, sounded to good to be true.
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.
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.
Long awaited prequel to A Fire Upon the Deep. The stories are taking place in the same universe, but are otherwise not connected. I don’t think that it matter what order you read them in – the important thing is that you read them.
Continue reading 'A Deepness in the Sky by Vernor Vinge.'»
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).
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.
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.
This is the first book, by Vinge that I’ve read and it couldn’t have started much worse than it did or end much better. aFud starts off with a family crash-landing their space ship on an uncharted planet, the parents get killed nearly right after planet fall and the kids have to survive in an alien and medieval society. Yuch! Sounds like the basis for a really bad young adult novel.