Screen Scraping & Data Table

[Katarina (Eva Katarina Helbig)]

Hey guys,

I have a table in the browser and need to download a file in each row.
The table has a different number of data sets, depending on the settings.

Shall I use Screen Scraping, create a data table and iterate through each line?
Is it possible? How do I get the data from the Sceen Scraping in a data table?

I am beginner and appreciate all kind of help.
Thank you so much.
Katarina

[ppr (Peter Preuss)]

@Katarina
Welcome to the forum

Give a try on Table Extraction

Activities - Extract Table Data

data scraping

Also have a look here:

[HowTo] Data Scraping - Advanced Configuration - Text Field, Image Source, Url, CSS Classname, Hover text

This HowTo introduces on how Data scraping can be configured to retrieve also on non standard information from a web table. After indicating the different data columns with the wizard the extract data definition was post edited and changed to the relevant attributes e.g. value (Text field), src ( Image Source), class (CSS Class Name), tite (Hover Text), href (Url). Introduction Following web table is to use for data scraping and also the non text information should be retrieved. [grafik] We…

[Palaniyappan (Palaniyappan P)]

Hi

Welcome to uipath forum

You can use DATA SCRAPPING method which will help you to scrap the required text or URLs from the browser and get the output as datatable itself

If you are trying to use screen scrapping it will give string as a output
Pass that string variable to a GENERATE DATATABLE activity AND get the output as dt

For example pls refer this

Example of Using Data Scraping

Once after getting the URL then you can use simple activities in UiPath to download file
But pls mention how will you download the files manually

Cheers @Katarina

[Katarina (Eva Katarina Helbig)]

Thanks @ppr & @Palaniyappan for your quick response!

So the Data Scaping worked.

1. for me it seems to be quite static - so how to deal with it when the number of the data sets changes? Or am I wrong?
2. for now, i was working with the Click activities to download the file. How am I supposed to do it now since I am not able to click on the first row in the second column …

Hope you understand my issue.
Thanks a lot!

[Palaniyappan (Palaniyappan P)]

@Katarina

for me it seems to be quite static - so how to deal with it when the number of the data sets changes? Or am I wrong?

It can handle dynamic dataset as well

How to extract data from website using dynamic data scraping?

Hi All I’m new to UiPath. I want to do data scraping in amazon website. That is to search the items from user defined variable and get the product name and price from the result respected to that search. I have try in many ways such as, 1. creating variable in the selector using UIExplorer, 2. to create the variable in url and use that url instead of using Title tag in selector . 3. try to edit extracted data result in extract wizard window but cannot succeed. By using these ways .i can se…

And for this
You can use the same with click activity just by creating a variable in selector and pass the column row values one by one to that variable inside a for each row loop

Steps involved
— for each row -pass th datatable as input
—inside the loop use a assign activity and pass the specific column value to a variable
—next use a click activity and pass that variable in the selector
Now it will click one by one and download it

Studio - Dynamic Selectors

Cheers @Katarina

[Palaniyappan (Palaniyappan P)]

Hi @Katarina

Pls let know for any queries
If this gets clarified it would be great if you can mark the right comment as solution with tick mark so that it will be useful for others

[Katarina (Eva Katarina Helbig)]

Hey - thanks for your answer.

It iterates through the rows and also assigns the columns to the variables.
But still for each row it downloads just the first file.

So in the click activity I tried to pass a variable (the onclick) in the selector but it does not work. It says: the selector is invalid. But the onclick event changes every row so I passed this to a variable and put it in the selector.

What am I doing wrong?
Thanks a lot!

[Palaniyappan (Palaniyappan P)]

Fine
Is the id incremented for every loop

@Katarina

[Katarina (Eva Katarina Helbig)]

No - I think just the onclick changes.
Thats another row:

[Katarina (Eva Katarina Helbig)]

Do you have an idea?