generating json from csv file in Ruby

Question

I need to read a CSV file containing huge data and transform it into a JSON Object. I have written this code but the JSON Objects generated are having some error in it and is not according to my expectations.

def readFromFile(fileName)

        jsonFile = File.open('some.json','w')

         CSV.foreach(fileName,:headers => true, :header_converters => :symbol) do |row| 
         $jsonData['Email'] = {
              :subject => row[0],
              :body => row[1],
              :fromName => row[2],
              :fromEmail => row[3],
              :toName => row[5],
              :toEmail => row[6]
          }
          # puts "data is #{jsonData[jsonData.length-1]}"

          jsonFile.write(JSON.pretty_generate($jsonData));

         # CSV.parse(row).to_json
         # @jsonFile.write(JSON.pretty_generate(@jsonData));
       #   csv = CSV.new(fileName, :headers => true, :header_converters => :symbol, :converters => :all)
        #  csv.to_a.map {|row| row.to_hash }
    end

What is the error? Could you post it.

Papaya Labs
– Papaya Labs

2015-03-15 16:22:59 +00:00
Commented Mar 15, 2015 at 16:22 — Papaya Labs
– Papaya Labs, Commented Mar 15, 2015 at 16:22
it got fixed..thanks

qwas
– qwas

2015-03-15 17:02:51 +00:00
Commented Mar 15, 2015 at 17:02 — qwas
– qwas, Commented Mar 15, 2015 at 17:02

Papaya Labs · Accepted Answer · 2015-03-17 18:59:46Z

1

I think this code will help you ( I get it from http://jasonheppler.org/2014/07/12/parsing-csv-to-json/ ):

def readFromFile(fileName)
  def is_int(str)
    # Check if a string should be an integer
    return !!(str =~ /^[-+]?[1-9]([0-9]*)?$/)
  end

  lines = CSV.open(filename).readlines
  keys = lines.delete lines.first

  File.open('some.json', "w") do |f|
    data = lines.map do |values|
      is_int(values) ? values.to_i : values.to_s
      Hash[keys.zip(values)]
    end
    f.puts JSON.pretty_generate(data)
  end
end

edited Mar 17, 2015 at 18:59

answered Mar 15, 2015 at 16:41

Papaya Labs

1,0899 silver badges12 bronze badges

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

4 Comments

qwas Over a year ago

This worked smoothly..also could you guide me to some books which is starightforward in how to write programs in ruby using classes(similar to java) and regular expressions(RegEx in ruby)

Papaya Labs Over a year ago

I like Eloquent Ruby by Russ Olsen

Papaya Labs Over a year ago

Please check the answer if it helps u. :P

Papaya Labs Over a year ago

Yeah, there is a check with a 0 and one up row and one down row. Will be great if you click there ;-)

Collectives™ on Stack Overflow

generating json from csv file in Ruby

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related