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)
February 15, 2021, 12:52am
2
Hello @Iron_Man_XXX ,
It is just an idea, which might be much faster than clicking on the “lens”.
Complete the combo box from here: http://vincoliinrete.beniculturali.it/VincoliInRete/vir/bene/ricercabeni
Click Ricerca
Use data scraping to get the entire table as a datatable
Use For each row
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.
Can you please send me a screenshot/example related to the part ‘For each row’ ?
Thanks in advance.
wasea
(Vasile)
February 16, 2021, 11:31am
5
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.
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)
February 16, 2021, 12:00pm
7
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)
February 16, 2021, 5:52pm
11
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…
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)
February 16, 2021, 11:00pm
13
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)
February 17, 2021, 10:52am
15
Hello @Iron_Man_XXX ,
The scenario is easy, I believe. Below for the scenario above.
Create a new datatabe (ResultsDT) , with those 3 columns…
2.For each row (from ExtractedDT)
3.Navigate to each URL
Get text activity - varID
Get text Activity - varTiposcheda
Get text Activity - varTipobene
Add row - Activity - to datatable (ResultsDT)
These are the the main steps I believe for this scenario.
I hope it helps.
Vasile.
wasea
(Vasile)
February 17, 2021, 4:31pm
17
Hi @Iron_Man_XXX ,
try the flow attached. It has only built in activities, should work…
Italy.zip (8.6 KB)
Vasile.
wasea
(Vasile)
February 18, 2021, 9:22am
19
If these solved your issues or answered to your question… you can mark the answer as a solution…
system
(system)
Closed
February 21, 2021, 9:22am
20
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.