Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
| Comment: | Add basics of getting previous statements |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
b65738a784a4d14c10944f9c4b94777c |
| User & Date: | atomicules 2015-07-02 20:54:34 |
|
2015-07-04
| ||
| 11:21 |
Build it into a proper script
I'm not entirely sure whether a class structure is appropriate for this. At the - I'd got credits and debits the wrong way round | |
|
2015-07-02
| ||
| 20:54 | Add basics of getting previous statements check-in: b65738a784 user: atomicules tags: trunk | |
|
2015-07-01
| ||
| 20:26 | Check for Bulletin Board sumbit check-in: 3b0a9cbf4e user: atomicules tags: trunk | |
Changes to smile.rb.
50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 |
#array of hashes?
transactions = []
#Skip first row (ths)
rows = rows[1..-1]
rows.each do |row|
#Skip last row, maybe
unless row.elements.length == 1
date = row.elements[0].text
name = row.elements[1].text
credit = row.elements[2].text
debit = row.elements[3].text
transactions << { :date => date, :name => name, :credit => credit, :debit => debit}
end
end
#TODO: Need to figure out a way to get input for number of previous pages required. Well, a good way, perhaps limit by a date?
puts "Enter date back to fetch transactions to"
#Assume ISO thingy format
date_limit = gets.strip #.convert_to_date
#Previous statements
page = a.click(page.link_with(:text => "previous statements"))
#TODO: Then need to click the top most page and go back through each page.
#Write transactions out
#TODO: Might need to sort by date
File.open("smile.dat", "w") do |file|
transactions.each do |transaction|
file << Date.parse(transaction[:date]).strftime("%Y/%m/%d")+"\t"+transaction[:name]+"\n"
|
> | > > > < > > > > |
50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 |
#array of hashes? transactions = [] #Skip first row (ths) rows = rows[1..-1] rows.each do |row| #Skip last row, maybe unless row.elements.length == 1 #TODO: Need to skip BROUGHT FORWARD as well for previous item pages date = row.elements[0].text name = row.elements[1].text credit = row.elements[2].text debit = row.elements[3].text transactions << { :date => date, :name => name, :credit => credit, :debit => debit} end end #TODO: Need to figure out a way to get input for number of previous pages required. Well, a good way, perhaps limit by a date? puts "Enter date back to fetch transactions to" #Assume ISO thingy format? date_limit = gets.strip #.convert_to_date #Previous statements page = a.click(page.link_with(:text => "previous statements")) #Get first page of previous statements page = a.click(page.links_with(:href => %r{getDomestic} )[0]) #TODO: get transactions in the same way #then click back #TODO: This needs to be in a loop page = a.click(page.link_with(:text => "previous statement page")) #Need someway of stopping if I call the above in a loop. So probably check dates. #Write transactions out #TODO: Might need to sort by date File.open("smile.dat", "w") do |file| transactions.each do |transaction| file << Date.parse(transaction[:date]).strftime("%Y/%m/%d")+"\t"+transaction[:name]+"\n" |