Website information gathering

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.

Thanks,
Mike
LVL 10
mcrosslandAsked:
Who is Participating?
 
javajwsCommented:
QuicKeys:
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.
http://www.cesoft.com/products/quickeys.html

Or Windows Power Pro (free):
http://powerpro.webeddie.com/

I haven't used Windows Power Pro, but QuicKeys is VERY easy to use and is only $80 per user.
0
 
rockiroadsCommented:
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 http://www.windowsdevcenter.com/pub/a/windows/2005/04/12/automate_xp.html
0
 
Dushan De SilvaTechnology ArchitectCommented:
If you are using AS400 , best is DB2 with PHP. (Use DB2 ODBC Connector).

BR Dushan
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
rockiroadsCommented:
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). http://support.microsoft.com/default.aspx?scid=kb;en-us;168151

http://support.microsoft.com/?id=259100

other links regarding wininet
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wininet/wininet/handling_authentication.asp
0
 
mcrosslandAuthor Commented:
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.
0
 
mcrosslandAuthor Commented:
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?
0
 
rockiroadsCommented:
If u want macros then here is a cuirrent topic  http://www.experts-exchange.com/Applications/Q_21798846.html which may be of interest

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.