Troubleshooting uipath

Help Studio
1

Hello everyone, I am doing an automation, to automate a website to scap data and paste it on excel subsequently. but I have issues with troubleshooting the automation and I don’t know how to sort and filter my data, I don’t understand how it works.

WhatsApp Image 2023-07-29 at 20.10.50
WhatsApp Image 2023-07-29 at 20.10.501536×2048 361 KB

2

Hi @Jolin_Soh

I think you have modified the selectors for attach browser activity.
When executing the attach browser activity the bot couldn’t find the UI element on the screen.

Modify the selectors in the attach browser.

If you are using to open the browser to automate, better to use open browser activity instead of attache browser activity.

Hope it helps!!

1 Like
3

@Jolin_Soh

Use attach browser activity click “Indicate browser on screen” if you working on chrome in properties select dropdown as “Chrome”
Indicate it on the page you want to extract the data
Use data scraping activity to scrap the data on the target website and store it in datatable.
Use write Range Workbook to write the data to the excel.

  1. Sorting Data:UiPath has activities to sort data in Excel. You can use the “Sort Table” activity to sort the data in ascending or descending order based on one or more columns. Here’s how you can use it:
  • Drag and drop the “Sort Table” activity from the activities panel to your workflow.
  • Indicate the Excel file or table you want to sort.
  • Specify the sorting criteria (column name and sort order).
  1. Filtering Data: To filter data in UiPath, you can use the “Filter Data Table” activity. This activity will help you filter the data based on specific conditions. Here’s how you can use it:
  • Drag and drop the “Filter Data Table” activity from the activities panel to your workflow.
  • Indicate the data table you want to filter.
  • Define the filter conditions using expressions. For example, you can filter rows where the value in a particular column meets a certain condition.
1 Like
4

I did use open browser to scrap my data but when I finshed it will automatically become attach browser.

5

Can’t get you. Could you be elaborate more @Jolin_Soh

6

I used open browser to indicate the websit link subsequently I scraped the data. When I have finshed scrapping my data , the products I have scraped appear on “Attach browser”

image
image967×506 27.2 KB

7

I think you are using the web recorder to scrap the datatable data.

Instead of web recorder drag and drop the required activities from the activities panel.

If you are clicking any element in the first webpage it is redirecting to other webpage.

Then use one more open browser activity and in the properties uncheck the new session option.

Inside second open browser activity insert the extract datatable activity then indicate the datatable.

Hope you understand!!

8

@Jolin_Soh

Welcome to the community

When you record steps by keeping the site open by default you will get attach broswer…what you can do is after recording…drag a open broswer and copy all the content inside attach browser into open broswer and use it

Attach broswer can then be removed

Cheers