Have a look at this branch compare. (https://github.com/driftingrub...

You basically will need to temporarily create a file to store it and pass the path to ActiveJob. While this is currently working on local filestore, it can also work with S3 or fog.

The * is a splat operator. So, take the following example.

[2] pry(main)> fields
=> ["first_name", "last_name"]
[3] pry(main)> User.first.attributes.values_at(fields)
User Load (0.5ms)SELECT`users`.* FROM `users` ORDER BY `users`.`id` ASC LIMIT 1
=> [nil]
[4] pry(main)> User.first.attributes.values_at(*fields)
User Load (0.5ms)SELECT`users`.* FROM `users` ORDER BY `users`.`id` ASC LIMIT 1
=> ["System", "Administrator"]

http://blog.honeybadger.io/rub...

The ! at the end of find_or_create_by will raise an exception on validation errors.

How do I export nested attributes to CSV? i.e. I have a primary contact model, and I nested secondary contact into it. How do I export both as single CSV file?

What's the best approach to this using the Kaminari Gem so that I can pull all rows in the index, not just the amount listed on the first page? ``` def index search = params[:term].present? ? params[:term] : nil @nodes = if search Node.search(search) else Node.order(:node).page(params[:page]) end respond_to do |format| format.html format.csv { send_data @nodes.to_csv, filename: "nodes-#{Date.today}.csv" } end end ```

You can do a check if the `request.format.csv?` is true and exclude the `page(params[:page])` method.

Wow, that was easier than I thought it was going to be. Thank you!! :)

unknown attribute 'account_number' for Customer. 

def import
  Customer.import(params[:file])
  redirect_to customers_path, notice: "Customers Imported."
end

  def self.import(file)
    CSV.foreach(file.path, headers: true) do |row|
      customer_hash = row.to_hash
      customer = find_or_create_by!(sla_number: customer_hash['sla_number'])
      customer.update(customer_hash)
    end
  end

 <%= form_tag import_customers_path, multipart: true, class: 'form-inline' do %>
   <%= file_field_tag :file, class: "" %>
   <%= submit_tag "Import CSV", class: "btn btn-info" %>
<% end %>

  create_table "customers", force: :cascade do |t|
    t.string "name"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
    t.string "account_number"
    t.string "sla_number"
    t.string "mobile_phone"
    t.string "work_phone"
    t.string "home_phone"
    t.string "municipality"
    t.string "main_product"
    t.string "contract_name"
    t.date "contract_from"
    t.date "contract_to"
  end

bin/spring stop

  def self.import(file)
    CSV.foreach(file.path, headers: true, header_converters: :symbol) do |row|
      customer_hash = row.to_hash
      customer = find_or_create_by!(sla_number: customer_hash[:sla_number])
      customer.update(customer_hash)
    end
  end