Do you want to learn all about UiPath (Data and Screen scraping as well)? Then check this +2 hour tutorial, ruclips.net/video/3ZKzTHdpsTs/видео.html, where you will learn everything to get started and with all the best practices for automating 🤖
Hey Dipen. Thank you 😊 What you want to do, is to use data scraping like here: ruclips.net/video/vIAJvk4quqA/видео.html (multiple pages) and then you can do is to make a simple counter (either with Get Text or a variable you create and add one to). Then it will be easy to only get 3-7 (you can also just stop it with the counter, when 7 is done). Kind regards, Anders
Hi Anders, very good video. Do you have any recommendation for presenting the data after it is saved to excel? I wonder how to make it look nicer so it may be sent as a link in email body. I guess it's a kind of long story so maybe you can talk about it in the future videos :)
Hey Marcin 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 Marcin you could have an empty already formatted excel template if you know how your data should look and import into it the data from the scraped datatable.
Hello. Maybe you can help me. I want to parse info about smartphones and I want to add to everyone row in excel URL of current page. I think I can do it by selecting search line like element for parsing but it doesn’t work.
Hey Sheremetyev Dmitriy 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
Absolute fantastic video Anders and I'm having a little tinker to adapt it for eBay too. Have a question if possible though, when the data is captured from Excel, how do I copy the information to the cell next to the value thats been captured? so with A1, A2, A3 etc. containing the Book Name, I want to paste the data in the corresponding B1, B2, B3 etc.
Hey Steve. Thanks a lot! Sure. It can be done in several ways. Here comes the easiest one. Right after use a For Each Row on your dtExtractResults. Put in an assign row.item("columnB") = row.item("columnA") (make sure they are of the same data type, e.g. strings, integers etc.). Then write out to Excel etc. Let me know, if that helps :) Kind regards, Anders Ps. You're welcome to join my FB group "UiPath RPA Professionals", where we solve problems and share useful links (or in fact it just me at the moment) :D
@@andersjensenorg Thank you Anders and I have joined the Facebook Group too. With what you describe, do you have a video which explains this/the fundamentals of this? Would this contain the info? ruclips.net/video/-wkxkI3SuUk/видео.html I added an assign but wasn't working, so would like to see a good video on it to understand it more
Did you noticed the order the of the sheets..Sheets1 goes to the far right..and the first in the list SQL will be create to its Left..and etc etc...But if you use workbook Write range, the order will be perfect... Is this a UiPath Bug?
Thank you so much foe this video. this is very helpful to me, I am new in uipath.. I still have a questions, the search is base on excel file...WHAT IF it is not found when you search it? the CLICK activities will be invalid because there is no image to click to get data. How do you handle the error in UIPath to continue to next product. Thank you I hope you understand my English 😃 . I'm from Philippines .:-)
Hey Rex 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, Is it possible to do the same with Power Automate ? for google search result scraping ? Thanks in advance :)great videos btw, been learning a lot of power automate by you :)
Hey Jalal. Thank you :) Yes, for sure, but it lacks a lot of features compared to UiPath. You can use the "Extract Data from Web Page" activity. Let me know, if you have problems with it. Have a great weekend, kind regards, Anders
@@andersjensenorg Thank you so much, you are my new idol and Hero 🙏🏽 Please keep up the amazing work to help so many of us solve complex issues using RPA with your free education platform🙏🏽🙏🏽
Hi Anders, I would like to perform actions in the workflow based on conditions on data scraped from the website.For eg if book of a preferred author found...save it to cart and take further action.
Hey Deepika. Split you workflow into two. First Data Scrape. Second iterate through your Data Table and if author found perform the action. You could ofc also do it once, but it will get more complex. Kind regards, Anders
Hey Ravi shekar N 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, can you please make a video how to create an User Interface with UiPath? So I mean an interface that interact with the user and tells you what comes next und what will be to do (e.g. upload a file). Thank you in advance. BR
What a great coincidence! Thank you very much. I am currently struggling with such an user interface and hope you/ your video can help me to get a nice user interaction. Best regards Marc
Hi Anders great video. I am scraping from a website where I want to grab total number from this string "Showing results 1 to 48 from 59725" I want to grab 59725
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
I feel so bad about this data scraping function. Because it is not 100% support all the web pages. Here is a website named: www.taste.com.au, when I try to search food and extract the recipes' url, it failed all the time, I tried on diff browsers, diff ways, no use...(try this and extract the links: www.taste.com.au/search-recipes/?q=banana , I can see the data extract table, but there is nothing happened when I click "Finish" button) However, when I do the same on Ebay or JBHIFI, it works fine, too bad so sad... Can you have a look on this issue? Many Thanks
Hey ZY Wang 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 Mokate Moreki 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
Do you want to learn all about UiPath (Data and Screen scraping as well)? Then check this +2 hour tutorial, ruclips.net/video/3ZKzTHdpsTs/видео.html, where you will learn everything to get started and with all the best practices for automating 🤖
Hi Anders thanks for very quick video , I have one question how to extract the data from selected pages like from page number 3 to page number 7
Hey Dipen. Thank you 😊 What you want to do, is to use data scraping like here: ruclips.net/video/vIAJvk4quqA/видео.html (multiple pages) and then you can do is to make a simple counter (either with Get Text or a variable you create and add one to). Then it will be easy to only get 3-7 (you can also just stop it with the counter, when 7 is done). Kind regards, Anders
Hi Anders, very good video.
Do you have any recommendation for presenting the data after it is saved to excel?
I wonder how to make it look nicer so it may be sent as a link in email body. I guess it's a kind of long story so maybe you can talk about it in the future videos :)
Hey Marcin
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 Marcin you could have an empty already formatted excel template if you know how your data should look and import into it the data from the scraped datatable.
Hello. Maybe you can help me. I want to parse info about smartphones and I want to add to everyone row in excel URL of current page. I think I can do it by selecting search line like element for parsing but it doesn’t work.
Hey Sheremetyev Dmitriy
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
Absolute fantastic video Anders and I'm having a little tinker to adapt it for eBay too. Have a question if possible though, when the data is captured from Excel, how do I copy the information to the cell next to the value thats been captured? so with A1, A2, A3 etc. containing the Book Name, I want to paste the data in the corresponding B1, B2, B3 etc.
Hey Steve. Thanks a lot! Sure. It can be done in several ways. Here comes the easiest one. Right after use a For Each Row on your dtExtractResults.
Put in an assign row.item("columnB") = row.item("columnA") (make sure they are of the same data type, e.g. strings, integers etc.).
Then write out to Excel etc.
Let me know, if that helps :)
Kind regards, Anders
Ps. You're welcome to join my FB group "UiPath RPA Professionals", where we solve problems and share useful links (or in fact it just me at the moment) :D
@@andersjensenorg Thank you Anders and I have joined the Facebook Group too. With what you describe, do you have a video which explains this/the fundamentals of this? Would this contain the info? ruclips.net/video/-wkxkI3SuUk/видео.html I added an assign but wasn't working, so would like to see a good video on it to understand it more
Thank you! this was very helpful
You're very welcome, Vignesh Kumar Palanimuthu - your support helps me a lot 😍
Did you noticed the order the of the sheets..Sheets1 goes to the far right..and the first in the list SQL will be create to its Left..and etc etc...But if you use workbook Write range, the order will be perfect... Is this a UiPath Bug?
Hey Guru. Haha, nice spot - no I didn't noticed 😮 I'm not sure, but will try it out monday. Thanks for letting me know. Kind regards, Anders
Thank you so much foe this video. this is very helpful to me, I am new in uipath.. I still have a questions, the search is base on excel file...WHAT IF it is not found when you search it? the CLICK activities will be invalid because there is no image to click to get data. How do you handle the error in UIPath to continue to next product. Thank you I hope you understand my English 😃 . I'm from Philippines .:-)
Hey Rex
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, Is it possible to do the same with Power Automate ? for google search result scraping ? Thanks in advance :)great videos btw, been learning a lot of power automate by you :)
Hey Jalal. Thank you :) Yes, for sure, but it lacks a lot of features compared to UiPath. You can use the "Extract Data from Web Page" activity. Let me know, if you have problems with it. Have a great weekend, kind regards, Anders
@@andersjensenorg Thank you so much, you are my new idol and Hero 🙏🏽 Please keep up the amazing work to help so many of us solve complex issues using RPA with your free education platform🙏🏽🙏🏽
I used the table extraction at the end, but I have a problem when it searches for something in the search bar it stops, it doesn't search anymore
Check this one instead: ruclips.net/video/A8cLOfItmv8/видео.html (from 23:33). Kind regards, Anders
Hi Anders,
I would like to perform actions in the workflow based on conditions on data scraped from the website.For eg if book of a preferred author found...save it to cart and take further action.
Hey Deepika. Split you workflow into two. First Data Scrape. Second iterate through your Data Table and if author found perform the action. You could ofc also do it once, but it will get more complex. Kind regards, Anders
Hey Andres. I wan to know the career opportunites of UiPath in terms of job openings and freelancing. Can you plz throw some light on this topic.
Hey Ravi shekar N
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 man for the tutorial
Martin, you're the man - thanks a ton for all your support :) Kind regards, Anders
It's very easy understand this web scraping sir ....
Hey Diwagar. Thanks a lot. You comment help me a lot 🙂 Kind regards, Anders
@@andersjensenorg Thanks 🤗 you sir
@@andersjensenorg
Sir plz tell Instagram ID name sir
I don't use it, but LinkedIn and Facebook?
Hi Anders, can you please make a video how to create an User Interface with UiPath? So I mean an interface that interact with the user and tells you what comes next und what will be to do (e.g. upload a file). Thank you in advance. BR
Hey Marc. Sure, that's easy. Why? Because I've already made it 😀 It is scheduled to the 25th of November. Kind regards, Anders
What a great coincidence! Thank you very much. I am currently struggling with such an user interface and hope you/ your video can help me to get a nice user interaction.
Best regards Marc
Hi Anders great video. I am scraping from a website where I want to grab total number from this string "Showing results 1 to 48 from 59725" I want to grab 59725
Hey OnTheGo, you can use Regex. You can try it in a Write Line: System.Text.RegularExpressions.Regex.Match("Showing results 1 to 48 from 59725","(?
Can i do the same with coded automation, if yes how?
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
nice sharing
can do tutorial to passte uipath delevoper exam ??
You're very welcome, megadisc1982 - your support helps me a lot 😍
I feel so bad about this data scraping function. Because it is not 100% support all the web pages.
Here is a website named: www.taste.com.au, when I try to search food and extract the recipes' url, it failed all the time, I tried on diff browsers, diff ways, no use...(try this and extract the links: www.taste.com.au/search-recipes/?q=banana , I can see the data extract table, but there is nothing happened when I click "Finish" button)
However, when I do the same on Ebay or JBHIFI, it works fine, too bad so sad... Can you have a look on this issue? Many Thanks
Hey ZY Wang
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 job thanks for this tutorials. I have sent through an email for a request, i hope you can be able to help . thanks Mokate
Hey Mokate Moreki
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