Unable to copy paste from excel to Main frame app

When I tried to create a list and add to mainframe its not pasting under Item number after 1st item number its going to quantity field.

Hi @Syed_Sultan_Ahmed1

Mainframe (3270/5250) screens are position-based, not row-based like Excel. After entering the first Item Number, the cursor automatically moves to the next input field, which in this case is the Quantity field. That’s why from the second value onward, the data goes into Quantity instead of the next Item Number line.

Pasting or typing a full list will not work correctly on mainframe screens.

You can try this approach -

You must reposition the cursor before entering each item number

  1. Loop through the item list and for each item then Move the cursor to the correct row and column of the Item Number field then Then type the item number

  2. Use Set Cursor Position (Row, Column) or navigation keys (Home/Down/Right) before typing.

  3. If quantity is fixed, enter both values together (Item + Tab + Quantity).

  4. If available, use F20 – Single Line Entry, which is designed for entering multiple items.

If solution works for you please mark as solved

Thanks & Hapoy Automations

Hello @Syed_Sultan_Ahmed1 ,

You can try this solution

loop through the list and type each item one by one using Send Keys / Type Into with exact navigation keys (Tab, Enter, PF keys), or use mainframe-specific activities (like Set Field / Terminal activities) instead of copy-paste.

Thanks for the help I will try and keep you posted

1 Like

thanks Again its working by using for each row and counter variable

No worries,
Happy to help!!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.