-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathautomation template.xaml
230 lines (230 loc) · 16.7 KB
/
automation template.xaml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
<Activity mc:Ignorable="sap sap2010" x:Class="Main" VisualBasic.Settings="{x:Null}" sap2010:Annotation.AnnotationText="UPTF00000088eyI8SGVscExpbms+a19fQmFja2luZ0ZpZWxkIjpudWxsLCI8SW5pdGlhbFRvb2x0aXA+a19fQmFja2luZ0ZpZWxkIjpudWxsLCI8VmVyc2lvbj5rX19CYWNraW5nRmllbGQiOjF9" sap:VirtualizedContainerService.HintSize="850.4,1599.2" sap2010:WorkflowViewState.IdRef="ActivityBuilder_1" xmlns="http://schemas.microsoft.com/netfx/2009/xaml/activities" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:mit="clr-namespace:Microsoft.IdentityModel.Tokens;assembly=Microsoft.IdentityModel.Tokens" xmlns:sap="http://schemas.microsoft.com/netfx/2009/xaml/activities/presentation" xmlns:sap2010="http://schemas.microsoft.com/netfx/2010/xaml/activities/presentation" xmlns:scg="clr-namespace:System.Collections.Generic;assembly=System.Private.CoreLib" xmlns:sco="clr-namespace:System.Collections.ObjectModel;assembly=System.Private.CoreLib" xmlns:sd="clr-namespace:System.Data;assembly=System.Data.Common" xmlns:uga="clr-namespace:UiPath.GSuite.Activities;assembly=UiPath.GSuite.Activities" xmlns:ugage="clr-namespace:UiPath.GSuite.Activities.Gmail.Enums;assembly=UiPath.GSuite.Activities" xmlns:ugm="clr-namespace:UiPath.GSuite.Models;assembly=UiPath.GSuite" xmlns:ui="http://schemas.uipath.com/workflow/activities" xmlns:umab="clr-namespace:UiPath.Mail.Activities.Business;assembly=UiPath.Mail.Activities" xmlns:umabh="clr-namespace:UiPath.Mail.Activities.Business.HtmlEditor;assembly=UiPath.Mail.Activities" xmlns:usau="clr-namespace:UiPath.Shared.Activities.Utils;assembly=UiPath.GSuite.Activities" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml">
<TextExpression.NamespacesForImplementation>
<sco:Collection x:TypeArguments="x:String">
<x:String>System.Activities</x:String>
<x:String>System.Activities.Statements</x:String>
<x:String>System.Activities.Expressions</x:String>
<x:String>System.Activities.Validation</x:String>
<x:String>System.Activities.XamlIntegration</x:String>
<x:String>Microsoft.VisualBasic</x:String>
<x:String>Microsoft.VisualBasic.Activities</x:String>
<x:String>System</x:String>
<x:String>System.Collections</x:String>
<x:String>System.Collections.Generic</x:String>
<x:String>System.Collections.ObjectModel</x:String>
<x:String>System.Data</x:String>
<x:String>System.Diagnostics</x:String>
<x:String>System.Drawing</x:String>
<x:String>System.IO</x:String>
<x:String>System.Linq</x:String>
<x:String>System.Net.Mail</x:String>
<x:String>System.Xml</x:String>
<x:String>System.Xml.Linq</x:String>
<x:String>UiPath.Core</x:String>
<x:String>UiPath.Core.Activities</x:String>
<x:String>System.Windows.Markup</x:String>
<x:String>GlobalVariablesNamespace</x:String>
<x:String>GlobalConstantsNamespace</x:String>
<x:String>UiPath.Excel</x:String>
<x:String>System.ComponentModel</x:String>
<x:String>System.Runtime.Serialization</x:String>
<x:String>System.Xml.Serialization</x:String>
<x:String>UiPath.Excel.Activities.Business</x:String>
<x:String>UiPath.Shared.Activities</x:String>
<x:String>System.Reflection</x:String>
<x:String>UiPath.GSuite.Activities.Drive.Enums</x:String>
<x:String>UiPath.Shared.Activities.Utils</x:String>
<x:String>UiPath.GSuite.Drive.Models</x:String>
<x:String>UiPath.Platform.ResourceHandling</x:String>
<x:String>UiPath.GSuite.Activities.Sheets.Enums</x:String>
<x:String>UiPath.GSuite.Sheets.Enums</x:String>
<x:String>UiPath.GSuite.Sheets.Models</x:String>
<x:String>UiPath.GSuite.Activities</x:String>
<x:String>UiPath.Shared.Activities.ConnectionService.Contracts</x:String>
<x:String>UiPath.Shared.Activities.Business</x:String>
<x:String>UiPath.Excel.Model</x:String>
<x:String>System.Linq.Expressions</x:String>
<x:String>UiPath.Excel.Activities</x:String>
<x:String>Microsoft.IdentityModel.Tokens</x:String>
<x:String>UiPath.DataTableUtilities</x:String>
<x:String>UiPath.GSuite.Models</x:String>
<x:String>UiPath.Shared.Api.Google.Gmail.Models</x:String>
<x:String>UiPath.GSuite.Activities.Gmail.Enums</x:String>
<x:String>UiPath.GSuite.Activities.Gmail.Filters</x:String>
<x:String>UiPath.Mail</x:String>
<x:String>UiPath.Mail.Activities.Utils</x:String>
<x:String>UiPath.Mail.Activities.Business.HtmlEditor</x:String>
<x:String>UiPath.Mail.Activities.Business</x:String>
<x:String>UiPath.Mail.Activities</x:String>
</sco:Collection>
</TextExpression.NamespacesForImplementation>
<TextExpression.ReferencesForImplementation>
<sco:Collection x:TypeArguments="AssemblyReference">
<AssemblyReference>Microsoft.VisualBasic</AssemblyReference>
<AssemblyReference>mscorlib</AssemblyReference>
<AssemblyReference>PresentationCore</AssemblyReference>
<AssemblyReference>PresentationFramework</AssemblyReference>
<AssemblyReference>System</AssemblyReference>
<AssemblyReference>System.Activities</AssemblyReference>
<AssemblyReference>System.ComponentModel.TypeConverter</AssemblyReference>
<AssemblyReference>System.Core</AssemblyReference>
<AssemblyReference>System.Data</AssemblyReference>
<AssemblyReference>System.Data.Common</AssemblyReference>
<AssemblyReference>System.Data.DataSetExtensions</AssemblyReference>
<AssemblyReference>System.Drawing</AssemblyReference>
<AssemblyReference>System.Drawing.Common</AssemblyReference>
<AssemblyReference>System.Drawing.Primitives</AssemblyReference>
<AssemblyReference>System.Linq</AssemblyReference>
<AssemblyReference>System.Net.Mail</AssemblyReference>
<AssemblyReference>System.ObjectModel</AssemblyReference>
<AssemblyReference>System.Private.CoreLib</AssemblyReference>
<AssemblyReference>System.Xaml</AssemblyReference>
<AssemblyReference>System.Xml</AssemblyReference>
<AssemblyReference>System.Xml.Linq</AssemblyReference>
<AssemblyReference>UiPath.System.Activities</AssemblyReference>
<AssemblyReference>UiPath.UiAutomation.Activities</AssemblyReference>
<AssemblyReference>WindowsBase</AssemblyReference>
<AssemblyReference>UiPath.Studio.Constants</AssemblyReference>
<AssemblyReference>UiPath.Excel.Activities.Design</AssemblyReference>
<AssemblyReference>UiPath.Excel.Activities</AssemblyReference>
<AssemblyReference>UiPath.Excel</AssemblyReference>
<AssemblyReference>System.ComponentModel.EventBasedAsync</AssemblyReference>
<AssemblyReference>System.ComponentModel</AssemblyReference>
<AssemblyReference>System.ComponentModel.Primitives</AssemblyReference>
<AssemblyReference>System.Private.ServiceModel</AssemblyReference>
<AssemblyReference>System.Runtime.Serialization.Formatters</AssemblyReference>
<AssemblyReference>System.Private.DataContractSerialization</AssemblyReference>
<AssemblyReference>System.Runtime.Serialization.Primitives</AssemblyReference>
<AssemblyReference>System.Private.Xml</AssemblyReference>
<AssemblyReference>UiPath.Testing.Activities</AssemblyReference>
<AssemblyReference>UiPath.OCR.Activities</AssemblyReference>
<AssemblyReference>UiPath.Mail.Activities</AssemblyReference>
<AssemblyReference>UiPath.UIAutomationCore</AssemblyReference>
<AssemblyReference>System.Reflection.DispatchProxy</AssemblyReference>
<AssemblyReference>System.Reflection.TypeExtensions</AssemblyReference>
<AssemblyReference>System.Reflection.Metadata</AssemblyReference>
<AssemblyReference>System.Data.SqlClient</AssemblyReference>
<AssemblyReference>UiPath.GSuite.Activities</AssemblyReference>
<AssemblyReference>UiPath.GSuite</AssemblyReference>
<AssemblyReference>UiPath.Platform</AssemblyReference>
<AssemblyReference>UiPath.UIAutomationNext.Activities</AssemblyReference>
<AssemblyReference>NPOI</AssemblyReference>
<AssemblyReference>System.Memory.Data</AssemblyReference>
<AssemblyReference>System.Console</AssemblyReference>
<AssemblyReference>System.Configuration.ConfigurationManager</AssemblyReference>
<AssemblyReference>System.Security.Permissions</AssemblyReference>
<AssemblyReference>System.Memory</AssemblyReference>
<AssemblyReference>System.Private.Uri</AssemblyReference>
<AssemblyReference>System.Linq.Expressions</AssemblyReference>
<AssemblyReference>System.Linq.Async</AssemblyReference>
<AssemblyReference>System.Collections</AssemblyReference>
<AssemblyReference>System.Collections.NonGeneric</AssemblyReference>
<AssemblyReference>Microsoft.IdentityModel.Tokens</AssemblyReference>
<AssemblyReference>netstandard</AssemblyReference>
<AssemblyReference>UiPath.Mail</AssemblyReference>
<AssemblyReference>UiPath.Mail.Activities.Design</AssemblyReference>
</sco:Collection>
</TextExpression.ReferencesForImplementation>
<Sequence DisplayName="Main Sequence" sap:VirtualizedContainerService.HintSize="750.4,1534.4" sap2010:WorkflowViewState.IdRef="Sequence_1">
<Sequence.Variables>
<Variable x:TypeArguments="sd:DataTable" Name="DStudentData" />
<Variable x:TypeArguments="x:Object" Name="dname" />
<Variable x:TypeArguments="mit:DateTimeUtil" Name="time" />
<Variable x:TypeArguments="x:String" Name="dmail" />
</Sequence.Variables>
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
<ui:ReadRange DataTable="{x:Null}" AddHeaders="True" DisplayName="Read Range Workbook" sap:VirtualizedContainerService.HintSize="688,128" sap2010:WorkflowViewState.IdRef="ReadRange_1" Range="A1:C99" SheetName="Sheet1" WorkbookPath="D:\xyz\StudentData.xlsx" />
<Sequence sap:VirtualizedContainerService.HintSize="688,1317.6" sap2010:WorkflowViewState.IdRef="Sequence_6">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
<ui:ForEachRow ColumnNames="{x:Null}" CurrentIndex="{x:Null}" DataTable="[DStudentData]" DisplayName="For Each Row in Data Table" sap:VirtualizedContainerService.HintSize="625.6,1205.6" sap2010:WorkflowViewState.IdRef="ForEachRow_1">
<ui:ForEachRow.Body>
<ActivityAction x:TypeArguments="sd:DataRow">
<ActivityAction.Argument>
<DelegateInArgument x:TypeArguments="sd:DataRow" Name="CurrentRow" />
</ActivityAction.Argument>
<Sequence DisplayName="Body" sap:VirtualizedContainerService.HintSize="592,1016.8" sap2010:WorkflowViewState.IdRef="Sequence_5">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
<ui:MultipleAssign DisplayName="Multiple Assign" sap:VirtualizedContainerService.HintSize="529.6,188" sap2010:WorkflowViewState.IdRef="MultipleAssign_1">
<ui:MultipleAssign.AssignOperations>
<scg:List x:TypeArguments="ui:AssignOperation" Capacity="4">
<ui:AssignOperation sap:VirtualizedContainerService.HintSize="334.4,24.799999999999997" sap2010:WorkflowViewState.IdRef="AssignOperation_1">
<ui:AssignOperation.To>
<OutArgument x:TypeArguments="x:Object">[dname]</OutArgument>
</ui:AssignOperation.To>
<ui:AssignOperation.Value>
<InArgument x:TypeArguments="x:Object">[CurrentRow.Item("Name")]</InArgument>
</ui:AssignOperation.Value>
</ui:AssignOperation>
<ui:AssignOperation sap2010:WorkflowViewState.IdRef="AssignOperation_3">
<ui:AssignOperation.To>
<OutArgument x:TypeArguments="x:String">[dmail]</OutArgument>
</ui:AssignOperation.To>
<ui:AssignOperation.Value>
<InArgument x:TypeArguments="x:String">[CurrentRow.Item("mail_id").ToString]</InArgument>
</ui:AssignOperation.Value>
</ui:AssignOperation>
</scg:List>
</ui:MultipleAssign.AssignOperations>
</ui:MultipleAssign>
<uga:ForEachEmailConnections AllLabels="{x:Null}" ConnectionAccountName="{x:Null}" ConnectionId="{x:Null}" CurrentIndex="{x:Null}" Filter="{x:Null}" Length="{x:Null}" ManualEntryFolder="{x:Null}" AuthScopesInvalid="False" BrowserFolder="Inbox" BrowserFolderLabelId="INBOX" DisplayName="For Each Email" FolderInputSelectionMode="Browse" sap:VirtualizedContainerService.HintSize="529.6,742.4" sap2010:WorkflowViewState.IdRef="ForEachEmailConnections_1" ImportantOnly="False" IncludeSubfolders="False" MarkAsRead="False" MaxResults="100" StarredOnly="False" UnreadOnly="False" UseConnectionService="True" WithAttachmentsOnly="False">
<uga:ForEachEmailConnections.Body>
<ActivityAction x:TypeArguments="ugm:GmailMessage, x:Int32">
<ActivityAction.Argument1>
<DelegateInArgument x:TypeArguments="ugm:GmailMessage" Name="CurrentEmail" />
</ActivityAction.Argument1>
<ActivityAction.Argument2>
<DelegateInArgument x:TypeArguments="x:Int32" Name="CurrentEmailIndex" />
</ActivityAction.Argument2>
<Sequence DisplayName="Do" sap:VirtualizedContainerService.HintSize="496,507.2" sap2010:WorkflowViewState.IdRef="Sequence_7">
<sap:WorkflowViewStateService.ViewState>
<scg:Dictionary x:TypeArguments="x:String, x:Object">
<x:Boolean x:Key="IsExpanded">True</x:Boolean>
</scg:Dictionary>
</sap:WorkflowViewStateService.ViewState>
<umab:SendMailX Account="{x:Null}" Bcc="{x:Null}" Cc="{x:Null}" HtmlBodyFromText="{x:Null}" ReplyTo="{x:Null}" Body="here's your certificate {dname}" BodyType="Text" DisplayName="Send Email" sap:VirtualizedContainerService.HintSize="433.6,420.8" sap2010:WorkflowViewState.IdRef="SendMailX_1" Importance="Normal" MaxBodyDocumentSizeMB="2" Sensitivity="Normal" Subject="Sending certificates" To="[dmail]" UseDocumentAsBody="False">
<umab:SendMailX.Files>
<scg:List x:TypeArguments="InArgument(x:String)" Capacity="1">
<InArgument x:TypeArguments="x:String">D:\xyz\{dname}.pdf</InArgument>
</scg:List>
</umab:SendMailX.Files>
<umab:SendMailX.HtmlBodyFromFile>
<umabh:HtmlContentArgument FilePath="{x:Null}" HtmlBody="{x:Null}">
<umabh:HtmlContentArgument.RuntimeImages>
<scg:Dictionary x:TypeArguments="x:String, InArgument(x:String)" />
</umabh:HtmlContentArgument.RuntimeImages>
<umabh:HtmlContentArgument.ValueMappings>
<scg:List x:TypeArguments="umabh:HtmlValueMappingBase" Capacity="0" />
</umabh:HtmlContentArgument.ValueMappings>
</umabh:HtmlContentArgument>
</umab:SendMailX.HtmlBodyFromFile>
</umab:SendMailX>
</Sequence>
</ActivityAction>
</uga:ForEachEmailConnections.Body>
<uga:ForEachEmailConnections.FolderIdBackup>
<usau:BackupSlot x:TypeArguments="ugage:FolderInputMode" StoredValue="Browse">
<usau:BackupSlot.BackupValues>
<scg:Dictionary x:TypeArguments="ugage:FolderInputMode, scg:List(x:Object)" />
</usau:BackupSlot.BackupValues>
</usau:BackupSlot>
</uga:ForEachEmailConnections.FolderIdBackup>
</uga:ForEachEmailConnections>
</Sequence>
</ActivityAction>
</ui:ForEachRow.Body>
</ui:ForEachRow>
</Sequence>
</Sequence>
</Activity>