Data Extraction from Ui Portal

Help Studio
1

For every hostname in this picture, I am supposed to extract only the percentage figures of CPU Util, Mem Util, and var Util. It is a Ui Automation. How do I go about it and what activity can I used to extract the information for each of them. Would I extract them all ones and saved in a data table, paste them in a ppt template I am using or I will extract them one after the other and paste them in the ppt template? Please help.

image
image1133×485 46 KB

2

@Baba_Karim_Abdulai,

Try using Table extraction for this.

1 Like
3

@Baba_Karim_Abdulai

you can use table extraction and extract all at once

cheers

1 Like
4

Hi @Baba_Karim_Abdulai

You can consider below approach:

  1. use table extraction to extract all values.

  2. use filter datatable activity on the output from step 1 to only keep columns - CPU Util , Mem Util , and var Util

  3. now you only have the info that you need.

Hope this helps.

Regards
Sonali

6

Hi @Baba_Karim_Abdulai

  1. Extract All Data at Once into a DataTable:
    Use Data Scraping (Modern: Table Extraction) to extract the entire table into a DataTable.
    Then filter/select only the columns you need:
    Host name
    CPU Util (Used %)
    Mem Util (Used %)
    FS: /var Util
    This approach is scalable and easier to maintain.

In UiPath Studio

Go to App/Web Recorder → Table Extraction.
Indicate the table.
Select columns you need (CPU Util, Mem Util, FS: /var Util).
Output will be a DataTable

7

use ectract data table activity for required data extraction, if fails ‘get text’ activity with anchor base selector is there, but later approach will not be efficient.