Github Issues export to Assembla CSV

github_export.rb

require 'github_api'

components = %w{ tag1 tag2 tag3 tag4 }
users = {
'github-username' => 'new-system-username'
}

assembla_issues = []

client = Github.new login: 'user', password: 'password'

github_issues = client.issues.list_repo 'user', 'repo', per_page: 100

puts "FETCHED #{github_issues.count} issues"

github_issues.each do |issue|
  assembla_issues << {
    component: (issue.labels.map(&:name) & components).first,
    summary: issue.title.gsub('"', '\"'),
    assigned_to: issue.assignee ? (users[issue.assignee.login] || issue.assignee.login) : '',
    description: issue.body.gsub('"', '\"')
  }
end

File.open 'tickets.csv', 'w+' do |file|
  
  file << "summary,assigned_to,description,component\n"
  assembla_issues.each do |issue|
    file << ["\"#{issue[:summary]}\"", issue[:assigned_to], "\"#{issue[:description]}\"", issue[:component]].join(',')
    file << "\n"
  end

end