gistfile1.rb

    def build_address_lines(record)
      lines = []
      %w{store_name address1 address2 address3}.each do |field|
        lines << record[field].strip unless record[field].blank?
      end
      last_line = ''
      %w{city state zip country}.each do |field|
        last_line << ' ' + record[field].strip unless record[field].blank?
      end
      lines << last_line unless last_line.blank?
      lines
    end

    csv.map do |line|
      customer = {
        name:          line['name'].strip,
        number:        line['number'].strip,
        region:        line['region'].strip,
        inventory_source: line['source'].strip,
        access_key:    line['key'],
        address_lines: build_address_lines(line),
        locations:     []
      }

      first = true
      line.children.each do |location|
        customer[:locations] << {
          number:        first ? '' : location['store_number'],
          name:          location['store_name'],
          address_lines: build_address_lines(location)
        }
        first = false
      end

      if customer_record = Customer.where(number: customer[:number]).first
        customer_record.update_attributes!(customer)
      else
        Customer.create!(customer)
      end
    end
  end