Ruby: QuickTapSurvey to MailChimp converter.

qtsconverter.rb

#!/usr/bin/env ruby

# https://gist.github.com/mrded/17317466b3ebf71eb07a

require 'csv'

class MailChimpConverter
  attr_accessor :columns

  COLUMNS_HEADER = {
    :email => 'Email Address',
    :industry => 'Career interests',
    :graduation_year => 'Graduation year',
    :source => 'Source',
  }

  def initialize(options = {})
    @files = options[:files]
    @columns = []
    options[:files].each { |file| fill(file) }
  end

  def save
    CSV.open("output.csv", "wb") do |csv|
      # Add header
      csv << COLUMNS_HEADER.values

      @columns.each { |column| csv << column.values }
    end
  end

  private
  def fill(file)
    CSV.read(file).each do |column|
      email = column[6]

      @columns.push(
        :email => email,
        :industry => fix_industry(column[4]),
        :graduation_year => column[5],
        :source => File.basename(file, ".csv"),
      ) if email_is_valid?(email)
    end
  end

  def email_is_valid?(email)
    !/\A[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]+\z/.match(email).nil?
  end

  def fix_industry(value)
    # Escaping commas.
    industries = []
    CSV.parse_line(value).each do |industry|
      industries += [industry.gsub(/\,/, '\,')] # Replace ',' to '\,'
    end

    return industries.join(', ')
  end
end

MailChimpConverter.new(files: ARGV).save

Hi Tishan, unfortunately QuickTapSurvey doesn't support MailChimp Groups.

• MailChimp Knowledge Base - Lists
• Using groups to manage your lists
• Segmentation and Groups