Hello Guys,
Let's discuss how to import .csv file into database using ruby processor.
Read the .csv file:
require 'fastercsv'
rows = CSV.read("#{RAILS_ROOT}/test.csv")
header = rows[0]
rows[1..-1].each do |row|
data = {}
header.each_with_index do |key, index|
data[key.downcase] = row[index].strip
end
ModelObject.create!(data)
end
header = rows[0]
rows[1..-1].each do |row|
data = {}
header.each_with_index do |key, index|
data[key.downcase] = row[index].strip
end
ModelObject.create!(data)
end
test.csv looks like
No,Name,Percentage
1,Priyanka,81
2,Rahul,82
3,Ruby,75
No comments:
Post a Comment