Convert Upwork Transaction History to format suitable for Zoho Books

upwork-to-zoho-csv.rb

#!/usr/bin/env ruby

# Script to convert upwork transaction history to a CSV
# format that Zoho Books does accept.

require 'csv'
require 'pry'
require 'time'
path = ARGV.first

csv = CSV.read(path, headers: true)
csv = csv.entries.map do |row|
  row = row.to_h
  row['Date'] = Time.parse(row['Date']).strftime("%Y-%m-%d")
  row['Direction'] = row["Amount"].to_f > 0 ? "c" : "d"
  row["Amount"] = row["Amount"].to_f.abs()
  row
end

mod_csv = CSV.generate do |str|
  str << csv.first.keys
  csv.each do |x|
    str << x.values
  end
end

File.write(path, mod_csv)
puts "Generated modified CSV at: #{path}"