col_active_importer_starter

col_active_importer_starter is a starter(or wrapper) to active_importer - https://github.com/continuum/active_importer gem.

Features

col_active_importer_starter makes full use of active_importer gem to import tabular data from spreadsheets or similar sources into Active Record models.

The best practices of active_importer, such as:
- Custom parameters · continuum/active_importer Wiki - https://github.com/continuum/active_importer/wiki/Custom-parameters
- Events and callbacks - https://github.com/continuum/active_importer/wiki/Callbacks.
Introduce a optional cache to retain data in the memory
Use rubyXL to write out a file with the original data and more information for result

Installation

Add this line to your application's Gemfile:

gem 'col_active_importer_starter'

And then execute:

bundle

Or install it yourself as:

gem install col_active_importer_starter

Usages

Suppose there is a ActiveRecord model Article:

class Article < ApplicationRecord

end

and tabular data file data/Articles.xlsx

Title	Body
Article.1.title	Article.1.body
Article.2.title	Article.2.body

Create a ArticleImporter extend ColActiveImporterStarter::BaseImporter

# app/importers/article_import.rb

class ArticleImporter < ColActiveImporterStarter::BaseImporter
  imports Article

  transactional
  module ColumnName
    Title = "Title"
    Body = "Body"
  end

  column ColumnName::Title, :title
  column ColumnName::Body, :body

  def handle_fetch_model
    params = {
      title: row[ColumnName::Title],
    }

    model = Article.find_or_initialize_by(params)

    model
  end

  fetch_model do
    handle_fetch_model
  end

  def handle_skip_rows_if?
    row[ColumnName::Title].blank?
  end

  skip_rows_if do
    handle_skip_rows_if?
  end

  # ArticleImporter.execute
  def self.execute(file = "#{Rails.root}/data/Articles.1.xlsx")
    params = {
      cache: {},
      file: file,
      result_index: 10,
    }
    import(file, params: params)
  end

  private
end

Import data from a file.

ArticleImporter.import("#{Rails.root}/data/Articles.1.xlsx")

# Or use ArticleImporter instance.
# importer = ArticleImporter.new(file, {params: params(file)})
# importer.import
# puts importer.row_count

Or specify more arguments.

params = {
  cache: {},
  file: "#{Rails.root}/data/Articles.1.xlsx",
  result_index: 3,
}

ArticleImporter.import(file, {params: params})

# Or use ArticleImporter instance.
# importer = ArticleImporter.new(file, {params: params(file)})
# importer.import
# puts importer.row_count