Pattern Based Data Extraction | Recorder Package | While Loop - Automation Anywhere A2019 #21

[@qualityassurancelab7764]

Hi Guys! Hope you found this video useful. Please like, share and subscribe to my channel. This will motivate me to create more good contents. Thanks!

[@abhishekmisra608]

Your tutorial videos are really helpful, Thanks!

[@nehag2367]

mam, please provide notes link

[@abhijeetsingh089]

Once again superb

[@qualityassurancelab7764]

Thanks a lot!

[@RahulKumar-qy2kj]

This is the video i was waiting for. Thanks QAL.😇🙏

[@qualityassurancelab7764]

You are welcome, keep learning!

[@roshnigannote5162]

Hi mam, in my code the counter variable is not working only static value I'm getting not dynamic.

[@Ramaramarama471]

Wow nice explanation..

[@premrajnish2046]

Please create a video for learning xpath. Thanks. I watch all your videos and find them so helpful.

[@testaccount9002]

Hi i want a little info, is it possible to extract from "data grid view tables" from a website.

[@sakthivelcslm]

Thanks for all you A2019 videos . All your videos much helpful for learning A2019. Could you please post few videos for Excel Pivot table for dynamic range and SAP , ***Copy excel table and paste in Email body and send the report to mailID" , PLease post one video like this , if possible"

[@qualityassurancelab7764]

I am glad that you found my videos helpful. i will plan for the requested videos.

[@shoaibshabir1914]

you can put the outer loop condition at the end of the inner loop

[@qualityassurancelab7764]

Yes, that's why I have checked the box to check the condition at the end end of iteration

[@navedansari7778]

Hi, I can't find NumberUtil action (22:26). I am working on AA Bot agent version 18.10.8800. and AA Enterprise version 20.19.8122 Can you please suggest any alternative to this action ?

[@qualityassurancelab7764]

Please use Number -> Increment instead

[@Boykub1111]

@@qualityassurancelab7764 sorry, it's not work for me Can you please suggest any alternative to this action ?

[@jassujaswanth6393]

Thanks for the info

[@vijayrajagopal5591]

Thanks for the video!! Requesting one session related to mainframe application, Can you please make one.

[@prabhatsuyal6266]

this vedio is very important I tried exactly the same scenarioes that you are using, but I am getting issue while finding the description and price //div[@class='_2kHMtA'][$counter$]//following::div[@class='_4rR01T'] I think dynamic xpath is not working. i can use this only //div[@class='_2kHMtA']//following::div[@class='_4rR01T'] Can you please help , is there any other way to find xpath that work for multiple elements

[@SY_B_03_OmkarAher]

Mam in my case in the first loop you provided number assign and to string action that is not working actuallly it directly jumping to next loop thats we im getting only 3 entries in my extraction result based on conditions in the first loop

[@vinitjoshi9225]

Thank you for this Amazing Video! Your all A2019 videos are simply amazing, the way you explain every step is very appreciable.! Great help in learning A2019! I have followed the exact same steps but I am facing 1 issue- "Instead of extracting all 74 records it's extracting only few records in a log file. Can you help me resolve this issue please?" Thanks in Advance!

[@qualityassurancelab7764]

You are welcome, glad that you found the videos helpful. Could you please let me know the pattern of few records which got added to the log file? Are the records from a single page or from multiple pages? I noticed at present, most of the Iphone 11 results from flipkart are temporarily unavailable. Since the xpaths of temporarily unavailable items are different, those would not be extracted.

[@ashokkumar-fv6go]

Hi madam, can you please take one class on xpath so that we get idea how to do changes in different scenarios. Tq

[@escapeenrique]

HI, I did same as you but my capture for "get property"is not working, also the iteration among the different elements is happening but m not getting any value in any of the "get property" steps

[@qualityassurancelab7764]

Hi, please let me know what xpath and property name you used.

[@escapeenrique]

@@qualityassurancelab7764 //div[@class='_2pi5LC col-12-12'][$counter$]//following::div[@class='_4rR01T'] -->for product desc //div[@class='_2pi5LC col-12-12'][$counter$]//following::div[@class='_30jeq3 _1_WHN1']-->for product price

[@manoharnookala4212]

How you know use only search for iphone 11, user might be search for any product, right. then how can i automate that process

[@nirajbhanushali8884]

Hi, I have one excel and in that excel some cell contains hyperlink of the sheets of same excel i want to open that sheet from cell hyperlink how can i do that ?

[@sajalgpt8]

Hello Maám! My extraction didn't get saved in the text file inside the log action. I followed the exact path that has been told in the video. Please help !

[@qualityassurancelab7764]

Hello, could you please check by adding a message box with the extraction values before the log to file action? Please check if you get the values in the message box. Also, make sure the actions are added properly within the loops. You can use flow view to validate the actions in loops

[@martinettm7048]

@@qualityassurancelab7764 Hi mam ..I did everything perfectly ..But didnt get the values in my message box or my log file..pls help me with this mam

[@ajithcs4321]

Thanku u mam so much for this video cud u create more complicated bots using automation anywhere or any use cases if any if possible.It would be of great help .

[@qualityassurancelab7764]

You are welcome, I will share the bots with complex logic soon.

[@vahinikrishnaa9642]

thanks for the vedio!! i did this ,but the bot is not navigating to the third page it stops at the second page any suggestions for this

[@qualityassurancelab7764]

Did the bot threw any error? Did it extract complete data from page 1 and page 2?

[@vahinikrishnaa9642]

@@qualityassurancelab7764 no error, yep it extracted

[@qualityassurancelab7764]

@@vahinikrishnaa9642 Please try by adding a delay action with delay of 10 sec after inner loop is over

[@anushkanaroji9981]

How to extract the data in Excel sheet instead of note pad?

[@dibsaha5593]

Hi please assist me. Didn't showing the website under universal recorder or normal recorder which I want to capture if i will refresh it even its not works. What is the reason?

[@qualityassurancelab7764]

Hi, could you please try by opening the website in a new window?

[@dibsaha5593]

@@qualityassurancelab7764 great, thanks

[@ThePraveenkent]

So A2019 do not have pattern based data extraction feature ? There is lot of xpath coding

[@qualityassurancelab7764]

There is no direct option to do pattern based data extraction. And, it is good to learn about xpaths, very helpful for dynamic elements

[@sumanthbs2555]

In one bot, I created one variable say count and in another bot bot I'll create variable count ..is these two variables are same.? In the second the bot if I select count variable, which variable it ll select? Is it select from the first bot or second bot

[@qualityassurancelab7764]

Second bot will pick up variable declared in the second bot.

[@sumanthbs2555]

@@qualityassurancelab7764 oh ok..it ll not display previous variable

[@sumanthbs2555]

Mam I hav asked one question in real time project vedio..pls reply on that

[@user-ss9ow7wd9k]

Hi , my requirement is to save the whole web page as a pdf , can u suggest any process, rather than doing ctrl +p

[@rohittembhare6412]

if i required last mobile description and amount for all 4 pages, how i should get it what modification required in code.

[@pravinkumarchavan9669]

Hello, I got a query , where my xpath points to the text box and i am taking values from excel and write it to text box and get the result. However on one of the result my scrollbar moves to bottom of the page and in this my program fails as i believe it unable to find textbox. How to resolve it

[@meghanavincent3469]

Could you confirm my below query: To capture the item description, Can we use Property name as innerText instead of innerHTML?

[@qualityassurancelab7764]

Hi, in this demo both innerText and innerHTML will work. But the behavior of both these properties are different. So use them as per the requirement. Quick Reference - www.microfocus.com/documentation/silk-test/210/en/silktestworkbench-help-en/SILKTEST-21EEFF3F-DIFFERENCEBETWEENTEXTCONTENTSINNERTEXTINNERHTML-REF.html

[@meghanavincent3469]

@@qualityassurancelab7764 thanku :) I want to join your channel to get support for Advanced RPA certification, have sent an email as well, Kindly reply.

[@barath4ever]

Thanks for these videos. Helpful in learning and understanding on how to use this RPA tool. Is there any reason on creating a number variable first as count, assign 1 to it and then convert it to string?

[@qualityassurancelab7764]

Thank you for the valuable feedback! I took number variable so that I can increment it by 1 under Calc Action- $Count$+1 I took assign Action so that the Counter variable resets to 1 every time before inner loop starts. Inner loop should start working with Counter variable value to 1 I converted it into string because Number variables can not be used in xpaths Hope this helps, please let me know for any further questions.

[@barath4ever]

@@qualityassurancelab7764 Thanks. This helps.

[@meghanavincent3469]

@@qualityassurancelab7764 Can we also use Increment action as alternative to Calc action.

[@priyeshsharma4476]

@@meghanavincent3469 yes

[@Aviat91]

Hi,I'm Avinash would like to join for the RPA Course is there any online class????

[@rohittembhare6412]

well explained, can u please make a video on fetching latest courier tracking details from any courier company as you have more than 2 shipment no. and u want to fetch the latest tracking details (like Location, date and status) from the courier website for all the shipment.

[@qualityassurancelab7764]

Thanks, I will plan for the video on the mentioned scenario

[@bhautichauhan2254]

Hello Ma'am On Flipkart website page is going to next button page stop to move forward. Even I go though with your given steps only still i got these error (Client Search Criteria did not match at line no.9) can you please guide me to solve this..!?

[@qualityassurancelab7764]

Hi, what action you have at Line no . 9? Is your bot extracting data only from first page? And, is the bot not moving to second page?

[@bhautichauhan2254]

@@qualityassurancelab7764 I have used Capture:(Recorder) at line no. 9 and 10. I got only Single Product value approx. 74 times and also bot not moving to another page.

[@meenaxavier3575]

please provide video for html mail body in a2019(send excel table in mail body) in html fomat

[@ritupolictchacklen7325]

Hello mam Every time loop is running only the first phone details getting printed in text file continuously I mean all the 24 times. Please help

[@dream11fantacytips19]

Hello, could you please help me on how to extract specific columns from one excel to other using A2019.

[@qualityassurancelab7764]

Hi, please use Excel Advanced -> Read Column Action

[@lividalanoori3824]

I'm getting a error at line 9,unable to perform GETPROPERTY action. CLIENT is unavailable.... Pls tell how should I rectify this error.

[@neenusb2370]

hi, how we write into text after extracting information from site?

[@NILESHKUMAR-yc1vj]

Please create some content on excel operations briefly..

[@qualityassurancelab7764]

Please checkout these videos, hope these would be helpful - kzbin.info/www/bejne/j3appXivpKx1ocU kzbin.info/www/bejne/h6TZnmmFoaecb7c

[@Artech.Ranjit]

if there is no next button or 2nd page, but we have a list of links on the same page to click , what is the solution?

[@rajeshyeluri2492]

In Domxpath if if pass counter variable im getting error - unable to find Clients.criteria did not match. But if i pass normal number it is executing correctly how to fix that problm

[@qualityassurancelab7764]

Please share the DOMxpath and object properties selected for the action

[@MrSackatack]

Hello how are you, I made the bot in the same way even with the same variables but with a different page, I checked that the correct data was selected but when executing it it does not save any data and it appears that it was executed correctly, if someone can help me Tell me why that happens or what do I need to capture and save the data? Greetings

[@mansigp27]

Hello ma'am I m note able to find launch web site option

[@mansigp27]

Hello ma'am you provide training in this technology also please let me know

[@rajeshyeluri2492]

If i check xpath in browser it is Identifying elements correctly but in bot for second iteration bot thows error

[@qualityassurancelab7764]

Please share the xpath you are using

[@rajeshyeluri2492]

For description_ //div[@class='_1AtVbE col-12-12'][$Scounter$]//following::div[@class='_4rR01T'] For cost_ //div[@class='_1AtVbE col-12-12'][$Scounter$]//following::div[@class='_30jeq3 _1_WHN1']

[@mirellemartis1017]

Could you do the same for the amazon website

[@aishusekar4972]

Hi mam. Can u help me with this project. Say, a website about various schools . If we filter out a schools name, it will fetch all records of the schools and put it in excel format. Please help

[@sreeharis3989]

how can we save the data into an Excel sheet with column names ProductName and ProductPrice

[@ajitkumar-oo8qy]

Hi, Can anyone tell me how to get the last downloaded file details from "chrome://downloads" page using AA 2019. Not able to use capture command, as the controls are not getting highlighted to capture them. Thanks in advance

[@Artech.Ranjit]

Somewhere in 2nd page, it got stopped. didnt go to the 3rd page.

[@qualityassurancelab7764]

Please check loop conditions. If everything is correct , add the Delay action before capture action to click on Next button

[@yallamrajuanirudh9425]

I am unable to find NumberUtils in the Action bar Does anyone have a solution for that?

[@Firewatch1234]

its not clicking on next button , only first page data is extracted

[@AG-qp8pb]

I have question. I am not technical guy and i lost my focus on your video, despite it is informative. So is this video for technical people or for all ?

[@Tarak_Tech]

Thanks for the video!! Requesting one session related to mainframe application, Can you please make one