I am not able to scrap all the 2000 rows of records using data scrapping, where I am getting only 16 rows of data. Please help me in this. I tried increasing number of results to 5000 still getting only 16 rows of data instead of 2462 rows of data. Moreover data definition is also same for all the rows checked with selectors.
Web application.
Does the rows auto loads when you scroll down or all the 2000 rows are available at once in the page? Do you see only 16 rows at a time visible in the screen? Just trying to understand if the table rows itself if visible in the screen for the robot to scrape all the rows.
I see all the 2462 records at once, if you see 1st screenshot I posted on the screen there are 11 rows visible but it extracted 16 rows of data. I think it is not problem with table visibility. But don’t know the exact reason for not extracting all the rows of data. Is there any workaround for this, I checked 17th row value with selector, I see its properties are same as the extracted 16 rows values defined in data definition.
Hi Rishabh, I tried both ways the one i posted is with manual extraction you can see single column, I tried whole table as well with which i got only 1 row of data.
It may not be an efficient way but you can also try to scrape the table data using Find Children activity if everything else fails.
Use a Find Children Activity and indicate the table selector. You may have to provide the proper filter tag that filters the particular value for each of the row for a column. Use a For Each Loop on the list of elements and then get the aaname or relevant attributes that has that row value using Get Attribute activity.
I have tested iterating in while loop as well, it is getting only 16 rows of data based on the rows visible on screen. 17th row is becoming index ‘3’ if i make it visible by scrolling down and again able to fetch next 16 records. How to handle this in UI path.
Hi Rishab,
I am getting UiElement is no longer valid error. Is there any workaround to get all rows of data from same page (by scrolling down). I tried screen scrapping, data scrapping and While loop get text based on Index still was able to get only 16 rows of data. next after scrolling down the index is again starting from ‘3’ till ‘18’ so it is working on visible sets of data.
So all the rows are not available at once to scroll the data table. May be you can first send page down or End hotkey until the scrollbar reaches the end, so that all the rows are visible and then try to scrape the datatable.
I had the same issue. I finally fixed it by continually deleting items from the “Edit Data Definition” box until i got what I wanted. I had about 60 items to retrieve. After I deleted the first 3 lines from the Data DefinitionBox, I was finally able to get all 60 rows instead of the first 16 like I was originally getting.