Howto add default additional data to csv parsed from file? about active_admin_import HOT 15 CLOSED

before_batch_import: ->(importer) {
  #your manipulation with data before import 
  #.....
  importer.csv_lines.map! { |row| row << importer.model.catalog_id}
  importer.headers.merge!({:'Catalog Id' => :catalog_id}) #this line needed if you're reading CSV headers from file, otherwise just put :catalog_id at the end of :csv_headers  declarative array 
}

<p class="active_admin_import_hint">
   <%= raw(@active_admin_import_model.hint) %> 
</p>
<%= semantic_form_for @active_admin_import_model, url: {action: :do_import}, html: {multipart: true} do |f| %>
    <%= f.inputs name: t("active_admin_import.details") do %>

    <%= select_tag 'catalog', 
      options_for_select(Catalog.all.collect{|catalog| [catalog.name, catalog.id, {:name=>catalog.name}] }, {:prompt => 'Catalog'})%>

        <%= f.input :file, as: :file %>
    <% end %>

    <%= f.actions do %>
        <%= f.action :submit, label: t("active_admin_import.import_btn"), button_html: {data: {disable_with: t("active_admin_import.import_btn_disabled")}} %>
    <% end %>
<% end %>

   <%=f.input :catalog_id, as: :select, :collection => Catal.pluck(:name, :id)%>

 active_admin_import :validate => true,
 :template => 'admin/course_import' ,
 headers_rewrites: { :'subjectarea_id' => :subjectarea_id, :'generaleducation_id' => :generaleducation_id,},
 before_batch_import: ->(importer) {
                subject_names = importer.values_at(:subjectarea_id)
                 # replacing subject area name with subject area id
                 subjects   = SubjectArea.where(name: subject_names).pluck(:name, :id)
                 options = Hash[*subjects.flatten] # #{"Jane" => 2, "John" => 1}
                 puts options
                 importer.batch_replace(:subjectarea_id, options)

                  ge_names = importer.values_at(:generaleducation_id)
                  # replacing general education name with general education id
                  geneds  = GeneralEducation.where(name: ge_names).pluck(:name, :id)
                  options = Hash[*geneds.flatten] # #{"Jane" => 2, "John" => 1}
                  puts options
                  importer.batch_replace(:generaleducation_id, options)

                  # catalog_names = params[:catalog_id]
 #              # replacing author name with author id
 #              catalogs  = Catalog.where(name: catalog_names).pluck(:name, :id)
 #              options = Hash[*catalogs.flatten] # #{"Jane" => 2, "John" => 1}
 #              puts options
 #              importer.batch_replace(:catalog_id, options)
 #
               },
 :template_object => ActiveAdminImport::Model.new(
 #:hint => "file will be imported with such header format: 'body','title','author'",
 :csv_headers => ["title", "code", "description", "credit", "start_date", "end_date", "local_course_id", "prefix", "section", "prerequisites", "corequisites", "books_url", "registration_url", "active", "level", "school_id", "subjectarea_id", "course_area", "generaleducation_id", "instructor", "course_method", "seats_available", "class_full"] 
 )

ActiveAdminImport::Model.new(
 #:hint => "file will be imported with such header format: 'body','title','author'",
:catalog_id => nil, #<<<this

 :csv_headers => ["title", "code", "description", "credit", "start_date", "end_date", "local_course_id", "prefix", "section", "prerequisites", "corequisites", "books_url", "registration_url", "active", "level", "school_id", "subjectarea_id", "course_area", "generaleducation_id", "instructor", "course_method", "seats_available", "class_full"] 
 )

<p class="active_admin_import_hint">
   <%= raw(@active_admin_import_model.hint) %> 
</p>
<%= semantic_form_for @active_admin_import_model, url: {action: :do_import}, html: {multipart: true} do |f| %>
    <%= f.inputs name: t("active_admin_import.details") do %>
              <%=f.input :catalog_id, as: :select, :collection => Catalog.pluck(:name, :id)%>  #this works now
               <%= f.input :file, as: :file %>
            <% end %>
    <%= f.actions do %>
        <%= f.action :submit, label: t("active_admin_import.import_btn"), button_html: {data: {disable_with: t("active_admin_import.import_btn_disabled")}} %>
    <% end %>
<% end %>

 active_admin_import :validate => true,
 :template => 'admin/course_import' ,
 headers_rewrites: { :'subjectarea_id' => :subjectarea_id, :'generaleducation_id' => :generaleducation_id,},
 before_batch_import: ->(importer) {
                subject_names = importer.values_at(:subjectarea_id)
                 # replacing subject area name with subject area id
                 subjects   = SubjectArea.where(name: subject_names).pluck(:name, :id)
                 options = Hash[*subjects.flatten] # #{"Jane" => 2, "John" => 1}
                 puts options
                 importer.batch_replace(:subjectarea_id, options)
                  ge_names = importer.values_at(:generaleducation_id)
                  # replacing general education name with general education id
                  geneds  = GeneralEducation.where(name: ge_names).pluck(:name, :id)
                  options = Hash[*geneds.flatten] # #{"Jane" => 2, "John" => 1}
                  puts options
                  importer.batch_replace(:generaleducation_id, options)
               },
 :template_object => ActiveAdminImport::Model.new(
 :catalog_id => nil,
 #:hint => "file will be imported with such header format: 'body','title','author'",
 :csv_headers => ["title", "code", "description", "credit", "start_date", "end_date", "local_course_id", "prefix", "section", "prerequisites", "corequisites", "books_url", "registration_url", "active", "level", "school_id", "subjectarea_id", "course_area", "generaleducation_id", "instructor", "course_method", "seats_available", "class_full"] 
 )