Advent Challenge #4

Welcome to the 2020 Advent Challenge #4!

All users are welcome! :innocent: (You can still join. You don’t need to participate in previous challenges)

Earn Stars :star: to increase your chances to win a prize :gift:
More info here .

Santa needs your help again! :santa: After he left from Copenhagen :denmark: he visited a lot of kids in many cities and decided to make a little break in Rome :it: Here, he has a meeting with his good friend. He would like to show him the two places where he would like to spend his holidays after the Christmas season. But our dear Santa got a virus on his computer and the images are now encrypted and completely unreadable.

image

We need to help Santa to decode those images and get coordinates of these encrypted locations inside so that Santa will know the destination paths!

*Please include in your reply which challenge you are solving - “Beginner” or "Advanced"

Beginners Advent Challenge #4:

  • Task:

    • decode the file -> Image for Begginers
      • you can use any website or this library given by a helpful elf -> Library File (library will place image called “DecodedImage.jpg” on your desktop)
    • after you get the name of the place from the image, get coordinates of it using automation and extract them to the Output panel.
      • Coordinates can be grabbed from any site you want
  • Upload evidence (screenshot/s) that you successfully obtained the results using UiPath.

    • Suggestion:
      For image decoding -> show the used method and properties of encoded image file.
      For coordinates -> Share a screenshot of your ‘write line’ results for coordinates
    • Your XAML file as an evidence would be appreciated

Tasks don’t need to be made in single project. You can have one project for image decoding and another one for getting the coordinates based on string with encoded place.

Advanced Advent Challenge #4:

  • Task:

    • decode file -> Image for Advanced
      • use a native VB or C# method
    • read place name using OCR
    • use automation to go into Google Maps, search for a place you got with OCR and extract coordinates to console output
  • Upload evidence (screenshot/s) that you successfully obtained the results using UiPath.

    • Suggestion:
      For image decoding -> present some screens with code needed for decoding image
      For coordinates -> show the way how you grabbed coordinates from Google Maps
    • Your XAML file as an evidence would be appreciated

Everything needs to be made in one single project

Deadline:

Submissions must be posted in this thread and will be accepted until 2020-12-12T22:59:00Z

image

Bonus points will be awarded for Star Wars references, creative solutions and responses :smiley:

11 Likes

Santa is fed up with the constant harassments of Hackers. He knows the right person for this bounty…

Mando wishes for more micronized Beskar Iron for Christmas and Santa wants to get rid of hackers. Match made in heaven?

  1. Mando first loads up his armor because encoded strings fight back with vengeance like the Empire!. He first converts the text into Bytes and then to image file and saves it.

  2. Next Mando does what he does best; look for locations far and wide to travel. Here he employs a different approach rather than trying to find the needle in the haystack, he chooses to find if the dark planet which contains beskar! i.e., uses a country list to see if that exists in the OCR string. Success! He knows now where the location is.

  3. Google knows everything about Mando, so he does not care and he searches for the location in Google Maps anyways. Looks like the location Santa is heading to …

The main file LocationLocationLocation.xaml invokes three Wokflows.

“This is the way, Santa: 64.5944444,-28.1791174”

Here is my submission for Advanced Advent Challenge #4. Santa will need to have an edge UiPath extension for this to work.
AdvancedAdventChallenge 4.zip (833.0 KB)

14 Likes

Here’s a story of how Santa solved this challenge:

:santa:: Rome, what a lovely capital city! Such a historical place!

:man:t4:: Hello Santa, how are you? Enchanté!

:santa:: Hello there, my friend! Nice to meet you too!

:man:t4:: What are you upto Santa? I heard that you are doing cool things with your new UiPath robot friend?

:santa:: Oh, yes! He is my little helper! I’ll introduce you to him later. I’m here now to show you the places I’m about to visit after the holidays. Would you like to come along?

:man:t4:: Sure! That’d be a great start to 2021.

:computer:: Your file :file_folder: is encrypted :lock:, please decrypt before using :unlock:

:santa:: Hahaha, about time. Let me call my friend Skywalker to do this for me. His lightsaber should be able to break things in no time.

:zap:: Zoop! What? Nothing happened! Can you do this Obi?

:zap:: Zoop! Still nothing? We’re sorry Santa, this is hard for us, please call your robot friend to do this.

:santa:: Ha ha ha! Alright then folks. Hello robot!

:robot:: Hello again, Santa!

:santa:: I have these files…

:robot:: I’m on it. Let me take a look at the files and decide how to decode them.

:santa:: Take your time, just explain to me what you’re doing so I understand.

:robot:: Alright, I’m ready! Let’s go :rocket:

Advent Challenge #4, Beginner :

Workflow Screenshot:

Approach Used:
Initialize variables, decode the text file using the ImageDecoder activity (which is borrowed from one of Santa’s elves), open the image, get the city name through input box, open google, search the city name, read the coordinates, print it to the console.

Bot Run Screenshot:
advent-day4-bot-run-beginner

:santa:: Wow, that was quick!

:robot:: Of course! Now, file 2. Lets go :rocket:

Advent Challenge #4, Advanced :

Workflow Screenshot:

Approach Used:
Initialize variables, read the text file, pass it to the invoke code activity, generate image, read the image using OCR, get the country name, go to Google maps, search for the country, perform string manipulations, print the coordinates to the console.

Bot Run Screenshot:
advent-day4-bot-run-advanced

:robot:: I’m done, Santa! Here is the workflow file, if you need it: UiPath-Advent-Day4.zip (382.0 KB)

:santa:: You keep getting better day by day! Thanks, my friend!

:robot:: Anytime, Santa! See you soon!

:man:t4:: I’m out of words… I need a friend like this.

:robot:: That’s UiPath’s vision, a robot for every person!

:man:t4:: Oh yeah, I’m definitely getting one to help me at work.

:santa:: And that’s my Christmas gift to you! :gift:

:man:t4:: Awesome! Thanks, Santa!

:santa:: Let me book my tickets now.

:man:t4:: Okay, lets do that :airplane:

Happy Santa and his friend now book tickets to Honolulu :us: and Iceland :iceland:

:santa:: This was a perfect experience, wasn’t it?

:man:t4:: By the way Santa, which one your elves knows how to code? I almost forgot to ask that to your robot friend. Who gave him that custom package?

:santa:: He is the wisest of them all who says ‘Do or do not, there is no try!’

Guess who was behind all this? It’s Yoda! :star_struck:

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

Cheers,
Rahul

8 Likes

Beginner

Hey Santa :santa:, My name is Ninja Hattori :crossed_swords: and I’m a Ninja man.

Hey Hattori, could you please help me to decode those images and get me the coordinates of the encrypted locations to reach my destination paths?

I’m here to help you santa :santa:. I will decode those images with my Naruto Ninja tool (Library File).

Let me do this first santa then I will find the exact location name :smiling_face_with_three_hearts: :smiling_face_with_three_hearts: :stuck_out_tongue:

Santa: OMG :astonished: You’re sooo talented Hattori. I can’t believe this

images

Hahahahah. Yes I’m :wink: :wink:

images (1)

Ok, So I will first decode the file and here is my workflow one

Decode_Image_WF1

After finding the Location name I will use my power for fetching the coordinates with the help of my OCR Ninja Tool with the help of webpage. :heart_eyes: :heart_eyes: :heart_eyes: :heart_eyes:

So, here is my second workflow santa :santa:.

Decode_Image_WF2

and I will use the match method for fetching the exact coordinates with the help of regex.

Ohhh hattori I’m very Impressed by your talent :smiling_face_with_three_hearts: :smiling_face_with_three_hearts: :smiling_face_with_three_hearts:

Ohhh Thank you santa for appreciation and now close your eyes.

Ok, Hattori :blush: :blush:

Dingggg Dingggg Dinggggg
Output is ready.

Santa :santa: now you can open your eyes and here is the exact coordinates of your location.

images (2)

OOOOOOOO MMMMMMMMM GGGGGGGGGG… This is really awesommmmmeee :astonished: :astonished: :astonished: :astonished: wowwwwww Hattori. You’re ammazing :star_struck: :star_struck: :star_struck: :star_struck:

Thank you Hattori for helping me to get out from this problem… :smiling_face_with_three_hearts: :smiling_face_with_three_hearts: :heart_eyes: :heart_eyes: :heart_eyes: :heart_eyes:

Now, I can easily reach to my destination. :smiling_face_with_three_hearts: :smiling_face_with_three_hearts: :smiling_face_with_three_hearts:

5 Likes

Dear Santa,

I found coordinates of the places that you ask for.

Greetings from Turkey, I wish you come to visit us someday… :santa::christmas_tree::tr:

Beginners Challenge

Workflow

Output

beginner-output

AdventChallenge4.Beginner.zip (3.6 MB)

Advanced Challenge

Workflow

advancedworkflow-2

Output

advanced-output

AdventChallenge4.Advanced.zip (4.9 MB)

3 Likes

Yo-da all!!

Yoda found an old cipher machine to help Santa find his way after X-Mas.

Challenge#4 Advanced.Challenge#4.xaml (155.7 KB)

6 Likes

Hello Santa! Hope u had a great stay at Copenhagen :denmark: and Rome :it:.
as you are really tired, let me help you clear the virus on your Pc.
:santa: Can u give me your computer?
:elf: I will give you wait a sec…
:slightly_smiling_face: Here you go, Virus is detected and cleared :grin:

ok now lets find how to fix your encrypted images and find some location coordinates?

[Used read text file activity and Library file provided @Pablitoz to decode text file and founded image]

:santa: What about my coordinates ?? :santa?
[used Screen scraping technique to extract data from image and with the help of browser I have solved your coordinates issue too]

:elf::santa: Do u wanna have alook?

:slightly_smiling_face: take a look at this screenshots…:dancer:

:grin: May be you can keep this coordinates file with you…

:santa: and :elf: sure we can keep them safe …

:grin: Here you go , I will share zip file here.

AdventChallenge4.zip (817.0 KB)

:grin: @ :santa: Hope you will have a safe trip… Happy Christmas

Happy Automation & Cheers

3 Likes

Dear Santa,
I found the location for you !

<“Beginner challenge”>
Result

4thAdvent Challenge - beginner.zip (1.6 MB)

4 Likes

**Advance-Challenge #4 **

:deer: ** It’s the best time of the year, Filled with holiday cheer :deer:**
:santa: ** so true :deer ! This is the time to have :elf: in the house ,
streets filled with snow **
:deer: ** It is a pleasant month which showers cheers :smiley: on
anyone’s face **
:santa: ** Ho, Ho, Ho , Ho! **
:deer: ** Ok let’s finish our task by finding coordinates **
:santa: ** Lets rush!!!Ho!!Ho!!Ho!! **
** Find attachments Below **

[ decoded text file using c# and store image file in project folder]

[ Used maps to Scrape Data and by using extracted data find coordinates of it in a browser … output screen shot is a proof]

:deer: ** Wow Santa we found our coordinates so lets Start our Journey to
extracted place from these coordinates **

:santa: ** Sure lets Say grab some presents too… Happy Friday **

Advance_AdventChallenge_4.zip (824.8 KB)

Happy Automation & Cheers

4 Likes

Advanced - CSharp with Master Yoda Style Output

Single Sequence Project

Decrypt Image

Extract Place Info w/ OCR

Extract Location Info of Place From Google Maps

UiPath_Advent2020_Advanced_CSharp_rpavanguard_Yoda_Style.xaml (58.3 KB)

3 Likes

image

I felt a disurbance in Santa’s Force!

image

It was time for us to help him!

But the coordinates to find the location were unreadable, and R2D2 had only a part of the message to show us
image

So we gathered all our droids in order to help Santa decode his image
image

And with a small effort the image was recovered!
image

But now we’ll have to find the exact location, and the Galaxy is enormous!

image

This time is C3PO that uses a link he memorized to retrieve the coordinates: maps.google.com

image

image
image

and so the coordinates were retrieved and Santa could go on with his journey!
image

Finally everyone in the Galaxy is ready for Christmas!
image

AdvChallenge4.xaml (34.9 KB)

3 Likes

Katniss was very excited to help… Hence, she shouted!

Nacho Fast! Said Nacho Libre! Who said you can help Santa. Not without going through me first

What in the Star Wars Universe are you talking about. Both of you, please move away. We will handle this.

Hence, the story of the Beginner and Advanced Solutions for Santa’s problems

Beginner

image

That is right, Santa wants to go to Honolulu first

Thanks to the Santa’s friends who shared the image decoder package " You must unlearn what you have learned."

image image

Aftewhich, the bots got the coordinates via latlong.net then finally string manipulation

Advanced

I would like to thank first @StefanSchnell as i leveraged on his VB Code for this.

Upon reading the Image using the VB Code

R2D2 and the team opened identified that Santa would like to go to Iceland

image

I sense something off Santa…Seems you do not want to go back…


(Note: False Advertisement)

tsk tsk tsk… Santa, we know your style…

image

But Santa made a great excuse, he said he just wanted to visit his holiday village in Rovaniemi in Lapland

Going back to the topic…

R2D2 and the team opened googlemaps, searched for Iceland,


then used a Do while loop to ensure that the page has fully loaded.

image
Afterwards, the droids used Get attribute activity to get the URL which contains the coordinates.

With the help of string Manipulation, the droids were able to find the coordinates of Iceland.

Below are the .xaml files for both Beginner and Advanced Solutions

Advent Challenge4.zip (186.3 KB)

Advent Challenge Number 4:

4 Likes

Ho ho hoo…Mary Christmas

:evergreen_tree: :evergreen_tree: :evergreen_tree: :evergreen_tree: :evergreen_tree: :evergreen_tree: :evergreen_tree: :evergreen_tree: :evergreen_tree: :evergreen_tree: :evergreen_tree: :evergreen_tree: :evergreen_tree: :evergreen_tree: :evergreen_tree: :evergreen_tree: :evergreen_tree: :evergreen_tree: :evergreen_tree: :evergreen_tree: :evergreen_tree: :evergreen_tree: :evergreen_tree: :evergreen_tree: :evergreen_tree: :evergreen_tree:

If you wish to watch my Santa Story the

Episode #1 ==> :snowman_with_snow: Advent Challenge #1

Episode #2 ==>:Santa: Advent Challenge #2 (Everyone welcome to join the event!)

Episode #3 ==> Advent Challenge #3

:star_struck: :star_struck: :star_struck: :star_struck: :star_struck: :star_struck: :star_struck: :star_struck: :star_struck: :star_struck: :star_struck: :star_struck: :star_struck: :star_struck: :star_struck: :star_struck: :star_struck: :star_struck: :star_struck: :star_struck: :star_struck: :star_struck: :star_struck: :star_struck: :star_struck: :star_struck:

Welcome to my Santa Story Episode #4 (Beginners Challenge Inside)

:point_right: :point_right: :point_right: :point_right: :point_right: :point_right: :point_right: :point_right: :point_right: :point_right: :point_right: :point_right: :point_right: :point_right: :point_right: :point_right: :point_right: :point_right: :point_right: :point_right: :point_right: :point_right: :point_right: :point_right: :point_right: :point_right:

Now the game is begin……

I hope you remember on my Episode #1 ==> :snowman_with_snow: Advent Challenge #1 at that moment Santa got help to hack the Zeus Weather Control panel

Unfortunately, Zeus got to knew that Santa is the man who did that…
He was angry again… this time too much…

because still, Zeus believes that at least this year he will get a gift from Santa, but the santa is having many troubles during this year he is in late of gift delivery.

But Zeus won’t care about it, He did the worst thing to Santa that no one event didn’t think to do, how bad is the …isn’t he ? for one gift :crazy_face: :sweat_smile:

Zeus sent his magical lightning spell into the earth


… … … … … … … … … … … … … … … … … … … … …

So sad… this time Santa is in Rome :astonished: :scream: , I don’t need to explain to you that what is the relationship between Zeue and Rome
The magical bonds still live inside Rome with zeuse , it was activated in sudden and moved into the hotel that Santa staying

and the Zeuse’s ghost make virus on Santa’s laptop and the images are now encrypted and completely unreadable

Meanwhile Zeus
tumblr_5f51af6db0307b5fb83ed7c519ffded2_24243997_500

Hohoho you remember the Anonimus Hacker the friend of Santa in Episode #1

He came again help to Santa, he has done the decode of all data in Santa’s laptop finally/////


Challange 4 - Main.xaml (17.3 KB)

3 Likes

Beginner
Hello Santa ! :santa:
It is late but i found the place where you would like to spend your holidays after Christmas :slightly_smiling_face:
This place is Honolulu !
Beginner


image

1 Like

Hello Community,

Following an earlier post yesterday, we made a short video that demonstrates solution by @rpavanguard

Cheers! :+1: :slight_smile:

4 Likes

Beginners Advent Challenge #4

Santa sings the song Bohemian Rhapsody, parallel to Gonzo, while editing the Advent Challenge #4.

Is this the real life? Is this just fantasy?
Caught in a landside, no escape from reality
Open your eyes, look up to the skies and see
I’m just a poor Santa, I need more RPA
Because I’m easy come, easy go, little high, little low
Any way the wind blows doesn’t really matter to me

Santa sings more, not a real Christmas song. He decided to convert the image from Base64 to the image format as tiny Invoke Code activity.

image

He interrupts the workflow with an InputDialog and the input of the desired location name. Santa sings now louder.

In the next step Santa loads from simplemaps.com a database, with all locations around the world and their latitude and longitude.

Santa extracts the zip file and reads from the CSV file the geo location.

image

Santa and his elves sings now:
I see a little silhouetto of a man
Scaramouch, Scaramouch will you do the Fandango?
Thunderbolt and lightning, very, very frightening me
Galileo, Galileo, Galileo, Figaro, Magnifico

Santa gets the data he wants.

Main.xaml (9.7 KB)

The song is over and Santa feels good, any way the wind blows.

Advanced Advent Challenge #4

Santa thinks that Star Wars is very popular, but he likes Spaceballs more - especially Dark Helmet.

But before he watch this movie it is necessary to solve this challenge. Santa uses his approach from the beginner section to convert the image from Base64 to an image. So far so well. Santa decides to use Tesseract OCR.

image

He loads the image and uses the OCR. But the result isn’t very good, so it is necessary to use Regex to detect the correct text.

The OCR is not very fast, Santa dreams of Princess Vespa in the meantime.

He opens the browser with Google Maps and puts the second hit in the search box. Iceland is not unique, but Island is.

image

To be sure that the target location is full in the browser window Santa adds three times to push the zoom in button.

Last but not least he reads from the browsers address bar the geo location. To realize this Santa uses Regex too.

Santa writes the geo location data to the output window.

image

Santa asks himself, if Dot Matrix is also equipped with a geo location system.

May the RPA force be with you.

Main.xaml (21.1 KB)

1 Like