Associations

[asecondwill]

How can I go about importing associations? I've tried adding it to the CSV like this

 first_name,last_name,email,encrypted_password,industry
Joe,Blogs,user@example.com,12345678,gardening 

but i just get an "Missing column for value at index 4" error. I guess because there isn't a Industry column on the user model.

[Fivell]

@asecondwill , is there industry_id column ? If yes take a look to example https://github.com/activeadmin-plugins/active_admin_import/wiki/change-columns-on-the-fly-by-association

StackOverflow

http://stackoverflow.com/questions/26131855/ruby-activeadmin-csv-custom-import/28066000#28066000

ActiveAdmin.register Post  do
             active_admin_import validate: true,
              headers_rewrites: { :'Author name' => :author_id },
              before_batch_import: ->(importer) {
                authors_names = importer.values_at(:author_id)
                # replacing author name with author id
                authors   = Author.where(name: authors_names).pluck(:name, :id)
                options = Hash[*authors.flatten] # #{"Jane" => 2, "John" => 1}
                importer.batch_replace(:author_id, options) #replacing "Jane" with 1, etc
              }
         end

[asecondwill]

ok. cool. got it. thanks fivell