Assignment 1 academy

I completed my assignment 1. But when I run… it opens the browser and login and it navigates to work items and it’s stops… execution has been cancelled info is showing on the screen. Data scraping is not happening. But when I try to run the data scraping workflow alone…it runs successful…what to do. Help me plz

@soorya_prasad

Could you please run the workflow in debug mode and check what is the exact error.

Hi @soorya_prasad

Buddy make sure the extract data table is there inside a attach browser activity and the login page and getting to work items must be in separate attach browser activity…
–place the attach browser activity with login setup and getting to work items as the first one in sequence
–then place the attach browser with extract datatable that takes the data from the workitem table in the webpage

This would work for sure buddy and the reason why the extract workflow when ran separately works is you might have kept the web page ready while trying to extract the data…and that must be missing in the workflow as the bot is not able to find the work item table…and this can be made visible with proper attach browser activity added to it
Cheers @soorya_prasad

1 Like

@soorya_prasad

I can’t see Data scraping activity executing in these logs. Could you please add next screenshots also.

I don’t do any change and I just run another time. but now it runs upto data scrapping ativity. and it stops.

extracting data table workflow

can i have view on the selector of the attach browser activity @soorya_prasad

the login page and navigating to workitems are in separate workflow. do I need to open different tab and then do the data scrapping? and the same for navigating to work items?

@soorya_prasad

Have you created argument of type DataTable or DataRow [ ] and direction as ‘out’ to store result of DataScraping activity in Extract_WorkItems xaml file ?

1 Like

yes. it is in red colour. so what to do now??

yes… that’s all good

1 Like

simple problem. when I tried to change the selector for extract data table activity, it turns green.
automatically the selector for navigate workitems turns red. how to overcome this selector prob?

1 Like

that doesn’t matter buddy…actually that should be in separate workflow only
Fine in data extracting workflow in the very beginning before extractstructured data and after the attach browser add a click activity and make a click on that window…the reason is the though you have navigated to work item window, while using a new workflow of attach browser and extract datatable, the window where we are extracting might not be active…so to make it active we are using a click activity in the workflow where we are extracting…that should work for sure…
Try ad let know buddy
Cheers @soorya_prasad

1 Like

yes. I done that. now it navigates though each page of extracting workitems. there are totally 9 pages. but it stops on the 5th page.

Fantastic…
Check with the properties in the extract structured data activity buddy
check with number of data to be retrieved
set it to 0 @soorya_prasad
Cheers @soorya_prasad

@soorya_prasad

Go to properties of Extract Structured Data Activity and check MaxNumberOfResults value. I guess 100 is there. Could you please change it 0. Then it will read all pages data.

I tried with 0. but it navigates upto 5th page first time and it stops. then I retry the data scrapping and made it 0 this time too. this time it runs upto 6th page and ended. so if I delete the data scraping window now and do it again with value 0, it will run upto 7th page and it will end… but the selector is valid everytime and it is green. I don’t know where I got struck

may i know how many pages are there in total… @soorya_prasad
yah mentioning 0 will work for sure…or sometimes lets mention like in high numbers like 1000
this is weird but that works many times…lets try with that
or if that doesn’t work try to extract again and run the workflow
Cheers @soorya_prasad

1 Like

@soorya_prasad

Could you please check attached workflow for Extracting data from webpage and compare all selectors.

ExtractWorkFlowItems.xaml (8.8 KB)