UiPath Tutorial 12 - Real Time Project | Extract Multiple PDFs Data to Excel | Anchor Base| Get Text

Hi Guys,
In this video, we will create a demo project to extract data from multiple PDF and write to excel.
==================================================================
JMeter Tutorial Playlist:
• JMeter Tutorial
Git and GitHub Tutorial Playlist:
• Git and GitHub Tutorial
Automation Anywhere Tutorial Playlist:
• Automation Anywhere A1...
UiPath Tutorial Playlist:
• UiPath Tutorial
Subscribe for more tutorials - / @qualityassurancelab7764

[@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!

[@VNTHOTA]

This is the best video I watched. The faculty is excellent and her voice is pleasant

[@qualityassurancelab7764]

@@VNTHOTA Thanks for your time and feedback

[@hareeshsfamily8221]

@@qualityassurancelab7764 Can someone please help me with PDF files used in this demo

[@rajulgupta3614]

Microsoft OCR is not working on my system can you please tell me why this is happening please help me to solve this problem

[@itulone9399]

I need the 3 PDF's please. I have mailed you also.

[@merazhussain6022]

Your way of teaching is the reason it's very easy to understand all the steps required to create a robot. Thanks for sharing your valuable knowledge to the masses

[@qualityassurancelab7764]

I am glad my videos are helpful to you. Keep learning and please share these videos with your group.

[@munakalagopalreddy2545]

#Nice Explanation...# Its is very helpful for for us.... # Thank you....

[@andyyeo5757]

Excellent use case, Madam. This is very useful, I really appreciate your effort to teach us all these. Thank you.

[@MultiFeelmylove]

getting error in ui path anchor based selectors are not supported in selector editor getting this error

[@qualityassurancelab7764]

This is an expected behavior. After the anchor is set, the selector of the activity next to it will be limited to a partial selector in relation to the anchor.

[@rpabeginners4576]

Thank you for this vedio, i was not cleared about anchor base activity and pdf automation but now it's clear thanks again ma'am 👍

[@NT-it3gr]

This video is very helpful. Thanks for also repeating the whole flow right at the end.

[@molinodeviento8598]

This is a brilliant explanation and case representation, thank you very much!

[@martaduino1600]

Great explanation, thanks a lot!

[@yashparekh22]

Hi, how can we extract data in case of scanned pdfs with multiple invoices in it and also the format of invoices will be different.

[@ashwinikadam9002]

hey did you get the solution for this

[@kamleshbogun7222]

Awaiting solution for scanned pdfs too.

[@josefisrael9887]

Thank you for sharing your knowledge with such clarity. God bless you

[@sudhanshuvats8293]

thanks sahiti

[@PRAVEENKUMAR-gb4wn]

Super

[@mohamedraffat6814]

Hi, I have a problem to do this project as "Anchor Base" Activity has been removed and i dont know how to get only one element in the PDF file

[@anilgulati9060]

Hello Ma'am, what if, i have a multipal pages pdf with different vendors invoices. so can i use the same process? however, that pdf contains scanned invoice & system genrated invoices. please advise.

[@Artech.Ranjit]

would u suggest if the content extended to next page, how to handle?

[@nehadhawan9623]

Brilliant ...

[@shreyjain7729]

Great vid! I want to extract specific data from pdf and for that i am using anchor base. but the trouble is that it works for a couple pdf's and then it throws an activity timeout error. Any ideas!?

[@sanjnasingh6885]

Hey mam please really as soon as possible mam main attach window nhi dekh pa rahi hun apne ui path par kya aap batayenge iske package ka naam ya phir main kya karun bata deejiye

[@negarmishu]

Hi, in my case, my uipath can't change the read order by using hot key command, any idea why it happens ?. Thanks

[@sumittariyal6538]

I can't target on the specific item and that tagged reading order option is not shown in my adobe what can i do

[@SyedAli-iq4ku]

Thank you!

[@rajulgupta3614]

Microsoft OCR is not working on my system can you please tell me why this is happening please help me to solve this problem

[@Adipoll007]

Brilliant!

[@manasarajasekaran]

I’m getting Activity time-out exception in the find element frequently. Can you help me with this ??

[@rohitchauhan9987]

Send hotkey (Ctrl + shift + 5) isn't working and directly jumped to enter, not showing the reading option after that it is showing activity timeout exceeded in find element

[@qualityassurancelab7764]

Could you please try again by adding a delay under Send Hotkey Activity? For that, move to properties of all Send Hotkey Activity. Provide the value 10000 (i.e. 10 sec) under Common -> DelayAfter and DelayBefore

[@rohitchauhan9987]

Still the same issue is there shortcut keys aren't working and in that time i have to porvide it manually then it is showing the result

[@nathanmora9734]

@@rohitchauhan9987 Im also having the same issue

[@MrAnupam200]

@@nathanmora9734 First open pdf file, click on properties and check whether tagged pdf is "yes" or "no".... if it is no you have to use OCR engine for extracting data, it cannot be done using find element .... hope this answers you

[@subhasishghosh2467]

What if the extraction is supposed to be done from the second screen

[@rajasekhar7825]

Supper mam

[@swatimoghe6725]

Hi, Unable to write Captial I in send hot key, it takes only small i , so I didn't get proper output...any other short key for that available send hot key option.Thanks

[@hobbyako9326]

Thank you for sharing this great video. I am wondering if this could on multiple pdf files but in different format, example different invoice format from different suppliers, and extract the common data like invoice no. and invoice amount to excel spread sheet

[@srinivaspothula6243]

kudos to u

[@ganga2997]

Mam, why is there a need to move the pdf to its actual size? Also I am not able to select specific data from pdf even after changing the reading mode, what should I do?

[@AdityaPrasad-kd6wq]

mam how to do same pdf setting micro soft edge when we r opening pdf

[@sakthivelcslm]

Thank you...very much helpful.. How to extract and move the date from different type of pdf document.. I have many 50 PDF document which have different format.

[@mysticeyedigitalsolutions299]

Thanks for your classes on UIPath. Its really helpful and I really appreciate your effort in creating this video. Am using Foxit pdf it is not highlighting the individual after doing the "Infer reading the document" Is there any other way we can fix this? Are do I need to use only acrobat pdf reader?

[@MrAnupam200]

Use OCR engine instead of infer reading

[@abangimran82]

I dont see the screen scrapping and data scrapping menu at the ribbbon section. Can you teach and guide me please? Its very frustrating to be unable to find it. Thank you

[@prashantrai5911]

While using attach windows and modify the selector as per your instructions and when it's run it through selector error.what will be the reason

[@AqilahSulaiman-m9w]

Hi Madam, thanks for your insightful video! However, I encountered message box appear AV2MetaDataPanel when running. Can you explain, what happen and what should I do? Thanks !

[@ebonystinger]

Hi, is it possible to share the sample invoices?

[@qualityassurancelab7764]

sure, please send me an email at [e-mail]

[@murugand4158]

Hey how to select multiple cells or range from multiple excel file one by one and Paste in Transpose mode in one excel automatically using Uipath ??

[@himanshumehta8481]

did you get the solution ?

[@rimantasdanilevicius6754]

Hi, will you be able add to description those .pdf examples to work with? :)

[@qualityassurancelab7764]

Hi, I have sent he PDFs to you over the email.

[@hareeshsfamily8221]

@@qualityassurancelab7764 Can you pls share pdf files to work with

[@qualityassurancelab7764]

@@hareeshsfamily8221 sent

[@threefingers]

This video is very clear. However i have 3 issues: i) When I changed the Read Mode to "Infer" I was unable to select the target ii) The "Close Application" activity returned an error as it pointed to the specific file name. Any way to omit title for the "Close Application" activity? iii) The anchor base shows the correct text when I'm creating, but when I run, it returns a different set of text. Appreciate if you could help me Ma'am.

[@murugand4158]

when I run the file the value of gettext was not right. But in anchor base it shows right value.. any solutions?

[@ashish_dewal4245]

Hi, I want to write the Path of the folder in the Excel sheet as a link. So do you have the solution...

[@qualityassurancelab7764]

Send HotKey Activity will be useful here. Press ctrl + k by using Send hot keys to open the Insert Hyperlink window Again, make the use of Send HotKey Activity to provide necessary information under Insert Hyperlink window

[@kannikantibharat6347]

HI , I had used all the shown hotkeys and 1st-time "Change reading options of the current document" is displayed and the start button was clicked. Issue: Observed the popup is again coming and human intervention is needed in middle, i had tried so many hotkeys but nothing worked, Could you please help.

[@MG-vb6ms]

I am facing the same issues.

[@MG-vb6ms]

Hello miss, can u please check the hot keys again as thay are not working in my case. I have followed u exactly but after enter is pressd the cursor just goes to end of the page and find element activity gets timeout.

[@monicapolepaka6715]

Hi mam, my Uipath studio set up is getting closed automatically..can you please suggest and help me in this...

[@qualityassurancelab7764]

Hi Monica, could you please close all the processes that start with UiPath from task manager and try again? Let me know if that works!

[@monicapolepaka6715]

@@qualityassurancelab7764 ok mam, I will try and let you know

[@monicapolepaka6715]

Mam..i doesn't find any Uipath thing in task manager..everytime I need to install it from the set up..im not getting what went wrong..

[@qualityassurancelab7764]

@@monicapolepaka6715 At what point Uipath studio set up is getting closed automatically? Which OS are you using? Could you please share the error logs from UiPath and Event Manger?

[@abangimran82]

I do not have "attach window" activity How do i obtain it please? Tq

[@sarathkumar4510]

once sequence end it again runs that same how to end , please guide me

[@Rajendra-k3x9g]

Why you used attach windows container

[@hellofoxxymeow5003]

Hey I got the Reading Untagged Document with Assistive Technology Prompt so what do I do?

[@utsabbashyal7929]

i have changed the reading options of current document to infer reading order but it still highlights more than on word for number any solutions please?

[@marcr2204]

Looks tedious to get just those two pieces of information from PDF's any other option or alternative?

[@qualityassurancelab7764]

If you have multiple of fields to be extracted from multiple pdf files, it is going to be very helpful. You can also checkout IQ bots for data extraction - kzbin.info/www/bejne/mWqwaKmqq6eJi6s

[@SandeepYADAVggn]

What if the pdf page size is different, i.e., A4/Legal, etc... Then how to extract.?

[@muzammil2927]

Mam though I changed the read mode to infer , anchor base selects the whole, what should I do??

[@qualityassurancelab7764]

Hi, put a delay and try again

[@prasanthvarma9501]

​ @Quality Assurance Lab Can you please send the pdf files to me? I was using the pdf's with infer reading order mode, but even then when I click on find element it selects the whole pdf

[@qualityassurancelab7764]

Sure, please send me email at [e-mail]

[@vaishnavivikram5575]

Add Data Row: Cannot set column 'Name'. The value violates the MaxLength limit of this column....what sort of error is this ?

[@qualityassurancelab7764]

May I know what value you added in ArrayRow field? Have you checked account number and contact number extracted properly using message box?

[@anthonyjosephramosramos5220]

Can you please share those pdf files? It is hard to follow the lesson than we dont have the same files

[@satishpandey4447]

Excellent, pls share the dummy PDF file as mine was giving the wrong output...thanks

[@qualityassurancelab7764]

thanks, please send me email at [e-mail], I'll share the pdfs

[@kaushik__7728]

hey can i get this pdf for practice

[@monikabhatroy9648]

hii ma'am actually i want to ask u if we want table data from the pdf and save it into excel how we will do that could u plz tell me

[@abangimran82]

My "for each" activities is different from yours. Why is that? Another thing, can you teach and guide me how to bring out the activities "Microsoft OCR" as well? Tq

[@constantinctin3100]

I cannot find attach window in my uipath

[@amancheema8419]

Thanku so much ma'am Ma'am when I run the file the value of gettext was not right. But in anchor base it shows right value

[@nanir9625]

Hi, can you please share those pdf files? It is hard to follow the lesson than we don't have the same files, Thanks in advance.

[@qualityassurancelab7764]

Sure, please send me a mail at [e-mail], I will reply with the PDFs

[@nanir9625]

@@qualityassurancelab7764 Thanks for quick response

[@itulone9399]

@@nanir9625 Did you get the files? Can you share them plz?

[@Flash_Trendz872]

@itulone Did u get those pdf.

[@Flash_Trendz872]

Please send me those pdf

[@deepakss1091]

HI ..can you tell me how to load urls in a single browser tab from a variable

[@qualityassurancelab7764]

Do you mean a url1 will be launched in a browser tab and url 2 will be opened in the same tab (url1 will be closed) ?

[@deepakss1091]

@@qualityassurancelab7764 yes.. after loading url one and performing data scraping .we have to close and open url2 in the same tab

[@qualityassurancelab7764]

@@deepakss1091 Please follow below steps: Add Open Browser activity to launch url1 In the body of Open Browser: Add Send Hotkey activity with Key Ctrl+t to open 2nd tab Add Type Into activity to type url2 in 2nd tab

[@garywilliams1162]

Please provide a link to download the PDF file.

[@qualityassurancelab7764]

Do you mean the pdf files which I have used in the video? If yes, could you please send an email at [e-mail]

[@garywilliams1162]

@@qualityassurancelab7764 OK I sent email.

[@nitintembhurne3902]

Can you please make one more video on the same topic and make it very simple way, Please

[@mayur2021]

How to solve the problem "Communication between UiPath Studio and Taxanomy manager ended unexpectedly"?

[@test1koo285]

error :- anchor based selectors are not supported in selector editor

[@zulqarnainkhan317]

What if we have multiple pdf files with different names?

[@bharathreddybharathreddy7713]

hi , while execution its throwing me an error like this format plzzzz can you help with this one source:find element chrome_renderwidgethost message:acitvity timeout exceeded exception type:uipath.core.acitvities.activitytimeout exception

[@yusufshaikh4902]

Hi Quality assurance lab, I am watching your videos from start and it is best videos, but now i am try to extract PDF data using Anchor base after watching your video the output i get every time is 0. Can you (Quality assurance lab) help me in this.

[@qualityassurancelab7764]

Hi, could you please share the pdf and your UiPath project file at [e-mail], I'll take a look.

[@hareeshsfamily8221]

Hello can you pls share pdf files used for this demo

[@hareeshsfamily8221]

Hello can you please share PDF files to [e-mail]

[@hareeshsfamily8221]

Can someone please help me with PDF files used in this demo

[@qualityassurancelab7764]

@@hareeshsfamily8221 I sent files to you email

[@abhijeetsingh089]

Mam please complete A2019 course..for Automation Anywhere..we are Highly dependent on you

[@qualityassurancelab7764]

Here you go for Automation Anywhere A2019 Video - kzbin.info/www/bejne/gXbdmHetn9GpjK8

[@ujangsujana5272]

Verry detail, thanks for tutorial

[@qualityassurancelab7764]

@@ujangsujana5272 You are welcome, keep learning!

[@ujangsujana5272]

👍

[@213-shreyapatil.9]

Error yetoy start process la sir

[@santiagoramirez9406]

5:04

[@richardlazaro6969]

Hi Good day to you, This is Richard, i am continuously watching your session, just need you expertise for some project that we need to provide with Event Viewer. Step1 Type in the Event Viewer on the search tab, press enter Step 2: Double click Windows logs and click Application. Step 3 is the critical part that i cannot figure out. Client wants me to only get the "Error" without using the Filter logs. they want me to get the data for all Error for "Date and time", "Source" , "Event ID" and the message in "General" automatically save it to Excel file. what function in UI path do i need to use? filtering the log for error will have more or less 2899 datas that need to be extracted. Appreciate your help.

[@pradeepreddy5682]

can u please me pdf file for practice ????

[@qualityassurancelab7764]

sure, please ping me at [e-mail]

[@janmillenserna2147]

Hello, ma’am. Can I have the copy of those PDF files?

[@dakimitrov8787]

Hi I have some UiPath issues how can I contact you? Do you have a telegram group or discord e-mail adress? I

[@qualityassurancelab7764]

Hi, please reach out to me at [e-mail]

[@kasthuriyuvaraj2702]

I need gross seperate net seperate tax seperate name and check num seperate..will this platform support everythin..pls guide me on this.wat are all i need to give

[@asmuru78anand25]

Please share pdf file which is used in this video, Thanks in advance

[@qualityassurancelab7764]

sent

[@Flash_Trendz872]

​@@qualityassurancelab7764please share the pdf

[@rimantasdanilevicius6754]

Can you please share those pdf files? It is hard to follow the lesson than we dont have the same files :)

[@qualityassurancelab7764]

Hi, I have sent he PDFs to you over the email.

[@hari-codes]

Hello Maam, @Quality Assurance Lab I am facing a issue. so even after i select the "Infer reading order from document", it still highlights a block of text instead of the single word. Can you tell me what can I do?

[@qualityassurancelab7764]

Lets say To move to "infer reading order from document", you typed ctrl+shift+5. Could you please let me know which Reading order is selected by default if you again type ctrl+shift+5?

[@hari-codes]

@@qualityassurancelab7764 yeah I selected the same but when I try to highlight on a specific text it highlights both indicator and its value

[@ashwinikadam9002]

@@hari-codes hey did you get the solution for this, if so please tell, even am facing the same

[@ashuterdal2897]

Hi ...please share PDFs for practice..

[@bhargavmanisankar157]

Please share those Pdf's for practice purpose

[@suriyar1906]

Can you please share the PDF files

[@WongXinYin]

Hi Lady,my get text activities keep getting empty, do you know what happened?

[@qualityassurancelab7764]

Hello, have you changed the reading order to Infer reading order?

[@WongXinYin]

@@qualityassurancelab7764 Ok,let me try😁，thanks for replying btw.

[@totsiemarquez802]

Hi! Can you share me the PDF files?

[@qualityassurancelab7764]

sure, please send me an email at [e-mail]

[@rohitchauhan9987]

Actually i don't have any of utility bill so can you help me out from where i can get all these sample pdf

[@qualityassurancelab7764]

Please send me an email at [e-mail] and I will share these sample pdf files.

[@rohitchauhan9987]

@@qualityassurancelab7764 i have send u my mail plz check it out plzzzz

[@Likhith-fq1vr]

Can you please sent that pdf files

[@anuritamishra98]

What to if the pdf folder names are different???

[@qualityassurancelab7764]

Store all folder names in Array of String variable and add For each activity to loop through that array. Do the entire project shown in the video under For Each Activity

[@jeyapauldavid5596]

I want extract text for 10000 + documents can use it.

[@anfinrozario6823]

Could you please sent me the pdf files? Thanks In Advance

[@qualityassurancelab7764]

sure, please ping me at [e-mail]

[@sabinaliao5272]

Could you please sent me those pdf files? Thanks!

[@qualityassurancelab7764]

Hi, please ping me at [e-mail]

[@aakashlakhangaonkar912]

@@qualityassurancelab7764 Can you please send me the files too, I have pinged you on mail.

[@nccbnccb5567]

need help please

[@diwaanchandarcs3010]

Hello, I had sent a mail regarding those invoice files. Please send me it. Thanks in advance.

[@qualityassurancelab7764]

Hi, I sent the files

[@vuppalavivek4382]

Hi Mam, Firstly tutorial you have given is very helpful and easy to understand. I have tried doing the same but got the below error. Could you please help me on this. Source: Read Range Message: Object reference not set to an instance of an object. Exception Type: System.NullReferenceException

[@qualityassurancelab7764]

Thank you so much. Please follow below steps to resolve the issue: Move to Manage Packages -> Search UiPath.Excel.Activities -> Click on Update on the right side of Manage Package window to update the package. If the issue is still not resolved, please add a defacult value as new System.Data.DataTable to the data table variable which you created in the read range activity. Hope this helps!

[@vuppalavivek4382]

@@qualityassurancelab7764 Hi Mam, Thanks for the Reply !! I tried in both the ways by updating the package and adding "new System.Data.DataTable" to the data table variable of Read Range activity. But I am getting the same error. Is there any other way that i can resolve this issue.

[@RohitBConnects]

Actually in this video all 3 invoices are same what if the invoice are different