Contents

require "smart_importer/version"
require "smart_importer/spreadsheet"
require 'rubygems'
require "roo"
require "logger"
require "active_support/all"

module SmartImporter
  class Importer
    def initialize(file_path:, model:, key_attribute: id)
      @file_path = file_path
      @model = model
      @xlsx = Roo::Spreadsheet.open(@file_path.to_s)
      @number_of_imported_records = 0
      @key_attribute = key_attribute
    end

    def import_all
      import_sheets([e-mail]-1)
    end

    def import_sheet(sheet)
      import_sheets(Array(sheet))
    end

    def import_sheets(sheet_array)
      raise 'Import sheets expects an array of sheet numbers.' unless sheet_array.to_a.all? {|i| i.is_a?(Integer) }
      logger = Logger.new(STDOUT)
      logger.info "Importing #{@entity_type.to_s.underscore.pluralize} from #{@file_path}..."
      begin
        import_these_sheets sheet_array
      rescue => exception
        logger.error "Failed to import #{@entity_type} because #{exception}"
      else
        logger.info "Done importing. Imported #{@number_of_imported_records} #{@entity_type.to_s.pluralize}."
      end
    end

    private

    def import_these_sheets(sheet_array)
      @xlsx.sheets.each do |sheet|
        @xlsx.default_sheet = sheet
        spreadsheet = Spreadsheet.new(sheet: @xlsx, model: @model, key_attribute: @key_attribute)
        @number_of_imported_records += spreadsheet.import_objects
      end
    end
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
smart_importer-0.1.0	lib/smart_importer.rb