RUMBA emulation

[J. Freed]

I'm trying to control a RUMBA session from within Access/VBA so I can
automate the scraping process. Specifically, I want to take an Access table
and send values from it into a RUMBA session, retrieve the relevant screen,
screen scrape it, save it then get another value to send into the session.

So far RUMBA has been of no help and no one in my organization has the
expertise to assist me. Any ideas? Finding information about the RUMBA API
would be a big start.... thanks!

 

[Tony Toews [MVP]]

I'm trying to control a RUMBA session from within Access/VBA so I can
automate the scraping process. Specifically, I want to take an Access table
and send values from it into a RUMBA session, retrieve the relevant screen,
screen scrape it, save it then get another value to send into the session.

So far RUMBA has been of no help and no one in my organization has the
expertise to assist me. Any ideas? Finding information about the RUMBA API
would be a big start.... thanks!

Looks like there aren't a lot of solutions. Are you trying to hit a
mainframe or AS/400 or equivalent? You may need to search on 3270 or
5250 screen scraping and choose a different product if such exists.

I saw one hit for Rumba Tools for Visual Basic however that was dated
1998 and used VBXs.

Can you somehow get to the raw data via ODBC?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[J. Freed]

I wish I could ODBC it. Unfortunately, we're pulling from a mainframe and the
data in question relates to application security and is not downloadable.

I've got everything I need all set up to work with the scraped data; I can
even produce the scraped data file manually. But I have several thousand
screens I'd need to scrape so manual processes don't do me much good.

Thanks for responding.

 

[Tom van Stiphout]

On Tue, 17 Mar 2009 10:19:03 -0700, J. Freed

Talk about a blast from the past. I used to do this on a regular
basis, using HLLAPI, which is an instruction set that comes with
pretty much all terminal emulators. Finding information? How about
going straight to the vendor?

-Tom.
Microsoft Access MVP

 

[herewi]

Hello,
a long time ago you have had a question about Rumba Screen-Scraping for VB.

We have developed a series of functions in VB6 and RUMBA-AS400-Emulation.

This Package permits simple and full Control over the AS400-Session from within VB.

Best regards