Automate collecting tabular data from web page and insert into excel file

No video

Automate collecting tabular data from web page and insert into excel file - Selenium UI flow (RPA)

Рет қаралды 30,922

Reza Dorrani

Күн бұрын

Пікірлер: 76

@pavansrikarnarayan6392 4 жыл бұрын

Reza, Thanks a lot I have been exploring on the UI flows for a long time and happy to see this kind of explanation .

@RezaDorrani 4 жыл бұрын

Thank you

@ashu49 3 жыл бұрын

Absolutely Brilliant....."Walk the Talk" kind of stuff.Thank you for this.

@RezaDorrani 3 жыл бұрын

Thank you Ankesh

@khadimali9755 3 жыл бұрын

Awesome tutorial. Hats off for you, Reza.

@RezaDorrani 3 жыл бұрын

Thank you

@qman1274 3 жыл бұрын

Thank you so much for this. This was invaluable. I got around the double quotes issue by using Store instead of execute script. I was able to get to the jsonVal variable in the instant flow just the same. But still, this video was perfect!

@RezaDorrani 3 жыл бұрын

Very happy to know you got this to work. Great work. Its been a while now and UI flows has made a lot of progress since. The new Power Automate Desktop is now in preview and provides a lot more capabilities with a lot more intuitive interface.

@Lethal83 4 жыл бұрын

Hi @Reza. This video was invaluable for me. Nearly covered off everything I needed to do. Great video!!!

@RezaDorrani 4 жыл бұрын

Glad it was helpful!

@jameshenryhinton 4 жыл бұрын

Brilliant! So useful - thank you Reza!

@RezaDorrani 4 жыл бұрын

Thank you

@talsdaddy 3 жыл бұрын

Reza, this is an awesome video. Thank you very much.

@RezaDorrani 3 жыл бұрын

Glad you liked it! This definitely is one of my most watched videos :)

@gayathridrawpathy7694 4 жыл бұрын

Thank you so much Reza.Very informative.

@RezaDorrani 4 жыл бұрын

Your welcome

@rajasekar5069 3 жыл бұрын

Awesome bro

@RezaDorrani 3 жыл бұрын

Thank you

@williammarchek9078 3 жыл бұрын

This is brilliant!

@RezaDorrani 3 жыл бұрын

Thank you William

@ravichandrababu9133 4 жыл бұрын

Great Demo Sir! ...thumbs up

@RezaDorrani 4 жыл бұрын

Thank you Sir 🙏

@kevinekikuvuidi5114 Жыл бұрын

Hi Reza, Thanks for the link you had sent me the other time, in any case it helped me a lot, and from this link I got many suggestions for the desktop flow, which I have been following this last time. The question I still can't find the answer to, if you can get the explanations: For unattended desktop flow execution that is triggered with a scheduled cloud flow, will this flow execute correctly if the target machine is turned off? Thanks in advance.

@RezaDorrani Жыл бұрын

I did respond to this same comment :) Machine will need to be ON.

@pashupatimishra9335 3 жыл бұрын

Great video 👌.

@RezaDorrani 3 жыл бұрын

Thank you

@1in1x10n6 3 жыл бұрын

Hi Resa, thank you for your work. Thi shas helped me as a hobbyist. How do you keep your JSON clean if the scraped data contains a " ?

@RezaDorrani 3 жыл бұрын

That would have to be done in the flow calling the RPA flow. You can use expressions to manipulate the data obtained. To learn flow expressions: aka.ms/learnexpressions

@javier_ilde 4 жыл бұрын

Reza, you are a star!! Thanks a lot for the video. I am not a technical person but I am trying to do my best thanks to you videos. May I ask you a doubt I have? I am in trouble when a field captured with your method, contains a single quote. For instance, O'Grady. It fails. Any guess? Not sure if there is any way "replace" that character in Selenium for Flow. Thanks a lot in advance.

@RezaDorrani 4 жыл бұрын

I have not tried with a special character. Is error at in flow or selenium? In flow you can run expressions to manipulate the strings

@javier_ilde 4 жыл бұрын

Wow! Thanks for your quick response. I refer to Selenium IDE, at your Step 53, executing the script where you join strings on ${JsonVal}. If a variable include a single comma, send a single error "Test ended with 1 error". It is because the text captured from a tabular table contains a comma. For instance: O'Grady , Microsoft's. That comma is killing me :(

@ChrisDCowin 4 жыл бұрын

If your table doesn't have an ID, but has a class, use css=table.[class name] in the target field.

@RezaDorrani 4 жыл бұрын

Yes. As long as you can parse the DOM and get to your element. Typically I try to grab the id of a parent element to the table (if no id for table) and then use xpath to drill down to the table

@saqibshaikh3411 3 жыл бұрын

Awesome! I want to know is there any way we can read cells one by one from an excel file and extract data for that particular text from the webpage? I m trying to work on my mini project but stuck.

@RezaDorrani 3 жыл бұрын

Check Power Automate Desktop Tool. It has a lot of possibilities.

@obeidmirzagmail 3 жыл бұрын

You have been extremely helpful! Watched your video like 10-15 times. it's my first time exploring Selenium UI Flow I had few questions: What shall I do when the table's values have " example: "Yoga"? Is there a way I can replace the " with something else when running the store command?

@obeidmirzagmail 3 жыл бұрын

it's cool I resolved this, thanks for making this video for us.

@RezaDorrani 3 жыл бұрын

Looks like you got this resolved.

@RezaDorrani 3 жыл бұрын

Great

@pashupatimishra9335 3 жыл бұрын

Just have a question,how can we achieve queue processing in PowerAutomate,like other RPA tools, where we work on a case in multiple stages. Like multiple flows working on 1 case in sequence.

@RezaDorrani 3 жыл бұрын

If multiple RPA requests are sent at the same time, they automatically queue up. Only 1 RPA will run on a server at 1 time. You can also setup load balancing using data gateway to have requests run on multiple servers.

@pashupatimishra9335 3 жыл бұрын

Thank you 😊

@maxi88564 3 жыл бұрын

Hi Resa, your video is very useful. Thanks a lot! Now is possible to use “ in the execute script command?. I would like to generate the JSON object inside a while loop and at the end of the process save the JSON object into a variable with the Store Json command

@RezaDorrani 2 жыл бұрын

Possible. I have done this video long back so it would be tough for me to go back to this and try out the changes :) Power Automate Desktop is the new tool that one should be using for RPA in Power Platform. I would recommend to give that a try.

@pranithamaddi6054 2 жыл бұрын

Hi I am a beginner and just started exploring on creating the PVA (chatbots) I don't see the option to create UI flow? May I know how to get that option?

@RezaDorrani 2 жыл бұрын

UI flows are now rebranded as Desktop flows. Check kzfaq.info/get/bejne/sJdpdqSI1pfYe2w.html

@Theworldofeverything_67 3 жыл бұрын

Sir,what if the table has fixed number of columns and rows forever,will the process become simple?

@RezaDorrani 3 жыл бұрын

Yes. your formulas would be more simple.

@MrSunni10 2 жыл бұрын

Hi Reza....can you please add video on how to open a webpage with login info and then select parameter an then save the output to csv file. Thank you

@RezaDorrani 2 жыл бұрын

I will add this request to my backlog. I would need a lot more requests on this topic to give it a higher priority though :)

@MrSunni10 2 жыл бұрын

@@RezaDorrani Thank you Reza.

@Suryaprakashgadi 4 жыл бұрын

Hi@Reeza your videos are wonderful and worth can we read data from excel and insert into selenium ide what is the connector for that. Which command we use in selenium ide. Thanks in advance Surya

@RezaDorrani 4 жыл бұрын

Here is the list of selenium ide commands www.selenium.dev/selenium-ide/docs/en/introduction/faq

@MauriDR5 3 жыл бұрын

it there a way to get the same result in power automate desktop without using Selenium IDE?

@RezaDorrani 3 жыл бұрын

This is surely possible with PAD. I do not have a video on that though.

@nakulmandhre3897 3 жыл бұрын

Can we do this to copy data from LinkedIn sales navigator to excel?

@RezaDorrani 3 жыл бұрын

Yes, possible.

@selwynvanrooyen9432 3 жыл бұрын

Why do i not see UI flows (preview) ?

@RezaDorrani 3 жыл бұрын

They have been renamed to desktop flows and there is a new tool called Power Automate Desktop that should be leveraged.

@lavanyareddy246 4 жыл бұрын

we are unable to open this la fitness link which you show in this video will you please provide the link.ASP

@RezaDorrani 4 жыл бұрын

Hi Lavanya, The LA fitness link was just given as an example. Currently, due to COVID LA Ftiness schedules are not posted and the link is not accessible.

@cmac6877 4 жыл бұрын

I always get a flowsessions error when I try to run

@RezaDorrani 4 жыл бұрын

Ensure you have the latest version of the UI flows installed.

@sampadamirashi9557 4 жыл бұрын

Can you please provide LA Fitness URL

@RezaDorrani 4 жыл бұрын

-Hi Sampada, LA Fitness is currently closed due to COVID hence the class schedules have been taken down. Here is the link lafitness.com/pages/classscheduleprintversion.aspx?clubid=322 This video is just a simple demo on how you can fetch tabular data from any web page.-

@Riskninjaz 3 жыл бұрын

Why not just use power query?

@RezaDorrani 3 жыл бұрын

To scrape a web page?

@Riskninjaz 3 жыл бұрын

Reza Dorrani yea

@madamaczone 3 жыл бұрын

I'm Mac user, and Power Query isn't available for Excel, that could work for Mac users. I have a doubt this software aren't free right? They need a subscription plan?

@selwynvanrooyen9432 3 жыл бұрын

Can you schedule a reload with power query?

@Riskninjaz 3 жыл бұрын

@@selwynvanrooyen9432 just update source file dude. PQ does all the heavy lifting from there