How to capture output

Technical support and scripting issues

Moderators: Dorian (MJT support), JRL

Post Reply
nkwhftw
Newbie
Posts: 8
Joined: Thu Sep 01, 2005 12:44 pm

How to capture output

Post by nkwhftw » Thu Sep 01, 2005 5:11 pm

When I run the macro to obtain an output I am having a problem in capturing the data. Is there a way to capture the output in a text format and place it in Notepad. If I use the cntrl keys it takes a picture of the data in which I can not import into an Excel sheet. I have found I can Left click and encompass the data then "copy" and "paste" into Notepad. That seems cumbersome at best. I would like to know how to auto capture the data.

Thanks,

CEW

User avatar
Bob Hansen
Automation Wizard
Posts: 2475
Joined: Tue Sep 24, 2002 3:47 am
Location: Salem, New Hampshire, US
Contact:

Post by Bob Hansen » Thu Sep 01, 2005 5:55 pm

Lots of good help available here, but your question is not clear.

You need to be more specific about what you are trying to do.
What programs are you using? What version of Macro Scheduler?
What are you trying to accomplish?
How are you trying to do that?

Provide a copy of the macro you are using.
Point out what section is not working as you expect it to.
Hope this was helpful..................good luck,
Bob
A humble man and PROUD of it!

User avatar
support
Automation Wizard
Posts: 1450
Joined: Sat Oct 19, 2002 4:38 pm
Location: London
Contact:

Post by support » Thu Sep 01, 2005 6:01 pm

"the macro"?
"an output"?
"the data"?

Which macro, what output and which data?

Please explain what you are trying to achieve, what your macro does or has to do and what the problem is.
MJT Net Support
[email protected]

nkwhftw
Newbie
Posts: 8
Joined: Thu Sep 01, 2005 12:44 pm

Capture data

Post by nkwhftw » Thu Sep 01, 2005 6:26 pm

I have a Telnet session (3270), in which it returns my requested data which is shown on the screen in columns and lines. I am using RUMBA to access the session. My PC is Windows XP. My Excel is 2000. Sometimes the data is too large to appear on one screen it will be either several additional pages and some times the columns exceed up to 120 caracters. 100 lines by 120 caracters is not uncommon.

The system does not allow me to save the data or print the same. I would like to capture that data that appears on the screen and move it over eventually to an Exel spread sheet. The screen appears to be ASCII and is driven by my requested data.

The Macro Scheduler Pro 7.3.11.4 is the vehicle, and I am using script editor to build the macro.

Me_again
Automation Wizard
Posts: 1101
Joined: Fri Jan 07, 2005 5:55 pm
Location: Somewhere else on the planet

Post by Me_again » Thu Sep 01, 2005 6:31 pm

So you can't use a telnet client that has data capture?

User avatar
support
Automation Wizard
Posts: 1450
Joined: Sat Oct 19, 2002 4:38 pm
Location: London
Contact:

Post by support » Thu Sep 01, 2005 7:42 pm

Most TELNET clients let you highlight the contents of the screen and copy to the clipboard. The standard Microsoft telnet client certainly does. So you can send the keystroked to select-all and then edit/copy and then use GetClipBoard to retrieve the data. Then parse it.
MJT Net Support
[email protected]

Me_again
Automation Wizard
Posts: 1101
Joined: Fri Jan 07, 2005 5:55 pm
Location: Somewhere else on the planet

Post by Me_again » Thu Sep 01, 2005 8:31 pm

The microsoft client also has text capture to a file that could be automated. The poster is using Rumba but I would be surprised if that doesn't have a capture function too.

Post Reply
cron
Sign up to our newsletter for free automation tips, tricks & discounts