Copying from Emulator Hummingbird to Excel



Discuss about all tools related to Mainframes but usable in a PC/Computer like Mainframe Simulators, Emulators, Abend Assist etc...

Copying from Emulator Hummingbird to Excel

Postby Najamuddin » Tue Nov 14, 2017 1:31 pm

Hello All,

I am new and don't have knowledge on mainframe macros.

Could you please help me with Macro for copying the number/identifier from mainframe emulator hummingbird to Excel and then reject the request and then open another request and perform the same action copy from mainframe and paste into Excel and so on till the last row/request is reached. The number of rows/request is not known we can limit it to any number if the fixed number of rows are needed. The number/identifier length to copy after opening the request is would be 9 bytes.
Najamuddin
 
Posts: 2
Joined: Tue Nov 14, 2017 12:47 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Copying from Emulator Hummingbird to Excel

Postby enrico-sorichetti » Tue Nov 14, 2017 1:45 pm

I am new and don't have knowledge on mainframe macros.

irrelevant ...
You will need to learn about <hummingbird> macros :mrgreen:

and ...
hummingbird is NOT a mainframe emulator , it is a 3270 terminal emulator
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Copying from Emulator Hummingbird to Excel

Postby Najamuddin » Tue Nov 14, 2017 2:16 pm

Thanks much for your reply. Could you please help me with the macro code or point me in right direction

Thanks again
Najamuddin
 
Posts: 2
Joined: Tue Nov 14, 2017 12:47 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Copying from Emulator Hummingbird to Excel

Postby enrico-sorichetti » Tue Nov 14, 2017 2:26 pm

look at the hummingbird manuals
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Copying from Emulator Hummingbird to Excel

Postby NicC » Tue Nov 14, 2017 4:28 pm

Alternatively, FTP (or whatever) the data set (not a file) to the machine where the Excel is running(the data will now be in a file) and load the file to Excel.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: Copying from Emulator Hummingbird to Excel

Postby steve-myers » Tue Nov 14, 2017 5:24 pm

NicC's solution is the most generically viable solution, but it is quite difficult to create XLS or XLSX data on a mainframe. The usual method is to create text type CSV data on the mainframe and send it to the workstation. This is not necessarily the most ideal solution, as CSV can't do some of the fancy formatting some of the spreadsheet programs like Excel can do, but at least the data can be sent.

Rather to my surprise I discovered CSV data can contain spreadsheet formulas for at least some spreadsheets. OpenOffice / Libreoffice as well as Excel will take formulas.
steve-myers
Global moderator
 
Posts: 2105
Joined: Thu Jun 03, 2010 6:21 pm
Has thanked: 4 times
Been thanked: 243 times

Re: Copying from Emulator Hummingbird to Excel

Postby enrico-sorichetti » Tue Nov 14, 2017 5:32 pm

from the wording it looks like the TS wants to script some 3270 screen sequence
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2994
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times


Return to Simulators & Emulators

 


  • Related topics
    Replies
    Views
    Last post