Convert AmEx travel expense CSV output to PDF files

amex_travel_expenses_to_pdf.rb

#!/usr/bin/env ruby

require 'rubygems'
require 'csv'
require 'bigdecimal'
require 'prawn'                           # gem install prawn
require 'prawn/measurement_extensions'
require 'prawn/table'                     # gem install prawn-table

raise "No CSV file given" if ARGV[0].nil?
csv = ARGV[0]
raise "CSV file #{csv} does not exist" if !File.exist?(csv)
pdf = File.join(File.dirname(csv), File.basename(csv, '.csv') + '.pdf')

table_data = []
CSV.foreach(csv, headers: false) do |r|
  eur = r[2].strip
  next if eur.gsub(",",".").to_f < 0
  table_data << [
    ["Date",        Date.parse(r[0])],
    ["Amount",        "€ #{eur}"],
    ["Creditor",     r[3]],
    ["Info", r[4].gsub("&#8364;","EUR")],
  ]
end

Prawn::Document.generate(pdf, page_size: 'A4',
                         info: { Title: 'Travel Expense Report' }) do
  font_size 8
  table_data.each_with_index do |row, index|
    table(row, width: page.dimensions[2]/1.2, position: :center) do
      cells.overflow = :shrink_to_fit
      cells.style do |c|
        c.background_color = 'FFFFFF'
        c.style(:width => BigDecimal.new('1.5').cm) if c.column == 0
      end
    end
    start_new_page unless (index == table_data.size - 1)
  end
end