Create a Cumulative Flow Diagram using Greenhopper

Ok so after much hunting around I have finally found a solution to creating a cumulative flow diagram using Greenhopper – albeit a workaround!

1) Download Toad for MySQL: http://www.quest.com/toad-for-mysql/

2) Connect to your JIRA Database

3) Use the following query to pull out accumulative totals – tweak parameters based on the project you are working on:

SELECT DATE_FORMAT(changegroup.CREATED, ‘%Y/%m/%d’) AS CountDate, changeitem.NEWSTRING, Count(changeitem.NEWSTRING) As Total
FROM changeitem
left outer JOIN changegroup
ON changeitem.groupid = changegroup.ID
left outer JOIN jiraissue
ON changegroup.issueid = jiraissue.ID
left outer JOIN projectversion
ON jiraissue.PROJECT = projectversion.PROJECT
WHERE jiraissue.PROJECT = ** Your Project ID**
AND changeitem.FIELD = ’status’
AND projectversion.vname = ‘Release 1′
GROUP BY CountDate, changeitem.NEWSTRING
ORDER BY CountDate ASC

4) Export your result set into Excel and create a pivot table
5) Change the graph to type Area
6) Summaries your results by running total

See Example here

Cumulative Flow Diagram example

Obstacles Welcome by Ralph de la Vega, 2009

So, it has been two months since my last blogger book review. After my previous read I was looking forward to my next book from Thomas Nelson but unfortunately my expectations weren’t met.

Obstacles Welcome is the story of Ralph de la Vega’s rags to riches progression to becoming the President and CEO of AT&T Mobility. My expectation of the book was a roller coaster story of personal development and growth, but instead it turned out to be a business theory book intertwined with elements of Ralph’s journey.

Now don’t get me wrong, there is nothing wrong with the theory and it is clearly effective in practice. Personally though, I found that I didn’t connect with the story and what should have been a compelling biography read more like a group of case studies from a university text book.

This is a pity as one cannot deny that Ralph is clearly a dynamic leader and gifted businessman. Obstacles Welcome is not the book for me; however, I recommend it to all those entrepreneurs out there interested in business development and growth.

You can find out a little bit more about Ralph on the site created for this book: http://www.obstacleswelcome.com

Long weekend in Bath with friends

What a great weekend! The mercury is dropping close to zero in the UK but that isn’t stopping us from getting out and about. It is a 3 hour journey from London out to the picturesque town of Bath. Our friends stay in the suburb of Odd Down which looks out over the city of Bath with views of the country side.

On Saturday we hit the town and local sites. Stonehenge was our first stop. Now to cut straight to it – I was expecting more. We stumbled on the site rather unexpectedly – it is situated around a busy intersection and literally looks like a spare field that a farmer sold off with a rock garden in it. Anyways that said I jaywalked across the road to get a couple pics instead of paying the 7 pounds entrance fee. After Stonehenge we stopped off at a local pub for lunch and then headed off the city centre.

We strolled along the river, past the rugby club and sports fields (odd to come across a Lacrosse match in the UK?) and finally landed up at the Roman baths. The 11 pound entrance fee was well worth it – loads of interesting historical facts and architecture. This leg of the journey was rounded off at the supposedly famous Sally Lunns for Sally Lunns buns – not sure what all the hype was about?

Anyway – all in all what a great time – we are definitely looking forward to going back and possibly exploring Bristol and surrounding areas in more detail. If you get a chance make sure you stop off in Bath!

View a Slideshow

Stonehenge Stonehenge Nance and I outside the pub Lloyd, SJ and Nance next to the river Shot of the Abbey from across the river Bath rugby stadium Lacrosse match being played with views of Bath behind Roman Baths Abbey next to the Roman Baths Roman Baths

Kabul 24 by Ben Pearson & Henry Arnold, 2009

This is my first book review for Thomas Nelson publishers. I am a supporter of their approach which provides bloggers with free books in exchange for reviews – great win-win idea! Anyway, here’s to many more books and blog reviews – enjoy.

kabul-24Kabul 24 captures the story of a group of Christian aid workers who risked their lives to serve the people of war-torn Afghanistan. The common thread that ties the aid workers together is the organisation they are a part of, Shelter Now International (SNI). The aim of SNI is to come alongside refugee communities and serve, love and care for them and provide for their day-to-day needs.

This true life story is set around the time of the 9/11 terror attacks and imminent American invasion of Afghanistan. The atmosphere surrounding the SNI team in Kabul rapidly changes becoming tense and unpredictable. A sense that things could go horribly wrong starts to creep up on the team; and what they certainly hoped would not happen, does. They find themselves caught up in a hostage drama that only God can pull them out of.

My opinion of this book certainly improved the further I progressed. I pushed through the first 50 pages, which I found rather weak, and I am glad that I did. I felt that more historical context could have been given to the characters and the SNI organisation. Once into the main body of the story, I found myself wrapped up in the emotion of the situation. I had found a good companion for my evening commute.

I found this story personally challenging and humbling, particularly the risk taken to serve these refugees. I am left wondering what is to become of Afghanistan. Such anger, deception and brokenness – one can only hope that God has a plan to heal and restore. Overall Kabul 24 is a good read and a book I recommend.

Piccadilly, Battersea Park fireworks and Mercedes Live 09 – what a weekend!

This weekend has been great fun! It all started with a golf outing, otherwise know as a “work training course”, on Friday up north in Harpenden. Caught the train with my golf clubs all the way there and back (oh so committed – not too many funny looks). 18 holes of golf, including a quick pit stop at the Wicked Lady (pub) for some beer battered cod and a brewski made for a fantastic start to the day. Rain and the waning light bought a swift end to the round and saw me heading back to London for the next leg of the journey. All Bar One in Piccadilly was the next meeting point. Great to see a number of South African friends and grab a fairly late Italian meal after walking the streets of Chinatown and round the West End.

After a lazy Saturday morning the wife and I hit the shops with avengence – driven by the icy chill to find winter coats. Two successful purchases and we were ready for the fireworks in Battersea Park. What a fantastic display!! Quick clip for you to view below. Heard so many SA accents in the queue on the way in – we are literally everywhere!

Sunday morning saw us up bright and early to traipse off to the Mercedes Live 09 end-of-season event. Braving the icy conditions we managed to see all the Mercedes drivers and cars along with 12,000 other Formula One fans – great experience. Thank the Lord it didn’t rain. What a weekend!

Mikka Hakkinen The queue outside the event Shot out over the Mclaren grounds Mclaren HQ Mclaren F1 car Lewis Hamilton after cruising round the track in the Merc Gull Wings DC signing autographs at Mercedes Benz Live 09

Day trip out to the white cliffs of Dover, Kent

Today we travelled east from Maidstone Kent to the cliffs of Dover. About a 40 min drive from Maidstone city centre along the M20. We decided to go on a National Trust walk and then for tea. There was a 3 pound entry fee to the National Trust area which has fantastic panoramic views of  the White Cliffs, France and Dover castle.

The ferry takes 30 min’s to reach France where a range of fresh produce shops can be found. Quite popular to do a monthly shop and wine restock – definitely got to try this some time!

View Slideshow

The white cliffs of Dover Dover's port Dover castle France in the distance Ferry leaving the port

What you need to relocate to the UK from SA

My wife and I have just gone through the process of relocating to the UK from SA. Along the way we have discovered loads of interesting sites and picked up valuable tips from friends see below:

South African and British flags

British Citizenship and Passport

If applying for British citizenship and a passport before your relocation ensure that you give yourself enough time as these can take up to 6 months to process. Also factor in the time for collecting the relevant documentation required from home affairs. Here is a link to the website used to help with the processing of my application: http://ukinsouthafrica.fco.gov.uk/en/passports/. Note that if your mother is of British descent and you were born before 1983 then you are eligible for a British passport. That was news to me…good news!

Visa

We used a company called 1st Contact to help us with the process of applying for my wife’s spousal visa. The reason for this being that it can be tricky figuring out all the documentation you need to send with the application. You don’t want to waste R 8,000 on a failed application. They handle all the paper work and admin which is great. Their services cost about R 2,000. I, along with a number of my friends in the UK, highly recommend them. 1st Contact also offer loads of other helpful services.

Money

So how do you get money into the UK? Here are a couple options that we considered.

FNB offer a Visa Travelex Card which you can load pounds onto and draw from any ATM in the UK. There are fees which you are charged for drawing this money on the other side, obviously these need to be considered. If you are interested go to the Forex desk at FNB and ask for a Travelex Card or phone 08601 FOREX (08601 36739). You should be able to buy similar products from your bank or a local Forex company.

An SA credit card comes in handy in the UK, especially if you are looking to rent a car when you arrive. You have to have worked for a period before a UK bank will give you a credit card over here and car rental companies will only accept credit cards for payment. Your credit card can also be used as an alternate source for loading money on to, which you can spend when in the UK. Double check the expiry date on your credit card before leaving.

Opening a UK Bank Account

UK bank accounts are not easily acquired as most banks require a utility bill with your name on it before opening an account. To help us with this process we signed up for 1st Contacts Kickstart package. As part of the service 1st contact organise an appointment with a selection of UK banks (Lloyds, Barclays, or HSBC) and write an accompanying letter, which the bank accept as an alternative to a utility bill. This allows you to quickly set up a bank account upon arrival while starting the process of applying for jobs…very helpful! The Kickstart package also includes O2 SIM cards and loads of other use full information and extras.

Flights

When booking flights, naturally, you will always look for the cheapest options. We booked one way flights through Student Flights and found their service fantastic.

One thing to consider when moving country is the baggage restrictions of the airline that you are flying with. We flew Virgin Atlantic, they restrict passengers to one large bag weighing up to 23 kg and one piece of hand luggage of up to 6 kgs per passenger (Hint: they don’t usually weigh this). There is a chance that you could be charged up to $ 25 per kg for overweight bags when checking in. This all however depends on the mood of the person booking you in on the day. Most airlines will allow you 5 kg leeway, in my opinion though, stuffing in that extra book isn’t worth the risk. If you have the cash and need to send over extra baggage calco cargo and u-bag.com offer unaccompanied baggage transfer services, which are worth considering.

One bonus discovery that I made is that most airlines offer a free allowance for golf clubs. You can transport 14 golf clubs, boots, umbrella and 12 balls. Pity they don’t have a free musical instrument allowance – had to leave my guitar behind, bleak! You can pick up a decent golf travel bag at theProshop for around R 800 (see below).

New travel bag I bought for my clubs - UK here we come!

Searching for employment

My advise is to get your CV out on one of the websites below upon arrival. Make sure that you include your correct UK mobile number – school boy error I made first time round! I was fortunate enough to be picked up by a specialist IT recruiter – Eurobase. There service has been fantastic and with their help I have managed to secure a job within the first month of being here. Here are a couple more good websites for job searching:

For any further information regarding applying for jobs and finding accommodation take a look at the 1st Contact website. Hope you found this info useful – you welcome to comment with any further suggestions for other readers.

Day trip through to Reigate Surrey

Today Nance and I day tripped through to Reigate Surrey. Reigate is approximately 4o min bus drive from Sutton where we are currently based (10 Pounds for two day passes on Metro Bus). The amazing views from Reigate Hill combined with the fantastic fading summer weather made for a perfect day. The biggest surprise of the day was Priory Park – wow – what an amazing facility for the community’s families. We arrived at the park around midday along with most of the towns business people, moms and tots on lunch break. After a quick walk around the park we stopped off for a pint and bite to eat at The Market Hotel. Couple photos of our adventure below.

View a slideshow

Reigate farm vista Reigate Panorama 6 Reigate Panorama 5 Reigate Panorama 4 Reigate Panorama 3 Reigate Panorama 2 Reigate Panorama 1 Nance with Reigate in the background Close up of Reigate Reigate Hill - North Downs Priory Park Priory Park Priory Park Priory Park - Gooooooose Priory Park The Market Hotel

Day trip to Leeds castle in Kent

If you find yourself near Maidstone in Kent make sure to venture out to Leeds castle. The castle is beautifully kept and has a number of interesting attractions (Castle itself and surrounding grounds, aviary, falconry, maze, restaurant, golf course etc…).  You pay 16 pounds 50 pence for a year long season ticket which allows you full access to the grounds and all facilities…great value if you have young kids! The castle is a 15 min drive from the centre of Maidstone, the county town of Kent.

View a slideshow

Arty castle shot 2 Arty castle shot 3 Courtyard inside the palace View of the moat One of the many black swans One of the castle turrets 9 hole golf course which is to one side of the castle Nice croquet lawn in front of the castle Arty castle shot Another maze victory

Science Museum and the Boathouse

This past weekend we have ended up doing a range of things. Friday started with an interview for me in the centre of London which went well and ended with watching the Dark Night which was flippen awesome – even Nancy enjoyed it! Steve, of course, donned his batman t-shirt for the occasion.

The great weather has continued to provide us with opportunities to get out and see London and on Saturday we hit the Science Museum. Our highlights were the F1 display, sponsored by Mclaren, and the Deep Sea the 3D Imax film narrated by Johnny Depp and Kate Winslet.

The evening saw us navigate our way to Putney to join friends at the Boathouse pub for a couple pints while peering over the Thames. I am quite amazed by the amount of air traffic in London – you can literally spot a new plane every 3 min. Chinese lanterns floating up from the park across the river provided a welcome break from tracking vapour trails.

There a couple photos below – please excuse the quality – I had to use the camera on Nancy’s phone after leaving ours at home. I am working on updating our photo gallery so that you can view the photos in a pop-up on the site and leave comments without having to click through to flickr.

View a slideshow

Computer monitored bike at the F1 display Nance at the F1 display First mechanical computer ever created Old school paddle boat Prince Albert Memorial Royal Albert Hall Vapour Trails