Hi All,
I am trying to automate an application(WinAMS) where i need to do data scrape from a table. But with UiPath I am not able to scrape the data and it says not a valid table cell to get the data. I have tried using OCR, get text and nothing is working. Could you please help/suggest some ideas to automation this.
Hello @santosh.kumar2 ,
The table which looks like a table is not a table, what actually you can do is explore the application and check if you have the option to export the table or not.
I hope that is available, it will make your task easy.
Thanks,
Sanjit
Hi @santosh.kumar2 is it desktop application or web application? Could you share a screenshot that you want to scrape?
There is no way i can export the data via excel.
@santosh.kumar2 are you able to indicate that table by structure data table activity?
No, I am not able to indicate. That’s why I am not able to access those data.
@santosh.kumar2 could try with screen scrapping with Microsoft ocr and set the scale value to 3.
Hello @santosh.kumar2
Can you try Extracting the entire fields as a text and use Generate Data Table activity to make changes and you can be able to get desired output, do let me know if this works out.
Hello @santosh.kumar2
Plz inspect on a row in the table using ui explorer and share the selecting here. Can share the screenshot here for better understanding.
Thanks
Its giving me null value. I tried all possible way like normal text extraction and with OCR. But no results.
Each row level I am not able to get the selectors that’s why I am not able to get those data
Screenshots and selectors for reference.
Hi @Tapan_Behera1 , I tried this method I am getting data but not in proper way. Also after i get data i need to edit those fileds as well. How to edit as I am not able to get the selectors in row level
Hello @santosh.kumar2 ,
Try changing the frameworks and indicate on the screen again, Try different frameworks.
@santosh.kumar2 Could you please try using Get full text activiy inside a loop by givingthe selectors dynamic
This way you can achieve scraping the texts inside the application
Regards
Sreejith S S
Hi , There is no selectors. How to give dynamically.
Try to use Ui explorer
You will get more idea.
IF data scraping is not working then the only way to scrap text is using the screen scrapping or by using the Get text activity
Regards
Sreejith S S