Quick and dirty script to convert Shinsei Power Direct "CSV" files into QIF files for importing into applications

convert.rb

#!/usr/bin/env ruby
#coding: SJIS
require 'rubygems'
require 'qif'
require 'csv'

file_path = ARGV[0]

bank_file = IO.read(file_path).force_encoding('utf-8')
bank_file = CSV.parse(bank_file, col_sep: "\t")

Qif::Writer.open("satement.qif", type = 'Bank', format = 'dd/mm/yyyy') do |qif|
	bank_file.each do |row|
		next if ( row.empty? || row[0] == "Activity For" || row[0] == "Current Balance"  || row[0] == "Start Date"   || row[0] == "Value Date" )
		row.each { |value| value.to_s.gsub!(/^\s+|\s+$/,'') }
		date = row[0].split("/").reverse.join("/")
		qif << Qif::Transaction.new(
	      :date         => date,
	      :amount       => row[3].nil? ? row[4].to_f : -row[3].to_f,
	      :memo         => row[1],
	      :payee        => row[2]
	    )
	end
end

Gemfile.rb

source "https://rubygems.org"

gem "qif"