UiPath Document Understanding: Extract Tables Out of PDFs

Sdílet
Vložit
  • čas přidán 3. 08. 2024
  • This full video tutorial shows, how to extract table data out of PDFs with the Document Understanding Package from UiPath to Excel. With the help of a template we are able to extract data from PDFs with our UiPath Workflows. Here we have a structured PDF document, as it is time sheet forms.
    You could also watch:
    🔵 UiPath Document Understanding - Invoice Data Extraction - • UiPath Document Unders...
    🔵 How to extract data from PDF's with RegEx - • How to extract data fr...
    0:00 Use case presentation
    We have a folder with time sheets PDFs and we want to extract data out of each of them with the Document Understanding package from UiPath and into Excel. The data is structured, meaning that the layout is fixed across all the documents. We will use a template-based approach to determine, which data to read and collect.
    1:41 Install packages
    We install three packages (1) UiPath.DocumentUnderstanding.ML.Activities, (2) UiPath.IntelligentOCR.Activities and (3) UiPath.OmniPage.Activities to enable the activities, we will use in this use case.
    2:25 Load Taxonomy
    We use the Load Taxonomy activity to define and set the files/data for the extraction. You can later edit it, if you miss something, so don't worry. We will create a group and category, where our Time Sheet case will go in. We extract a single field of text (employee number) and a table of the time registrations.
    5:17 Digitize Document
    We now digitize the text and the location and will have output of a string (the text itself) and a Document Object Model (information and properties about the text). You can use all the OCR Engine, but I prefer the OmniPage.
    6:53 Data Extraction Scope
    Based on our rules we can very easily extract the PDF data. I recommend you install Notepad++ (simply just Google and download). We use the program to edit our taxonomy JSON. We need to copy the DocumentTypeID from the JSON to use in our workflow. Because we have structured/form data, we can use a Form Extractor activity. Use the default End Point and then go to your UiPath Automation Cloud and get the Api Key (it's free). Afterwards we create a template, where we define how our looks like and then specify what data, we want to extract. In Configure Extractors just pick everything.
    13:23 Export Extraction Results
    We take our extraction results and output it into a DataSet.
    13:50 Understand the output data
    With a For Each, an Output DataTable and a Write Line we can take a look at the data. Remember to use the Tables property to our DataSet. We now have two DataTables with our data, that we can work with.
    16:02 Build DataTable for output data
    We create a DataTable with just one column (Employee Number), which we can later merge with our time sheet table data. Besides the column header there is nothing in it.
    17:08 Merge Data Table
    We merge the newly created Data Table with the Employee number header with the Data Table with the extraction results (the time sheets table).
    17:54 Iterate through our output and add data
    Using a For Each Row we iterate through our extracted data and then add our employee number as a string.
    19:02 Write the extracted to Excel
    Use the Write Range activity to write the data to Excel. Remember to Add Headers.
    20:26 Extract multiple PDF files
    We expand our solution to solve for the case, where we have more than 1 PDF file. We use a For Each and the Directory.GetFiles method. Remember to change the TypeArgument to String. Drag our activities in and change the strDocumentPath to item. Furthermore we need a final DataTable, that is completely empty, where we add data for each of our iterations.
    💼 Get the files from the video: andersjensen.org/uipath-docum...
    Connect with me:
    🔔 Subscribe - czcams.com/users/klogeande...
    💼 LinkedIn - / andersjensens
    👥 Facebook - / andersjensenorg
    💌 Email Newsletter - andersjensen.org/email-newsle...
    #uipath #rpa #documentunderstanding

Komentáře • 139

  • @andersjensenorg
    @andersjensenorg  Před 3 lety +3

    Learn how to extract unstructured invoice PDF data in this tutorial: czcams.com/video/cp1hbChzUQ4/video.html

  • @blunderking2279
    @blunderking2279 Před 3 lety +1

    I've watched many tutorials online but nothing seems to work until I stumbled across your channel. Great work Anders! Thanks!!

    • @andersjensenorg
      @andersjensenorg  Před 3 lety

      Hey Syed. Thanks a ton, let me know, if you have any questions in future. Have a great weekend. Kind regards, Anders

  • @ahmedmustafamalik3313
    @ahmedmustafamalik3313 Před 3 lety +1

    Thank you so much!
    I was about to go crazy trying to figure out how to get the line items and this video solved my issue!

    • @andersjensenorg
      @andersjensenorg  Před 3 lety +1

      Hey Ahmed. Haha, I know the feeling :D Thanks a ton for taking your time to write me with such a nice message. Kind regards, Anders

  • @rajurec2721
    @rajurec2721 Před rokem +4

    Useful content, well explanation thank for your efforts anders

    • @andersjensenorg
      @andersjensenorg  Před rokem +1

      You're very welcome, Raju Rec - your support helps me a lot 😍

  • @supritpradhan6655
    @supritpradhan6655 Před 3 lety +1

    Very informative video and use case.. Thanks for uploading 👍👍

  • @rossukonjandech4460
    @rossukonjandech4460 Před 2 lety +1

    Hello Anders,
    Happy New Year 2022!
    I have started my career in RPA developer since December 2021.
    Your videos and lessons have been very impress by me.
    Thank you so much for giving your time for volunteer doing these helpful records.
    Applicate,
    Rossukon K.

    • @andersjensenorg
      @andersjensenorg  Před 2 lety

      Hey Rossukon. Thanks a lot - your words are highly appreciated. I'll create a lot of new videos in the coming. This is now what I do full time 😀 Kind regards, Anders

  • @StepanZhemevko
    @StepanZhemevko Před měsícem +1

    Very Interesting and it helps a lot! But I have a question. If we have tables in different files with different sizes? It may not find all the data correctly. How would you recommend to improve this?

    • @andersjensenorg
      @andersjensenorg  Před měsícem

      Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 12,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders

  • @Artech.Ranjit
    @Artech.Ranjit Před 2 lety +1

    Excellent!

  • @crmichaelmattos
    @crmichaelmattos Před 2 lety +1

    Hi Anders, you are a genius! I have been fighting with this for some time now, thanks for the solution!!!
    I have only one question, if in case of multiple files I had multiple sheets in the PDF, can I loop through the pages?

    • @andersjensenorg
      @andersjensenorg  Před 2 lety

      Hey BATMIKE
      Thanks for the nice words and for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: czcams.com/video/C6xmGfEL07I/video.html
      Have a great day.
      Kind regards,
      Anders

  • @Artech.Ranjit
    @Artech.Ranjit Před 2 lety

    Q1- What is accepts anchor definitions, it shows while managing template?
    Q2- If a file has multiple pages with unique data each, will it work?
    Q3- If one particular field has extra data extended to next page of the file, how it works?
    I am trying for live project, using your method. Thanks for solving my queries in adv.!!

    • @andersjensenorg
      @andersjensenorg  Před 2 lety

      Hey Ranjit
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: czcams.com/video/C6xmGfEL07I/video.html
      Have a great day.
      Kind regards,
      Anders

    • @Artech.Ranjit
      @Artech.Ranjit Před 2 lety

      @@andersjensenorg i understand tht. Could u plz suggest the 3rd one atleast? I neee to capture the next page content for a same field. So one field value is part of page 1 and 2 both.
      Thanks in adv.
      I hv infact posted in grp. No reply yet.

    • @Artech.Ranjit
      @Artech.Ranjit Před 2 lety

      @@andersjensenorg Can u plz reply, does it support atleast for multiple pages content and how. A simple clue atleast. Thanks!

  • @changlungoh4806
    @changlungoh4806 Před 2 lety +1

    Hi Anders, appreciate the content. But what about documents that have an unknown number of rows, would you still use form extractor or machine learning instead?

    • @andersjensenorg
      @andersjensenorg  Před 2 lety

      Hey ChangLun Goh
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: czcams.com/video/C6xmGfEL07I/video.html
      Have a great day.
      Kind regards,
      Anders

  • @raymondlee8951
    @raymondlee8951 Před 11 měsíci +1

    Hi Anders
    Could you make an update of this lesson?
    The "For Each" activity has changed since you made this video and the we can't follow the project up to that point.
    Thanks

    • @andersjensenorg
      @andersjensenorg  Před 11 měsíci

      Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 9000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders

  • @jyothsnagaraga2633
    @jyothsnagaraga2633 Před 2 lety +1

    Thanks for video!! Can we check whether data present in table of multiple page document.?

    • @andersjensenorg
      @andersjensenorg  Před 2 lety

      Hey Jyothsna
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my UiPath Groups, where we all can post and solve problems or simply just hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: czcams.com/video/C6xmGfEL07I/video.html
      Have a great day.
      Kind regards,
      Anders

  • @sureklitalebe
    @sureklitalebe Před rokem +1

    Hi Anders. Tahnx for this video, it is really helpful. I need some help for 'for each' activity. On my uipath i can not see the Properties in right side only this activity. Because of that i can not change this activities's settings. Thanks in advance

    • @andersjensenorg
      @andersjensenorg  Před rokem

      Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 7000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders

  • @strawberrychampagne5804
    @strawberrychampagne5804 Před 3 lety +1

    Hello Anders, this is great content, thank you very much for helping everyone out there.
    Im struggling with merging datatables, im getting this error: "System.Data.DataColumn.Friend Default Property Item(record as Integer) As Object" is not accesible in this context because it's "Friend".
    I couldnt find any online documentation about this, i cant understand the error, do you mind helping me out, or explaining this to me? Thank you so much.

    • @andersjensenorg
      @andersjensenorg  Před 3 lety

      Hey Strawberry. Thanks for writing. Is it because you are trying to merge columns of different types? Let me know or join my Discord (link on channel page) and upload a screenshot in the UiPath channel 🙂 Kind regards, Anders

  • @MsOmazin
    @MsOmazin Před 2 lety +1

    Thanks for sharing. I'm trying to find how to modify an existing table in a pdf and save the pdf

    • @andersjensenorg
      @andersjensenorg  Před 2 lety +1

      Hey Grace Simmons
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: czcams.com/video/C6xmGfEL07I/video.html
      Have a great day.
      Kind regards,
      Anders

  • @Starshameer
    @Starshameer Před 3 lety +1

    Thanks for the content ! Quick question what if I need to find the total of overtime hours for each employee by employee ID as reference . What activity should be used ?

    • @andersjensenorg
      @andersjensenorg  Před 3 lety +1

      Hey Shameer. Can you do a lookup: czcams.com/video/vKYkqkEBRE4/video.html Kind regards, Anders

    • @Starshameer
      @Starshameer Před 3 lety +1

      @@andersjensenorg thank you so much.

    • @andersjensenorg
      @andersjensenorg  Před 3 lety

      @@Starshameer You're very welcome 😊

  • @robg9971
    @robg9971 Před 2 lety +1

    Thanks for the valuable guidance. I have a doubt, if I have a table that can vary the number of rows from PDF to PDF what should I do? For example an order slip where the number of pieces and therefore the number of pages of the pdf can be different from PDF to PDF

    • @andersjensenorg
      @andersjensenorg  Před 2 lety

      Hey Rob G
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: czcams.com/video/C6xmGfEL07I/video.html
      Have a great day.
      Kind regards,
      Anders

  • @travllingisfun6189
    @travllingisfun6189 Před 2 lety +1

    Hi Anders, if we have multiple pages and multiple table in different pages and single table extended to multiple pages... Can we export that one as well.. Through this approch kindly suggest... However, your videos are very informative..
    Thanks for that.
    If you can kindly make a video for that as well.. Thanks

    • @andersjensenorg
      @andersjensenorg  Před 2 lety

      Hey Travlling is Fun
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: czcams.com/video/C6xmGfEL07I/video.html
      Have a great day.
      Kind regards,
      Anders

  • @guruphot
    @guruphot Před 3 lety +1

    Hi @anders... Great video..what if the table rows grows ? Say if I have 2 rows and the table had ended ...and in the next invoice I have 5 ...in this case since initially we just select only 2 rows in the beginning right..it will not read 3 rows on the next invoice ..correct ? How do we solve this ?

    • @andersjensenorg
      @andersjensenorg  Před 3 lety +1

      Hey Guru. Thank you and great question 🙂 Initially in the template manager we need to mark all 5 rows. Then the output of our flow will include up to 5 rows. And likewise if you want 10 rows out. Did that make sense? Kind regards, Anders

    • @sudheerkumars4110
      @sudheerkumars4110 Před 3 lety

      @@andersjensenorg But it is giving zeros and empty fields if there is no data available to extract, how can we handle this ? could you pls help
      Thanks in advance.

  • @siddhartaliang3322
    @siddhartaliang3322 Před 3 lety +1

    Hi, Thanks for your sharing content.. I tried it to read several pdfs, and i have a question... What if the table in each pdf is not exactly same in row numbers ? my pdf table does not have empty rows, so the footer section is in dynamic position following the table, and Document Understanding will keep read the footer as part of table. Please advise

    • @andersjensenorg
      @andersjensenorg  Před 3 lety +1

      Hey Siddartha. You're welcome. I think I understand you. Can we remove the footer afterwards with logic/regex? Kind regards, Anders

    • @siddhartaliang3322
      @siddhartaliang3322 Před 3 lety

      @@andersjensenorg Thanks for your response, I tried your workaround and successfully removed table footer using filter datatable. Thanks again.

  • @vitoralexandrecardoso1717

    Fantastic Anders! I'm trying to use it, and comes an error: BC30512: Strict ...from "DataTableCollection" to "IEnumerable(Of DataTable)".

    • @andersjensenorg
      @andersjensenorg  Před rokem +1

      Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders

  • @hemamanoharan4023
    @hemamanoharan4023 Před 3 lety

    Hi, Thank you very much for the video. Kindly help me how can we extract the column totals of your time sheet pdfs and also the position of the column totals are dynamic. Say you have more entries and in the other pdfs your total appears in the mid of the pdf. I have requirement like this. kindly help.

    • @andersjensenorg
      @andersjensenorg  Před 3 lety

      Hey Hema. Thanks for the question and sorry for the late reply. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: czcams.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

  • @Tony-nh5rz
    @Tony-nh5rz Před 10 měsíci

    @Anders - I have followed your tutorial flawlessly (or so I think), however the workflow fails everytime it gets to 'Merge Data Table' Source: dataSet.Tables(2) Destination: dtOuput. Says the 'Object reference not set to an instance of an object'. I did not see you have to declare that anywhere. Secondly, why once it runs the excel sheet shows the word 'Table' versus having the extraction data? I really do appreciate your videos...some of the best out there!

    • @andersjensenorg
      @andersjensenorg  Před 7 měsíci

      Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders

  • @urgonnah8this
    @urgonnah8this Před 3 lety +1

    When selecting the "Form Extractor", you said you were doing so because it is "structured" data. I have a case where I am trying to extract line item information from purchase orders but the table can vary greatly in length. One PO may have 3 items and the next PO could have 100 items. Is the form extractor still a valid approach or is there a better method? I have not had success trying to use the form extractor thus far.

    • @andersjensenorg
      @andersjensenorg  Před 3 lety +1

      Hey Chad. I'm around 80% sure it will work 😏 Mark all the 100 items. I assume it's structured in the sense, that the line spaces are the same right? A more reliable method would be Regex: czcams.com/video/uCdBC2pXPyY/video.html Let me know, if that helped you a bit? Kind regards, Anders

    • @urgonnah8this
      @urgonnah8this Před 3 lety +2

      @@andersjensenorg, Thanks for your reply. I am beginning to think that the design of the table is too complex for extraction :-) The row height can vary because longer product descriptions cause the cell text to wrap. That makes it difficult to use the form-based extractor. I watched your recommended video on regex and it was very helpful. I am still running into some issues though. I have worked out an expression that works fine using Regexr, but when I use the same expression within UiPath, it does not return any text. Do you know if there are regex limitations with UiPath which do not exist in Regexr? I can send you a sample file if you'd like to take a look. Thanks again for taking the time. I find your content immensely helpful and very well produced.

    • @andersjensenorg
      @andersjensenorg  Před 3 lety +1

      @@urgonnah8this Can you send me a sample file on anders@andersjensen.org. I can't promise, that I'll have time for it, but I'll do my best!

    • @urgonnah8this
      @urgonnah8this Před 3 lety +1

      @@andersjensenorg Just sent it over. Thanks again, Anders.

    • @andersjensenorg
      @andersjensenorg  Před 3 lety

      Great, I will try to take a look 🙂

  • @poormanfwh
    @poormanfwh Před 3 lety

    Dear Anders, I want to extract more fields like employee number .how can I extract? i tried to added fields in Taxonomy and also configured in template and extractors, but no values were extracted.many thanks.

    • @andersjensenorg
      @andersjensenorg  Před 3 lety

      Hey Rony. Thanks for the question and sorry for the late reply. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: czcams.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

  • @heavysummer
    @heavysummer Před 3 lety

    Question: Would this work with an image or file sitting in a document retrieval system?

    • @andersjensenorg
      @andersjensenorg  Před 3 lety

      Hey Alicia. No, we can only read the data out of it in DT/String format. If you have a system with files/images, you have to do it the "hard" way. Kind regards, Anders

    • @heavysummer
      @heavysummer Před 3 lety

      @@andersjensenorg Anders! Thanks for the response. I must be confused then. Only files with these extensions can be used in this process? What if I was able to screenshot the document and save it into a local directory and save it as a pdf file, could that in theory work?

  • @saipappu660
    @saipappu660 Před 2 lety +1

    I am extracting invoice no.,Date, po number, and also entire table in pdf how to write these results in an excel file

    • @andersjensenorg
      @andersjensenorg  Před 2 lety

      Hey Sai
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: czcams.com/video/C6xmGfEL07I/video.html
      Have a great day.
      Kind regards,
      Anders

  • @vinodreddy1866
    @vinodreddy1866 Před 2 lety

    Hello Anders,
    Will the same approach work for handwritten documents?

    • @andersjensenorg
      @andersjensenorg  Před 2 lety +1

      Hey Vinod Reddy
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: czcams.com/video/C6xmGfEL07I/video.html
      Have a great day.
      Kind regards,
      Anders

  • @sudheerkumars4110
    @sudheerkumars4110 Před 3 lety

    Hi @Anders Jensen -What if there is no data available in table other than two rows how can we handle that

    • @andersjensenorg
      @andersjensenorg  Před 2 lety

      Hey Sudheer Kumar S
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: czcams.com/video/C6xmGfEL07I/video.html
      Have a great day.
      Kind regards,
      Anders

  • @madhumaurya8378
    @madhumaurya8378 Před 9 měsíci

    Hello,
    I have follow your videos but when try to to scrap hole table but only one row scrap

    • @andersjensenorg
      @andersjensenorg  Před 9 měsíci

      Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders

  • @adamcaruso6345
    @adamcaruso6345 Před 2 lety +1

    Hello Anders, if a PDF that is 4 pages long with tables on each page, how can I extract all the tables ?

    • @andersjensenorg
      @andersjensenorg  Před 2 lety

      Hey Adam
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my UiPath Groups, where we all can post and solve problems or simply just hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: czcams.com/video/C6xmGfEL07I/video.html
      Have a great day.
      Kind regards,
      Anders

    • @techgalaxy9740
      @techgalaxy9740 Před rokem

      Hey Adam, did you find solution for this

  • @rakeshsampath07
    @rakeshsampath07 Před 3 lety

    Hi sir !! How to do the same process , and extract tables from multiple pages of pdf, where table will have same structure.

    • @andersjensenorg
      @andersjensenorg  Před 3 lety

      Hey Rakesh. You can use this framework: czcams.com/video/INnbGPF5MwE/video.html and then apply the Document Understanding Tables/structured data from the present video :) Kind regards, Anders

  • @LesliesDemos
    @LesliesDemos Před rokem

    I installed all the packages in your video. When I search for a 'digitize document' activity, I only see one under 'Document Understanding'. I don't see 'IntelligentOCR' at all.

    • @andersjensenorg
      @andersjensenorg  Před rokem

      Hey Bob M Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: czcams.com/video/C6xmGfEL07I/video.html Have a great day. Kind regards, Anders

  • @kukpat
    @kukpat Před rokem

    I followed along and successfully downloaded the packages. However, the taxonomy manager in Studio version I'm running looks totally different and I got stuck there

    • @andersjensenorg
      @andersjensenorg  Před rokem

      Hey Patrick Moss Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: czcams.com/video/C6xmGfEL07I/video.html Have a great day. Kind regards, Anders

  • @KunalKumar-tt4bt
    @KunalKumar-tt4bt Před 2 lety

    How to use write range for each pdf using this taxonomy because write range overwrite?

    • @andersjensenorg
      @andersjensenorg  Před 2 lety

      Hey Kunal Kumar Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: czcams.com/video/C6xmGfEL07I/video.html Have a great day. Kind regards, Anders

  • @nagesh022
    @nagesh022 Před 3 lety

    Hi Jensen, Thanks for the step by step process, but while running the BOT am find the following error in Export Extraction Result activity could you please let me know solution.
    Export Extraction Results: Method not found: 'System.Data.DataSet UiPath.DocumentProcessing.Contracts.Results.ExtractionResult.AsDataSet(Boolean)'.
    Thanks

    • @andersjensenorg
      @andersjensenorg  Před 3 lety

      It's very hard to say. But you're probably trying to apply a method on the DataSet, which doesnt exist. So check the last part of the workflow again. Sorry, I can't help you further, but I can't see your code. Kind regards, Anders

    • @nagesh022
      @nagesh022 Před 3 lety

      @@andersjensenorg Thanks for the answer, I fixed the issue intelligent package I was using older one. From latest one I can able to run it 😀

  • @mageshwaran4683
    @mageshwaran4683 Před 3 lety

    Hey hi I have some doubts I did the same way for pdf extraction but my result will have one additional duplicate value. For employee number.

    • @andersjensenorg
      @andersjensenorg  Před 3 lety

      Hey Magesh. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: czcams.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

  • @user-qm9tg9fk2b
    @user-qm9tg9fk2b Před 4 měsíci

    I have a question regarding the home version of UiPath I'm using. Whenever I try to run the program, I receive a warning message stating that my license may not be valid. What should I do?

    • @andersjensenorg
      @andersjensenorg  Před 4 měsíci

      Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 11,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders

  • @gayustambunan6250
    @gayustambunan6250 Před 5 měsíci

    Hi Anders. What if we want to add "Employee Name" and "Department" into our Excel sheet too instead of just "Employee Number"?
    How can we do that?
    I've try the Multiple Assign activity, repeat For Each Row three times but nothing works.
    Anyone got a solution?

    • @andersjensenorg
      @andersjensenorg  Před 5 měsíci

      Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 11,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders

  • @tomixeneize07
    @tomixeneize07 Před 2 lety

    Hi! I have a problem when I try to digitize like you at 10:24, a banner appears that says "An error has occurred" without much explanation, any idea what it could be?

    • @andersjensenorg
      @andersjensenorg  Před rokem

      Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 4900+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders

  • @Hoxerm
    @Hoxerm Před 2 lety

    Two Questions:
    1. My data tables vary in size and sometimes have 1 row and sometimes multiple, is it possible to get the automation to take out all the rows depending on how many there are?
    2. Can it do it over several pages? If there is too many lines in my PDF it goes to a new data table on page 3 because it puts in a data explanation page in page 2. It even does the same if the data spans to three pages then it's 1,3,5 with data tables and 2,4 with data explanation.

    • @andersjensenorg
      @andersjensenorg  Před 2 lety

      Hey Mads Hoxer Larsen
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: czcams.com/video/C6xmGfEL07I/video.html
      Have a great day.
      Kind regards,
      Anders

    • @Hoxerm
      @Hoxerm Před 2 lety

      @@andersjensenorg thanks I'll try it

    • @ambikasingh8674
      @ambikasingh8674 Před rokem

      Hey did you get any solution for it?

    • @Hoxerm
      @Hoxerm Před rokem

      @@ambikasingh8674 Yeah I made a different solution

  • @manjeshjk
    @manjeshjk Před 3 lety

    Hello Anders. I was trying out this option, I have an error "Data Extraction Scope: Your license could not be validated. Please make sure that the API key parameter is correctly configured.". This is one part . I have table data in 2 different pages for 1 invoice so how do you extracted the 2 tables. Your feedback would be very helpful.

    • @HP.0
      @HP.0 Před 3 lety +1

      Make sure the API key you are using is for document understanding.

    • @HP.0
      @HP.0 Před 3 lety +1

      Make sure the API key you are using is for document understanding.

    • @andersjensenorg
      @andersjensenorg  Před 3 lety

      Thank you HP :)

  • @ketan1187
    @ketan1187 Před 11 měsíci

    How to extract data from a table that is spanned across multiple pages of the PDF file?

    • @andersjensenorg
      @andersjensenorg  Před 11 měsíci

      Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 9000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders

  • @lokeshmello3391
    @lokeshmello3391 Před 2 lety

    I have the same use case but I have to extract only for one pdf where should I stop in that workflow to finish for only one pdf please help me I am new to the uipath

    • @andersjensenorg
      @andersjensenorg  Před 2 lety

      Hey Lokesh Mello Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: czcams.com/video/C6xmGfEL07I/video.html Have a great day. Kind regards, Anders

  • @zahid_rahim
    @zahid_rahim Před rokem

    Hi, Taxonomy Manager icon is not available in my top tool bar. How can I go in Taxonomy Manager?

    • @andersjensenorg
      @andersjensenorg  Před rokem

      Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 8000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders

  • @JoseHernandez-nt6gj
    @JoseHernandez-nt6gj Před rokem

    hello, please your help. i tried with other document buy say me error : Data Extraction Scope: The document type(s) NoGroup.NoCategory.DOCUMENTO1.DocumentType could not be found in the Taxonomy. To correct this error please check and save the classifier configuration in the Data Extraction Scope activity.

    • @andersjensenorg
      @andersjensenorg  Před rokem

      Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders

  • @bGud
    @bGud Před rokem

    I get this error: Unable to find an entry point named 'cveInputArrayFromVectorOfMat' in DLL 'cvextern'.
    Can you assist please

    • @andersjensenorg
      @andersjensenorg  Před rokem

      Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 4900+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders

  • @ricamaemonteverde5336
    @ricamaemonteverde5336 Před 2 lety

    Hi sir Anders, what if there are multiple pages of tables on a pdf file?

    • @ricamaemonteverde5336
      @ricamaemonteverde5336 Před 2 lety

      Already watched related pdf videos of yours and it helped me with my questions! Thanks, Anders I'll be looking forward learning from u more :)

    • @andersjensenorg
      @andersjensenorg  Před 2 lety

      Hey Rica Mae Monteverde
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: czcams.com/video/C6xmGfEL07I/video.html
      Have a great day.
      Kind regards,
      Anders

  • @reddappareddy7552
    @reddappareddy7552 Před 9 měsíci

    Hi Anders, Could you please share sample timesheet pdf's file through lync/URL for downloading

    • @andersjensenorg
      @andersjensenorg  Před 9 měsíci

      Hey Redapp, Unfortunately I don't have them 😞 Kind regards, Anders

  • @rajurec2721
    @rajurec2721 Před rokem

    How to do for different table structures

    • @andersjensenorg
      @andersjensenorg  Před rokem

      Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders

  • @user-iw6kg8fc9p
    @user-iw6kg8fc9p Před 8 měsíci

    which version of your ui path

    • @andersjensenorg
      @andersjensenorg  Před 8 měsíci

      Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders

  • @daxteoh27
    @daxteoh27 Před 3 lety

    Does this work for scanned PDF?

    • @andersjensenorg
      @andersjensenorg  Před 3 lety +1

      Hey Dax. Yeah, that's one if it's strengths 😊 Have a great day. Kind regards, Anders

  • @rajurec2721
    @rajurec2721 Před rokem

    Please share invoices for practice p

    • @andersjensenorg
      @andersjensenorg  Před rokem

      Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 4900+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders

  • @R.DENDY.Y
    @R.DENDY.Y Před 9 měsíci

    what if the table is more than 1 page?

    • @andersjensenorg
      @andersjensenorg  Před 9 měsíci

      Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): czcams.com/video/xWFz-S96XGo/video.html Kind regards, Anders

  • @saipappu660
    @saipappu660 Před 2 lety

    I need help

    • @andersjensenorg
      @andersjensenorg  Před 2 lety

      Hey Sai
      Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best).
      I've created my UiPath Groups, where we all can post and solve problems or hang out around our favorite tool, UiPath. So you're very welcome. Get the addresses here: czcams.com/video/C6xmGfEL07I/video.html
      Have a great day.
      Kind regards,
      Anders

  • @i-hengpai1621
    @i-hengpai1621 Před 2 lety +1

    oh my god 😂 it's crazy