Hello everyone,

I'm facing an issue where I want to copy data from an Excel or text file and paste it into Bluezone. Bluezone has rows and columns, and when the total number of columns exceeds 15, I have to tab to navigate to the next screen. My requirement is that when I paste the data, all of it should be pasted automatically. I've attempted using pasting options, but not all the data is pasted successfully. This is where I'm encountering a roadblock. Thank you for your assistance.

PS: Please find attached examples for reference.

Thanks

------------------------------
jerry ven
------------------------------

Dear Jerry

>>>>  My requirement is that when I paste the data, all of it should be pasted automatically.  <<<<

I notice that 5250 session in IBM i ACS provides Edit --> Paste and Edit --> Paste Next functions.  This should mean that, at least for interactive session, you cannot paste all entries at once when a vertical block of screen input fields has less entries than all the data entries you have to copy.  You should first use Edit --> Paste and the first 15 entries will go in and then you page down or move your screen cursor to the top of the next vertical block of input fields and do Edit --> Paste Next for the subsequent entries. 

I try this with 21 entries and it works. In the first paste action, please note that the option Paste Next appears to be grey-out (inactive) but it automatically becomes active for selection in the second paste. After all entries are pasted, Paste Next option is grey-out again. 

------------------------------
Chance favors only the prepared mind.
-- Louis Pasteur
------------------------------
Satid S.

Original Message:
Sent: Wed January 17, 2024 09:30 AM
From: jerry ven
Subject: Data Pasting Issue in IBM i with Columns Exceeding 15

Hello everyone,

I'm facing an issue where I want to copy data from an Excel or text file and paste it into Bluezone. Bluezone has rows and columns, and when the total number of columns exceeds 15, I have to tab to navigate to the next screen. My requirement is that when I paste the data, all of it should be pasted automatically. I've attempted using pasting options, but not all the data is pasted successfully. This is where I'm encountering a roadblock. Thank you for your assistance.

PS: Please find attached examples for reference.

Thanks

------------------------------
jerry ven
------------------------------

Jerry,

use the solution that Satid provided and create a macro from it.

Call it paste all, and make the steps:

1. Paste
2. Page-Down
3. Paste-Next
4. if last field in screen is not blank - goto step 2
5. end

This should do it - but you have to dig a bit into the macro language of iACS to do that.

HTH
Daniel

Dear Jerry

>>>>  My requirement is that when I paste the data, all of it should be pasted automatically.  <<<<

I notice that 5250 session in IBM i ACS provides Edit --> Paste and Edit --> Paste Next functions.  This should mean that, at least for interactive session, you cannot paste all entries at once when a vertical block of screen input fields has less entries than all the data entries you have to copy.  You should first use Edit --> Paste and the first 15 entries will go in and then you page down or move your screen cursor to the top of the next vertical block of input fields and do Edit --> Paste Next for the subsequent entries. 

I try this with 21 entries and it works. In the first paste action, please note that the option Paste Next appears to be grey-out (inactive) but it automatically becomes active for selection in the second paste. After all entries are pasted, Paste Next option is grey-out again. 

------------------------------
Chance favors only the prepared mind.
-- Louis Pasteur
------------------------------
Satid S.

Original Message:
Sent: Wed January 17, 2024 09:30 AM
From: jerry ven
Subject: Data Pasting Issue in IBM i with Columns Exceeding 15

Hello everyone,

I'm facing an issue where I want to copy data from an Excel or text file and paste it into Bluezone. Bluezone has rows and columns, and when the total number of columns exceeds 15, I have to tab to navigate to the next screen. My requirement is that when I paste the data, all of it should be pasted automatically. I've attempted using pasting options, but not all the data is pasted successfully. This is where I'm encountering a roadblock. Thank you for your assistance.

PS: Please find attached examples for reference.

Thanks

------------------------------
jerry ven
------------------------------