Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <Activity mc:Ignorable="sap sap2010 sads" x:Class="Main" mva:VisualBasic.Settings="{x:Null}" sap2010:WorkflowViewState.IdRef="Main_1"
- xmlns="http://schemas.microsoft.com/netfx/2009/xaml/activities"
- xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
- xmlns:mva="clr-namespace:Microsoft.VisualBasic.Activities;assembly=System.Activities"
- xmlns:sads="http://schemas.microsoft.com/netfx/2010/xaml/activities/debugger"
- 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=mscorlib"
- xmlns:sco="clr-namespace:System.Collections.ObjectModel;assembly=mscorlib"
- xmlns:sd="clr-namespace:System.Data;assembly=System.Data"
- xmlns:ui="http://schemas.uipath.com/workflow/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.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>System.Xml.Serialization</x:String>
- </sco:Collection>
- </TextExpression.NamespacesForImplementation>
- <TextExpression.ReferencesForImplementation>
- <sco:Collection x:TypeArguments="AssemblyReference">
- <AssemblyReference>System.Activities</AssemblyReference>
- <AssemblyReference>Microsoft.VisualBasic</AssemblyReference>
- <AssemblyReference>mscorlib</AssemblyReference>
- <AssemblyReference>System.Data</AssemblyReference>
- <AssemblyReference>System</AssemblyReference>
- <AssemblyReference>System.Drawing</AssemblyReference>
- <AssemblyReference>System.Core</AssemblyReference>
- <AssemblyReference>System.Xml</AssemblyReference>
- <AssemblyReference>System.Xml.Linq</AssemblyReference>
- <AssemblyReference>WindowsBase</AssemblyReference>
- <AssemblyReference>System.Xaml</AssemblyReference>
- <AssemblyReference>PresentationFramework</AssemblyReference>
- <AssemblyReference>PresentationCore</AssemblyReference>
- <AssemblyReference>UiPath.UiAutomation.Activities</AssemblyReference>
- <AssemblyReference>UiPath.System.Activities</AssemblyReference>
- <AssemblyReference>UiPath.Studio.Plugin.Workflow</AssemblyReference>
- <AssemblyReference>System.ServiceModel</AssemblyReference>
- <AssemblyReference>UiPath.Excel</AssemblyReference>
- <AssemblyReference>UiPath.Mail</AssemblyReference>
- <AssemblyReference>System.Data.DataSetExtensions</AssemblyReference>
- <AssemblyReference>System.ValueTuple</AssemblyReference>
- </sco:Collection>
- </TextExpression.ReferencesForImplementation>
- <Sequence sap2010:WorkflowViewState.IdRef="Sequence_2">
- <Sequence.Variables>
- <Variable x:TypeArguments="ui:GenericValue" Name="searchTerm" />
- <Variable x:TypeArguments="x:Int32" Default="300" Name="maxResults" />
- <Variable x:TypeArguments="x:String" Name="average" />
- <Variable x:TypeArguments="sd:DataTable" Default="[New System.Data.DataTable]" Name="ExtractDataTable" />
- </Sequence.Variables>
- <ui:InputDialog Options="{x:Null}" DisplayName="Get user input" sap2010:WorkflowViewState.IdRef="InputDialog_1" IsPassword="False" Label="Enter an item that you would like to search for:" Title="Enter an item that you would like to search for:">
- <ui:InputDialog.Result>
- <OutArgument x:TypeArguments="ui:GenericValue">[searchTerm]</OutArgument>
- </ui:InputDialog.Result>
- </ui:InputDialog>
- <ui:OpenBrowser UiBrowser="{x:Null}" BrowserType="IE" DisplayName="Open Browser" Hidden="False" sap2010:WorkflowViewState.IdRef="OpenBrowser_1" NewSession="True" Private="False" Url="www.ebay.com">
- <ui:OpenBrowser.Body>
- <ActivityAction x:TypeArguments="x:Object">
- <ActivityAction.Argument>
- <DelegateInArgument x:TypeArguments="x:Object" Name="ContextTarget" />
- </ActivityAction.Argument>
- <Sequence DisplayName="Do" sap2010:WorkflowViewState.IdRef="Sequence_1">
- <Sequence.Variables>
- <Variable x:TypeArguments="ui:GenericValue" Name="average2" />
- </Sequence.Variables>
- <ui:MaximizeWindow Window="{x:Null}" DisplayName="Maximize Window" sap2010:WorkflowViewState.IdRef="MaximizeWindow_1" />
- <ui:TypeInto DelayBetweenKeys="{x:Null}" DelayMS="{x:Null}" Activate="True" ClickBeforeTyping="True" DelayBefore="3000" DisplayName="Enter search term" EmptyField="True" sap2010:WorkflowViewState.IdRef="TypeInto_1" SendWindowMessages="False" SimulateType="True" Text="[searchTerm]">
- <ui:TypeInto.Target>
- <ui:Target ClippingRegion="{x:Null}" Element="{x:Null}" TimeoutMS="{x:Null}" InformativeScreenshot="d8dce15b4b369d6e87fa6e7c90546099" Selector="<webctrl id='gh-ac' tag='INPUT' />" WaitForReady="INTERACTIVE" />
- </ui:TypeInto.Target>
- </ui:TypeInto>
- <ui:Click DelayBefore="{x:Null}" DelayMS="{x:Null}" ClickType="CLICK_SINGLE" DisplayName="Click search Button" sap2010:WorkflowViewState.IdRef="Click_1" KeyModifiers="None" MouseButton="BTN_LEFT" SendWindowMessages="False" SimulateClick="False">
- <ui:Click.CursorPosition>
- <ui:CursorPosition Position="Center">
- <ui:CursorPosition.OffsetX>
- <InArgument x:TypeArguments="x:Int32" />
- </ui:CursorPosition.OffsetX>
- <ui:CursorPosition.OffsetY>
- <InArgument x:TypeArguments="x:Int32" />
- </ui:CursorPosition.OffsetY>
- </ui:CursorPosition>
- </ui:Click.CursorPosition>
- <ui:Click.Target>
- <ui:Target ClippingRegion="{x:Null}" Element="{x:Null}" TimeoutMS="{x:Null}" InformativeScreenshot="b5709bc87eda9b6de2d2a2b80189c8b0" Selector="<webctrl id='gh-btn' tag='INPUT' />" WaitForReady="INTERACTIVE" />
- </ui:Click.Target>
- </ui:Click>
- <ui:ExtractData ContinueOnError="True" DataTable="[ExtractDataTable]" DelayBetweenPagesMS="300" DisplayName="Extract Structured Data" ExtractMetadata="<extract><row exact='1'><webctrl class='s-item ' tag='li' /><webctrl class='s-item__wrapper clearfix' tag='div' idx='1' /><webctrl class='s-item__info clearfix' tag='div' idx='1' /></row><column name='Product' attr='text' exact='1'><webctrl class='s-item ' tag='li' /><webctrl class='s-item__wrapper clearfix' tag='div' idx='1' /><webctrl class='s-item__info clearfix' tag='div' idx='1' /><webctrl class='s-item__link' tag='a' idx='1' /><webctrl class='s-item__title' tag='h3' idx='1' /></column><column name='Price' attr='text' exact='1'><webctrl class='s-item ' tag='li' /><webctrl class='s-item__wrapper clearfix' tag='div' idx='1' /><webctrl class='s-item__info clearfix' tag='div' idx='1' /><webctrl class='s-item__details clearfix' tag='div' idx='1' /><webctrl class='s-item__detail s-item__detail--primary' tag='div' idx='1' /><webctrl class='s-item__price' tag='span' idx='1' /></column></extract>" sap2010:WorkflowViewState.IdRef="ExtractData_1" MaxNumberOfResults="[maxResults]" NextLinkSelector="<webctrl idx='4' parentid='srp-river-results-SEARCH_PAGINATION_MODEL_V2' tag='svg' />">
- <ui:ExtractData.Target>
- <ui:Target ClippingRegion="{x:Null}" Element="{x:Null}" TimeoutMS="{x:Null}" InformativeScreenshot="f5be4bd1692359225d62a108e81180d2" Selector="<webctrl parentid='srp-river-results' tag='UL' />" WaitForReady="COMPLETE" />
- </ui:ExtractData.Target>
- </ui:ExtractData>
- <Assign sap2010:WorkflowViewState.IdRef="Assign_1">
- <Assign.To>
- <OutArgument x:TypeArguments="x:String">[average]</OutArgument>
- </Assign.To>
- <Assign.Value>
- <InArgument x:TypeArguments="x:String">[ExtractDataTable.AsEnumerable.Sum(Function(x) Convert.ToDouble(x("Price").ToString.Replace("$","").Trim)/maxResults ).ToString("##.00")]</InArgument>
- </Assign.Value>
- </Assign>
- <ui:ExcelApplicationScope Password="{x:Null}" DisplayName="Excel Application Scope" sap2010:WorkflowViewState.IdRef="ExcelApplicationScope_1" WorkbookPath="[searchTerm + " - ebay results bot " + DateTime.Now.ToShortDateString.Replace("/","-") + ".xlsx"]">
- <ui:ExcelApplicationScope.Body>
- <ActivityAction x:TypeArguments="ui:WorkbookApplication">
- <ActivityAction.Argument>
- <DelegateInArgument x:TypeArguments="ui:WorkbookApplication" Name="ExcelWorkbookScope" />
- </ActivityAction.Argument>
- <Sequence DisplayName="Do" sap2010:WorkflowViewState.IdRef="Sequence_3">
- <ui:ExcelWriteRange AddHeaders="False" DataTable="[ExtractDataTable]" DisplayName="Write Range" sap2010:WorkflowViewState.IdRef="ExcelWriteRange_1" SheetName="Sheet1" StartingCell="A1" />
- </Sequence>
- </ActivityAction>
- </ui:ExcelApplicationScope.Body>
- </ui:ExcelApplicationScope>
- </Sequence>
- </ActivityAction>
- </ui:OpenBrowser.Body>
- </ui:OpenBrowser>
- <sads:DebugSymbol.Symbol>d3RDOlxVc2Vyc1xNaWNoYWVsIFRheWxvclxHb29nbGUgRHJpdmVcVWlQYXRoIC0gU3luYyBBY3Jvc3MgQWNjb3VudHNcVWlQYXRoIFByb2plY3RzXFRTQVxFYmF5UHJpY2VDYWxjdWxhdG9yXE1haW4ueGFtbCM/A4gBDgIBAUIzQjgCAQNEOERVAgECRgVKFgIBJEsFhgEWAgEERo4BRsABAgEoSDhIRAIBJkbHAUb5AQIBJUu7AUvJAQIBI1ELgwEWAgEFVQ1VhQECASJWDVobAgEeWw1pGAIBHGoNbh4CARJvDXYWAgEOdw2CASgCAQZYoAFYygECASFWmAJWpgICASBWflaEAQIBH2egAWfLAQIBHWr8CWqKCgIBGmygAWzZAQIBGWpnamwCARhqLWozAgEXaj5qUgIBFWqcCmr5CgIBFGqjAWq4CQIBE3Q4dMEBAgERcTlxQgIBD3eoAXezAgIBDX0Tfx4CAQd+FX7QAQIBCH7JAX7NAQIBDH5GfloCAQp+swF+uwECAQk=</sads:DebugSymbol.Symbol>
- </Sequence>
- <sap2010:WorkflowViewState.ViewStateManager>
- <sap2010:ViewStateManager>
- <sap2010:ViewStateData Id="InputDialog_1" sap:VirtualizedContainerService.HintSize="588.571428571429,91.4285714285714" />
- <sap2010:ViewStateData Id="MaximizeWindow_1" sap:VirtualizedContainerService.HintSize="553.142857142857,21.7142857142857" />
- <sap2010:ViewStateData Id="TypeInto_1" sap:VirtualizedContainerService.HintSize="553.142857142857,133.142857142857" />
- <sap2010:ViewStateData Id="Click_1" sap:VirtualizedContainerService.HintSize="553.142857142857,105.142857142857" />
- <sap2010:ViewStateData Id="ExtractData_1" sap:VirtualizedContainerService.HintSize="553.142857142857,105.142857142857" />
- <sap2010:ViewStateData Id="Assign_1" sap:VirtualizedContainerService.HintSize="553.142857142857,60.5714285714286" />
- <sap2010:ViewStateData Id="ExcelWriteRange_1" sap:VirtualizedContainerService.HintSize="313.714285714286,86.2857142857143" />
- <sap2010:ViewStateData Id="Sequence_3" sap:VirtualizedContainerService.HintSize="335.428571428571,209.714285714286">
- <sap:WorkflowViewStateService.ViewState>
- <scg:Dictionary x:TypeArguments="x:String, x:Object">
- <x:Boolean x:Key="IsExpanded">True</x:Boolean>
- </scg:Dictionary>
- </sap:WorkflowViewStateService.ViewState>
- </sap2010:ViewStateData>
- <sap2010:ViewStateData Id="ExcelApplicationScope_1" sap:VirtualizedContainerService.HintSize="553.142857142857,318.285714285714" />
- <sap2010:ViewStateData Id="Sequence_1" sap:VirtualizedContainerService.HintSize="574.857142857143,1067.42857142857">
- <sap:WorkflowViewStateService.ViewState>
- <scg:Dictionary x:TypeArguments="x:String, x:Object">
- <x:Boolean x:Key="IsExpanded">True</x:Boolean>
- </scg:Dictionary>
- </sap:WorkflowViewStateService.ViewState>
- </sap2010:ViewStateData>
- <sap2010:ViewStateData Id="OpenBrowser_1" sap:VirtualizedContainerService.HintSize="588.571428571429,1165.71428571429" />
- <sap2010:ViewStateData Id="Sequence_2" sap:VirtualizedContainerService.HintSize="610.285714285714,1420.57142857143">
- <sap:WorkflowViewStateService.ViewState>
- <scg:Dictionary x:TypeArguments="x:String, x:Object">
- <x:Boolean x:Key="IsExpanded">True</x:Boolean>
- </scg:Dictionary>
- </sap:WorkflowViewStateService.ViewState>
- </sap2010:ViewStateData>
- <sap2010:ViewStateData Id="Main_1" sap:VirtualizedContainerService.HintSize="650.285714285714,1540.57142857143" />
- </sap2010:ViewStateManager>
- </sap2010:WorkflowViewState.ViewStateManager>
- </Activity>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement