Hi Guys,
I need help for this please, I need edit client Details from Application depending the data from excel sheet:
Read Range
Open browser
get the (ex: contract ID from excel sheet)
scrap data table from browser
matching the ( browser contract ID = excel Contract ID)
Select the row in Browser
Select Edit
How can I select the cID from browser depending on cID in excel sheet?
@Dhiaa-ABM
little information is derivable for the details. But have a look here for some concepts:
Hello, @Dhiaa-ABM
In this case you can use selector that using variable, The variable is the value in you data in excel.
If you face any issue please drop your question in here
Cheer
Hi,
If you can, please send a screenshot.
Inspect how the table is structured.
Check on how you can use the cID to identify the specific row you want to click.
Sorry I cant make screenshot, the scenario:
1-Get client data from excel sheet( Variable is cID)
2-Extract data from browser.
3-Find the same cID in browser row data table
4- Click edit button in same row
Just I want how to find the cID in browser data table and select it
I need to find cID in data table and and select it in browser window
Check also if you can go to the edit page by using the URL and cID as a parameter.
https://acme-test.uipath.com/edit-row/123456
Where 123456 is a cID.
Yes it is, I i have cID in excel sheet for example(88863793), and I want find it in this table in browser and select the row to click the open button
Get the selector of the select/open button on the same row.
Check if it uses the cID anywhere on it’s attribute or properties.
Hi @Dhiaa-ABM cID value can be passed into the selector dynamically everytime that reads from an input excel
- Read the data into a data table
- Loop through each row
- Within the loop take Element Exists activity to check that Cid present in the browser. Here, Cid value has to be passed dynamically into the selector
- if present, click on that open icon button using Anchor concept of selectors
Below workflow for Reference
SampleProcess.zip (3.0 KB)
Excel Data Table(cDT1, cDT2, cDT3, ,ETC)
Browser Data Table(cDT1, cDT2, cDT3, ,ETC)(Multiple pages)
Read Range from excel data table
OPEN BROWSER
loop:
For each row(Excel data table)
Extract Data from browser data table
For each row browser data table
select cDT1=cDT1 ON browser data able
Click edit button
Excel Data Table(cDT1, cDT2, cDT3, ,ETC)
Browser Data Table(cDT1, cDT2, cDT3, ,ETC)(Multiple pages)
Read Range from excel data table
OPEN BROWSER
loop:
For each row(Excel data table)
Extract Data from browser data table
For each row browser data table
select cDT1=cDT1 ON browser data able
Click edit button