ActiveAdminImportable

CSV imports for Active Admin with one line of code.

Installation

Add this line to your application's Gemfile:

gem 'active_admin_importable'

And then execute:

$ bundle

Or install it yourself as:

$ gem install active_admin_importable

Usage

Add the following line into your active admin resource:

active_admin_importable

The Import button should now appear. Click it and upload a CSV file with a header row corresponding to your model attributes. Press submit. Profit.

Usefull options

active_admin_importable options

• :find_by => :id

Try find row by ID (or specified field) and update or create it.

• :reset_pk_sequence => true

After process primary key sequence will by reset (tested on PostgreSQL).

• :before_save => proc { |row| row[:salary] ||= 0 }

Modify field values before write (and before find, if present).

•  :replace_headers => {
       first_name: :name,
       whatsapp_link_location: :location
   }
  

Allows you to replace headers coming from the CSV (take into account that headers like "User Identification" will become "user_identification").

Custom Import Behavior

Need to do something special with the import? active_admin_importable accepts an optional block that will be called on each row, replacing the default functionality ( calling create! on the associated model). The associated model and a hash of the current row will get passed into the block. For example:

ActiveAdmin.register Product do
  active_admin_importable do |model, hash|
    store = Store.find_by_name(hash[:store_name])
    hash[:store_id] = store.id
    hash.delete(:store_name)
    model.create!(hash)
  end
end

Contributing

1. Fork it
2. Create your feature branch (git checkout -b my-new-feature)
3. Commit your changes (git commit -am 'Added some feature')
4. Push to the branch (git push origin my-new-feature)
5. Create new Pull Request