Data Scrapping from website

Help Studio
1

Need to click on each countries one after other from the website someone please guide me how to do??

@Palaniyappan
@ushu
@Nithinkrishna
@geetishree.rao
@Gokul001

Capture
Capture1228×530 62.5 KB

1 Like
2

Use Find Children Activity For this

3

Thanks for reply, can you please explain a bit more??

4
5

done with datascraping

grafik
grafik663×670 135 KB

then iterate and click

6

Hey @HeartCatcher

I hope that’s a menu which you are showing.

Use Find Children activity to get all the menu elements inside the menu container

Loop through it and use each element into the Click activity.

Hope that helps

Thanks
#nK

2 Likes
7

  1. Use Find Children Activity

  2. Gather All the selectors of the items (countries)

  3. Add all selectors to a collection

  4. loop through the collection using for each loop, use click activity and pass the looping variable in it.

8

Screenshot (35)
Screenshot (35)1366×768 118 KB

But I am getting the selectors like this, when I try to iterate it is not looping

9

Screenshot (36)
Screenshot (36)1366×768 113 KB

10

Hello @HeartCatcher ,

Better to use Table extraction and get it to a datatable. Then you can loop through each row and click on the links by dynamically passing the value “CurrentRow(0).ToString”

It should work fine.

11

@HeartCatcher

  • Please use data scraping which stores all those countries in a data table
  • Loop through each country (Use for each row in data table activity)
  • Within the loop take click activity
  • Pass the dynamic selector for aaname (which is the name of the country) within the click activity
1 Like
12

I used the data scrapping but I am getting entire data at a time as in the attachment I need one by one please do needful

Screenshot (39)
Screenshot (39)1366×768 158 KB

13

@HeartCatcher

Use for each row in data table activity and can get the one by one row. Use below exp within the for each

Currentrow(0).ToString
14

Thanks it is working fine now.

Now i need to click on each currency using the click activity, should I click only on first currency name or I need to change anything in the selectors??

15

Screenshot (40)
Screenshot (40)1366×768 123 KB

16

@HeartCatcher Follow these steps within the for each activity

  • Create a variable of string type (say CountryName)
  • Take assign activity and assign Currentrow(0).ToString to the created variable
  • Now, Select the first country using click activity
  • Open the selector in UiExplorer and check the aaname attribute
  • Make sure you enable that aaname into your selector
  • Pass this variable(CountryName) into the aaname of the click activity selector

Refer below link of how to pass variables in the selector

1 Like
17

Screenshot (41)
Screenshot (41)1366×768 114 KB

while writing the extracted data into excel getting the error as in the attachment

18

@HeartCatcher Use excel application scope instead

19

I used Excel application scope only

20

@HeartCatcher Try to kill excel before this activity and check once