SirLunk
12-23-2006, 07:48 AM
Hi Folks,
Anyone up for a challenge?
First, let me say that I'm a newbie to this forum and this is my first post, so go easy ;)
Second, please bear in mind that I'm not a developer (although I have done plenty of windows and active directory scripting), so please presume that I know very little about this when you reply. For example, I don't even know how to determine the form fields on a page and then post to these via a command line script.
Third, please let me say that this isn't my first port of call. I have done a fair amount of research into tools and methods for achieving my objectives, but I haven't had much luck. (more info below)
Objective:
Create a script or automate a utility on my home computer (Windows XP) that will automatically login to my online banking site, retrieve my account balances and email them to me. Once complete, I will schedule the script to run daily. Given the requirement to schedule the script to run whether or not I happen to be logged in at the time, I am not looking to use a web browser plug in to create macros.
Details:
The web site in question is NatWest Bank's Online Banking site: https://www.nwolb.com. My username and password is 2732923467, YesImKidding. :D
The first step (as per NWOLB1.jpg -attached) is to enter a customer number and proceed to page 2. On page 2 (as per NWOLB2.jpg), users are prompted for random characters from their pins and passwords. Assuming the login is successful, page 3 displays lastlogin and any messages. The user clicks 'continue' and proceeds to a list of accounts and balances. The info on page 4 is what I'm looking to email to myself on a daily basis.
Requirements:
1. A command line utility or script that will open an SSL session to the web page, handle all cookie and referrer checks and then display the login page.
2. A mechanism for posting the customer number and virtually clicking the "Next button"
3. A mechanism for reading which characters from pin and password are required and then posting these in their individual boxes and clicking Next.
4. A mechanism for clicking Next on any subsequent message pages prior to the account balances page being displayed. There is usually only 1 message page, but sometimes another is added to warn customers about scams.
5. A mechanism to capture some, but not all of the text from the account balances page
6. A mechanism to email this info. I believe I can achieve this myself as I have several scripts, but I'd be interested in your approach as well.
7. A mechanism to then log out of the internet banking site.
Findings to date:
I've done a fair amount of research into command line tools and text based web browsers. The closest I got was cURL for windows with SSL support, but as cURL isn't a web browser, I couldn't find a way to handle cookies and all the redirecting that the web site does. I eventually gave up.
Finally... Can you help? Any ideas for solving the problem or perhaps just suggestions for other things I should look into? In my opinion, this should be fairly simple to achieve and I'm hoping that my failure to date is simply related to not really knowing where to start or what's available out there.
Thank you in advance for your help and guidance. I look forward to hearing from you and Merry Christmas / Happy Holidays to you all!
Regards,
Lunk
Anyone up for a challenge?
First, let me say that I'm a newbie to this forum and this is my first post, so go easy ;)
Second, please bear in mind that I'm not a developer (although I have done plenty of windows and active directory scripting), so please presume that I know very little about this when you reply. For example, I don't even know how to determine the form fields on a page and then post to these via a command line script.
Third, please let me say that this isn't my first port of call. I have done a fair amount of research into tools and methods for achieving my objectives, but I haven't had much luck. (more info below)
Objective:
Create a script or automate a utility on my home computer (Windows XP) that will automatically login to my online banking site, retrieve my account balances and email them to me. Once complete, I will schedule the script to run daily. Given the requirement to schedule the script to run whether or not I happen to be logged in at the time, I am not looking to use a web browser plug in to create macros.
Details:
The web site in question is NatWest Bank's Online Banking site: https://www.nwolb.com. My username and password is 2732923467, YesImKidding. :D
The first step (as per NWOLB1.jpg -attached) is to enter a customer number and proceed to page 2. On page 2 (as per NWOLB2.jpg), users are prompted for random characters from their pins and passwords. Assuming the login is successful, page 3 displays lastlogin and any messages. The user clicks 'continue' and proceeds to a list of accounts and balances. The info on page 4 is what I'm looking to email to myself on a daily basis.
Requirements:
1. A command line utility or script that will open an SSL session to the web page, handle all cookie and referrer checks and then display the login page.
2. A mechanism for posting the customer number and virtually clicking the "Next button"
3. A mechanism for reading which characters from pin and password are required and then posting these in their individual boxes and clicking Next.
4. A mechanism for clicking Next on any subsequent message pages prior to the account balances page being displayed. There is usually only 1 message page, but sometimes another is added to warn customers about scams.
5. A mechanism to capture some, but not all of the text from the account balances page
6. A mechanism to email this info. I believe I can achieve this myself as I have several scripts, but I'd be interested in your approach as well.
7. A mechanism to then log out of the internet banking site.
Findings to date:
I've done a fair amount of research into command line tools and text based web browsers. The closest I got was cURL for windows with SSL support, but as cURL isn't a web browser, I couldn't find a way to handle cookies and all the redirecting that the web site does. I eventually gave up.
Finally... Can you help? Any ideas for solving the problem or perhaps just suggestions for other things I should look into? In my opinion, this should be fairly simple to achieve and I'm hoping that my failure to date is simply related to not really knowing where to start or what's available out there.
Thank you in advance for your help and guidance. I look forward to hearing from you and Merry Christmas / Happy Holidays to you all!
Regards,
Lunk