trello-export-to-csv.rb

require 'json'

file = ARGV[0]

unless file
  puts "Usage: ruby #{$0} <json filename of the export>"
  exit
end

unless File.exist? file
  puts "File #{file} not found."
  exit
end

content = JSON.parse(File.read(file))

lists = content['lists'].reduce({}) do |a, c|
  a[c['id']] = c['name']
  a
end
                                                                                                                                                                                                                                                                                                                                                                             
parsed = content['cards'].reduce('') do |a, c|
  labels = c['labels'].reduce([]) do |x, l|
    x << l['name']
    x   
  end 
  a << "\"#{lists[c['idList']]}\";\"#{c['name']}\";\"#{labels.join(', ')}\"\n"
  a
end
puts "\"Month\";\"Topic\";\"Labels\"\n"
puts parsed