Sudoku Solver in Power Automate Desktop
1:11:38
Dark Mode Is Important To Me
9:27
C# | Armstrong Numbers
6:51
5 ай бұрын
C# | Prime Factors on Leap Day
9:35
C# | Triangles Are People Too
17:06
C# | That's a Big Integer
14:24
6 ай бұрын
C# | Only 1 mistake this time
7:39
C# | Last Time On Dragon Ball C
19:54
C# | Tell me how bad this code is
16:54
Пікірлер
@Dinesh-bd8bt
@Dinesh-bd8bt 9 сағат бұрын
Which version we have this options? 7 and above only?
@gatesv1326
@gatesv1326 16 сағат бұрын
Thanks for giving us a look into the new app modeller. I was wondering what it looked like and the benefits it had to offer. It’s interesting. And between you and me (and the whole world), when SS&C shows us that they work on improving stuff, it’s enough to make me happy, whatever it is. 😉
@DaveTheRPAGuy
@DaveTheRPAGuy 16 сағат бұрын
@@gatesv1326 Samesies!
@praving7732
@praving7732 9 сағат бұрын
That's true 😂
@praving7732
@praving7732 9 сағат бұрын
Thanks @DaveTheRPAGuy for sharing this information with us.
@andygray563
@andygray563 Күн бұрын
Hi Dave. I want to attach to an already saved and running excel file. This works for me if I use say C:/temp/ but fails for me if I have the file using a network address like \\server1\work\ Do you know why this fails or how I can get this to work?
@DaveTheRPAGuy
@DaveTheRPAGuy 16 сағат бұрын
Try using the UNC path for your local temp folder as well and see if that fails too. For example, try \\localhost\c$\temp or whatever. Doing this works for me. I don't currently have access to any network file shares that I can test this with so I just tested on localhost. One other question though. Have you tried just putting the name of the Excel document into the Document Name input of Attach to Running Excel? This also works for me, and I would think it'd get around your UNC path issue. Of course if even that doesn't work, then I would assume you have some kind of issue access file shares in PAD. If you continue having this issue, you could join the ILoveAutomation Discord server where there are people far more knowledgeable than I am about PAD and may be able to help.
@cinbar
@cinbar 2 күн бұрын
Wow I didn't know about wide-zoom pan tool. I think it's great!
@DaveTheRPAGuy
@DaveTheRPAGuy Күн бұрын
I know, right!? It's been hiding in plain sight all this time. 🤣
@gatesv1326
@gatesv1326 3 күн бұрын
These “stages to the border of the screen” bug is a pain in pre-7.3 versions. It was about time that they fix this. I’m still on 7.2.2 so that’ll have to wait a few months. We weren’t ready to replace our Outlook VBO yet (which 7.3 was forcing us to do it seems) so we went with 7.2.2 for now.
@DaveTheRPAGuy
@DaveTheRPAGuy 3 күн бұрын
@@gatesv1326 Yeah we are planning an upgrade from 6.10.1 to 7.3.1, and that comes with quite a few differences. I'm trying to think why you'd need to replace the Outlook VBO though. Was it something to do with 64bit?
@gatesv1326
@gatesv1326 2 күн бұрын
Hi Dave. No. Unrelated to 64-bit. The 64-bit architecture is what pushed us to go to 7.2. That’s the first release that has this architecture (and it was about time). The update to the new Outlook VBO is required for 7.3. I can’t recall exactly the reason, but the BP release notes for 7.3 mention it. We’re moving out of using the Outlook VBO to use the MS Graph API. Once we’ve updated all of our processes and have cut the ties to the Outlook VBO, we’ll update to 7.3 (or whatever is the latest release at that point), likely in Q1 2025. Until then, we’ll stick with 7.2.2 cause we’ve made too many adjustments to the base VBO to replace it.
@DaveTheRPAGuy
@DaveTheRPAGuy Күн бұрын
@@gatesv1326 ​ I looked into this today because this made me concerned that I would also need to handle this when we upgrade to 7.3.1 within the next few months. It turns out that the new Outlook VBO (the NetOffice one) has the same functionality and technically will work with 7.3+. I just tested it in 7.3.1. I do not know whether I am allowed to mention the reason for the change in VBO. But if you are already using the Outlook VBO and have the Microsoft Interop DLL, you can continue to use it in 7.3+. This just wouldn't be officially supported by Blue Prism (the company). However, it is apparently supposed to be exactly the same and requires nothing beyond importing the new VBO and the rest should work the same. For me, I think I will delay the adoption of that NetOffice newer version of the VBO because we've edited our VBO and thus it'll take some effort for me to make the same changes in the NetOffice version. So, I just wanted to follow up with you and let you know that you can upgrade to 7.3.1 or whatever without changing the Outlook VBO. You may still not want to upgrade, and there's no problem there. I just wanted to let you know what I found.
@gatesv1326
@gatesv1326 Күн бұрын
Hey Dave. Just to clarify things, what you meant to say is the OLD VBO (the one we’re using now in pre-7.3 versions) will work with 7.3+, right?
@DaveTheRPAGuy
@DaveTheRPAGuy Күн бұрын
@@gatesv1326 correct
@barskarakas4927
@barskarakas4927 3 күн бұрын
Dave you are making me wanna go back to Blue Prism :) Awesome video as always!
@barskarakas4927
@barskarakas4927 3 күн бұрын
Man I miss Blue Prism... One thing I love about the compare functionality is that you can easily export both versions by going to File tab on the compare window and clicking the export left/right side options. You can have it as a back up file and roll back to that version by importing it any time. Blue Prism design studio is very visual easy to see and read in my opinion compared to some other very popular tools
@DaveTheRPAGuy
@DaveTheRPAGuy 3 күн бұрын
Haha! Thanks! Yeah, the Compare functionality is a great feature, and yeah I often enjoy the visual nature of Blue Prism compared to other tools. Now, if they can just implement Dark Mode, I'll be happy. =)
@Marc-hh7px
@Marc-hh7px 3 күн бұрын
Hey Dave, thanks for the content. What's the difference between one object per screen and one object for all the screens?
@DaveTheRPAGuy
@DaveTheRPAGuy 3 күн бұрын
One object for all the screens sounds like what Blue Prism recommends avoiding which is to put all actions in a single object. This isn't the same thing as what I showed for Dynamic Objects. This would be if you just clicked around the whole application and created application modeller elements for every element you need to interact with and then you created all the different actions that you need one after another regardless of what screen they are on. This kind of massive object would end up having tons and tons of actions usually convoluted logic and traverse all kinds of screens in the app, and this becomes really hard to manage, consumes a lot of memory due to the size of the object, etc. The kind of actions I'm referring to here would be like "Launch, Login, Create Person, Edit Person, Add Address, Read Order Results, Reconcile Orders, Issue Invoice, etc. etc." You can see how these seem to have no cohesiveness with each other. They are random different actions across the whole app and instead should be separated. Just to be clear, what I showed in the second method with the Dynamic Object approach is different from that. It might use just one object, but in this case we're creating dynamic actions that could be used on different screens, but they are not tied to different specific screens.
@gatesv1326
@gatesv1326 6 күн бұрын
Thanks for this video Dave. There’s two types of logging you can do. One is based on debugging to find out the root cause of exceptions. The other is for audit purposes. For the later, it might be required that you log parameters on collections so that you can do operational tracking on transactions. What we do in our production environnement is to log what we need to log, but then at the end of the process, we export the logs to a network drive. We also have a process that runs daily which cleans the logging in the environnement and keeps only two months of logs. We always have the exported logs to go back to if auditors ask questions.
@DaveTheRPAGuy
@DaveTheRPAGuy 5 күн бұрын
@@gatesv1326 We do similar where we keep only session logs in blue prism for the last 90 days and the rest gets archived out into files.
@BridgeWatches
@BridgeWatches 7 күн бұрын
Great content Dave. 👍
@DaveTheRPAGuy
@DaveTheRPAGuy 7 күн бұрын
@@BridgeWatches Thanks!
@GilesBathgate
@GilesBathgate 7 күн бұрын
I am wondering in terms of usability, when you cannot delete, instead of an error it should allow you to retire. This could be done by providing, on the confirm deletion window, an extra button 'retire'. (The delete button would be disabled when you cannot delete, perhaps a label/tooltip saying why its disabled for newbies would still be needed.)
@DaveTheRPAGuy
@DaveTheRPAGuy 7 күн бұрын
@@GilesBathgate I agree. I suspect Blue Prism Next Gen will be made with more user friendly features.
@iddondepths
@iddondepths 7 күн бұрын
There is a great pluging for notepad++ for json management/formatting, highlights errors and makes it look pretty. Think its called JSTool or something along them lines.
@gatesv1326
@gatesv1326 7 күн бұрын
Just so you know, the filter bar at the top of the EV window doesn’t exist in 7.2.2, so it’s likely an addition of 7.3.
@DaveTheRPAGuy
@DaveTheRPAGuy 7 күн бұрын
That makes sense. Thanks for letting me know!
@Marc-hh7px
@Marc-hh7px 8 күн бұрын
How do you manage having BP on a personal machine, do you pay for a licence or its just a learning addition that you keep renewing?
@DaveTheRPAGuy
@DaveTheRPAGuy 8 күн бұрын
@@Marc-hh7px Just the learning edition that I keep renewing.
@HarshalZade
@HarshalZade 8 күн бұрын
Awesome. As we don't have in our BP version filtering for Env, we use Config CSV and then convert those to collection. But I think is better way, as value titles are directly coming as columns of collection. Thanks Dave. Keep it up. Awaiting eagerly for new BP videos.
@DaveTheRPAGuy
@DaveTheRPAGuy 8 күн бұрын
@@HarshalZade I'm glad this helped!
@artelisabeth
@artelisabeth 8 күн бұрын
I hate spaces too 😂😆
@DaveTheRPAGuy
@DaveTheRPAGuy 8 күн бұрын
🤣
@gatesv1326
@gatesv1326 8 күн бұрын
It’s good to see you again on BP tutorials. I’ve learned a lot from you 6 years ago when I started RPA development on BP. I’m still going strong at it. Please keep this good stuff coming in. 👍
@DaveTheRPAGuy
@DaveTheRPAGuy 8 күн бұрын
Awesome! Thank you!
@bjoern5796
@bjoern5796 8 күн бұрын
Same here. Also started 6 years ago and Dave was abolutely helpful. And in a few weeks I have to develop a process using JSON, so again, just at the right time another helpful video. Shoutouts to Dave. You´re the best!
@cinbar
@cinbar 8 күн бұрын
Hi Dave! I love your videos about BP. Please keep uploading BP videos :) I would like to ask you how you read invoices. We tried decipher but with bad results. Thank you!
@DaveTheRPAGuy
@DaveTheRPAGuy 8 күн бұрын
I have done some work with reading invoices, but it was always spotty in results. I have only used Decipher a little bit, and I have kind of stayed away from it because I'm unsure whether Blue Prism is planning to support it long term. That is not official from Blue Prism, but it is the feeling I get. In general, I actually try to discourage using Blue Prism for reading invoices because I think there are other platforms that are just much better at it.
@DaveTheRPAGuy
@DaveTheRPAGuy 17 күн бұрын
I just realized I misspelled Sudoku in the Subflow name. 😅
@farberka
@farberka 22 күн бұрын
Crazy :)
@karakasartworks
@karakasartworks 24 күн бұрын
Good content
@barskarakas4927
@barskarakas4927 24 күн бұрын
Thanks a lot for the mention Dave :) Awesome video as always.
@randomrouting
@randomrouting 24 күн бұрын
Appreciate PAD content, I learned some new stuff so thanks :)
@SirGG
@SirGG 29 күн бұрын
im waiting for dark theme for 4 years allready
@DaveTheRPAGuy
@DaveTheRPAGuy 26 күн бұрын
@@SirGG 😥
@MrArbitraryNumber
@MrArbitraryNumber Ай бұрын
This is exactly what i needed as a newbie RPA builder. Was trying to figure out how to click through multiple pages and click each item on a page before going to the next page. .
@DaveTheRPAGuy
@DaveTheRPAGuy 26 күн бұрын
@@MrArbitraryNumber awesome! i'm glad i posted it then!
@OmPrakash-wz7eq
@OmPrakash-wz7eq Ай бұрын
Hey Dave, it's really a good stuff for beginers. Thanks.
@DaveTheRPAGuy
@DaveTheRPAGuy Ай бұрын
@@OmPrakash-wz7eq Thanks!
@aditigupta1569
@aditigupta1569 Ай бұрын
Also Dave, why did you use " Data" instead of using normal Data database..?
@DaveTheRPAGuy
@DaveTheRPAGuy Ай бұрын
I'm not sure what you're referring to. I see that I used a collection variable (data item) named "Data", but what do you mean by "using normal Data database"?
@aditigupta1569
@aditigupta1569 Ай бұрын
Hi Dave, global send keys is not inputting the values. Can you suggest some other way?
@DaveTheRPAGuy
@DaveTheRPAGuy Ай бұрын
The only reason global send keys won't work is if you haven't set the focus/cursor into the blank first and/or if the browser isn't in the foreground. The standard way to handle this in Blue Prism is to use Activate Application, then (if necessary) Global Mouse Click into the field, then Global Send Keys. Is that the design you've tried?
@rammsteiner18
@rammsteiner18 Ай бұрын
Hi Dave, do you know the issue why I`m as admin could not setup a alarm using rightsclick menu for users? ( its greyed out - and idk why :-/ ) thx
@DaveTheRPAGuy
@DaveTheRPAGuy Ай бұрын
@@rammsteiner18 Are you sure you have true Sys Admin permissions or a custom role that someone just calls Administrator? Nothing should be greyed out for System Administrators.
@mytciopinfo
@mytciopinfo 2 ай бұрын
Dave, any time I try to select a UI element using the picker, I get stuck with a perpetual "Wait for action" message. In other words, I'm not able to capture any UI elements. Terribly frustrating. Any idea why?
@DaveTheRPAGuy
@DaveTheRPAGuy Ай бұрын
@@mytciopinfo My first thought would be to check if the target application is running with elevated privileges which can cause it to not work. Otherwise, I don't know without being able to reproduce it myself. PAD has given me various frustrating issues so it isn't surprising.
@r0n1nrcr
@r0n1nrcr 2 ай бұрын
Man, this was great! Just so relatable; the whole trial-and-error process. Also, not just being satisfied with "Ok, it works..." and calling it a day, but trying to optimize and eliminate redundant UI components in the Selector Builder. I wasn't bored at all. Thank you!
@DaveTheRPAGuy
@DaveTheRPAGuy 2 ай бұрын
Thanks! I really appreciate the kind words.
@vendettasnares
@vendettasnares 2 ай бұрын
I love XPath for object targeting in Automation Anywhere because of how easy is to test it in browser.
@tyronebranch7154
@tyronebranch7154 3 ай бұрын
Thank you!
@BarkBark790
@BarkBark790 3 ай бұрын
PLS HELP: everytime i use the recorder, the window that im using responds to my clicks, so when power automate adds it and clicks again, that messes everything up. How do i make it so that this doesnt happen??
@DaveTheRPAGuy
@DaveTheRPAGuy 3 ай бұрын
What do you mean by adds it and clicks again? I would say the recorder feature is something to just move on from if you're having issues with it. I think it's fine to use, but I would still say you'll come out with a better automation if you design the click by click yourself and choose which actions to use.
@BarkBark790
@BarkBark790 3 ай бұрын
@@DaveTheRPAGuy um, that is what i tried first (just making the automations manually) but for some reason, when i use the move mouse, in some programes like roblox, it doesnt register, which means that when i click il be clicking in the exact same spot. this problem is with many automation apps, and the only one that i found that works is a location based autoclicker.
@DaveTheRPAGuy
@DaveTheRPAGuy 3 ай бұрын
@@BarkBark790 To move the cursor/mouse properly in stuff like video games especially that are 3D and change your perspective as the movement happens, you have to do a sort of relative mouse movement. When I tried this before, I found it couldn't really be done properly without custom C# to make it happen.
@JokerGaming-of8ms
@JokerGaming-of8ms 4 ай бұрын
the local database is not installed properly, and i couldnt install sql server also, every time i just get some errors. pls let me know wat else i can do.
@DaveTheRPAGuy
@DaveTheRPAGuy 4 ай бұрын
Did I show in the video what to try uninstalling from add/remove programs? I thought I showed uninstalling some version of SQL Server that gets installed.
@DanielNetSet
@DanielNetSet 4 ай бұрын
done the OCR thing the hard way in python using PyTesseract. never say impossible ;)
@satisfyvideos4392
@satisfyvideos4392 4 ай бұрын
bro you should go for night mode from the windows. Its actually reduce the glare.
@DaveTheRPAGuy
@DaveTheRPAGuy 4 ай бұрын
I have Black Out curtains on the windows, so basically no light gets into my office room from the Outside Light Mode World out there. =)
@Lucas-en3jw
@Lucas-en3jw 5 ай бұрын
Promo_SM
@DaveTheRPAGuy
@DaveTheRPAGuy 5 ай бұрын
Thanks for stopping by, bot!
@cinbar
@cinbar 5 ай бұрын
I love your videos! You are so funny :) But it's true that we need dark mode in BP. I hope we can have it someday.
@DaveTheRPAGuy
@DaveTheRPAGuy 5 ай бұрын
One day!
@Katleenfarine
@Katleenfarine 5 ай бұрын
51:20 It's great that you show us what type of error we can do... but, it would be great of there was a -> skip to the real method, haha, so we don't get mixed.
@DaveTheRPAGuy
@DaveTheRPAGuy 5 ай бұрын
Yeah, that's fair. I have always been conflicted about whether to show the full steps I took including being confused and messing up a few times. At the time, I was still experimenting with including practically everything. More recently, I've started doing more like you're suggesting. But in the end, if anyone learns anything from my videos, that's purely by accident. A happy accident for sure but I didn't make these like a tutorial. I just can't bring myself to properly do tutorials AND enjoy it haha.
@guilhermeferreira4375
@guilhermeferreira4375 5 ай бұрын
Can you bring a video of a project you've done in Blue Prism and discuss the architecture it was built on? And tips you learned. I love your videos and have been following you since the beginning. Greetings from Portugal 🇵🇹 Keep up the good work! I love it. Dark mode is a must!
@DaveTheRPAGuy
@DaveTheRPAGuy 5 ай бұрын
I'll have to put some thought into that. Projects I've done are all code saved in client environments, and I make it a policy never to show client environments or even say the name of the clients in my videos. So I'd have to more just discuss it theoretically without actual code on screen. I'll give it some thought though.
@artelisabeth
@artelisabeth 5 ай бұрын
I also love dark mode. But I do have to have light mode in case I want to take a screenshot for something. I definitely need both 😂😆
@DaveTheRPAGuy
@DaveTheRPAGuy 5 ай бұрын
Same!
@myounis
@myounis 5 ай бұрын
Thank you Dave for this amazing Tutorial , much appreciate your hard work 👌👌👌👌
@DaveTheRPAGuy
@DaveTheRPAGuy 5 ай бұрын
Thank you!
@ricardoluizmarcello
@ricardoluizmarcello 5 ай бұрын
Your video is perfect. I feel like it was done for me today! You’ve struggled exactly what I got stuck
@ABhi_rajya
@ABhi_rajya 5 ай бұрын
bro good one...its interesting ... m gonna start a faceless channel on the same lines...
@ABhi_rajya
@ABhi_rajya 5 ай бұрын
guess we need a automation to download object files in xml :) :)
@aaronlinton-chambers
@aaronlinton-chambers 6 ай бұрын
What language do you think supplements blue prism the best ?
@DaveTheRPAGuy
@DaveTheRPAGuy 6 ай бұрын
For sure C# and VB.NET because Blue Prism only supports those directly in code stages.
@aaronlinton-chambers
@aaronlinton-chambers 6 ай бұрын
I like was you break down the problem into segments.
@aaronlinton-chambers
@aaronlinton-chambers 6 ай бұрын
I do like code katas.
@DaveTheRPAGuy
@DaveTheRPAGuy 6 ай бұрын
Hmmm, I just looked into code katas. That sounds like good practice. Thanks for the suggestion.
@micahman33
@micahman33 6 ай бұрын
I'm apparently 2 years late here- but love this build - thanks much for sharing.... let me know if you want to try this again with Resilient Recorder and I can get you set up...it makes this build way easier and does so through the use of AI.
@DaveTheRPAGuy
@DaveTheRPAGuy 6 ай бұрын
No worries on being late. =) As far as trying this again with Resilient Recorder, I would say yes, but I just don't have any extra time right now for RPA stuff. I may come back around to do more rounds of RPA tool testing, and I'll remember to reach out to you in that case. Thanks!