Running task for each entry on table with CV

Help StudioX
,
1

Hi,

I have a request, if anyone can help me out on how to proceed.

I am using a virtual desktop, where I can only use CV,

I want to basically run through a loop for each row inside a table. For each iteration of the loop, I want to click on the row itself, and then click on a new window that says browse notes, and save those.

Setting up the clicking procedure is simple, my issue is how I can use CV to run the loop for the table in the first place.

Screenshot 2024-08-20 165055

Above is a screenshot of the table, with personal data obviously blurred out. How can I run a sequence for each loop?

Thanks.

2

Hi @muhammad_khan

Are you able to get the row numbers, so that you can pass that number into the Click Selector as a variable?

Hope this helps

3

Unfortunately not :confused:

The only data is are the subheadings included in the image, and none of those are ascending.

4

Ok, if possible could you please share the selector of first and second rows?

5

Apologies, can you elaborate a bit on the selectors you wish to see, I’m not familiar

6

Use UiExplorer, indicate on first row of the table so that you will see the selector.

7

Please go through the detailed steps

Use the CV Screen Scope Activity
Start by placing your automation within a “CV Screen Scope” activity to define the area where UiPath will perform computer vision activities.
Use the CV Extract Table Activity**:

  • Within the “CV Screen Scope,” use the “CV Extract Table” activity to extract the table data. This activity outputs a DataTable.
    For Each Row Activity**:
  • Once you have extracted the table, use the “For Each Row” activity to loop through each row of the DataTable.
    Use CV Element Exists and CV Click Activities**:
    Inside the loop, use a combination of “CV Element Exists” and “CV Click” activities. You’ll need to identify the row using selectors that match the specific row you are iterating over.
    You might need to create a dynamic selector that changes with each iteration. The selector could be based on a unique value in each row (e.g., an ID or name in a column).
    Click on Each Row
  • Inside the loop, use the “CV Click” activity to click on the identified element of the current row.
8

I have reached until the point of using CV element exists.

But how can I check I program the loop to go through the data one by one.

I can not really use UI explorer, as I am using a virtual machine that I can not install anything to.

When prompted with element exists, I can click on existing elements, but I would rather work my way down the row.

image

This is an example of the table. I want to click on each name, one by one, and perform my task.

9

If you pass the output DataTable to a For Each Row activity, the loop will iterate through each row one by one, allowing each CV Click action to click on each name in the table.

10

image

How can I get it to click on the name specifically, I have extracted the data, but am unsure on how to configure it to click on the specific name of the current row.

11

se a combination of “CV Element Exists” and “CV Click” activities. You’ll need to identify the row using selectors that match the specific row you are iterating over.
You might need to create a dynamic selector that changes with each iteration. The selector could be based on a unique value in each row (e.g., an ID or name in a column).

12

How can I set selectors if I am restricted in using the UI explorer?

13

Indicate on Screen: When you add an activity like Click or Type Into, you can directly indicate the UI element on the screen. UiPath will generate a basic selector automatically.