Advent Challenge #3

[avanmeurs (Aram van Meurs)]

@loginerror

uipath+santa_files@discoursemail.com

To stay in touch with the jolly Christmas spirit, Santa decided to model his flow in an alliterating fashion. The flow consists of three core components:

1. Bring_Back_Beardy_Backups.xaml

2. Combine_Christmas_Components.xaml

3. Merry_Mailer.xaml

Bring_Back_Beardy_Backups.xaml loops through gifts_advanced.xlsx and navigates to each of Santa’s sources. To prevent the need for using different selectors, Santa programmed his ‘Click Download button’ activity as a try-catch:

First, Santa’s robot helper will try to click on a selector that contains ‘download’ within the ‘aria-label’ attribute:
If that doesn’t work, the robot tries using a different selector:
This way, the robot will be able to find the download button on all of the source websites.

After downloading each beardy backup, the robot proceeds to Combine_Christmas_Components:

Here, each ‘Christmas component’ is extracted into a combined archive.

Finally, Santa’s robot helper emails the Combined Christmas Components within the “Merry_Mailer” workflow:

[prasath17 (Guru)]

Beginners Advent Challenge #3

Santa is trying to download the files from the cloud by sitting closer to the Clouds…LoL

We are getting Sonny’s help to finish the job and Sonny did his job much quicker than expected !!! and Handed the output…

and workflow looks like this…

Santa receive the below email with the attachment contains the backup files.

Santa is back to the cloud…

XAML : Main.xaml (31.1 KB)

[SamiKiran (Kiran Sami)]

u use outlook???

[prasath17 (Guru)]

@SamiKiran - I have configured my gmail account in my outlook…

[monsieurrahul (Rahul Prabhu)]

Meanwhile in Copenhagen, Denmark

: Ah, that was a great nap! I feel… wait a minute, I left my wish book in the cloud! What am I gonna do?

: Fret not, Santa! I’m here to help you!

: Can you retrieve my files from the cloud? I thought you could only do regex.

: Haha, I can do wonders! Give me the list of your file names.

: Here you go (Santa hands over the list).

: Okay Santa, you can relax now! I’ll take care of this. I’ll let you know once I’m done.

: Cool but, can I see you in action?

: Very well, in that case, let me tell you how I solve the first problem.

Advent Challenge #3, Beginner:

Workflow Screenshot:

Approach Used:
UI automation, since all the files are going to be downloaded from the same website + Santa wanted to see it in action

Email Screenshot:

Bot Run Screenshot:

: 1 new message for Santa

: This is awesome, UiPath robot! Can you please do the same for the second problem as well but, I’m afraid I’ve scattered these files. It’s because of these reindeers.

: Thanks, Santa! Of course but, this time I’m going to follow a different approach since the files are scattered across different clouds.

Advent Challenge #3, Advanced:

Workflow Screenshot:

Approach Used:
Check the book address cloud name and use an if condition to determine the endpoint and pass it to the HTTP Request activity.

The downloaded files are stored in a folder named “AdvancedFiles” and after the for loop, this folder is zipped and emailed.

Email Screenshot:

Bot Run Screenshot:

: 1 new message for Santa

: Oh my goodness! Thank you very much, UiPath robot! You really saved Christmas!

: It’s my pleasure, Santa! Let me know if you need anything else.

: Nothing as of now. Let me go and get the gifts ready…

: Done! Thanks to my friend UiPath robot, I’m going to take another nap now

: Haha, sleep tight Santa! I’m always by people’s side, helping them reboot work. I can’t wait to see what’s next!

Thanks for this @Vibhor.Shrivastava, @loginerror, @Steven_McKeering, @AndersJensen, and others. Appreciate your efforts!

Cheers,
Rahul

[monsieurrahul (Rahul Prabhu)]

Also, appreciate your swift response @StefanSchnell

Love what the you’ve made the minions accomplish @Anna_Maziarz

There’s nothing Indy can do! Creative one, @stefano_negro

[abu.behlim (Abu Hurera Behlim)]

Advent Challenge #3 (Advance)

Hello Santa,

My name is Doremon and I heard that you need someone’s help who can fetch all your long travelling list from different cloud.

So, Don’t worry santa. I’m here to help you with my new Gadget and his name is Robomon

Robomon will first fetch all the cloud address from where he will download the all the travelling list files in ZIP.

Santa here is my workflow and with the help of this workflow I will send you all the files in combine zip format. yuppieeee… yeeee
First one

Second one

OK, doremon. Please do fast because I’m in hurry.

So, Now my Robomo will use the HTTP request activity to download the file at one place.

Doremon this is really awesome technique.

Let’s combine all the zip file into one archive file

And here is the file archive snapshot.

Santa be ready for the final moment where my ROBOMON will send you the all the files over the mail on your email ID .

1…2…3 Dear Santa could you please check your mail inbox My ROBOMON has sent you the email

Santa :Ok, Let me check.

Ohhh Yesss I got your email and your ROBOMON is really very talented MR.Doremon

And here is the Email Screenshot for the reference.

Thank you Doremon for helping me to fetching my travelling list file.
Will meet you soon… Byeeee

Now, I will go happily.

[prasath17 (Guru)]

Advanced Advent Challenge #3

Continuing from my Beginner workflow, I took the Regex path again( ) to find my matches and then use that in my Switch activity.

And the final email to Santa

XAML: Advent3_Advanced_prasath17.xaml (74.9 KB)

[emre.balci]

Dear Santa,
Don’t worry about the gift lists. I have a friend who can help you about fetch your files from cloud.

*When I told the situation to my friend he accepted the mission. *

Friend stork flied to the cloud that has the file of Santa Claus.

He fetched the files with using user interface.

Sent the files in “gifts_beginner.xlsx” successfully.

*But there was a second list of Santa Claus *

This time he tried “HTTP Request" to fetching files. It was more efficient way rather than using user interface.

After all the files fetched from clouds and sent to Santa Claus successfully.

Workflows

Beginners Challenge

Firstly, read “gifts_beginner.xlsx” to use the data.

Then, download files from the cloud with using its user interface.

Finally, the downloaded files sent to Santa Claus.

AdventChallenge3.Beginner.zip (51.7 KB)

Advanced Challenge

Firstly, read “gifts_advanced.xlsx” to use the data.

Then, sent http request for each cloud platform.

Finally, zipped all downloaded files and sent to Santa Claus.

AdventChallenge3.Advanced.zip (42.7 KB)

[Markus_Anding]

Hey Santa,
I finally found and reassembled your lost wishlists and posted them to your Northpole address. This was challenging, but fun.

Kudos to @AndersJensen and others for doing great how-to-videos.
P.s. Got problems with gmail not accepting the zipped file. Didnt like zipped zip-files with passwords…Challenge3_LostGifts_MarkusAnding_Advanced.zip (23.0 KB)

[Veena_Siva]

Beginner

Santa is calling Po to help him

My yummy food or help Santa !!!

Well UIAutomation is much more quick and reliable now, Let me do it right now
Check the different selectors available with modern UI Automation

Voila Files have been downloaded and sent to you email

Now back to my dumplings

Note
XAML attached.
Copy beginner xls file to project folder
Edge is the browser used and make sure to browser setting so that it always asks what to do with each download
SMTP mail message is used, and use your account for sending emails
Main.xaml (30.7 KB)
Cheers

[Markus_Anding]

Smart idea @Anna_Maziarz to go round different sources.
How did you find out the different syntaxes to direct download instead of do UI-clicking?
//Markus

[jeevith (Jeevith Hegde, Ph.D.)]

Thank you to all participants. I have been reading your solutions and each one of you have a unique solution. To me this is an amazing way of improving our knowledge within UiPath and RPA in general. Cheers to you all.

---------------------------------------------------------------------------------------

Here comes my submission for Advanced Advent Challenge #3

Looks like Santa has lost it, I mean his contacts!

After looking at the like wonderful solutions with Https requests from other community members, I must say Santa will be very impressed!

So after almost three days I realized… I will give some love to the new Ui Automation (@loginerror) !

1. The FileDownloader.xaml uses UI automation to download zip files depending on the incoming URL.
   

   

2. The MailThemContacts.xaml does the hard work of looking for files, unzipping and zipping them and sending it to Santa via an email.
   

   

3. I do hope santa has recieved it.
   

   

Attached is the solution files with annotations as usual: Advanced Advent Challenge 3.zip (7.4 MB)

[Anna_Maziarz (Anna Maziarz - Office Samurai)]

Thank you @Markus_Anding
I spent some time to find out the syntaxes.

For Dropbox I found solution on their forum.

For Google drive I noticed that after clicking the download button the url changed for a while, so I copied the generated link and tried use it in new window and this link worked.

For Sharepoint I did not find any documentation how download a file directly from the link, so I just tried a few options like ?dl=1, /download etc. and ?download=1 worked.

For Box I followed page requests on the website after clicking the download button and I observed that page send request using this endpoint.

As you can see every source is different and there is not one documentation where we could find the answer, unfortunately. I analyzed each case separately through trial and error.

[sarikayaebru (Ebru)]

Hey Santa,

Forgetting the your book? At the hotel??

You’re lucky because World’s Best Boss is here to help you

Beginner Advent Challenge

So, I used UI automation because I love traditional solutions for beginner…

And sent you the result mail:

Please check my workflow:
AdventChallenge_3_Beginner.zip (2.6 MB)

WHAT? Do you also want the advance solution?

Fine… Here you go!

Advanced Advent Challenge

As an advanced solution this time I’ve used http call with different endpoints according to the platform. Downloaded and unzipped all the files.

And then compressed all the files together in one folder.

Finally sent you another mail with the final main zip:

My advanced workflow:
AdventChallenge_3_Advanced.zip (7.5 MB)

By the way, I’ve sent you a mail without any attachment. Sorry about that, please ignore it.

All this work made me tired. I’ll be sleeping until you need me again.

Bye!

[seanrockvz13 (Sean Jerome Llanto)]

@loginerror

uipath+santa_files@discoursemail.com

Is it really that you just overslept there in Copenhagen? i doubt that Santa. Maybe you were drunk. hahaha but that is fine Santa.

And yes, im very sure Santa will have a nice stay at Copenhagen. Who wouldn’t?

Kidding aside, I know what you really did there. I have friends also who have eyes you know

First, they saw you in Tivoli Gardens

Then, they said you were hanging out with your good friend Chuck at the little mermaid statue

One thing is for sure, I’m sure you missed Rudolph, Dancer and Prancer because you cannot ride them there. So, you rode a bike with the Santa Ladies and Other Santa Men. thinking that we cannot identify who you really are within the group.

Tsk tsk tsk tsk… What would Mrs. Claus thinkv

But anyway, dont worry, you can show here this picture instead so that you have an alibi that you were just helping the elderly in CPG.

We appreciate that Santa.

Most probably that is why you were not forgot the list…Wink Wink Wink I totally understand.
WE ALL totally understand Wink Wink Wink

Such a kindhearted man you are… you deserver our help.

Hence, this is the email for both beginner and advanced for you.

BEGINNER

ADVANCED

Now you see Santa, i know the technology is quite fast. So i decided to use the best of both worlds solution for you. Hence, the solution is both using UiAutomation and some activities using direct UiPath activities such as Send Outlook Mail Messages and such.

I also used Navigate to instead of using HTTPS as it will be able to do the same for some of the downloading as long as we provide the proper endpoint.

Its 4am here in Singapore that is why im not able to create a very lengthy post for you. But rest assured! Ill be there the next time you raise a request.

Im sending you the workflow files for both beginner and advanced

UiPath Advent Challenge3.zip (9.4 MB)

Also, i would like you thank @Anna_Maziarz for sharing the tips and tricks to download directly.

[Maneesha_de_silva]

Ho ho hoo…Mary Christmas

If you wish to watch my Santa Story the
Episode #1 ==> Advent Challenge #1
Episode #2 ==>:Santa: Advent Challenge #2 (Everyone welcome to join the event!) - #36 by Maneesha_de_silva

Welcome to my Santa Story Episode #3 (Beginners/Advance Advent Challenge Inside)

Santa Suddenly remembered that he already have Uipath Orchestrator in his mobile

And Thanks to Cloud he already made Job process to Send Beginners and Advance file to mail with 2 different jobs

Ho ho… Santa is Smarter

When Santa Execute job Let me show you how the file has been downloading and zipping automatically in **jingle bell’s Server **

But …

don’t tell to her please…

Beginners Advent Challenge #3

Challange 3 Beginners Main.xaml (12.8 KB)

Advanced Advent Challenge #3

Challange 3 Advanced Main.xaml (12.1 KB)

[prashanthig]

@SamiKiran Did u figure out what is blocking to send smtp mail message? I am curious as I’m facing same trouble while sending mail with .zip attachments . It’s working fine with other attachments like xlsx/text files but couldn’t identify issue .zip attachments

RemoteException wrapping MailKit.Net.Smtp.SmtpCommandException: 5.7.0 This message was blocked because its content presents a potential
5.7.0 security issue. Please visit
5.7.0 File types blocked in Gmail - Gmail Help to review our
5.7.0 message content and attachment content guidelines. h1sm2108879qtr.1 - gsmtp
at UiPath.Mail.Activities.SendMailActivity.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)
at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

[prasath17 (Guru)]

@prashanthig - If you scroll up @loginerror has already posted a messge on this…Culprit is gmail …

So for the advance challenge… i have used an email ID provided by my Internet service provider…and it worked…

[prashanthig]

Thank you for quick response. will check editing with other id. Hope it works for me too.

happy Automation & Cheers