Citizen Developer - Course: First Automation Using Microsoft Office

Help StudioX
1

Hello,

I successfully built and ran the process yesterday following the videos while working from home on my company’s VPN. Today, I opened the project and made a minor change as I incorrectly had the IF condition as "does equal’ instead of “not equal”. I made this change as I saw errors within one of the invoices. I then removed the invoices from the invoices folder. I Removed the PDFs from the PDF folder. I made sure I had the webpage “Part 2” opened with Microsoft Edge which is the extension I used initially. I Made sure my Outlook client was opened and the same 4 emails were in the same folder structure. I hit run in StudioX. The process would run for about 5 seconds, closing Studio X, and then reopening it. Stating the process was successful. No invoice attachments were placed in the correct folder. No PDFs were created. The bot did not go to the website to verify the discounts. Yet the email that needed to be created at the end was (1.3) with no attachment. I’ve made no changes to this entire process other than updating the condition. The only nuance I can think of is that I was on a VPN yesterday, and today I am in the office using a different IP address. I would attach the excel exported file for the process, but UiPath indicates new users cannot upload attachments…sigh… I verified it all matches the steps in the 4 videos. I am not sure why it will not run the entire process. Any help or suggestions would be appreciated. I am only at this point in the course and still very green (2 hours) into automation.

2

Hi @BWhite ,

use log message to identify whre actually the isssue is going wrong

Log Message (Before opening browser)
Open Browser (Edge, URL)
Log Message (Browser opened successfully)
Type Into (Search box, “Movie Name”)
Log Message (Search executed)
Click (Search button)
Log Message (Search button clicked)
Find Children (Movie names)
For Each UiElement (in children)
Get Attribute (Text)
Log Message (Movie name: currentMovieName)
Add Data Row (to DataTable)
Write Range (to Excel)
Log Message (Excel written successfully)

Regards
Sandy

3

Hello,

I unfortunately am not sure what you are specifically telling me to do. I am following along with the course and not writing actual code if that is what you are inferring here. Below is what I copied from the exported Excel workbook of the project. This project matches to a T step by step on what was asked and walked through mimicking the entire project.

1.1 Single Excel Process Scope (SequenceX)
Private = False
Variables
Notes(IWorkbookQuickHandle)
CustomerDiscount(String)
FileName(String)
Activities
1.6 Use Desktop Outlook App (OutlookApplicationCard)
Account =Removed for Privacy in this example
Account mismatch behavior = UseDefaultEmailAccount
Private = False
Body
1.7 Do (Sequence)
Private = False
Activities
1.200 For Each Email (ForEachEmailX)
In emails from = MyInbox.Folder(Inbox\Projects\UiPath)
Unread only = False
With attachments only = False
Include subfolders = False
Retrieve attachments = True
Limit emails to first = 100
Private = False
Body
1.201 Do (Sequence)
Private = False
Activities
1.202 Save Email Attachments (SaveMailAttachmentsX)
Save to folder = string.Format({0}\Invoices, System.IO.Directory.GetCurrentDirectory())
Email = CurrentMail
Exclude Inline Attachments = True
Overwrite existing = True
Private = False
1.22 Use Browser Edge: ACME System 1 - Dashboard (NApplicationCard)
Unified Application Target
Selector =
URL = ACME System 1 - Dashboard
Input mode = DebuggerApi
Window attach mode = ByInstance
Resize window = None
Private = False
Body
1.23 Do (Sequence)
Private = False
Activities
1.24 For Each File in Folder (ForEachFileX)
In folder = string.Format({0}\Invoices, System.IO.Directory.GetCurrentDirectory())
IncludeSubdirectories = False
Skip folders where access is denied = False
Order = NameAscFirst
Private = False
Body
1.25 Do (Sequence)
Private = False
Activities
1.26 Use Excel File (ExcelApplicationCard)
Workbook path = CurrentFile.FullName
Create if not exists = True
Save changes = True
Read-only = False
Keep excel file open = False
Resize window = None
Private = False
Body
1.27 Do (Sequence)
Private = False
Activities
1.164 Type Into ‘Insert the’ (NTypeInto)
Text = Invoice.Sheet(Invoice).Cell(E8)
Activate = True
Click before typing = Single
Empty field = SingleLine
Verify execution
Input mode = SameAsCard
Target
Visibility check = Interactive
Responsive websites = False
Window selector (Application instance) =
Anchor 1
Strict selector =
Fuzzy selector =
Targeting methods = FuzzySelector, CV
CV Control type = Text
CV Text = Insert the client code to generate the discount value according to the promotion.
IsLinkedToReadOnlyObjectRepository = False
Strict selector =
Fuzzy selector =
Targeting methods = FuzzySelector, CV
CV Control type = InputBox
Private = False
1.152 Click ‘BUTTON submitButton’ (NClick)
Key modifiers = None
Click type = Single
Mouse button = Left
Verify execution
Activate = True
Input mode = SameAsCard
Target
Click offset
Anchoring point = Center
Offset X = 1
Offset Y = -1
Visibility check = Interactive
Responsive websites = False
Window selector (Application instance) =
Anchor 1
Strict selector =
Fuzzy selector =
Targeting methods = FuzzySelector
CV Control type = None
IsLinkedToReadOnlyObjectRepository = False
Strict selector =
Fuzzy selector =
Targeting methods = FuzzySelector
CV Control type = None
Private = False
1.136 Get Text ‘Discount’ (NGetText)
Scraping method = Default
Text = CustomerDiscount
Target
Visibility check = Interactive
Responsive websites = False
Window selector (Application instance) =
Anchor 1
Strict selector =
Fuzzy selector =
Targeting methods = FuzzySelector, CV
CV Control type = Text
CV Text = Discount
IsLinkedToReadOnlyObjectRepository = False
Strict selector =
Fuzzy selector =
Targeting methods = FuzzySelector, CV
CV Control type = AnyWordGroup
Private = False
1.86 If (If)
Condition = CustomerDiscount <> string.Format(This client doesn’t benefit from any discount)
Private = False
Then
1.116 Then (Sequence)
Private = False
Activities
1.117 Write Cell (WriteCellX)
Where to write = Invoice.Sheet(Invoice).Cell(E18)
What to write = CustomerDiscount
Auto increment row = False
Private = False
Else
1.96 Else (Sequence)
Private = False
Activities
1.97 Write Cell (WriteCellX)
Where to write = Invoice.Sheet(Invoice).Cell(E18)
What to write = string.Format(0)
Auto increment row = False
Private = False
1.67 Write Cell (WriteCellX)
Where to write = Invoice.Sheet(Invoice).Cell(A31)
What to write = string.Format(Chris Chris@UiPath.com)
Auto increment row = False
Private = False
1.47 Text to Left/Right (TextToLeftRight)
Text to split = CurrentFile.Name
Separator = .
Extracted text before the separator = FileName
Case sensitive separator = True
Private = False
1.28 Save Excel File As PDF (SaveAsPdfX)
Workbook = Invoice
Destination pdf path = string.Format(PDFs{0}.pdf, FileName)
Save quality = StandardQuality
Replace existing = True
Private = False
4

Hi Brian, I’m a newbie to, but I have a guess as to what was causing your problem. Did you have the emails sent to you only on the first day? The For Each Email action where the bot finds the emails from which to download the attachments is set up to look for the correct sender and to look only for emails sent today. Request the emails be sent to your account again on the day you want to continue working on your automation and this should clear up your error. It’s probably successfully finished running in 5 seconds because no emails met it’s criteria. Best of luck!