Finally finished it.
It has been a busy 2 months personally, with my wife’s 30th birthday and her various parties, upping running training to start tackling Marathons (and hopefully at the back end of 2016, Ultra 50ths), plus all my myriad of coding projects, including Windows 10 development and Windows 10 Internet of Things (IoT) for a Raspberry Pi App – more on that soon.
One of my coding projects is an App for the Clarizen Appathon. For anyone who does not know, Clarizen is a Project Management collaboration and tool, and honestly I’m a big fan. Clarizen comes with a a very good Custom Engine for building:
- Custom Fields
- Custom Work flows
- Custom Visualisations using HTML/JS (Called Panels)
- Custom Business Logic
- Not really part of the Customisation Engine but a robust RESTful API
This is very good, because there are some areas which Clarizen struggles with, one being their Agile/Scrum implementation. There are various bespoke add-ons for this area but they are not very good.
Which is where I come in.
I decided to try and create an interface to my favourite (free, as Clarizen is an Enterprise implementation) tool outside of work – Trello. This project grew larger than I expected, mainly due to the fact that I also decided to write a Clarizen .NET code library to wrap around their RESTful services. So that is what I did. Because I only wanted to pull down Tasks from Clarizen, I concentrated on the necessary actions from the list to accomplish this:
* Authentication / Session ID
* Metadata (DescribeEntities)
* Query and a simple Clarizen Query Language (CZQL) implementation.
I have of course used great frameworks like Newtstonsofts JSON.NET and json2csharp to create my POCO’s and built a brute-force alpha-stage API. I enjoyed doing this very much and plan in the following month to get these issues completed:
So once I have the bare basics of this done, I moved onto the quick and easy Clarizen2Trello console application, that pulls down tasks and updates Trello (Tasks as cards within various Todo/Doing/Done lists). here is a snippet:
.Where("StartDate > 2015-06-01");
foreach (Bradaz.Clarizen.API.Models.Task t in client.Tasks)
if (t.RemainingEffort.Value == t.Work.Value)
Card newCardTodo = trello.Cards.Add(new NewCard(t.Name, todo));
trello.Cards.AddComment(newCardTodo, "Remaining Effort is : " + t.RemainingEffort.Value);
if (t.RemainingEffort.Value == 0)
Card newCardDone = trello.Cards.Add(new NewCard(t.Name, done));
trello.Cards.AddComment(newCardDone, "Remaining Effort is : " + t.RemainingEffort.Value);
Card newCardDoing = trello.Cards.Add(new NewCard(t.Name, doing));
trello.Cards.AddComment(newCardDoing, "Remaining Effort is : " + t.RemainingEffort.Value);
Easy! Its the Trello.Net and Clarizen.Net API’s that are doing the grunt. Here is a quick video explaining how it works:
Code can be found here:
A little bit of Clarity.
Watch this space.