Hello Dave and thanks for this tutorial! As a new comer in rpa, I followed your solution for this challenge but I 've got this error: Internal : Could not execute code stage because exception thrown by code stage: The collection does not contain a field with the name 'Last Name' Solution: The .xlsx file provided from RPAChallenge.com had a space character in the end ('Last Name ', not 'Last Name'), if you edit this in ms excel everything runs smoothly. Dave, keep it up with this type of videos, thanks again.
You're absolutely right! Hmm...it looks like I didn't include that info in this video. Not sure why I forgot that. If you look at any of the other RPAChallenge videos I have out, I explained that I manually changed the input file, including that I manually fixed the Last Name field, forcibly deleted the first empty column, and also selected and forcibly deleted all the empty rows below the dataset. It looks like you've already come across the solution, but I'll put this here for reference. This should take you to another video right to the spot where I explain the 3 manual changes I made to the input file. ruclips.net/video/nW73nd6Qf5A/видео.html I'll go ahead and pin your comment so others will see it as well. Thanks!
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?
bro i geting this kind of error Internal : Could not execute code stage because exception thrown by code stage: The collection does not contain a field with the name 'Last Name' what can i do
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"?
bro i get this error-Internal : Could not execute code stage because exception thrown by code stage: The collection does not contain a field with the name 'Last Name'
At the time, Blue Prism was getting a 0% success rate with using Write stages as if it wasn't triggering the page to accept the values. I've tested the same thing on Blue Prism since then, and it doesn't need Send Keys in this situation, though I find that Blue Prism commonly requires this depending on how the web app is designed. If you were going to automate RPA Challenge now with Blue Prism, Write stages should work well.
Apologies for the super late response. I have missed some comments and I don't know how I missed them. Is this a public website you could point me to where I could try this myself? As a quick thought though, I would imagine this happens when somehow Blue Prism lets you choose an action in a navigate stage when it is using an element in an app that cannot do the operation its trying. For example, if it's a text field, then it cannot select an item because it's not a dropdown input. But I'd have to see your example to be able to guess what's happening.
Edited: If you mean adding items to the queue, I think you may want to watch the other version of this video/automation. RPAChallenge.com in Blue Prism 6.10.1 (The Robust Version). In that video, I show using a Work Queue for the same automation. Here’s a link: ruclips.net/video/UayWYcvlYAw/видео.html Skip to about 58 minutes into the video.
I’ve found it necessary in some apps to set the clipboard and then paste the value into an input field instead of sending each individual letter. However, you’d still have to use Send Keys in order to paste the value using CTRL+V. So if you’re asking about whether I’d suggest using paste as opposed to sending each individual letter then I’d say the paste technique is likely the better and more reliable choice in a lot of situations especially when the app itself is slow and key presses sometimes get ignored if they’re sent fast.
@@bharathkumar705 I made 3 videos about this in Blue Prism. Here's one where I used XPath Expressions and CSS Selectors and it's entirely in Object Studio. ruclips.net/video/nW73nd6Qf5A/видео.html
@@bharathkumar705 And in case I misunderstood you, here's another video where I built a full Process for this. ruclips.net/video/UayWYcvlYAw/видео.html
Haha! Actually, I recorded that video a few weeks ago. I just haven't edited and uploaded it yet. When I made these initial versions of this automation, I wasn't even aware that Blue Prism could use XPath Expressions and CSS Selectors. That's something I learned afterward. So, I'll absolutely be uploading a video for that. I just wanted to check out some other RPA Tools first before I did that. Thanks for the suggestion. You're right on point!
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
Hello Dave and thanks for this tutorial!
As a new comer in rpa, I followed your solution for this challenge but I 've got this error:
Internal : Could not execute code stage because exception thrown by code stage: The collection does not contain a field with the name 'Last Name'
Solution:
The .xlsx file provided from RPAChallenge.com had a space character in the end ('Last Name ', not 'Last Name'), if you edit this in ms excel everything runs smoothly.
Dave, keep it up with this type of videos, thanks again.
You're absolutely right! Hmm...it looks like I didn't include that info in this video. Not sure why I forgot that. If you look at any of the other RPAChallenge videos I have out, I explained that I manually changed the input file, including that I manually fixed the Last Name field, forcibly deleted the first empty column, and also selected and forcibly deleted all the empty rows below the dataset. It looks like you've already come across the solution, but I'll put this here for reference. This should take you to another video right to the spot where I explain the 3 manual changes I made to the input file. ruclips.net/video/nW73nd6Qf5A/видео.html
I'll go ahead and pin your comment so others will see it as well. Thanks!
Great Job brother.... Thanks for this and we wait for next challenge. This is goooood
I love this. great walkthrough and magic of match index. Thanks for sharing this, have a nice night 😊
Thanks!
Hi Dave, global send keys is not inputting the values. Can you suggest some other way?
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?
bro i geting this kind of error Internal : Could not execute code stage because exception thrown by code stage: The collection does not contain a field with the name 'Last Name' what can i do
Sorry getting back to you late. You probably figured it out, but what action were you using?
Also Dave, why did you use " Data" instead of using normal Data database..?
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"?
bro i get this error-Internal : Could not execute code stage because exception thrown by code stage: The collection does not contain a field with the name 'Last Name'
what object action are you calling when that happens?
Dave…in your ‘input values” you used global send keys instead of a write stage. Is there a reason as to why?
At the time, Blue Prism was getting a 0% success rate with using Write stages as if it wasn't triggering the page to accept the values. I've tested the same thing on Blue Prism since then, and it doesn't need Send Keys in this situation, though I find that Blue Prism commonly requires this depending on how the web app is designed.
If you were going to automate RPA Challenge now with Blue Prism, Write stages should work well.
In Input navigation I was facing errors like * the chosen action in row 1 is not permitted to the corresponding element type *
Apologies for the super late response. I have missed some comments and I don't know how I missed them. Is this a public website you could point me to where I could try this myself?
As a quick thought though, I would imagine this happens when somehow Blue Prism lets you choose an action in a navigate stage when it is using an element in an app that cannot do the operation its trying. For example, if it's a text field, then it cannot select an item because it's not a dropdown input. But I'd have to see your example to be able to guess what's happening.
Hi Dave, In this if we want add data to queue , How can I do that?
Edited: If you mean adding items to the queue, I think you may want to watch the other version of this video/automation.
RPAChallenge.com in Blue Prism 6.10.1 (The Robust Version). In that video, I show using a Work Queue for the same automation. Here’s a link:
ruclips.net/video/UayWYcvlYAw/видео.html
Skip to about 58 minutes into the video.
Dave, what do you think about using copy/paste instead of send keys?
I’ve found it necessary in some apps to set the clipboard and then paste the value into an input field instead of sending each individual letter. However, you’d still have to use Send Keys in order to paste the value using CTRL+V. So if you’re asking about whether I’d suggest using paste as opposed to sending each individual letter then I’d say the paste technique is likely the better and more reliable choice in a lot of situations especially when the app itself is slow and key presses sometimes get ignored if they’re sent fast.
Hi dave there is another rpa challenge its about pdf file and excel can you help with that please
Where is it?
@@DaveTheRPAGuy
I put the link 2 times but it’s disappear
“rpachallengeocr.azurewebsites.net/
@@ahmadhamza6596 Thanks. Looks like this would require Decipher to do properly so hopefully I’ll get some time to test with that.
@@DaveTheRPAGuy thanks a lot dave 🙏
Hi Dev, it's really helpful to us, can you please make a videos on Multi BOT architecture and Mainframe Application
Process studio for this execution??
Yes?
@@DaveTheRPAGuy where can I refer it can u attach the link here for the same above process in object studio
@@bharathkumar705 I made 3 videos about this in Blue Prism. Here's one where I used XPath Expressions and CSS Selectors and it's entirely in Object Studio. ruclips.net/video/nW73nd6Qf5A/видео.html
@@bharathkumar705 And in case I misunderstood you, here's another video where I built a full Process for this. ruclips.net/video/UayWYcvlYAw/видео.html
please make a video by using css selector and xpath for same web site
Haha! Actually, I recorded that video a few weeks ago. I just haven't edited and uploaded it yet. When I made these initial versions of this automation, I wasn't even aware that Blue Prism could use XPath Expressions and CSS Selectors. That's something I learned afterward. So, I'll absolutely be uploading a video for that. I just wanted to check out some other RPA Tools first before I did that. Thanks for the suggestion. You're right on point!
Here's the video using css selectors and xpath expressions for RPA Challenge in Blue Prism: ruclips.net/video/nW73nd6Qf5A/видео.html
@@DaveTheRPAGuy thanks for your effort