Rake Import CSV with Ruby/Rails

import_csv.md

# frozen_string_literal: true

namespace :import do
  desc 'import CSV'
  task csv: :environment do
    csv_file = File.join Rails.root, 'tmp/file.csv'
    counter = 0

    options = {
      encoding: 'windows-1250', 
      headers: true, 
      row_sep: :auto, 
      col_sep: ';', 
      skip_blanks: true
    }

    CSV.foreach(csv_file, options) do |row|
      name = row['NAME'].presence

      params = {
        name: name
      }

      save_params = Table.find_or_create_by!(params)

      if save_params.persisted?
        counter += 1
        puts "#{counter} : #{params}"
      end
    end
  end
end

rake import:csv