add_uploads_from_csv.rb

# encoding: utf-8
module Spotlight
  class AddUploadsFromCSV < ActiveJob::Base
    queue_as :default

    after_perform do |job|
      csv_data, exhibit, user = job.arguments
      Spotlight::IndexingCompleteMailer.documents_indexed(csv_data, exhibit, user).deliver_now
    end

    def perform(csv_data, exhibit, user)
      encoded_csv(csv_data).each do |row|
        if (url = row.delete("url")).present?
          Spotlight::Resources::Upload.create(
            remote_url_url: url,
            data: row,
            exhibit: exhibit
          )
        end
      end

    end
    private
    def encoded_csv(csv)
      csv.map do |row|
        row.map do |label, column|
          [label, column.encode('UTF-8', invalid: :replace, undef: :replace, replace: "\uFFFD")] if column.present?
        end.compact.to_h
      end.compact
    end
  end
end