I am unable to use data scraping in SAP. Anyone did?
These tables are called SAP labeled tables. For human-being they looks like a table, but from technical point of view it is just a set of characters.
There 2 ways of working with such tables:
Use native SAP Export functionality, which allows you to export the data in very fast manner for super huge tables in a seconds. It means, you are not relying on automation tool.
Use UiPath Studio for data scraping. Support for the SAP labeled tables was added with UiAutomation Pack starting from version 20.8
Best regards, Lev
Were you able to update as well the columns that are editable? In my case, I need to loop so I can update the prices or unit of measurement per article
unfortunately, we are using uiPath enterprise and 20.4 is the latest package for uipath automation activities.
But do you need to scrape the data or edit those columns?
Scrape and edit at the same time
But after you scrape the data and put in a DataTable, what will you need to do with that?
First I need the datatable so I can somehow loop in the SAP Table to update a certain field.
Well, for me, if i dont need all the data to be transported somewhere, i would not do a full scrape… To be able to edit a certain field, you wont need the DataTable…
hmmm but this table has many pages.
still, i dont see how scrapping a whole lot of data can help you to edit those columns you need…
Hello @LevKushnir - I have an issue to report or maybe education for me as I have a user trying to extract the data from Table and it works like a charm thank you for this nice addition. But when they try to pull data from spool on pre-run reports it wont work. See below steps. Maybe its just me or something i am missing here or maybe a worth enhancement for Data Scraping.
I was trying to extract (Data Scraping) for the SAP report spool data (not SAP Table) using Studio 20.4.3 with UiAutomation activity package 20.10.6. The result is successful run but blank table.
As soon I select a Cell in this spool table it changes the SAP screen to blank and as you can see the Extract Wizard preview section wont bring anything in. Which seems to be my issue. Not sure why the Page is changing to blank or what is wrong here.
Can you give me a transaction, you are using? That I can try to reproduce it
For me it looks good
We were going in to SM37 to get the pre-executed report output from spool.
Can you give me step-by-step instruction, how to come to the exact same screen?
In my case Data Scraping is always working, but I am not 100% sure, that I am on the same screen as you are
Here are the steps.
- Login to SAP using LOGIN
2.Run SM37 transaction to show the jobs.
3.look for the “AQG4PP_METRICS==REPORT_70=====” report
- Display spool list (Ctrl+Shift+F8)
- Click ABAP List
- Now trigger the data scraping and the issue gets reproduced.
Hope this helps. I now looked at your screen i think the data scraping work until step 4 the issue I see is in Step 5 going into Type and then pull the table data out.
The point above make me worries. It looks like the issue is with SAP itself and not with UiPath.
Do you know, why is this blank stuff coming? when exactly it is happening?
I have tried to reproduce it on my side and data scraping is working.
SAP changes to blank screen after I select the cell from the spool using UiPath data scrapping wizard. So to me its UiPath wizard triggering some command on SAP screen to make it look blank.
Could I ask you to use UiPath Studio 20.10 and UiAutomation Packages 20.10.
Take the latest one please and check if the issue still appears.