http://www.sapica.jp から SAPICA 利用履歴を取得するスクリプト

sapica.rb

#!/usr/bin/env ruby1.9

require 'rubygems'
require 'pit'
require 'nokogiri'
require 'mechanize'

config = Pit.get('sapica', :require => {
  'cardid' => 'your card id',
  'password' => 'your password'
})

agent = WWW::Mechanize.new
page = agent.get('https://www.sapica.jp/Login/')
form = page.forms.first
form.cardid = config['cardid']
form.password = config['password']
page = form.submit

history = []
doc = Nokogiri::HTML(page.body)
table = doc.xpath("//table[@id='historytable']")
table.xpath('tr').each do |tr|
  nodes = tr.xpath('td')
  rows = nodes.map{|r|r.text.sub(/^(?:\s|\xc2\xa0)+/,'')}
  history << rows unless rows.empty?
end

history.each do |h|
  [4,5].each {|i| h[i].gsub!(',', '')}
  puts h.join(',')
end