Query regarding table data

Help Studio
, ,
1

I have a table in website. i need to get the values in col A(which will have link and some text) and open the links in new tab. When i try to use extract table data option, it is extracting all the data in multiple pages. But the problem is i cannot perform the operation of opening it, as the navigation moves to last page of the table. when i try using findchildren activity, it is returning me only one element for that table, which has complete information of that specific page. How can i get it sorted. i need to navigate through all the pages of the table and more importantly i should open all the links in each row. Kindly advise. Thanks in advance.

2

@Karthik_Krishnan1

  1. Open Browser to Website
  2. Data Scraping Wizard to extract table data into a DataTable
  3. For Each Row in DataTable
    a. Extract link and text from Column A
    b. Open Browser to the extracted link
    c. Add any other actions on the opened tab
    d. Close the tab or navigate back to the original page if needed
  4. Handle Pagination
    • Use Click or Navigate activities to go to the next page until there are no more pages
  5. Close Browser

cheers…!

1 Like
3

@sai_gupta that is the issue, when i use data scraping, it is extracting all the pages data. there will be nearly 50 pages with 30 rows in each page. I am looking for something like page 1 is open, open the links of all the rows and complete the operations and then click next button and go to next page. Because it will take quite some time to load this page. And there will not be direct links…it will be hyperlink. i could not find a way to extract the link while using extract table data

4

@Karthik_Krishnan1

we have a navigate activity to redirect the page

what you want to open the page

Navigate to the First Page:

  • Open the browser and navigate to the first page.

Loop through Pages:

  • Use a loop (“While” or “Do While”) to iterate through the pages.

cheers…!

5

@sai_gupta
image
my table looks as this(after setting the filters)…here i need to click the hyperlink for each row. i am not able to use any looping activity because when the scraping acitivity completes the last page will be visible. so all i need is when page 1 is loaded with n number of rows i need to click url in each row and then i will use navigate browser. i am not able to add any code in between the extraction activity.

6

Hi @Karthik_Krishnan1

  1. You can extracts all the pages links at once and store in a Excel Sheet
  2. Then use read range to read the excel which stores all the links
  3. Next by using for each row in datatable activity you can read the excel and open the links one by one and can perform your required actions
7

@vinitha_yachamaneni No, it wont work because i am not able to extract the link from the table as it is hyperlink…it is copying as text.

8

@Karthik_Krishnan1

can you share the input screenshot if possible

9

@Karthik_Krishnan1

1.Open Browser to First Page
2.While Next Page Exists
3. Data Scraping to extract table into DataTable
4.For Each Row in DataTable
5. Extract Link from Column A
6.Open Browser to Link
7.Perform Operations on Opened Tab
8.Close Tab or Navigate Back
9.End For Each Row
10.Click Next Page Button
11. Wait for Next Page to Load
12.End While
13.Close Browser

cheers…!

10

image
image1282Ă—460 21.8 KB

11

Hi @Karthik_Krishnan1

This thread may help you once go through this