Uipath Invoice Extraction (PDF AUTOMATION 2021 COMPLETE TUTORIAL) Using Document Understanding

Рет қаралды 59,839

Күн бұрын

🔥 Subscribe for uipath tutorial videos
: Uipath invoice extraction in Uipath PDF Automation is one of the industrial need and learning this skill will add a lot to your profile. Today, I am going to teach complete Uipath PDF Automation Tutorial using UiPath Document Understanding.
The Goal of this Uipath Invoice Extraction (PDF AUTOMATION 2021 COMPLETE TUTORIAL) is as follows:
1. The bot should access all the pdfs from the folder
2. Extract required data from the PDFs
3. Store them in an excel file
We are going to achieve this PDF automation by using couple of Uipath Core Activities. UiPath PDF Automation is the key skill to acquire!
We will start with Directory.GetFiles() uipath activities, For Each Loop Uipath Activity and all the steps of UiPath Document Understanding.
I have shown how to design Taxonomy as per the industrial requirement. Digitization, Classification, Data Extraction Scope and Export the data has been shown.
Thank you for all your support and keep watching the channel videos!
Link to Access Sample PDFs or invoices for Exercise is provided here:
drive.google.com/drive/folder...
------------------------------------------------------------------------------------------------------
#uipath #rpa #roboticprocessautomation #automation #uipathexpohub *****
Dear Learners, I need your support too!
Please Subscribe to my channel and show your kind support!
Link to UiPath Beginners Playlist:
• UiPath Tutorial | Uipa...
Link to UiPath Excel and DataTable Playlist:
• UiPath Tutorial | Buil...
Link to UiPath Key Technique Playlist:
• Move File Uipath | Uip...
Link to UiPath Email Automation Playlist:
• UiPath Tutorial | Uipa...
Link to UiPath PDF Automation Playlist:
• UiPath Tutorial | Uipa...
Link to UiPath ReFramework Playlist:
• UiPath Tutorial | Uipa...
Link to UiPath Classic and Modern Excel Activities Playlist:
• UiPath Tutorial | UiPa...
Link to UiPath Regular Expression Playlist:
• Uipath Regex
Link to UiPath Orchestrator Playlist:
• Uipath Orchestrator Ho...
Link to Advance UiPath Orchestrator Playlist:
• How to Use Storage Buc...
Link to UiPath VB dot Net PlayList:
• UiPath VB.Net Complete...
Link to UiPath Use Case Playlist:
• UiPath Birthday Remind...
Link to UiPath Selectors Playlist:
• UiPath Introduction to...
Link to UiPath Enhanced Selectors Playlist:
• UIPath Enhanced Select...
Link to UiPath Computer Vision Playlist:
• Learn UiPath Computer ...
Link to UiPath Interview Series Playlist:
• UiPath Interview Quest...
Link to UiPath Document Undestanding Playlist:
• UiPath Document Unders...
Link to UiPath Action Center Playlist:
• UiPath Action Center i...
Link to UiPath Error and Fix Playlist:
• UiPath Error Message#1...
Link to UiPath Activities Playlist:
• Parallel For Each in U...
Link to UiPath Certification Playlist:
• UiPath DataTable Selec...
Link to UiPath Background Automation Playlist:
• Background Process Aut...
Link to UiPath Logs Playlist:
• UiPath Logs | UiPath L...
Link to UiPath GitHub Integration Playlist:
• How to Create a GitHub...
Link to UiPath API Integration Playlist:
• API | API in UiPath |...
Link to Python Playlist:
• How to Create a GitHub...

Пікірлер: 148

@abdulsaleem6353 Жыл бұрын

Seems, its been a while that you have created this video for us but just now only I have seen this. saying honestly, this is really help me alot Rakesh :). Thanks Bhai

@AutomatewithRakesh Жыл бұрын

You are most welcome Abdul

@ramyanamala6614 Жыл бұрын

Tried Simultaneously with your video, now i can able to do DU without any help, the way you explained each and every step was mind-blowing Rakesh, thanks a lot and keep up the good work.

@casgroupconsultingconsulto7249 Жыл бұрын

Excelente. Funciono todo bien. Gracias amigo.

@arteewalimbe1300 2 жыл бұрын

Hi Rakesh, I referred lot of your videos for the things where I was lacking.. believe me they helped me a lot and I got a job also.. thanks a lot for your efforts.. 👏👏👏

@AutomatewithRakesh 2 жыл бұрын

Congratulations Artee

@francescomariadaquino8842 3 жыл бұрын

Thank you so much for the time and effort you invested in.

@johannanderson848 2 жыл бұрын

Great video. I am grateful for the sample documents mostly. Most content creators don't share the documents. Thanks a lot and please continue the good work you do. Also hope in the future, you can do a video of comparing Google Vision OCR, Microsoft Azure OCR and Abby OCR to read handwritten and images showcase which OCR is the best for which document category.

@ravuri999 2 жыл бұрын

Thank You so much for your effort and explanation in detailed.

@pranavjalan8861 3 жыл бұрын

All the time invested in this is totally worth it..

@AutomatewithRakesh 3 жыл бұрын

Thank you Pranav

@sushilbhaskar5500 2 жыл бұрын

Thank you for this video Rakesh... And really appreciated your efforts :)

@soundaryasureshmohan7524 Жыл бұрын

i really wonder and no words to tell anything about the videos on document understanding... you are really doing a great job .. Thanks a lot

@AutomatewithRakesh Жыл бұрын

So nice of you, Thanks a Ton Soundarya!

@apangyksg 2 жыл бұрын

Hi Rakesh, excellent job - simple and clearly presented. Thank you.

@dhachanamurthydhachanamurt8447 Жыл бұрын

Wow..awesome....watched with 0 knowledge but now have good understanding

@AutomatewithRakesh Жыл бұрын

That's great!

@nehadhawan3441 2 жыл бұрын

This is a wonderful explanation, thanks so much Rakesh!

@AutomatewithRakesh 2 жыл бұрын

Thank you Neha

@rajurec2721 Жыл бұрын

Nice explanation rakesh, useful content.

@SyedSAhmed3 Жыл бұрын

Thank you for your amazing video..and extracting data using du is super exciting 🎉

@karthikeyannagarajan3376 9 ай бұрын

Great video. Content of delivery is very clear. Easy to understand the document understand concept.Thanks Rajesh for your great effort

@AutomatewithRakesh 9 ай бұрын

Thanks Karthikeyan 😇

@rajeswarib8815 2 жыл бұрын

Really it was good. The way u r explaining why, where, how to use is very helpful. Presenting and giving the content in a perfect manner. Please make video on UIPATH Apps to.

@Vijay_0815 Жыл бұрын

Thanq sooo much for wonderful series.... Regret to see very late. I fell DU series is something different,so I wasn't see this series. But you made easy to understand entire series... Thanq sooo much 💐

@AutomatewithRakesh Жыл бұрын

You are most welcome Vijay

@sojolhamid6356 2 жыл бұрын

Simply Superb!! I am just speechless by seeing your patience & persistency for teaching topics so deeply!! Hats off! May Almighty give you in return. Thanks once again.

@AutomatewithRakesh 2 жыл бұрын

Thank you Sojol🙏

@priyankasorate6707 11 ай бұрын

Perfect explanation

@shaiknabi4517 2 жыл бұрын

Thank You Rocky Bhai i successfully run the flow and Pdf data was fetch to excel !!!

@AutomatewithRakesh 2 жыл бұрын

😀 welcome

@senthilKumar-bo2is 2 жыл бұрын

tutorial & giving pratice material also ,really heartfull thanks to u man

@AutomatewithRakesh 2 жыл бұрын

You are most welcome Senthil

@abdulbashith3971 2 жыл бұрын

Great Content!

@tanlee423 Жыл бұрын

Thank you so much it is very useful, helpful, greatful video

@nirmalakhandagale7110 2 жыл бұрын

fabulous creation who has no experience on Document understanding that person also work on project by looking at this video. Thanks a lot

@AutomatewithRakesh 2 жыл бұрын

Thank you Nirmala this is one of the precious comments that I have seen in last few days thank you thank you again

@nirmalakhandagale7110 Жыл бұрын

@@AutomatewithRakesh 😍

@rajvenogopal9317 2 жыл бұрын

Hi Rakesh, brilliant efforts - much appreciated

@AutomatewithRakesh 2 жыл бұрын

Thank you Raj

@arteewalimbe1300 Жыл бұрын

A very nice video Rakesh.. You always make complex things learning very easy.. Thanks a ton!

@AutomatewithRakesh Жыл бұрын

My pleasure

@mohdqamaruddin6197 3 жыл бұрын

Thank you so much for your time and Effort sir.

@AutomatewithRakesh 3 жыл бұрын

Thank you

@dakimitrov8787 3 жыл бұрын

Keep up to good work helped me a lot

@scktch8933 3 жыл бұрын

Great job, your way of explaining is really excellent. Thank you very much I have a question in Invoice No. 1 I want to extract all the goods, each goods details in a row in Excel

@SathishSathish-ei3gu 2 жыл бұрын

thank you rakesh

@Soumalyadey Жыл бұрын

Very good explanation Sir...

@srinivasm1255 2 жыл бұрын

very good job ...

@ravitejabhavarajuuipathcom8593 3 жыл бұрын

👍 great explanation

@AutomatewithRakesh 3 жыл бұрын

Thank you Ravi

@affy2974 2 жыл бұрын

Hi Rakesh, your videos are great for anyone who is new to RPA UiPath. Your videos can make them PRO in no time! Thank you so much for your valuable content. It will be great help if you can show a process on how to extract a invoice number which is in same line of a PDF file. Ex: "INVOICE # INV00010" I only need the invoice number which is "INV00010", you can also think of a full name given and I need to split them into first name and last name and insert in excel columns. Can you please share your thoughts 🙏🙏🙏

@AppalarajuV-lo4do 10 ай бұрын

Thnk you so much sir... now i am able to do very easily sir..

@AutomatewithRakesh 10 ай бұрын

Keep it up

@AppalarajuV-lo4do 10 ай бұрын

@@AutomatewithRakesh One small doubt sir.. how to insert pdf name in one column automatically

@ganeshkulkarni9648 2 жыл бұрын

Hey, really liked the video tutorial, but what if we have different invoice and we want to create multiple template for them using form extractor, how we can solve this? Have you done any video on it? Any guidance would be appreciated.

@nithyasankar42 3 жыл бұрын

Hi Rakesh, I am using enterprise on-premise version of orchestrator. In that where can I find the api key for document understanding?

@waseemsayyad6315 2 жыл бұрын

Hi Rakesh, very nice explanation, I have trained the bot through form extractor for invoice with 3 lines, but when I try to execute the new invoice of same format with more than 3 lines its not extracting all of them. Can you please help me in this and also make a video for this.

@mohanvasan2629 2 жыл бұрын

Hi guys, If you do not understand or if you have clarification on these document understanding steps, Please go through the playlist of document understanding created by rakesh, he has spent lots of time on each activity, i had some doubts in it like why we should use this why cant selectors do the same job, after going through the playlist i clearly understood, if anybody stuck here please check document understanding playlist

@saiprasadkakumanu521 2 жыл бұрын

Hi Rakesh, obviously the video you made is excellent, one doubt i had is, i tried to print dataset but i got something like this - ?DT.Tables.Item(0).ToString "Simple Fields" ?DT.Tables.Item(1).ToString "Simple Fields - Formatted" but how is it the thought of DT.tables(0) helped to print data -- can you explain this

@anilgulati9060 2 жыл бұрын

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.

@artitripathi5748 3 жыл бұрын

thanks for all your effort and for making things simpler. Can you please make the videos for AI Center?

@AutomatewithRakesh 3 жыл бұрын

Sure

@kaushik__7728 2 жыл бұрын

In practical scnerio we use document understanding alone or inside RE FRAMEWORK.?

@icstrim76 2 ай бұрын

I would like to see this with an invoice or multiple invoices, where you would have product codes, prices, etc. and extract all that data... Thanks!

@saahilshaikh7445 2 жыл бұрын

Hi Rakesh can we do this on different types of invoice pattern in a single run like for eg: consider 2 invoice invoice A and invoice B but both looks different but we want to extract same field from them how can we do that can you please explain.

@user-ir6ob1ms1d 9 ай бұрын

in actual project while working on document understanding in company does omni page using or other any OCR engine please tell me

@SandeepYADAVggn 26 күн бұрын

Very Good. Will it work with image pdf i.e. OCR but size of invoice pdf is not same i.e. some are legal, and some are A4 size so anchor placement may not be exactly same for all files. How to do automation then?

@rahatrahman3070 Жыл бұрын

Hi Rakesh. THANK YOU SO MUCH FOR YOUR WONDERFUL VIDEOS. I am new to RPA and trust me, I am learned a lot from your video. I have a question. I am extracting one of the elements from my pdf file and it should be only numbers. but when it extract the data to excel it is including some letters in it. for example I am trying to extract 20-088022 but instead im getting this F2or0th-e0ta8xa8b0le2ye4a2r. How can i resolve this problem?

@qq-ok3zy 2 жыл бұрын

HI,thanks for your teaching,I've got in trouble that there is another「Billed to」in my output excel 's column "E", I don,t know why??

@sultanmia3895 Жыл бұрын

Nice 😊

@AutomatewithRakesh Жыл бұрын

Thank you Sultan

@yashobantadash6670 2 жыл бұрын

hello bro. atlast you saved the due date in string variable.is it saved as string ?

@chaitusai7674 3 ай бұрын

sir, as the interface of taxanomy mnager has changed, it is not showing the category block, what should we do now ?

@radhahotkar6722 2 жыл бұрын

Hi Rakesh, I am facing timeout issue while running data extraction scope and i have used the document which you have shared. Please help me to solve this issue

@prashanth191 11 ай бұрын

hi rakesh, I tried creating a template using form extractor but got an error that says "There was an error processing the document".I tried changing OCRs but it didn't work. I'm kind of stuck here. please help. Thank you.

@tarrrakyt6096 2 жыл бұрын

I got error : The extension '.xls' does not have a known content type defined Exception type : system.not supported exception...pls explain what to do

@Artech.Ranjit 7 ай бұрын

if i want to store different classifications, like Invoice and Purchase orders in separate sheets

@parvatia544 Жыл бұрын

1.Hey Rakesh .i tried this . ive got the result as is when was developing from the studio . So when i published and run from the orchestrator the data was not written to the excel sheet . 2. When i tried with ML extractor for scanned bills in the same way it says "error occurred while retrieving the capabilities from server. for this i gave the end point and api key correctly but still not able to figure it. Can u pls reply .Ty

@pankajchaudhari3999 2 жыл бұрын

Dear sir, I have an error occurred during assign activity as so kindly help me in this regard.

@AUTOINSTAN 2 жыл бұрын

thanks

@AutomatewithRakesh 2 жыл бұрын

You're welcome!

@anilkumarandra7557 2 жыл бұрын

Hi Rakesh thank you so much for your video and we need with different PDFs having different data for that we need a video

@AutomatewithRakesh 2 жыл бұрын

Sure will do

@anilkumarandra7557 2 жыл бұрын

@@AutomatewithRakesh Thank you so much Rakesh bro please do it as soon as possible because we want to upgrade our self with your continuous videos

@athiraharidasan7103 8 ай бұрын

Hello Sir ,How can i get this Load taxonomy activity and Taxonomy manager in studio?

@appuvlogs6139 2 жыл бұрын

Hi bro, I need how to extract multiple invoices data using string manipulation in Reframework. Thanks in advance.

@TJ-bv1li Жыл бұрын

Sir , I'm not able to download the packages , which u mentioned initially. It doesn't shows up ! What to do , sir ? Please do reply !..

@shaiknoor3967 2 жыл бұрын

can you please make video for dynamic tables Extract because same vendor have invoice with different line items eg:-1st pdf we have 3 line items 2nd pdf we have 5 lines 3rd pdf we have 15 lines

@shubhamsharma-db9eb 2 жыл бұрын

Can we extract unstructured pdf into excel with this?

@divyavanithadi392 Жыл бұрын

Sir can you make a video on du using Document Understanding Process Template?

@rnhprashant 5 ай бұрын

Hello, I am getting error when trying to run classifier and getting output in text file...error... Index was outside the bounds of the array

@kanchanggogoi7250 2 жыл бұрын

done

@kuntumallasreekanth7454 Жыл бұрын

Hi Rakesh How to edit the existing one in form extractor please help me

@kavuripriyanka3991 Жыл бұрын

When we use pdf activities and when we is UiPath.IntelligentOCR.Activities?

@arigelayedukondalu861 2 жыл бұрын

Data Extraction Scope: Could not detect a valid document type id from the given input parameters how to solve this

@shubhamsharma-db9eb 2 жыл бұрын

Shows error on data extraction scope that index was outside the bound of the array

@nikita9378 9 ай бұрын

I'm getting error in digitize document step as "Input document not found"

@salmanfaries3064 Жыл бұрын

Hi anyone please say what is the need of using document Understanding ,while we can extract invoices in normal way which is in the previous video?

@AutomatewithRakesh Жыл бұрын

Hi Salman, using DU we have many actions that can be done for example Bringing Human in Loop by integrating with Action Center. This is much more advanced than the trival way! We have Form Based Extractor, ML Extractor etc. Follow the playlist from the beginnig, slowly you will get an good understanding!

@salmanfaries3064 Жыл бұрын

@@AutomatewithRakesh sure rakesh, thanks for the reply!

@mbhuvana1708 2 жыл бұрын

After installing DU package ,all the Du related activities are slow .can you please help me here.Do we need to do anything specifically?

@AutomatewithRakesh 2 жыл бұрын

Try to restart the uipath studio and restart laptop once

@funedit732 Жыл бұрын

Hello sir.. How we can extract.. Data from multiple pages in single invoice

@jyothivadlamani4843 Жыл бұрын

Hi Rakesh. I need help. Iam getting this error while running the file 11/30/2022 17:25:22 Unexpected error has occurred during the library compilation process: The assembly compilation returned the following errors: * Property 'Item' is 'ReadOnly'.

@jyothivadlamani4843 Жыл бұрын

Here "Item" is the variable given in for each for the filepath

@sanjeshl.d8572 3 жыл бұрын

Thank you for your explanation.can you please explain what is dataset.tables(0),dataset.tables(1), dataset.tables(2) what does it means

@AutomatewithRakesh 3 жыл бұрын

Hi Sanjesh if you use only dataset.tables and write to an excel you may find duplicates. Try to experiment that

@sanjeshl.d8572 3 жыл бұрын

@@AutomatewithRakesh thanks for your reply sir.why they are putting (0),(1),(2) what they mean sir (ex : dataset.tables(1) )

@AutomatewithRakesh 3 жыл бұрын

@@sanjeshl.d8572 those are the index numbers like an array how you pull the first data from array using the 0 index and so on. Try to watch one of my array video from expohub you will be very clear

@sanjeshl.d8572 3 жыл бұрын

@@AutomatewithRakesh Thank you

@jegadeeshbabu3981 Жыл бұрын

The getting error for the "Data Extraction Scope: Index was outside the bounds of the array." how resolved this

@tanlee423 Жыл бұрын

I also got this error. How did you solve it?

@navyasreetumpala9526 Жыл бұрын

iam working on 2023 version, if i want to work on 2021 how can i do

@rohitsharma9755 5 ай бұрын

if there is different format of pdf so what we do???

@raviteja3605 Жыл бұрын

Good Afternoon sir, i got validation error while practicing, unable to execute sir, it says as Uipath.studio.plugin.workflow.validation.LightValidationService. pl help sir.

@sharmadeepak9395 11 ай бұрын

I m facing issue in end while using mege data table.

@AppalarajuV-lo4do 10 ай бұрын

we want insert extracted pdf name also in one column how to do this sir plz help sir

@shalinitiwari1805 2 жыл бұрын

Message Box: Index was outside the bounds of the array. i got this error while using the classificationresult(0).DocumentTypeId

@tanlee423 Жыл бұрын

I also got this error. How did you solve it?

@tanlee423 Жыл бұрын

I got an error : "Data Extraction Scope: Index was outside the bounds of the array."

@AppalarajuV-lo4do 10 ай бұрын

Hi sir, I am missing one column data sir in some images only not for all but more images data i am missing sir... Please sit what should i do= sir

@AppalarajuV-lo4do 10 ай бұрын

Now no problem sir i am getting everything is too good...

@payalatre9979 2 жыл бұрын

Hi sir, I am getting error while using Data Extraction Scope and creating template it is showing error : There was an error processing the documents. Please help me what should i do Thank you

@AutomatewithRakesh 2 жыл бұрын

What kind of document are you using ? try to change to some other document in case if you do not have proper documents look for the video sample invoice download

@kaushik__7728 3 жыл бұрын

shy we have used merge datatable here?

@AutomatewithRakesh 3 жыл бұрын

To get the output into excel in the beginning we have declared data table and then we are merging it

@ashishpandey1436 3 жыл бұрын

Sir how can we change the language of the file

@himanshuprataprana6867 3 жыл бұрын

if i have multiple pages in my pdf,how can i extract them?

@himanshuprataprana6867 3 жыл бұрын

My pdf is dynamic and unstructured

@sudhagarss 3 жыл бұрын

I have installing three packages,but to accept license dialog box

@AutomatewithRakesh 3 жыл бұрын

License dialog box! Which version and edition of studio you are using?

@sudhagarss 3 жыл бұрын

@@AutomatewithRakesh Version 2021.4.4 Uipath Community version

@sudhagarss 3 жыл бұрын

Any update?

@sivad2202 Жыл бұрын

Rakesh dataset to json and XML help me

@AutomatewithRakesh Жыл бұрын

Will try to create a content Siva

@sivad2202 Жыл бұрын

@@AutomatewithRakesh thanks Rakesh garu ASAP 🤔

@salakkad4512 2 жыл бұрын

Taxonomy Manager Interface changed

@KulkarniVedantMtech 2 жыл бұрын

I followed each and every step of this tutorial still it does not work

@sharmadeepak9395 11 ай бұрын

How to connect with u any email id pls

@BGMI-AshleelLonda31_Live 3 жыл бұрын

Wht ir format is not same

@AutomatewithRakesh 3 жыл бұрын

In that case we need to create more templates for each specific format if using form based extractor, if not you can use combination of machine learning extractor and check if the ml algorithm extracts the data

@ganeshkulkarni9648 2 жыл бұрын

@@AutomatewithRakesh how to use multiple form based extractor? I tried to use it, but it's not working and extracting the data based on the first template only. Because even though we're creating the template, we're storing all files in one location and template 1 going to scan all PDF so it would scan PDF of other types as well and will store wrong data. How to handle this? Any help would be appreciated.

@PrasannaLaxmi-fq9wf Жыл бұрын

Hi Rakesh... Iam learning Uipath... Your videos are superb...your explanation is very good.. I got the result for above video.. How can i contact you...could you share your email ID in case of errors

@raviteja3605 Жыл бұрын

Good Afternoon sir, i got validation error while practicing, unable to execute sir, it says as Uipath.studio.plugin.workflow.validation.LightValidationService. pl help sir.