Import only specific columns about active_admin_import HOT 3 CLOSED

@codehugger , you can use callback in importer to modify csv_lines just before it pass to activerecord-import.

https://github.com/activeadmin-plugins/active_admin_import/blob/v3.0.0.pre/lib/active_admin_import/importer.rb#L103

from active_admin_import.

The code below works :) Thanks!

  active_admin_import validate: true,
    before_batch_import: proc { |import|
      import.headers = { 'SERIAL' => 'serial_number', 'NAME' => 'name' }
      import.csv_lines = import.csv_lines.map { |l| [l[0], l[2]] }
    }

A nice to have would be to not have to rely on a certain column order in the file. Is there a way to get the values for csv_lines using the 'serial_number' and 'name' keys instead of 0 and 2 array indexes?

from active_admin_import.

@codehugger , you can capture position of csv column and then collect using this positions.
Example

But this can be implemented using custom code in your callback

from active_admin_import.