SAP Single Value copy problem

Help Something Else
1

The image shows a SAP interface for selecting multiple material values. (Captioned by AI)
The image shows a SAP interface for selecting multiple material values. (Captioned by AI)662Ă—388 35.4 KB

How can copy material to Single Value from Excel DataTable with UiPath?

2

Hi @mnmohajeri

Pleas check below thread,

Or

Happy Automation

3

@mnmohajeri

can you please elaborate a little

cheers

4

@mnmohajeri,

I think it’s related to your previous question to copy excel range to SAP. Am I correct? if yes, have you tried the approach suggested on previous question and what was the outcome?

5

Multiple Selection
Multiple Selection687Ă—333 19.3 KB

I faced with attached error after carry out the solutions.
Please let me the other way
Thanks

6

Dear Anil

I faced with attached error.

Multiple Selection
Multiple Selection687Ă—333 19.3 KB

7

Hi @mnmohajeri

Could you please do the following:

  1. before you are copying the value to sap, can you please use log message activity to print that value. Please check if its the right value you are intending to copy to SAP.
  2. Have you tried entering that value manually in the SAP and check? Is the error still same? if yes, you would need to check with the business on the data/file that needs to be copied to SAP. If you are able to do it manually but not via UiPath, then there is a problem in your UiPath workflow.

Regards
Sonali

1 Like
8

@mnmohajeri

how are you trying to set the value?

better to assign the value to clipboard and then use keyboard shortcuts/send hotkeys to send ctrl+v to paste the data and dont send it to single cell but use the full window to send hotkeys

also while reading how are you reading the data?

cheers

1 Like
9

@mnmohajeri,

Check if there is any trailing or leading spaces

1 Like
10

Let try this,

A column of material numbers from 10000001 to 10000020 in an Excel spreadsheet is highlighted with the text "From Excel Copy" displayed to the right. (Captioned by AI)
A column of material numbers from 10000001 to 10000020 in an Excel spreadsheet is highlighted with the text "From Excel Copy" displayed to the right. (Captioned by AI)355Ă—431 41.5 KB

A screenshot of an SAP interface showing the "Multiple Selection for Document Number" screen with a highlighted button for uploading from the clipboard (Shift + F12). (Captioned by AI)
A screenshot of an SAP interface showing the "Multiple Selection for Document Number" screen with a highlighted button for uploading from the clipboard (Shift + F12). (Captioned by AI)541Ă—425 32.4 KB

image

You can use

  1. Use Assign Activity ,
    Material =
    String.Join(Environment.NewLine & Environment.NewLine, DataTableName.AsEnumerable().Select(Function(row) row(“Material”).ToString()))

  2. Set to Clipboad Activity, Input = Material

  3. Click Activity ( Upload from clipboad )

1 Like
11

I can copy data from Excel manually but can’t do this with UiPath

12

@mnmohajeri

use read range and then join the values with envionment.newline and assign to clipboard and send ctrl+v

cheers

13

I solved my problem by First or Last column activity.

Thanks all

1 Like