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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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: ua-cam.com/video/C6xmGfEL07I/v-deo.html Have a great day. 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: ua-cam.com/video/C6xmGfEL07I/v-deo.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: ua-cam.com/video/C6xmGfEL07I/v-deo.html Have a great day. 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: ua-cam.com/video/C6xmGfEL07I/v-deo.html Have a great day. Kind regards, Anders
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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: ua-cam.com/video/C6xmGfEL07I/v-deo.html Have a great day. Kind regards, Anders
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html 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: ua-cam.com/video/uCdBC2pXPyY/v-deo.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.
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 ?
@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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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
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.
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: ua-cam.com/video/C6xmGfEL07I/v-deo.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.
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
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: ua-cam.com/video/C6xmGfEL07I/v-deo.html Have a great day. 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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: ua-cam.com/video/C6xmGfEL07I/v-deo.html 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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: ua-cam.com/video/C6xmGfEL07I/v-deo.html Have a great day. 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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?
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
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: ua-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
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): ua-cam.com/video/xWFz-S96XGo/v-deo.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: ua-cam.com/video/C6xmGfEL07I/v-deo.html Have a great day. Kind regards, Anders
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: ua-cam.com/video/C6xmGfEL07I/v-deo.html Have a great day. Kind regards, Anders
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: ua-cam.com/video/C6xmGfEL07I/v-deo.html Have a great day. 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: ua-cam.com/video/C6xmGfEL07I/v-deo.html Have a great day. Kind regards, Anders
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): ua-cam.com/video/xWFz-S96XGo/v-deo.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
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: ua-cam.com/video/C6xmGfEL07I/v-deo.html Have a great day. 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: ua-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?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: ua-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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: ua-cam.com/video/C6xmGfEL07I/v-deo.html Have a great day. Kind regards, Anders
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: ua-cam.com/video/C6xmGfEL07I/v-deo.html Have a great day. Kind regards, Anders
Hey Rakesh. You can use this framework: ua-cam.com/video/INnbGPF5MwE/v-deo.html and then apply the Document Understanding Tables/structured data from the present video :) Kind regards, Anders
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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: ua-cam.com/video/C6xmGfEL07I/v-deo.html Have a great day. Kind regards, Anders
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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: ua-cam.com/video/C6xmGfEL07I/v-deo.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.
Learn how to extract unstructured invoice PDF data in this tutorial: ua-cam.com/video/cp1hbChzUQ4/v-deo.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
Useful content, well explanation thank for your efforts anders
You're very welcome, Raju Rec - your support helps me a lot 😍
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Very informative video and use case.. Thanks for uploading 👍👍
Hey Suprit. Thanks a lot 👍😊
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: ua-cam.com/video/C6xmGfEL07I/v-deo.html
Have a great day.
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: ua-cam.com/video/C6xmGfEL07I/v-deo.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: ua-cam.com/video/C6xmGfEL07I/v-deo.html
Have a great day.
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: ua-cam.com/video/C6xmGfEL07I/v-deo.html
Have a great day.
Kind regards,
Anders
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html 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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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: ua-cam.com/video/C6xmGfEL07I/v-deo.html
Have a great day.
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html 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: ua-cam.com/video/uCdBC2pXPyY/v-deo.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 🙂
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: ua-cam.com/video/vKYkqkEBRE4/v-deo.html Kind regards, Anders
@@andersjensenorg thank you so much.
@@Starshameer You're very welcome 😊
@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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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.
Excellent!
Thank you, Ranjit 🙂
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.
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: ua-cam.com/video/C6xmGfEL07I/v-deo.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!
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
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: ua-cam.com/video/C6xmGfEL07I/v-deo.html
Have a great day.
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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: ua-cam.com/video/C6xmGfEL07I/v-deo.html
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html 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: ua-cam.com/video/C6xmGfEL07I/v-deo.html
Have a great day.
Kind regards,
Anders
Hey Adam, did you find solution for this
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): ua-cam.com/video/xWFz-S96XGo/v-deo.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?
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
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: ua-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
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): ua-cam.com/video/xWFz-S96XGo/v-deo.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: ua-cam.com/video/C6xmGfEL07I/v-deo.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
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: ua-cam.com/video/C6xmGfEL07I/v-deo.html
Have a great day.
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: ua-cam.com/video/C6xmGfEL07I/v-deo.html
Have a great day.
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: ua-cam.com/video/C6xmGfEL07I/v-deo.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): ua-cam.com/video/xWFz-S96XGo/v-deo.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 😀
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: ua-cam.com/video/C6xmGfEL07I/v-deo.html Have a great day. 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: ua-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?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: ua-cam.com/channels/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders
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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
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: ua-cam.com/video/C6xmGfEL07I/v-deo.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: ua-cam.com/video/C6xmGfEL07I/v-deo.html Have a great day. Kind regards, Anders
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: ua-cam.com/video/INnbGPF5MwE/v-deo.html and then apply the Document Understanding Tables/structured data from the present video :) 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
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): ua-cam.com/video/xWFz-S96XGo/v-deo.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: ua-cam.com/video/C6xmGfEL07I/v-deo.html
Have a great day.
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): ua-cam.com/video/xWFz-S96XGo/v-deo.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): ua-cam.com/video/xWFz-S96XGo/v-deo.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): ua-cam.com/video/xWFz-S96XGo/v-deo.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): ua-cam.com/video/xWFz-S96XGo/v-deo.html Kind regards, Anders
Does this work for scanned PDF?
Hey Dax. Yeah, that's one if it's strengths 😊 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): ua-cam.com/video/xWFz-S96XGo/v-deo.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: ua-cam.com/video/C6xmGfEL07I/v-deo.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
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 :)