enGrid Issue #22

README

Attachments for https://github.com/enGits/engrid/issues/22

Here are some links that I gathered while trying to figure out how to automated the transfer process from MantisBT to Github Issues:
 * https://gist.github.com/101002
 * https://gist.github.com/7f75ced1fa7576412901
 * http://stackoverflow.com/questions/7281304/migrate-bugzilla-issues-to-github-issue-tracker
 * https://github.com/Bazai/pivotal2github/blob/master/import_issues.rb

import_issues.rb

#encoding:UTF-8
#!/usr/bin/env ruby
#Source: https://github.com/Bazai/pivotal2github/blob/master/import_issues.rb

require 'rubygems'
require 'csv'
require 'httparty'
require 'json'
require 'highline/import'

def get_input(prompt="Enter >",show = true)
     ask(prompt) {|q| q.echo = show}
end
filename = ARGV.shift or raise "Enter Filepath to CSV as ARG1"

class GitHub
  include HTTParty
  base_uri 'https://api.github.com'

end
user = get_input("Enter Username >")
password = get_input("Enter Password >", "*")
GitHub.basic_auth user, password


visited_labels = []
CSV.open filename, :headers => true do |csv|
  csv.each do |r|
    body = {
      :title => r['Story'],
      :body => r['Description'],
    }
    labels = []

    if r['Labels'] != ''
      r['Labels'].split(',').each do |label|
        label = label.strip
        color ='' 
        3.times { 
          color << "%02x" % rand(255)
        }
       unless visited_labels.include? label
        labels << {:name => label, :color =>color} 
       end
      end
      labels.each do |label|
        p label
        # this hack doesn't care if you have an existing label - it just errors and moves on like a zen master
        # the server however is expected to be equally zen :D
        visited_labels << label[:name]
        label = GitHub.post '/repos/your_github_username/your_repository_name/labels', :body => JSON.generate(label)
        p label
      end
    end
    
    body[:labels] = r['Labels'].split(',').map {|l|l.strip} if r['Labels'] != ''

   
    p json_body = JSON.generate(body)
    issue = GitHub.post '/repos/your_github_username/your_repository_name/issues', :body => json_body
    p issue

    r.each do |f|
      if f[0] == 'Note'
        next unless f[1]
        body = { :body => f[1] }
        GitHub.post "/repos/Bazai/your_github_username/your_repository_name/#{issue.parsed_response['number']}/comments", :body => JSON.generate(body)
      end
    end
  end
end

mantis_xls_csv_2github.rb

#encoding:UTF-8
#!/usr/bin/env ruby
#Based on: https://github.com/Bazai/pivotal2github/blob/master/import_issues.rb
# NOTE: this script ended up not being used, because it would take longer to code
# and test the script rather than transfering manually 20 reports...

require 'rubygems'
require 'csv'
require 'httparty'
require 'json'
require 'highline/import'

def get_input(prompt="Enter >",show = true)
     ask(prompt) {|q| q.echo = show}
end
filename = ARGV.shift or raise "Enter Filepath to CSV as ARG1"

class GitHub
  include HTTParty
  base_uri 'https://api.github.com'

end
user = get_input("Enter Username >")
password = get_input("Enter Password >", "*")
GitHub.basic_auth user, password


CSV.open filename, :headers => true do |csv|
  csv.each do |r|
    body = {
      :title => r['Summary'],
      :body => r['Description'],
    }
    
    if r['Steps To Reproduce'] != ''
      body[:body] += r['Steps To Reproduce']
    end

    if r['Additional Information'] != ''
      body[:body] += r['Additional Information']
    end
    
    [ r['Category'] = ] case
    when 'bug'
      body[:labels] = ['bug']
    when 'feature request'
      body[:labels] = ['enhancement']
    end
   
    p json_body = JSON.generate(body)
    issue = GitHub.post '/repos/your_github_username/your_repository_name/issues', :body => json_body
    p issue

    r.each do |f|
      if f[0] == 'Note'
        next unless f[1]
        body = { :body => f[1] }
        GitHub.post "/repos/your_github_username/your_repository_name/#{issue.parsed_response['number']}/comments", :body => JSON.generate(body)
      end
    end
  end
end

mantisbt_XLS_export_with_manual_headers.csv