UiPath Document Understanding: Extract Tables Out of PDFs
HTML-код
- Опубликовано: 27 июл 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 - ruclips.net/user/klogeande...
💼 LinkedIn - / andersjensens
👥 Facebook - / andersjensenorg
💌 Email Newsletter - andersjensen.org/email-newsle...
#uipath #rpa #documentunderstanding
Learn how to extract unstructured invoice PDF data in this tutorial: ruclips.net/video/cp1hbChzUQ4/видео.html
I've watched many tutorials online but nothing seems to work until I stumbled across your channel. Great work Anders! Thanks!!
Hey Syed. Thanks a ton, let me know, if you have any questions in future. Have a great weekend. Kind regards, Anders
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!
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
Very informative video and use case.. Thanks for uploading 👍👍
Hey Suprit. Thanks a lot 👍😊
Useful content, well explanation thank for your efforts anders
You're very welcome, Raju Rec - your support helps me a lot 😍
Excellent!
Thank you, Ranjit 🙂
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.
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
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?
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: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
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?
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: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
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.
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
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
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: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
Thanks for video!! Can we check whether data present in table of multiple page document.?
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: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
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 ?
Hey Shameer. Can you do a lookup: ruclips.net/video/vKYkqkEBRE4/видео.html Kind regards, Anders
@@andersjensenorg thank you so much.
@@Starshameer You're very welcome 😊
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
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: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
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?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Thanks for sharing. I'm trying to find how to modify an existing table in a pdf and save the pdf
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: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
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 ?
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
@@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.
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
Hey Siddartha. You're welcome. I think I understand you. Can we remove the footer afterwards with logic/regex? Kind regards, Anders
@@andersjensenorg Thanks for your response, I tried your workaround and successfully removed table footer using filter datatable. Thanks again.
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
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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.
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: ruclips.net/channel/UCPdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
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.
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: ruclips.net/channel/UCPdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
@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!
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Hello Anders,
Will the same approach work for handwritten documents?
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: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
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
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Question: Would this work with an image or file sitting in a document retrieval system?
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
@@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?
Hi sir !! How to do the same process , and extract tables from multiple pages of pdf, where table will have same structure.
Hey Rakesh. You can use this framework: ruclips.net/video/INnbGPF5MwE/видео.html and then apply the Document Understanding Tables/structured data from the present video :) Kind regards, Anders
Fantastic Anders! I'm trying to use it, and comes an error: BC30512: Strict ...from "DataTableCollection" to "IEnumerable(Of DataTable)".
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Hi @Anders Jensen -What if there is no data available in table other than two rows how can we handle that
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: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
How to use write range for each pdf using this taxonomy because write range overwrite?
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: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders
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.
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: ruclips.net/video/uCdBC2pXPyY/видео.html Let me know, if that helped you a bit? Kind regards, Anders
@@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.
@@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!
@@andersjensenorg Just sent it over. Thanks again, Anders.
Great, I will try to take a look 🙂
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.!!
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: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
@@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.
@@andersjensenorg Can u plz reply, does it support atleast for multiple pages content and how. A simple clue atleast. Thanks!
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
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: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders
Hello Anders, if a PDF that is 4 pages long with tables on each page, how can I extract all the tables ?
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: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
Hey Adam, did you find solution for this
I am extracting invoice no.,Date, po number, and also entire table in pdf how to write these results in an excel file
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: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
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.
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: ruclips.net/channel/UCPdtz4gd_iYebJFYq9N8pWAcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
Hello,
I have follow your videos but when try to to scrap hole table but only one row scrap
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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
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
@@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 😀
Hi, Taxonomy Manager icon is not available in my top tool bar. How can I go in Taxonomy Manager?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
How to do for different table structures
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Hi Anders, Could you please share sample timesheet pdf's file through lync/URL for downloading
Hey Redapp, Unfortunately I don't have them 😞 Kind regards, Anders
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?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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
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: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders
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.
Make sure the API key you are using is for document understanding.
Make sure the API key you are using is for document understanding.
Thank you HP :)
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?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
which version of your ui path
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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.
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: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
@@andersjensenorg thanks I'll try it
Hey did you get any solution for it?
@@ambikasingh8674 Yeah I made a different solution
Does this work for scanned PDF?
Hey Dax. Yeah, that's one if it's strengths 😊 Have a great day. Kind regards, Anders
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?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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.
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Please share invoices for practice p
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
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.
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: ruclips.net/video/C6xmGfEL07I/видео.html Have a great day. Kind regards, Anders
I get this error: Unable to find an entry point named 'cveInputArrayFromVectorOfMat' in DLL 'cvextern'.
Can you assist please
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
Hi sir Anders, what if there are multiple pages of tables on a pdf file?
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 :)
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: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
what if the table is more than 1 page?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
How to extract data from a table that is spanned across multiple pages of the PDF file?
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): ruclips.net/video/xWFz-S96XGo/видео.html Kind regards, Anders
I need help
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: ruclips.net/video/C6xmGfEL07I/видео.html
Have a great day.
Kind regards,
Anders
oh my god 😂 it's crazy
Haha, in a good way? 😀
I feel distant , It’s complex for me