Extract the text from SAP which is table format

Help Studio
, ,
1

Hi team,

i used get text and get attribute to store the extracted data but it is extracting some other data instead of actual data i tried fuzzy selector, computer vision and strict selectors,
individually and togther

please find screenshot the text current value = true i need to store in a varaible

Screenshot 2024-09-04 175218
Screenshot 2024-09-04 1752181160×111 27.1 KB

2

Hi @Naveen_Kanike

Use Extract TableData activity to get all data, after that you can easily extract that value

Regards,

3

Hi,

You mean extract table data activity? extract datatable activity i don’t see it.

4

@Naveen_Kanike

The image shows a UiPath workflow with an "Extract Table Data" activity inside a "Use Application/Browser" activity, both marked with validation errors. (Captioned by AI)
The image shows a UiPath workflow with an "Extract Table Data" activity inside a "Use Application/Browser" activity, both marked with validation errors. (Captioned by AI)672×635 19.5 KB

Regards,

5

can you please tell me how to use i don’t how to use this activity

6

@Naveen_Kanike

Indicate that table

Regards,

7

@Naveen_Kanike After open the SAP and when you reached the table data inside the SAP used Extract Table activity from the ribbon panel

A screenshot of the UiPath Studio Community interface is displayed, highlighting the "Table Extraction" feature in the ribbon. (Captioned by AI)
A screenshot of the UiPath Studio Community interface is displayed, highlighting the "Table Extraction" feature in the ribbon. (Captioned by AI)1261×264 33.4 KB

make sure you enable the scripting . before working with SAP in UiPath.
cheers Happy Automation

8

can you connect if possible?

9

Sorry Brother not possible right now am at my workplace .
I’ll share you a Example flow

Example Workflow

Here’s a basic example of a workflow to extract table data from SAP:

  1. Open Application/Browser Activity: Open SAP GUI and navigate to the required transaction.
  2. Type Into Activity: Enter any necessary data into the SAP screen.
  3. Click Activity: Click on buttons or dropdowns to generate the report or table.
  4. Data Scraping Wizard: Use the Data Scraping wizard to select and extract the table data.
  5. Write Range Activity: Write the extracted data to an Excel file or database for further processing.

Considerations

  • SAP GUI Scripting: Make sure that SAP GUI scripting is enabled on both the server and client side.
10

iam getting empty output in message box

11

@Naveen_Kanike can you show the workflow and the output panel.
cheers

12

@Naveen_Kanike

Generally in sap you would have a export option please check for that use that instead of extract table that would be more reliable

Cheers

13

no i don’t have export option for this process

14

@Naveen_Kanike

Then please use ui explorer and adjust the selector to fit the screen

cheers

15

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