Unable to copy and paste from Mainframe Emulator to MSExcel

ThiruvenkatNathan · Posted: Tue Oct 12, 2010 4:28 pm

Hi ,

This is venkat . I am new to Mainframes so i thought before asking this question i should try google but i was not able to find a solution .

My query is i am unable to copy text (basically anything ) from my mainframe emulator to Excel sheet . As a fresher it is my main job to copy table names names and paste it . I am aware of FTP'ing from Mainframe to our machine but it would be very helpful if i am able to copy and paste directly .

I saw a particular option which said start the services " network DDE" and clipboard services but it is disabled by admin for security reasons . I am not sure what is the real cause .

Any help would be really appreciated .

Anuj Dhawan · Posted: Tue Oct 12, 2010 4:41 pm

one place to another

PeterHolland · Posted: Tue Oct 12, 2010 4:47 pm

I think you are talking about the clipbook servcie, there is no clipboard
service. And yes those services are most of the times disabled in networks.

Which emulator are you using?

ThiruvenkatNathan · Posted: Tue Oct 12, 2010 4:48 pm

yes anuj , i am able to do both of them .

thanks for the reply .

ThiruvenkatNathan · Posted: Tue Oct 12, 2010 4:54 pm

@peter

sorry . guess i just got confused there in the clipbook part . And i am using Rumba Emulator .

Before this i was using Smarterm . In that emulator i was able to copy and paste from mainframe to excel sheet or word .

Anuj Dhawan · Posted: Tue Oct 12, 2010 4:56 pm

Then please work with someone at your shop to understand what they've used to do what you want to do. I was under the impression that "ctrl+c" was not propery mapped for "copy" on your emulator and if so, nothing from emulator is copied to clip-board if you use "ctrl+c" and so nothing is pasted on spread-sheet.

ThiruvenkatNathan · Posted: Tue Oct 12, 2010 5:02 pm

@anuj

actually i am doing this for a client and for the same client we used Smarterm emulator for a while and now they provided Rumba emulator .

I agree with the part in which you said that while using Ctrl+C in emulator it is not getting copied to clip-board and that is the reason i am unable to paste it in Excel because there is no content in clip board .

Is there any way to make this happen from my end ? Or is this a problem with the emulator ? Do we have any options which can be changed in emulator ?

Please dont think i am bugging with irrelavant questions but any help would be very much appreciated .

PeterHolland · Posted: Tue Oct 12, 2010 5:06 pm

I never had copy/paste problems with rumba.

Can you mark/select parts of your rumba screen? And if so right clicking
gives the copy/paste popup screen?

ThiruvenkatNathan · Posted: Tue Oct 12, 2010 5:10 pm

hi peter ,

yes i am able to mark/select parts of my rumba screen and after right click it gives all the cut,copy,paste options .

kacks7 · Posted: Tue Oct 12, 2010 5:11 pm

are u getting the red colour 'X' in the left bottom corner while using ctrl+c ???

PeterHolland · Posted: Tue Oct 12, 2010 5:13 pm

And if you choose copy? Can you paste the selected part in excel, word,
notepad etc.? You have to be with your cursor in the selected text, and
the text has to stay selected.

ThiruvenkatNathan · Posted: Tue Oct 12, 2010 5:14 pm

hi bala ,

no i am not getting any red X while using Ctrl+C

thanks

ThiruvenkatNathan · Posted: Tue Oct 12, 2010 5:22 pm

hi peter ,

that part is the actual problem . after copying text from emulator while i paste in notepad/wordpad/excel it pastes some numbers or some irrelavant text .

So does it mean that my text which has been copied from emulator is not getting stored in clipboard ?

I am not sure.. The chances are while using Ctrl+V the random thing which gets pasted is from my earlier copy in my machine and not in rumba.. Any suggestion would be really appreciated..

ThiruvenkatNathan · Posted: Tue Oct 12, 2010 5:23 pm

@peter

also i am keeping the text selected the whole time..

PeterHolland · Posted: Tue Oct 12, 2010 5:25 pm

Good for you. But you didnt answer the question if it was possible to paste
into excel, word, notepad etc.

kacks7 · Posted: Tue Oct 12, 2010 5:26 pm

try with the copy abd paste buttons in the top of your emmulator.

ThiruvenkatNathan · Posted: Tue Oct 12, 2010 5:29 pm

@peter

if i click paste then it is pasting some random numbers everytime..

ThiruvenkatNathan · Posted: Tue Oct 12, 2010 5:37 pm

hi bala

jus wanted to clarify this.. when i copy and paste inside emulator - no problem

copy and paste inside excel sheet or MSword - no problem

actual problem is when i copy something from emulator - ex : jcl code and paste in word/excel/notepad it pastes a random number..

appreciate all you guys for tryin to help out this newbie

PeterHolland · Posted: Tue Oct 12, 2010 5:37 pm

So after all, copy/paste is working. The only thing is you get some
garbage pasted.
IIRC there are some options in rumba for copy/paste actions. Try those
options.

ThiruvenkatNathan · Posted: Tue Oct 12, 2010 5:43 pm

@peter

you got it exactly right

and i have checked every option in rumba for this but didnt get anywhere..

Since you mentioned that you have worked in rumba can you please assist me.. i would really appreciate if you can let me know where can i find this option or any manual on rumba or general emulator usage..

To ask step by step instruction from you guys would be so stupid . but my supervisor and myself , we both checked every option.. no go..

kindly help..

PeterHolland · Posted: Tue Oct 12, 2010 5:47 pm

Nathan,

im retired so im just working from memory.

If you have rumba installed, your site should have the manuals.

ThiruvenkatNathan · Posted: Tue Oct 12, 2010 5:50 pm

@peter

sure not a problem.. really appreciate all your replies

i would try to find out more from web..

if i get any more information on this i will update asap..

thank you all

PeterHolland · Posted: Tue Oct 12, 2010 6:12 pm

Ok, hope you find a solution.
Maybe it has to do with the EHLLAPI used by Rumba.

dick scherrer · Posted: Wed Oct 13, 2010 1:11 am

Hello,

Suggest you try to highlight & copy something from the 3270 screen and paste it into notepad. What happens?

None of my current sites use Rumba for terminal emulation, but when i did use Rumba, i never had problem using copy/paste. . .

ThiruvenkatNathan · Posted: Wed Oct 13, 2010 10:07 am

@ dick

yes i tried to copy and paste from that screen and same thing happened.

and i noticed that the thing which gets pasted in notepad is not a garbage value obviously.. It is the value/text which i copied already in my own machine from some other notepad/wordpad/etc..

my sentence formation is not good so please bare with me.. I guess you know what i mean when i say the value/text which has been copied already ( just before i copy contents from emulator ) in my machine..