Extract Specific Data from Scanned Invoice Pdf and Write Into Excel In UiPath | UiPathRPA

[@UiPathRPA]

Let's learn - Extract Specific Data from Scanned Invoice Pdf and Write Into Excel In UiPath

[@Varmaraj07]

what is difference between normal pdf and scanned pdf sir please reply

[@roshanlal785]

Contact no.

[@shantanudhar8773]

Hi Manish, I am getting the error: "None of the overload groups have all their required/optional activities arguments configured". How to resolve this issue? I am getting this error on "Add Data Row".

[@SwapnilSaheb101]

@@Varmaraj07 scanned me accha quality hota Normal hum log sirf extension change krke or convert krke bnate hai

[@manideephv3598]

Hi Manish, I have 5 images (.png) and how can I extract specific data from png and write to excel? I tried using this method and it didn't work.

[@internetroom]

I am beginer in UI Path. Your videos are helping me alot in completing my tasks. Thank you very much sir

[@UiPathRPA]

Welcome to UiPath! I am glad it helped you! Do you need UiPath compete training?

[@riyajain4929]

I am interested for taking the complete training.

[@UiPathRPA]

Please go through website and fill the form. uipathrpatraining.blogspot.com

[@BayMax639]

You're God or What... Became a fan bro.. Thanks to your efforts man. Take care

[@UiPathRPA]

Thanks for the appreciation.

[@ivannicho6199]

Thank four your video. I have a question, if the format of invoice are different, how is the manage?

[@Eichman86]

Thanks for the video, please for future videos shorts and to the point videos is always better, and attract more people to check it out

[@ashishtiwari7140]

Thank you so much 🙏😊

[@alfredrahul1015]

I cannot see the Tagged option in the accessibility feature

[@heisenberg6022]

Hi Manish, my get ocr text function is attached to the Uipath Screen OCR engine, is there a way to switch to tesseract engine?

[@arunkumarmulugu]

Hi Heisenberg.. For me also getting same, Could you please help me, what you did to switch OCR engine to Tesseract?

[@petercoleman8091]

Great help to an issue I had

[@UiPathRPA]

Glad to hear that this video helped you. Please do Like & Subscribe.

[@suryaappari7294]

Thank you Manish ji

[@archanashetty726]

Great effort. Thank you. Please upload the video with Regex and String manipulations so that the solution is optimal.

[@UiPathRPA]

Thank you for suggestion!

[@hepsibaagnes218]

@@UiPathRPA please upload video with regex

[@UiPathRPA]

@@hepsibaagnes218 Sure. I will do that

[@drsharanthapa]

I have a pdf which of my books , single page pdf contains 4 to 8 Multiple choice questions (MCQs) with options , i want to extract all of those questions with options to excel using power automate. kindly help how to do it ??

[@DanielWeikert]

What if the data is not on the first sheet. We basically need find the data in our pdf by searching an anchor and then extract the item on the right to this anchor? Thanks

[@UiPathRPA]

Try to make changes in the selector of find element in anchor base so that it will go and find the name in PDF based on aaname

[@umakritika1300]

Can you please make a video on how to extract data from unstructured datatable.

[@amandacalderon1250]

i would like too!!

[@ImranKhan-pw9xh]

Keep up the great work

[@UiPathRPA]

Thanks, will do!

[@rohittiwari7019]

Very nice video helped allot

[@UiPathRPA]

Thank you for watching videos!

[@satishmapate8329]

Your video's are more helpful to me. I am keep practicing. but I am unable to extract specific data from above PDF files. i.e. Total. Got an error. Can you suggest me what should i do ?

[@karunkumar4245]

Great Job...👏

[@MrShaikmustafa]

How to fix this error can you please help me (Read Range: Object reference not set to an instance of an object. )

[@ananygarg3897]

How to extract roll no from pdf and send that pdf to the email id mentioned in the excel file.

[@aprendiendorpauipath2759]

Can you show how this automated process would look? no need for manual data validation by human ... thanks. excelent video.

[@keertidovari3916]

There is an excel sheet with today's Date and there is an application where I have to update some column information into that application based on that particular date and time of that excel sheet..I am confused How to read data from that excel sheet and update it.

[@ramunisreeteja7240]

How to extract data from unstructured pdf. Can you make a video on this??

[@abdulhameedubayathula5453]

Great sir.. For. Me.. Data scrapping is working fine.. But it not moving to next row in excel.. Only all data updated on first tow only.. How to address it?

[@marcohama1]

Thank you, that's helped me a lot

[@__VasanthaRajK]

Where can we get the datasets for this project

[@avhimanyu1709]

Can any among the three leading RPA tools: UiPath, Automation Anywhere, or Blue prism : perform the following? Reading/Scrapping a TABLE from a Scanned Document in PDF format and Put on an EXCEL - Have to traverse through 2600 such documents where the position of table on Scanned Documents may vary.

[@mayankmanshabhargav6156]

sir mene get ocr text se data toh le paa rhu but ek prblm hai agr pdf mere pass 2 ek jessi contet ki ho lkin dusre wali pdf me thodi spaces hai jis wajha se content upr niche ho gya toh me kya kr sakta hu please help Sir

[@sunny784u]

Hi Manish, thanks for this video, can you also make a video how to draw elments using regex tool in uipath.

[@tudevnarmandakh9305]

Hi, Close application is not available. How can i add in activities

[@meafterme2042]

hi, what if the invoice contains inputs in other format such as checkboxes and radio button type.

[@sahajau]

Hi.. when i am trying to print the value(date) of text i am getting below error System.Collections.Generic.List`1[System.Collections.Generic.KeyValuePair`2[System.Drawing.Rectangle,System.String]] . can you please help me with this?

[@MrAnupam200]

Instead of putting Values in "Treseact OCR" "Output"--->"Result"..... Put the result in "Indicate Element Inside Window" "Output" "Result" section in Activity "Get OCR Text"....Hope this answers you

[@ankitgargvanshi]

Close application is not available. How can i add in activities

[@remixowlz]

PRESS F3 WHEN SCRAPING TO GET INDIVIDUAL ELEMENTS GUYS!

[@im_saurabhmthur]

Very nice video. I have handwritten pdf, so can I extract it to excel?

[@kunalthakor1679]

What do we do with PDF when it shows table instead of graphic?

[@syafiqahshaharudin256]

Hi. May I asked, why is mine when I select 'GetOCR' by the scrapping activities; when I drop on main, it didn't display 'Tesseract OCR', but 'UiPath Screen OCR'.. Is it okay? The 'tesseract' activity is exist solely. Should I add after it?

[@syafiqahshaharudin256]

It's okay. I just got it =D ...I just have to click on it, and delete the 'UiPath Screen OCR', then drop the 'Tesseract OCR' from the activities pane.

[@mohammednafees2808]

hello sir, hope you are fine. sir please make videos on ACME Systems. thanks in advance.

[@ShivamKumar-fc8so]

Getting Error what is that. Please reply Message:Scarp returned empty text Exception Type: System.Exception

[@andreaugusto6430]

It gives me this error. Can someone help me please? “Add Data Row: Object reference not set to an instance of an object”

[@gokulg6015]

Hi Manish, in my case invoices number position is been changed for different PDF Files How can we solve this can you please help me ?

[@AnuRadha-fg8ry]

I need ur help in extraction of invoices .Can you plz tell me how I can reach you..my pdf has full of tables..plz help me

[@rakshitharam9859]

If my pdf is in same pattern we can do like this. I want to know if my all pdf are in unstructure format contains all data like address, phonenum, place like this. How can i extract data in a loop. Please tell me if any activity is there.

[@TamilClassroom]

Contact me on whatsapp [phone]

[@aurenay]

I haven't see the step for creating InvoiceDT data table that's why I've taken a failure

[@V.MITHUNCHANNEL]

Can Plz Provide the video Links of the Regular Expression

[@kannikantibharat6347]

Hi Manish, In my PDF I was having a signature and some images also, I was trying to extract them and store to excel, But not able to, Could you please tell me by which activity I can do that?.

[@UiPathRPA]

You can use ocr method to extract these text from PDF.

[@daxteoh27]

thank you sir!

[@daxteoh27]

How about inconsistent Amount located in the invoice? I'm having difficulty to make the robot real 100% correct

[@UiPathRPA]

As I have told in video you can use increase or decrease scale number or change the ocr profile based on your PDF.

[@daxteoh27]

@@UiPathRPA No, what I mean is the invoice structure slightly different, like some time the amount slightly located lower some time higher. It's inconsistent. Do you have any solution for this kinda situation?

[@SwapnilSaheb101]

Source code?

[@Shoolin-Gaming007]

when i printing the value of text i am geting System.Collections.Generic.List`1[System.Collections.Generic.KeyValuePair`2[System.Drawing.Rectangle,System.String]]

[@archishajhunjhunwala7512]

Even I m facing similar issue and multiple pdfs are not opening. Only first PDF is opening. Please guide

[@MrAnupam200]

@@archishajhunjhunwala7512 Instead of putting Values in "Treseact OCR" "Output"--->"Result"..... Put the result in "Indicate Element Inside Window" "Output" "Result" section in Activity "Get OCR Text"....Hope this answers you

[@sudeshrajkumar7664]

Ap hindi me bataya karo ,please because it's really help me to understand deeply.

[@__VasanthaRajK]

Bro can you please give me your email id I have a problem while executing this in my system