Earn Stars to increase your chances to win a prize More info here
All users are welcome! (You can still join at any point, even if you haven’t completed any of the previous challenges)
After the travel, Santa had a nice stay in Copenhagen. In fact, he enjoyed it so much that he overslept today and while he was rushing to check out of the hotel, he forgot his book with all our wishes!
Thankfully, he is used to travelling through clouds where he is also always backing up his long lists.
He now needs help fetching them from different clouds. The wishes are all password protected, but he will be able to access them just fine and simply needs the files to be retrieved (Santa can easily access locked spaces, but he wouldn’t want to risk breaking the GDPR rules by exposing people’s wishes).
Santa would really like some help collecting all his files! Could you help him?
*Please include in your reply which challenge you are solving - “Beginner” or “Advanced”
Beginners Advent Challenge #3
Santa has found this handy list of backed up files on his mobile: gifts_beginner.xlsx (8.8 KB)
To Complete the Beginner’s challenge for Santa:
Download all files from the list
Send the files to Santa’s email address: uipath+santa_files@discoursemail.com (please include either beginner/advanced in the title, as well as your Forum username)
Upload evidence (i.e. screenshot/s) that you successfully obtained the results using UiPath.
Suggestion: Share some screenshots of your workflow
Or Upload your XAML in your reply
Advanced Advent Challenge #3
Santa has found this handy list of backed up files on his mobile: gifts_advanced.xlsx (8.9 KB)
To Complete the Advanced challenge for Santa:
Download all files from the list
Combine all files into one archive
Send the resulting file to Santa’s email address: uipath+santa_files@discoursemail.com (please include either beginner/advanced in the title, as well as your Forum username)
Upload evidence (i.e. screenshot/s) that you successfully obtained the results using UiPath.
Suggestion: Share some screenshots of your workflow
Or Upload your XAML in your reply
Deadline:
Submissions must be posted in this thread and will be accepted until 2020-12-09T22:59:00Z
Bonus points will be awarded for pop culture references, creative solutions and responses
Santa is a poor man, he has no Excel available so he has to import the data as CSV file. Santa also has Christmas wishes, an office suite.
With a tiny VB routine in a loop Santa downloads all the files from the list. Then the downloaded zip file are added to the MailMessage attachments of the Send SMTP Mail Message activity.
Dim WebClnt As WebClient = New WebClient
Dim Target As String
Dim TargetArr() As String
Try
TargetArr = Source.Split("/".ToCharArray())
Target = TargetArr(TargetArr.Length - 1)
WebClnt.DownloadFile(Source & "?dl=1", Target)
Catch ex As Exception
Console.WriteLine(ex.Message)
End Try
Dim Attach As Attachment = New Attachment(Target)
MailMessage.Attachments.Add(Attach)
And last but not least everything is sent via SMTP. Yes, not via Outlook, Santa does not have this office application either. This has the disadvantage that the attachment does not contain the individual zip files, it contains only one EML file which contains the zip files.
Santa is happy again. With a cheat sheet to @Anna_Maziarz solution and the hints of @SamiKiran it was possible to pass this challenge correctly. Many thanks to both
Beginner
Hello Santa !
This time I asked minions to help me solve your problem. They turned out to be very hardowrking and helpful. See how they dealt with it.
The minions didn’t wait a minute and went straight to work. First they started with a break
Okey, now the Minions can get to work. They downloaded all files from the gifts_beginner file by using HTTP Request activity and adding “?dl=1” at the end of the each url address.
Hello Kiran,
thanks for your reply. Interesting, I don’t know that SMTP doesn’t supports binary file attachments. I tried it with another email address and here it works, so I assume it works in any case.
@StefanSchnell thnx… how u use code to download… i see web client but its not downloading the complete file… can u pls share it with me? i am not going to submit my response… i am just started with uipath so i dont know much…
@StefanSchnell sir, i tried writing vb code sir but the issue is that before the current file download is finish, it download next file so full file size is not download… i google and it says use async… am dont know that so asking for code to learn…
am dnt know how to do this… but am learn sir… surely one day am master this…sorry for my english… am improve that too…
It looks like Gmail is protecting you from harm here:
(although the files are just password protected zips of text files…)
If you won’t be able to make it work, simply send them over via Forum private message to me @loginerror (can be manually, just make sure to describe how you retrieved them in this topic first and link your reply in that PM you send me )
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:
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:
to increase your chances to win a prize 
More info here
(You can still join at any point, even if you haven’t completed any of the previous challenges)
)
Akash_Javalekar1
Levent_Kurt
Ejaz_Ab
jamuna_T
jast1631
rashmisingh2695
devasaiprasad_K
promiseakwaowo.uk
pookie