Redmine

can you provide (attach) a sample graph produced by your query ?

Frederic Morin wrote:

can you provide (attach) a sample graph produced by your query ?

I can email you one if you want? It's essentially just a directed graph with nodes for open tickets (with ID and title) and edges for 'precedes' dependencies. Kind of a critical path diagram, although adding estimates to it would help with that.

Matthew W wrote:

I can email you one if you want?

I think you should attach a sample here, more than one person would be interested in seeing that..

I think you should attach a sample here, more than one person would be interested in seeing that..

Unfortunately it's a private project, not like super top secret or anything but at the same time not sure we want our dev stuff up here in all eternity. So probably best if you email me for it, sorry to be a pain.

Here is a complete ruby/rake solution :

namespace :redmine do
  task :graphviz => :environment do
    f = Tempfile.new('graphviz')
    f.puts "digraph redmine {" 
    Issue.find(:all).select do |i|
      !i.closed?
    end.map do |i|
      f.puts "#{i.id} [label=\"#{i.id}: #{i.subject.chomp.gsub(/((?:[^ ]+ ){4})/, "\\1\\n")}\"]" 
    end
    IssueRelation.find(:all, :include => [:issue_from, :issue_to]).select do |ir|
      ir.relation_type == "precedes" && !ir.issue_from.closed? && !ir.issue_to.closed?
    end.map do |ir|
      f.puts "#{ir.issue_from_id} -> #{ir.issue_to_id}" 
    end
    f.puts "}" 
    f.flush
    IO.popen("dot -Tpng -o /var/www/redmine_graph.png #{f.path}")
    f.unlink
  end
end

Jean-Baptiste Barth wrote:

Here is a complete ruby/rake solution :
[...]You can register it in "lib/tasks/graphviz.rake" and call it with "rake redmine:graphviz".
Any opinion about that ?

Nice, yeah that looks a lot cleaner than my shell script.

A couple of gotchas in that script are: it's doing some really crude word-wrapping on issue titles:

{{{
.gsub(/((?:[^ ]+ ){4})/, "\\1\\n")
}}}

because I couldn't figure out how to make graphviz do this - but maybe there's a better way. Also the label needs escaping for graphviz incase it contains a closing quote.

Imagine you might wanna customize where it puts the .png output too.

Cheers for tidying this up though, glad it's of use!

Re dependencies, I don't think it'd hurt to have a rake task in there with a runtime dependency on graphviz - it could warn people when run if graphviz isn't installed, but wouldn't affect the smooth running of anything else.

Here is a quick conversion to a controller that can be used inside a plugin:

class GraphvizController < ApplicationController
  unloadable

  def graph
    f = "" 
    f << "digraph redmine {\n" 
    Issue.find(:all).select do |i|
      !i.closed?
    end.map do |i|
      f << "#{i.id} [label=\"#{i.id}: #{i.subject.chomp.gsub(/((?:[^ ]+ ){4})/, "\\1\\n")}\"]\n" 
    end
    IssueRelation.find(:all, :include => [:issue_from, :issue_to]).select do |ir|
      ir.relation_type == "precedes" && !ir.issue_from.closed? && !ir.issue_to.closed?
    end.map do |ir|
      f << "#{ir.issue_from_id} -> #{ir.issue_to_id}\n" 
    end
    f << "}\n" 

    png = nil
    IO.popen("dot -Tpng", "r+") do |io|
      io.binmode
      io.write f
      io.close_write
      png = io.read
    end
    send_data png, :type => 'image/png', :filename => 'graph.png', :disposition => 'inline'
  end
end

No file is written on disk.
I just converted the script but some optimizations can be done when retrieving issues...

Jean-Philippe Lang wrote:

Here is a quick conversion to a controller that can be used inside a plugin:

[...]

No file is written on disk.
I just converted the script but some optimizations can be done when retrieving issues...

Thanks ! Actually I was wondering how to do that without a Tempfile, it's a perfect example...
And indeed, I didn't try to optimize it, it was just to show how it could be integrated to a rake task or something else in the app.

Is there already a plugin the code from Jean-Philippe Lang?
I use redmine to keep track over non ruby (on rails) projects, so I really dont know how to really do anything ruby related.

Really cool would be if I could set different filters, and if closed issues that are blocking ore preceeding other issues would be shown also, perfectly in another color. Different arrow-types for blocking, duplicate, preceeding would be awesome too :D

Since we cannot vote on features (at least not that I am aware of), I am writing this post to state that I would love to see the Graphiviz feature too!

+1

You could use redmine-wiki-external-filter-plugin to integrate this external program call when writing a <macro>show_issue_graph</macro> on a wiki seite where this png file will be embedded instead.

I've just created a plugin based on the controller code Jean-Philippe posted in #9. It's available on Github at https://github.com/mpalmer/redmine_issue_dependency_graph. At the moment it only does a graph of issues in a particular version, but I might go nuts one day and write a full "show me all issues related to this one" tree graph.

related:

issue relations network view
Workflow Enhancements -Part2

Matt Palmer wrote:

I've just created a plugin based on the controller code Jean-Philippe posted in #9. It's available on Github at https://github.com/mpalmer/redmine_issue_dependency_graph. At the moment it only does a graph of issues in a particular version, but I might go nuts one day and write a full "show me all issues related to this one" tree graph.

Hi Matt,

I tried to install your plugin with the actual redmine (2.5.2) with no success (I have no error on terminal when installing, but nothing appears on the plugin administrator tab on redmine). Have you tried to install it in new redmine versions?

Your plugin is the only one I have found that graph the dependencies between the issues, really valuable. Is there another one now around?.

Thanks in advance,

Santiago

+1

Hi,
I successfully migrated this plugin to Redmine 2.3.1. My pull request is available here: https://github.com/mpalmer/redmine_issue_dependency_graph/pull/2
Best of whishes,
Zły Kapitan

Hi Matt,

I was wondering if your plugin has been updated for the latest version of Redmine. If so, could you please send it to me?

Matt Palmer wrote:

I've just created a plugin based on the controller code Jean-Philippe posted in #9. It's available on Github at https://github.com/mpalmer/redmine_issue_dependency_graph. At the moment it only does a graph of issues in a particular version, but I might go nuts one day and write a full "show me all issues related to this one" tree graph.