Import CSV to database using Rails 4.0.3

Question

I am new to Ruby on Rails.

I am using Rails 4.0.3, Ruby 1.9.3.

I tried to import CSV file from the sample "396-importing-csv-and-excel-master" But it is throwing error.

Error:

attr_accessible is no longer in use

and suggests to use Strong parameter. Can any one help me to import CSV using strong parameter?

I suggest you read the comments to that Railscast. You'll find an answer there. If you have more specific questions come back and ask here. — nimrodm, Mar 19 '14 at 08:08
@JeevanRoydsouza, **do not** add `random` code formatting to `words` that you `think` are `important`. It makes things hard to read. — Charles, Mar 19 '14 at 19:27

score 1 · Answer 1 · answered Jan 07 '15 at 20:53

1

Let's say you are importing Tasks. Use this way for strong parameters

def self.import(file)    
  CSV.foreach(file.path, headers: true) do |row|
    task = find_by_id(row["id"]) || new
    parameters = ActionController::Parameters.new(row.to_hash)
    task.update(parameters.permit(:id,:name))
    task.save!
  end
end

answered Jan 07 '15 at 20:53

srbhattarai

792
7
9

I know this one is old, but it was helpful. What puzzles me here is why the import code goes in the model rather than in the controller with the other actions that create or update from user input? – dlu Apr 17 '19 at 21:01

score 0 · Answer 2 · answered Mar 19 '14 at 08:10

0

attr_accessible is no longer use in rails 4. In rails4 just like params.require(:person).permit(:name, :age)

I think this can help you

answered Mar 19 '14 at 08:10

alex fang

66
2

Import CSV to database using Rails 4.0.3

2 Answers2