04-15-2023 9:44 PM - edited 04-18-2023 6:40 AM
This post is part of the SAP Build Community Challenge (April 2023)
We're mixing it up for this week’s challenge, moving to SAP Build Process Automation and automation bots – which are a bit tricky but really cool!
It feels great to set up your bot, step by step, add all the activities and commands and configurations, and then click a button to have your bot do all your work. I love watching my automation open Excel, read data, open Outlook, create and send emails, open a web app, interact with it ... and a million other tasks.
We will be using the RPA Challenge web site for the community challenge.
Essentially, you will have to do 3 things:
The trick is that the fields on the web page move each time you click Submit, so you have to know how to find the right fields on the page (hint: based on CSS class).
If you’re new to SAP Build Process Automation, you should do the following tutorials:
Together, they will give you the knowledge to do the challenge.
You must have an SAP BTP account with SAP Build Process Automation. Luckily, it is available for free on the trial version of SAP BTP, or you can use your own account with the free-tier service plan. Setup is described in the SAP Process Automation now available in your Trial Account blog post.
You will also have to install the desktop agent, which automatically installs the Chrome extension. This is described in Install SAP Intelligent RPA On-Premise Components tutorial.
Once you are set up, do the following:
Ideally, you should get a score of 100%, with a time of under 30 seconds. But even if you don't, show us what you were able to do.
It is a little challenging, especially for newbies to SAP Build Process Automation, but it is doable in a couple of hours, and worth it.
Good luck (and join this SAP Builders group! 😺
04-16-2023 7:19 AM
It was a new experience for me. Enjoyed it. Thanks.
I found it very difficult to move around the steps at the build space as I could not find any scroll bar. I had to take two screenshots by searching the step names.
Thanks again for the interesting challenge.
04-16-2023 7:22 AM
04-16-2023 7:41 AM
This was my first iRPA project. I went through few online videos last month and set up the environment. But could not manage any hands on. The tutorials you shared with this post have been very helpful.
The steps I followed: First built the excel upload part and tested it following the tutorial 1 you shared. Then created the web page automation set up going through the third tutorial. Initially I started with static data without any loop. Then converted it to a loop when the static part was successful for at least one set.
Challenges faced: It took me a while to understand the DOM elements and map those with variables. Your hint on the CSS helped here. Another problem I faced with mobile number. It is a numeric field in the excel. But the web page accepts string. I could not convert it to string using the toString() function in the 'edit expression' section. I changed the excel column to string and reuploaded the template. I'll explore this part further.
I totally enjoyed it. 🙂
04-16-2023 8:15 AM
Got that Phone Number issue sorted out. There are two ways: 1. Using custom script to convert a numeric value to string. 2. Changing the field type in the reference structure while uploading from excel. Second one should be the right approach.
04-16-2023 9:30 PM
04-16-2023 10:14 PM
Great. I'll give another try. Thanks Dan.
04-16-2023 10:31 AM - edited 04-16-2023 10:34 AM
Hi @dan_wroblewski ,
How could proceed to create the SAP BTP environment if I get a message like this:
The options selected has been "For Me (I'm developer on my own or testing SAP BTP for my company)" but I am not able to create an SAP BTP environment to test.
Is there a way to solve it and continue with this challenge?
04-16-2023 12:17 PM
Can you use the free trial?
04-28-2023 10:14 AM
I have done the setup using this free trial you shared and it worked. But now when helping a colleague doing the same steps, when we create the subscription it starts Processing and after some time the subscription fails. We retried several times and it keeps failing.
How can we solve this issue?
04-30-2023 1:53 AM
What does the error message say -- click on the red rectangle or click View Details.
Did you follow everything in this blog? https://blogs.sap.com/2022/09/09/sap-process-automation-now-available-in-your-trail-account/
04-16-2023 3:05 PM
I was able to complete this task. I am a first timer and the instructions and reference tutorials helped me complete this.Below are my screenshots:
Thank you for all the efforts on the challenge.
04-16-2023 9:25 PM
04-17-2023 1:55 AM - edited 04-17-2023 1:58 AM
Hi @dan_wroblewski ,
I've completed the challenge, with help of your instructions and the reference tutorials. Thank you for that.
Here is my output,
04-17-2023 7:30 AM
04-17-2023 6:47 AM
Hi @dan_wroblewski ,
I completed the challenge of this week. Tutorials were very helpful to complete.
This was the first application I build.
Looking forward to next week.
04-17-2023 7:44 AM
04-17-2023 9:36 AM - edited 04-17-2023 11:42 AM
Here is my third contribution.
I am no developer, so understanding how to uniquely identify each field in the form, took me some time. The CSS Class hint was very helpful.
04-17-2023 10:48 PM
04-18-2023 5:37 AM
04-18-2023 5:40 AM
04-18-2023 7:57 AM
Hello @dan_wroblewski ,
Very useful challenge, I've been working with automations recently but first time using the "Application" artifact to explore the Web. I like the potencial.
04-18-2023 8:02 AM
04-18-2023 7:59 AM
Mine took 1309 millisecs, I am running it on Virtual Server Windows Hyper-V 2019
And the Automation itself
The Desktop Agent does not run on my local laptop, have raised an incident for it. Some security policies does not allow browser extension to run executables(CxChromeBroker.exe) to run.
Currently implementing few use cases in Automation for a client, this challenge was fun.
04-18-2023 8:03 AM
Also I do not think we need 'class' identifier to identify a variable. The property "ng-reflect-name' should work
04-18-2023 8:17 AM
Thank you for the challenge!!
This is the result of my rpa challenge (3248 milliseconds):
This is my build area :
Thank you again!
04-18-2023 8:33 AM
04-18-2023 8:39 AM
thanks for another challenge. This one was propably the easiest for me 🙂
04-25-2023 5:43 AM
04-18-2023 2:27 PM
My submission for week 3.
I have created two automations: one for extracting data from Excel, and the other for posing the data to the RPA challenge site.
The difficult part for me was to capture the web page. At the beginning, web pages were not detected at all. Then thanks to the comment in the blog post, I restarted my PC and pages got detected.
Next, I proceeded with type "Recorder" in capturing the web page. However, exporting the recorded application to an automation took too long (it was not responding), so I switched to "Manual Capture" option. After all, this was the right decision because I needed to specify selectors for each element on the screen.
I liked the testing capability of applications. This helped me recognize errors at an early stage.
04-25-2023 5:40 AM
04-19-2023 1:57 AM
This is done with my colleague @Jarmel
Very Interesting Challenge. We were able to even simulate the testing on the application screen.
04-25-2023 5:38 AM
04-19-2023 12:32 PM
I've built a few automations before.
I decided to add an extra step where I capture the result message and log it before closing the web page.
One tip for the excel cloud link activity: You can set the range to only include the column letters and the last row will be detected automatically. For example, in this exercise I set my Range Definition to A:G
Kudos Sandip for the 1309ms execution!
04-25-2023 4:34 AM
04-20-2023 12:14 AM
04-20-2023 9:01 AM
Hi @dan_wroblewski, thank you for another great challenge!
Mine took 2957 millisecs 😊
And the Automation
04-20-2023 7:34 PM - edited 04-20-2023 7:43 PM
Hi @dan_wroblewski ,
Challenge done with some issues but manageables.
I was wondering how to send an email at the end of the process. It is not as simple as UIPath (please, take it as a constructive opinion).
You can see it in this URL: https://youtu.be/_YS3XclEkfc
Thanks again and I'm looking forward to next challenge!
04-21-2023 11:54 AM
Hi @JJAIMES, sending an email will be similar to the steps you used to connect with excel. You can send an email with the results by following these steps:
1. Add the Outlook SDK in the Project Properties (gear icon in the top right corner)
2. Add the Open Outlook Instance, Send Email (Outlook), and Close Outlook Instance activities to the process and set the parameters for the send email activity
04-25-2023 4:08 AM - edited 04-25-2023 4:09 AM
You can send an email using Outlook automation, as @Max_McP says above, or directly with SAP Build Process Automation, as explained in this blog: https://blogs.sap.com/2022/05/09/send-emails-from-automation-inside-sap-process-automation/
You'll have to set up a mail server, but you can use Gmail or whatever
Thanks for participating in the challenge 😺