Downloading a file from website

Hello Guys!!!

I have a situation in WM that I have to login to the following site “https://intrustbank.ebanking-services.com/beplus_w2k/default.asp
and manually access the following folders on the left side of the page, select Accounting Reporting/Transaction Report.
That will take you to a page that allows you to select what information to extract for the file.(Please look at the sample data below)

Basically login to the above site and click the “Accounting Reporting/Transaction Report” folders where it will take you to the
different screen and pick the file in what ever format you would like to be based on the dates.

01,0054692306,340854,040708,1557,1,80,80,2/
02,340854,101100029,1,040601,0000,USD,2/
03,0040180107,USD/
16,301,75350,0,/
16,475,3000,0,00000016610,00000016610,/
16,475,15210,0,00000016580,00000016580,/
16,475,20280,0,00000016599,00000016599,/
16,475,30000,0,00000016583,00000016583,/
16,475,145000,0,00000016624,00000016624,/
49,288840,8/
98,288840,1,10/
02,340854,101100029,1,040602,0000,USD,2/
03,0040180107,USD/
16,475,200,0,00000016581,00000016581,/
16,475,3235,0,00000016652,00000016652,/
16,475,5355,0,00000016650,00000016650,/
16,475,5642,0,00000016646,00000016646,/
16,475,8640,0,00000016651,00000016651,/
16,475,9216,0,00000016642,00000016642,/
16,475,30000,0,00000016588,00000016588,/
16,475,38737,0,00000000166,00000000166,/
49,101025,10/
98,101025,1,12/

Is there anyway I can make this in WM. I know it needs manual intervention.

Thank You guys in advance!!!
Priyatham

Priyatham,

Are you asking how to process this file once you get it into webMethods or are you asking how to get this file into webMethods from the external web server?

Mark

Hi Mark,

I am already processing this BAI2.dat file from one of the UNIX directory. I am fine with this.

I am looking for something like this
Go to a website “https://webmethos_bla_bla.com” site click one button which will take you to another screen and select the file format we would like to have. We can select the bank file in different format, but in my case I need in BAI2 format as mentioned above.

I am not taking about FTP’ing to a remote server and getFile but to login to a website and download which requires a manual intervention.
Did you get Mark? Please let me know still if you didn’t catch my point.

Thank You very much!!!
Priyatham

I’m not sure, but it sounds like you want to create a new web page that will help automate the process of logging into the external site, navigating through a series of menus and downloading a file in the desired format. You are OK with some manual steps, but not as many manual steps as you have now.

If this is correct then I don’t think this is a webMethods question, but rather a web development question. A few releases ago there was something called WebTap that basically screen scraped a web page, but that’s been gone for some time now.

I would suggest contacting the developer or support contact for the external site to determine what, if any, options they offer for automating the process. Perhaps they already provide a web services-based interface that will let you retrieve the data directly rather than by navigating through their web pages.

If they don’t offer anything besides their ASP-based web interface, you may be able to use MS Visual Studio to create a new web page that would reduce the manual intervention. That said, that option seems like more work than it would be worth just to save a few steps.

HTH,

Mark

Priyatham - As Mark said, contact the site’s developers to see if they offer a more machine-accessible interface. The advantage is changes to such an interface are coordinated with its users, but changes to a public website’s are not - even a small HTML change has the potential to break a web-scraper.

If not, try knocking up a simple sequence of pub.client:http calls in a Flow service - this can give you what you need. However, you’d need to understand HTML and reverse-engineer the HTTP POST variables for each page: do-able but nasty.

Alternatively, you can use an external tool called from webmethods.
I’ve used JMeter (http://jakarta.apache.org/jmeter/) for load testing, but it may be able to do what you want. JMeter has a proxy server which can record your browser’s interaction with a website, then auto-generates the “test plan” – code to do the same thing automatically. One drawback of it’s proxy server is it cannot records HTTPS interactions though.

If you use JMeter, I’d expect you’d need to use it’s “Regular Expression Extractor” listener. Also, since it’s Java, you may be able to embed JMeter into IS – there was some talk on it’s mailing list about embedding JMeter into Tomcat but I don’t know how far it went.

Cheers,
Sonam