Importing a .csv file into mysql Ruby on Rails

[Jeremiah Parrack]

I have tried to use Nokogiri just to grab all the data s i could go around saving it into an .csv file. However, I kept getting 503 errors so i had to work around it.

I have an excel file with rows   :name  :address  :phone  :image and i want to import this data into my preexisting database.



My preexisting table in ruby is
 create_table "restaurants", force: :cascade do |t|      t.string   "name"      t.string   "address"      t.string   "phone"      t.string   "website"      t.datetime "created_at", null: false      t.datetime "updated_at", null: false      t.string   "image"   end


I saved my .csv file in my db folder and added import.rake to lib/tasks
  require 'csv'     desc "Import restaurants from csv file"   task :import => [:environment] do     file = "db/restaurants.csv"     CSV.foreach(file, :headers => true) do |row|       Team.create {         :restaurant => row[1],         :address => row[2],        :phone => row[3],        :image => row[7]      }    end  end



when i run rake import i get
rake import rake aborted! SyntaxError: /Users/Jeremiah/rails/yelp/lib/tasks/import.rake:8: syntax error, unexpected =>, expecting '}'      :name => row[1],                        ^


it gives this error for each of the rows I tried to import.
I am also worried that I'm doing this wrong and it will mess up my db so any advice would be appreciated.

[Uzbek Jon]

The issue is not in the CSV file. It is in your ruby code. You must add double braces around your `create` method like this:
   Team.create({        :restaurant => row[1],        :address => row[2],        :phone => row[3],        :image => row[7]    })
Also, if you are worrying about the data in your database, then you should not be running this code in your production environment. As a test run, you can run this code in sandboxed rails console (`rails c -s`).