def upload(file_name)
csv = IO.read(file_name).split("\n")
csv[1..-1].map do |x|
data = x.split(',')
sid = data[0].gsub(/"/, '')
puts sid
current_term = data[1].gsub(/"/, '').chop
number_of_payments = data[2].gsub(/"/, '').chop
Account.find_by(id: sid)&.update_columns current_term: current_term, number_of_payments: number_of_payments
rescue StandardError => e
puts data
puts e.message
next
end
end
upload('DOC-2021.csv')
05-10
2632
04-25
3072