Peforms the same action based on number of rows inside the web page

[Iron_Man_XXX (Gino)]

Hi ,
I need an automatic process in order to write some data into an excel file.
Starting from this base url
http://vincoliinrete.beniculturali.it/VincoliInRete/vir/bene/ricercabeni
I click on ricerca button after selecting in the combo box Regione ‘Campania’ and Provincia ‘Napoli’.
A query result will be displayed

My question is how I can create an action the performs a click on ‘lens’ button of each row

Thanks!

[wasea (Vasile)]

Hello @Iron_Man_XXX ,

It is just an idea, which might be much faster than clicking on the “lens”.

1. Complete the combo box from here: http://vincoliinrete.beniculturali.it/VincoliInRete/vir/bene/ricercabeni
2. Click Ricerca
3. Use data scraping to get the entire table as a datatable
4. Use For each row
5. Inside for each row, add the logic to navigate to specific item, since when you click on the lens it will open a new page that have at the end the Codici number.
   So here you can craft your URL like:
   “http://vincoliinrete.beniculturali.it/VincoliInRete/vir/bene/dettagliobene”+ row(“Codici”).tostring.trim
   For first item will be:
   http://vincoliinrete.beniculturali.it/VincoliInRete/vir/bene/dettagliobene125866

After these steps, you know better your logic if you want to save the data on an excel or so.

I hope is helpful for you.

Vasile.

[Iron_Man_XXX (Gino)]

Can you please send me a screenshot/example related to the part ‘For each row’ ?
Thanks in advance.

[wasea (Vasile)]

Hello @Iron_Man_XXX ,

You can find below a very short/quick flow that navigate to the link you mentioned, select specific options than creates a data table and navigate after that to each url from data table.

Than, you can put your login in the For each row and complete/extract information from those pages.

italy.zip (5.4 KB)

I hope it helps.

Vasile.

[Iron_Man_XXX (Gino)]

Hello,

first of all, thanks!
I tried to open italy.xaml but I get an error… Missing or invalidy activity.

In the error Output I see:

Could not find member ‘CursorMotionType’ in type ‘http://schemas.uipath.com/workflow/activities:Click’. Row: 178, Column: 56

Could not find member ‘Area’ in type ‘http://schemas.uipath.com/workflow/activities/uix:TargetApp’. Row: 275, Column: 28

[wasea (Vasile)]

Well, you might need to update the UiPath activities.

i use 2020.10.4 stable versions
UiPath system activities: 20.10.3
UiPath.UiAutomation.Activities: 2020.12.0-preview

Should work after you update those activities.

Vasile.

[wasea (Vasile)]

Some screenshots:

I hope this helps…

[wasea (Vasile)]

can you specify the code that not working?
Need to understand from where to remove 2 characters, first or last 2 characters…

It’s good for you to check this post…it will help you to understand how to work with strings…

How to manipulate a part of string: Split, Trim, Substring, Replace, Remove, Left, Right

Hi, if you are a beginner in the world of automation and would like to know how you can manipulate text based on the solutions available in the VB.NET code and using REGEX (regular expressions) then you are in the right place. In the topic below, you will learn how to easily extract data from any part of the search text using various methods. The topic includes solution examples with descriptions and graphics to better understand the topic for functions such as: Split Substring Left Right R…

I hope it helps…

[wasea (Vasile)]

That article have the solution for your issue.

Also, at a very quick look, this might be something helpful for you:
row(“Codici”).ToString.Trim.Substring(0,6)

The result for 12808715 will be 128087.

Vasile.

[wasea (Vasile)]

Hello @Iron_Man_XXX ,

The scenario is easy, I believe. Below for the scenario above.

1. Create a new datatabe (ResultsDT) , with those 3 columns…
   2.For each row (from ExtractedDT)
   3.Navigate to each URL
2. Get text activity - varID
3. Get text Activity - varTiposcheda
4. Get text Activity - varTipobene
5. Add row - Activity - to datatable (ResultsDT)

These are the the main steps I believe for this scenario.

I hope it helps.

Vasile.

[wasea (Vasile)]

Hi @Iron_Man_XXX ,

try the flow attached. It has only built in activities, should work…
Italy.zip (8.6 KB)

Vasile.

[Iron_Man_XXX (Gino)]

Great!!! Thanks a lot

Regards

[wasea (Vasile)]

If these solved your issues or answered to your question… you can mark the answer as a solution…