Formatting Screen Scraping

[rridlen]

CE 2019.5.0 - No programming/developer background outside of UiPath.

Task: Automate data entry to an application from a notification email. The email can contain a variable number of orders that need to be grabbed.

First problem: Trying to build a quick proof of concept for an email with only 1 item (no idea how to handle more than 1 item - problem 2). I was following the below thread until I hit the Data Scraping piece. The data scrapping wizard returns an error: Automation server can’t create object.

Extract data out of body of a mail

Yes, you get it by filter based on the subject. However the issue you have here is due to variable type. This assign will give a result = whether the current mail is having the subject that you want. This should be a Boolean (true/false) based on which you can proceed of move to next mail. Your left hand variable is related to the subject it self im guessing. Let me know you have understood what you need to do.

Get Text returns what I’m look for, but the selectors make it seem like it’s not repeatable, especially if the email has multiple orders - ie url name of file & an aaname that’s the dynamic value I’m looking to grab.

Screen Scraping will get all the text I need, but I can’t figure out how to fix the format. Every video I’ve watched magically has data that scrapes as desired. None of the [space][tab][new line] combinations give me the correct header & data pairings, so I expect I somehow need to split/parse the info.

Example of Get Full Text copied to clipboard:

ISCI/AdIdTitleLengthFlight DatesDestination(s)Format
HTR4597TEG60000Y Xyz - May Product 1 Bad Axe:305/24/2019 - 5/30/2019WIKW Video Format: HD
Audio Format: Stereo
Closed Caption: No
Encoding: None

Desired Output - Table

Length of the elements are not static and will vary form order to order.

Problem 2 - Need to be able to handle emails with multiple entries & variable lengths of each element. The selector for the table seems to be consistent so might just be in my head.

Any help is greatly appreciated.

[rridlen]

Saving as .html instead of .mht allows the Data Scraping wizard to work. Row 1 is shifted right 1 cell which was fixed using the Delete Range activity.

The only issue is the length gets dropped.