Extract Data from SAP

Help
1

Hi,

In a SAP R3 automation project, I face the following issues:
a) Cannot extract the output of a transaction in a CSV format. I could only get data as Text via Screen Scraping. How could I copy this info in CSV w/o further processing?

UiPath-Data%20To%20Extract%20from%20SAP
UiPath-Data%20To%20Extract%20from%20SAP1290×454 28.7 KB

b) in another form, when trying to click on the following button
UiPath%20-%20Click%20on%20SAP%20form

the SAP logon page appears
UiPath%20-%20SAP%20Logon

This disturbs the flow, but haven’t found a workaround to overcome this. any ideas? what’s causing this?

Scrapping Query
2

Is there an option to download to PC?
image

Does this happen only when robot clicks the button?

Cheers

3

  1. no option to download to PC

  2. yes, this happens when the robot runs

4

:frowning:

5

For the data extraction, I could save it locally as XLS –

6

Well, I have an experience with SAP that what they name XLS is in fact CSV…

7

right. BTW for the 1st issue: the button next to the field is displayed (visible) when you click on the input text.
I noticed that when the robot clicks on the input text, to clear any value, then the SAP logon screen pops-up…

any ideas when to set the focus back to the main window?

8

I did not experience such behavior so far. Sorry.

For SAP however I would recommend to use keyboard navigation where possible, i.e. minimize mouse clicks.

Cheers

9

yes. I used “Send HotKey” and combination of ALT+x and worked fine

thx

10

:+1: