Unable to extract cell information from a table using the CV Get Text activity on a remote machine

Help Activities
, , ,
1

I am trying to extract a cell information from a scrollable table in my remote machine using the CV Get Text activity but the bot is unable to find the correct cell (the correct row in the table).

Example:
The Table contains employee details (Column A: Client ID, Column B: Client Name, Column D: DOB, Column E: Address, Column F: Net Worth)
The table is scrollable in the remote machine.
I am trying to find the Client ID using the Client Name, DOB as reference in the CV Get Text activity
The syntax I am using is as below
“Target: TableCell (2,266,1811,687)” +
“ColumnName: Client ID (399,266,120,25)” +
“RowContains: Suresh Choudhary (2,546,89,17) RowCell: 2”+
“RowContains: 14/09/2021 (243,665,86,17) RowCell: 3”

But the BOT is only able to find the first instance of Client Name in the table and extracts the Client ID respectively, it disregards the DOB of the client. I want the bot to use both Client Name and DOB when it does a search in the scrollable Table.

Can someone please help me with it

Thank You

2

Is the Bot running on your Machine and that’s the reason you are using CV Get Text or is the Bot running on the remote machine? Could you possibly provide a screenshot?

3

You’re right, The Bot is running on my machine and I am trying to access a remote machine hence using CV scope.

4

@Suresh_Choudhary1

Is this an excel file you are trying to extract data from?

if yes cant you use the shared location on remote desktop and then share it and then read as an excel?

that way you do not need to use CV at all

cheers

5

I am trying to extract data from a table, once I extract the data I need to validate the extracted information and enter a value in the same table for the validated row in column X.

6

@Suresh_Choudhary1

Then try getting the row from the extracted data…then try making the cv descriptor dynamic to click at the required place or type into at required place…this might need some analysis from you to change the descriptor anchor values and all…try modifying it and check which fits best…Target table cell is what you need to try and modify as you need

Double anchors on Descriptor might not work as expected

Cheers

7

I am trying to do the same thing but the issue is the bot only returns the row for the first instance of the first anchor and not able to take more than one anchor.

8

@Suresh_Choudhary1

Instead of using anchor try chaging the coordinates by identifying the row number and see for each row how much number is getting added

Cheers