A Kanban view for Things 3 : Part II – extracting the relevant information

In a previous blog post entitled Adding an efficient, higher-level project view layer to Things 3: a proposal , I put forth that while Things 3 is a great task manager for day to day activities, it is not ideal when a higher altitude view is needed. However a visual presentation with key information, at the project level, would accomplish this task without the need for a more complicated project manager application. In this post, I have taken a first step toward getting to that point by extracting the necessary information out of Things.

Cultured Code has made available an extensive documentation for extraction information from Things using AppleScript. I am in fact using it extensively to automate many processes on my Mac (I use Automator to make the scripts available system-wide and associated to key combinations…but this is for a future post!). For those interested in what you can do, here is the link to the official documentation: Things AppleScript Guide – Cultured Code.

However, with very little effort (read Google search!), I found out that Things database is actually a SQLite3 database. Lo and behold, you can view it directly using application like DB Browser for SQLite. It also means that if you have Xcode install, you can query that database yourself. Alexander Willner has done just that and made the framework available on GitHub. Since the package can be install via brew. I had to try it. Installing and issuing the command things.sh stat gives the results shown below.

Capture d_écran 2018-08-10 à 17.28.44

Now having said that, even better sqlite3 is part of the standard Python library and, yes, Python is on your Mac (with Xcode installed)!!! 

I decided to have a little coding project during my vacation, dedicating a few hours to extracting information from my Things3 database using Python. Following the guideline I set forth in Part I, the idea is to extract just the information relevant for the Kanban view described in that document. Well, it turns out it was relatively easy and here is the output of my Python script:

Capture d_écran 2018-08-10 à 17.31.40

Notice that out of 115 projects (from things.sh above) only 40 have a due date attached to them (the others are collection of tasks in the GTD sense) and those projects currently have 121 active tasks associated to it, ranging from 0 (this is me needing to review my projects but since I am in vacation, it will be done slowly in the coming days) to a high 25. Yes, I displayed only the uuid of the projects instead of the project names, so that there is no need to go to Photoshop for privacy(!).

 

However, I now have in a single tuple: the project names, due date, uuid (so that I can construct a link back to Things3 from anywhere!) and the number of active tasks under each project. I basically have all the necessary information that I requested in my mock-up Kanban view (below):

Diapositive2

Now the more difficult part (as least for me), I am in need of a graphical representation to transform my tuple into a nice visual Kanban representation for easy review…

Any volunteer to help?

Posted on August 10, 2018, in General stuff, Software, Technology and tagged , , , , , . Bookmark the permalink. 2 Comments.

  1. alexanderwillner

    Thanks for using my things.sh script. A kanban view is also on my wish list. I‘d suggest to generate a simple HTML5 page with some nice CSS based layout. A first version would be easy to implement. Others can make it pretty afterwards.

    Like

    • My first reaction was to export the tuple to a CVS file and use Import2 by Wizard to get the data in Trello for visualization (both free for personal, limited usage). But it somehow feel unsatisfactory…

      Like

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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s

%d bloggers like this: