Website information gathering

Posted on 2006-04-01
Last Modified: 2012-05-05
I have an associate that made a request the other day.

The company has numerous bank accounts some within one web login and others with other banks.

Her is what the request was.
They would like some type of automation that would log into the bank website, select the first account, find the current balance, and write it to a spreadsheet.  Then move on to the next account for that bank and do the same..  and so on.
Then access other online bank accounts and do the same.  
After the fact, I would like the spreadsheet emailed to certain recepients.  This is currently a manual daily proces but they would like it automated.

Question by:mcrossland
    LVL 65

    Expert Comment

    I would not recommened that, especially the web logons. Any hacker good use that info.
    I use online banking, and it obviously users a secure site. my userid is stored in cookies, all I ever do is enter my password credentials.

    However if you do want it, you could try installing macro software. See what that does. Not sure how well it could work on secure servers.
    Examples are listed here
    LVL 17

    Expert Comment

    If you are using AS400 , best is DB2 with PHP. (Use DB2 ODBC Connector).

    BR Dushan
    LVL 65

    Expert Comment

    Mike, the example I gave requires no coding, just settting up
    if you want to develop it, what language do you want to use? because on Windows, there is WinInet, which can be used to access ftp and http sites. I just checked for https and apparently it does that also, though I have never tried it with that (I have done FTP though).;en-us;168151

    other links regarding wininet
    LVL 10

    Author Comment

    thank you very much.  My initial thought was a PC macro that would record every move and keystroke since I have to navagate and then get data into a spreadsheet, then email it daily.
    there are a VERY large number of bank accounts that need to be reviewed daily and I am just trying save the treasurer some time in her busy day.
    LVL 10

    Author Comment

    strange.  I noticed that Automate is on the top of the list.  This product is currently being used by one of our vendors to grab info from an AIX server and then either fax or email to recipients.  That would be great if we could use a software that we already own.  I know it does half the functions I'm looking for but not too sure about how it would navagate several bank websites and pull the daily balance.  Have you had experience with that product?
    LVL 9

    Accepted Solution

    A must-have utility that automates time-consuming and repetitive computer tasks with customized hot keys, toolbars and much more. With QuicKeys the ability to customize and control your computer is virtually endless. Available now for Mac OS X, Windows, and Mac Classic.

    Or Windows Power Pro (free):

    I haven't used Windows Power Pro, but QuicKeys is VERY easy to use and is only $80 per user.
    LVL 65

    Expert Comment

    If u want macros then here is a cuirrent topic which may be of interest


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Training Course: Android App Development

    This course will involve creating widgets, customize list view, grid view, spinners, etc. Creating applications using audio, video, and SQLite database. Ending with publication on Google Play.

    Suggested Solutions

    This article will show, step by step, how to integrate R code into a R Sweave document
    If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
    In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
    In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now