trello2csv

trello2csv.rb

require 'json'
require 'csv'

json_data = JSON.load(File.read(ARGV.first))

list_names = json_data["lists"].each_with_object({}) {|b, memo| memo[b["id"]] = b["name"]}
lists = json_data["lists"].each_with_object({}) {|b, memo| memo[b["id"]] = []}

json_data["cards"].each do |card|
  list_id = card["idList"]
  name = card["name"]

  lists[list_id] << name
end

out = CSV.generate do |csv|
  csv << list_names.values

  i = 0
  loop do
    first_val = nil
    row = []
    lists.values.each do |l|
      first_val ||= l[i]
      row << l[i]
    end

    break unless first_val
    csv << row
    i = i+=1
  end
end

puts out