Synchronisation of Atlassian JIRA with LiquidPlanner

While Atlassian JIRA is a great tool to manage a project, it is not really convenient to handle (many) multiple simultanious projects, especially as people need to work on different projects at the same time. I recently discovered LiquidPlanner which claims to be really good at multi-project/multi-resources management. After the trial period, our company decided to go with it and is very happy with the results so far.

Since we have already much information in JIRA, we needed a way to pull this information into LiquidPlanner in an automated way. I wrote a small tool in Groovy that uses the LiquidPlanner REST API and the JIRA REST API to automate this. This blog entry will show how it works, part 2 will show the code to make it all work.

A typical way that we structure the project inside LiquidPlanner is as follows:

We have a project with 2 sub-projects: Implementation and Testing. Testing depends on Implementation obviously. We plan our testing time in LiquidPlanner and not in JIRA, so this is already done here. As you can see, there is no time allocated for implementation yet, but this is where our synchronizer kicks in.

What we want to do is get all issues from JIRA that have a fix version of V1.03 in the ‘ABC’ project for each person. We add up all the remaining estimates for each issue and put this as the remaining work for that person in LiquidPlanner. Since our structure in LiquidPlanner is totally arbritary, how can we do this?

Luckily, each item in LiquidPlanner has an ‘External Reference’ field. We can use this to reference the JIRA project and version we want to sync to:

The synchronizer will read all items from LiquidPlanner that have an external reference. Then, it will do a query on JIRA as follows:

project="projectKey" and fixVersion="versionString" and resolution="unresolved" and assignee="userName"

Note that for convenience we made sure the usernames in LiquidPlanner are the same as in JIRA. If you make sure the task owner in LiquidPlanner is the correct person, then the query will do its job.

After running the synchronizer, we get the following result:

It is really as simple as that. Just put in the good external references and the remaining estimates will get synced. Head over to part 2 to see the code behind this.

Advertisements

6 thoughts on “Synchronisation of Atlassian JIRA with LiquidPlanner

  1. It looks like both Atlassian and LiquidPlanner are interested in what you’ve done – perhaps you could release the source to them to allow them to productionise?

  2. Pingback: Synchronizing LiquidPlanner with Exchange calendars | Wim Deblauwe's Blog

  3. Hello
    We are trying to the reverse way ie From LiquidPlanner to JIRA , but we are struggling at a stage to create new Project in JIRA using API . Is there any work around for this in your opinion ? We are getting List of projects from LiquidPLanner using their API and we want to create the equivalent project in JIRA . Can we do it via API , If so can you share end point details?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s