Getting Nil value while importing csv file into rails database

Question

i am trying to import all csv file data to my rails db but one attributes Area value getting nil data

my csv file data

IN my Seed file

require 'csv'

csv_text = File.read(Rails.root.join('db/product_data1.csv'))
csv = CSV.parse(csv_text, :headers => true, :encoding => 'ISO-8859-1') do |row|
  Ada.create!( {
    Area: row["Area"], 
    Item: row["Item"],
    Year: row["Year"], 
    Value: row["Value"]
  } ) 
end

in rails console i am geeting Area data is nil.

Does this answer your question? CSV.foreach Not Reading First Column in CSV File — dbugger
– dbugger, Commented Mar 23, 2022 at 16:54
Please replace the picture of your CSV file with text, thereby allowing readers to cut-and-paste your CSV data to test their code. — Cary Swoveland
– Cary Swoveland, Commented Mar 23, 2022 at 17:41

adarsh · Accepted Answer · 2022-03-23 18:56:32Z

0

I change the code it work for me.

  Area: row["Area"], 
  Item: row["Item"],
  Year: row["Year"], 
  Value: row["Value"]

into

   Area: row[0], 
   Item: row[1],
   Year: row[3], 
   Value: row[4]

answered Mar 23, 2022 at 18:56

adarsh

3085 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Prateek Choudhary · Accepted Answer · 2022-03-24 08:31:48Z

0

You need to make sure the file is saved with the correct encoding. I tried the same data with your example code and it worked for me.

You can verify it by copying over the same data to excel / google sheets, and save as .csv.

You could also check out this answer CSV.foreach Not Reading First Column in CSV File

answered Mar 24, 2022 at 8:31

Prateek Choudhary

1265 bronze badges

Collectives™ on Stack Overflow

Getting Nil value while importing csv file into rails database

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related