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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Dushan De SilvaTechnology ArchitectCommented:
If you are using AS400 , best is DB2 with PHP. (Use DB2 ODBC Connector).

BR Dushan
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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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.
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?
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Programming

From novice to tech pro — start learning today.