csv-runner-temp.rb

require "./lib/helpers"

events = [];

w.file_uploads.each do |f|
  puts "NEXT FILE\n\n\n"
  content = f.download
  CSV.parse(content, headers: true) do |row|
  d = row["AccountingDate"] || row["Accepted Date"] || row["Issued Date"]
  	payment_date = Date.strptime(d, "%m/%d/%Y %I:%M:%S %p")
  	description = row["Description"]
  	currency = row["Currency"] || "CAD"
  	total_amount = row["SubtotalAmount"].to_f + row["TipAmount"].to_f + row["TaxAmount"].to_f
  	puts [total_amount, currency]
  	amount_in_cents = if currency == "USD"
  		(total_amount * 100).to_i
  	else
		 (convert_currency_to_usd(
          total_amount,
          currency,
          payment_date
        ) * 100).to_i
  	end

    event = IntegrationEvent.create!(
      integrator_id: integrator.id,
      event: "event.payments.charge",
      identifiers: {"vendor": {}, "transaction": {"description": description}},
      modifiers: {
      	"payment_method": {
      	  "third_party_id": SecureRandom::uuid()
      	},
      	"amount_in_cents": amount_in_cents
      },
      metadata: {klick_csv:true},
      source_description: "csv",
      event_timestamp: payment_date
    )
    puts event.id
  end
end

puts "DONE"