IMPORTING CSV FILE DATA IN RAILS

We would like to import data from a CSV file into an existing database table. I do not want to save the CSV file, just take the data from it and put it into the existing table.

We need to put the gem in your gemfile:-

gem 'roo'

def import
            file = "Desktop/rohit.csv"
           # or
          file = "Desktop/rohit.xlsx"    # you can import any csv or xlsx file
                 
          doc = Roo::Excelx.new(file, nil, :ignore)
          header = doc.row(1)          # if we need header
          (2..doc.last_row).each do |i|
              row = Hash[[header, doc.row(i)].transpose]
              puts "#{row["id"]}"
          end 
end

Comments

Popular posts from this blog

psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

CARRIERWAVE - UPLOAD ANY MEDIA (AUDIO , VIDEO AND IMAGE ) FILE IN RAILS

SELECT COUNTRY WITH STATE AND IT'S CITIES RAILS

RAILS: UPLOADING PHOTOS VIA AMAZON S3 AND PAPERCLIP (UPLOADING FILES TO S3 IN RUBY WITH PAPERCLIP)

SEARCHING USING AJAX IN RAILS

UPLOAD ANY MEDIA FILE IN RAILS USING PAPERCLIP

UNINITIALIZED CONSTANT PAPERCLIP::STORAGE::S3::AWS

CURL COMMAND ON RUBY ON RAILS

CHECK PASSENGER RUBY PATH