Ruby on Rails CSV导入报错：param缺失或为空(incident_datum)

Hey there, let's break down what's going wrong here and fix it step by step!

The Core Issue #

Looking at your console logs, your form is submitting to the #create action instead of the #import action you built. That's why you're hitting the param is missing or the value is empty: incident_datum error—your create method expects an incident_datum parameter, but your form only sends a file parameter.

Step 1: Fix the Form's Submission Target #

Your form is using incident_data_path, which maps to the #create action for your resource. Since you defined import as a collection route, you need to point the form to the correct path:

Update your ERB form code:

<div id="import" class="well" style="display:inline-block;width:100%">
  <h3 style="margin-top:0px;">Import Data</h3>
  <div id="" style="float:left; flex:1;">
    <%= form_tag import_incident_data_path, multipart: true do %>
      <%= file_field_tag :file, :style=>'width: 600px;' %>
  </div>
  <div style="float:right; flex:1;">
    <%= submit_tag "Import CSV" %>
  </div>
  <% end %>
</div>
<a class="btn btn-info" href="/incident_data/">Incident Data</a>

The key change here is swapping incident_data_path for import_incident_data_path—this tells Rails to send the form data to your #import action instead of #create.

Step 2: Fix the Import Controller Action #

Your current import method has a couple of issues:

• @IncidentDatum.save is invalid (wrong case for the instance variable, and IncidentDatum.import should handle saving logic itself)
• It doesn't properly handle success/failure states from the import

Update your controller's import method:

def import
  if IncidentDatum.import(params[:file])
    redirect_to root_url, notice: "Incident Data Imported!"
  else
    flash[:alert] = "Failed to import incident data. Check the file format and try again."
    render :new
  end
end

Step 3: Ensure Your Model's Import Method Works #

Make sure your IncidentDatum model has a properly implemented import class method to parse the CSV and save records. If you haven't already, add something like this:

class IncidentDatum < ApplicationRecord
  def self.import(file)
    CSV.foreach(file.path, headers: true) do |row|
      # Use create! to catch errors during import, or find_or_create_by to avoid duplicates
      IncidentDatum.create!(row.to_hash)
      # Alternative for duplicate prevention:
      # IncidentDatum.find_or_create_by(number: row["number"]) do |incident|
      #   incident.attributes = row.to_hash
      # end
    end
    true # Return true if import completes without errors
  rescue StandardError => e
    Rails.logger.error "CSV Import Failed: #{e.message}"
    false # Return false to trigger the failure path in the controller
  end
end

Step 4: Confirm Your Route #

Your route definition is correct, but you can double-check by running rails routes in your terminal—you should see a line like this:

POST   /incident_data/import(.:format)  incident_data#import

This confirms the import_incident_data_path points to the right action.

Once you make these changes, your form will submit directly to the #import action, bypassing the incident_datum_params check that was causing your original error, and your CSV data will be properly processed and saved to the database.

内容的提问来源于stack exchange，提问作者Mark