<Activity mc:Ignorable="sap sap2010 sads" x:Class="InitSettings" this:InitSettings.in_ConfigFile="USFoods-InvStatus_MAIN.xaml.config" this:InitSettings.in_TextFileDelimiter=":="
 xmlns="http://schemas.microsoft.com/netfx/2009/xaml/activities"
 xmlns:av="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
 xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
 xmlns:mva="clr-namespace:Microsoft.VisualBasic.Activities;assembly=System.Activities"
 xmlns:njl="clr-namespace:Newtonsoft.Json.Linq;assembly=Newtonsoft.Json"
 xmlns:s="clr-namespace:System;assembly=mscorlib"
 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:this="clr-namespace:"
 xmlns:ui="http://schemas.uipath.com/workflow/activities"
 xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml">
  <x:Members>
    <x:Property Name="out_Config" Type="OutArgument(scg:Dictionary(x:String, scg:Dictionary(x:String, x:Object)))" />
    <x:Property Name="in_ConfigFile" Type="InArgument(x:String)" />
    <x:Property Name="in_TextFileDelimiter" Type="InArgument(x:String)" />
  </x:Members>
  <mva:VisualBasic.Settings>
    <x:Null />
  </mva:VisualBasic.Settings>
  <sap2010:WorkflowViewState.IdRef>InitSettings_1</sap2010:WorkflowViewState.IdRef>
  <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>UiPath.Excel</x:String>
      <x:String>System.Xml.Serialization</x:String>
      <x:String>System.Text.RegularExpressions</x:String>
      <x:String>Microsoft.VisualBasic.CompilerServices</x:String>
      <x:String>Newtonsoft.Json.Linq</x:String>
      <x:String>Newtonsoft.Json</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>UiPath.Core</AssemblyReference>
      <AssemblyReference>UiPath.Core.Activities</AssemblyReference>
      <AssemblyReference>PresentationFramework</AssemblyReference>
      <AssemblyReference>WindowsBase</AssemblyReference>
      <AssemblyReference>PresentationCore</AssemblyReference>
      <AssemblyReference>System.Xaml</AssemblyReference>
      <AssemblyReference>System.ServiceModel</AssemblyReference>
      <AssemblyReference>Microsoft.VisualStudio.Services.Common</AssemblyReference>
      <AssemblyReference>UiPath.Excel</AssemblyReference>
      <AssemblyReference>System.Data.DataSetExtensions</AssemblyReference>
      <AssemblyReference>System.ComponentModel.Composition</AssemblyReference>
      <AssemblyReference>Newtonsoft.Json</AssemblyReference>
    </sco:Collection>
  </TextExpression.ReferencesForImplementation>
  <Flowchart sap2010:Annotation.AnnotationText="//--- Description:&#xA;Reads settings file in 4 different formats (xlsx/xls,csv,text-based, or json) and returns settings in a 2-dimensional dictionary to be used throughout a project by either accessing the values directly or storing them into additional variables.&#xA;&#xA;//--- Arguments:&#xA;in_ConfigFile as String =&gt; filepath to settings file&#xA;in_TestFileDelimiter as String=&gt; &lt;text-based fiiles only&gt; character(s) used to space key from value and (optional) description&#xA;&#xA;out_Config (out) =&gt; 2-dimensional dictionary. that stores value objects as Numbers, Strings, or Arrays&#xA;    Example uses:&#xA;                                 out_Config(&quot;parent&quot;)(&quot;key&quot;).ToString or CInt(out_Config(&quot;parent&quot;)(&quot;key&quot;))&#xA;                                 &lt;convert settings list to array&gt; out_Config(&quot;parent&quot;).Select(Function(x) x.Value)&#xA;                                 &lt;array objects&gt; CType(out_Config(&quot;parent&quot;)(&quot;key&quot;),Object())&#xA;&#xA;    --- Arrays can be used in the setting column with a json format like [1,2,3] or ['a','b','c']&#xA;&#xA;//----------------------------------------------------------------------------------------------------&#xA;//---Last-Updated-2/14/18-14:50----------------- Enhancements made by Clayton Marischen" DisplayName="InitSettings" sap2010:WorkflowViewState.IdRef="Flowchart_1">
    <Flowchart.Variables>
      <Variable x:TypeArguments="ui:WorkbookApplication" Name="wb_Config" />
      <Variable x:TypeArguments="sd:DataTable" Name="table_Config" />
      <Variable x:TypeArguments="x:String" Name="text_Config" />
      <Variable x:TypeArguments="njl:JObject" Name="json_Config" />
    </Flowchart.Variables>
    <Flowchart.StartNode>
      <FlowStep x:Name="__ReferenceID4" sap2010:WorkflowViewState.IdRef="FlowStep_6">
        <WriteLine DisplayName="Write line - Initializing" sap2010:WorkflowViewState.IdRef="WriteLine_10" Text="--- INITIALIZING -------------------" />
        <FlowStep.Next>
          <FlowSwitch x:TypeArguments="x:String" x:Name="__ReferenceID2" DisplayName="FileType?" Expression="[If(Path.GetExtension(in_ConfigFile).ToUpper.Contains(&quot;XLS&quot;),&quot;EXCEL&quot;,If(Path.GetExtension(in_ConfigFile).ToUpper.Contains(&quot;CSV&quot;),&quot;CSV&quot;,If(Path.GetExtension(in_ConfigFile).ToUpper.Contains(&quot;JSON&quot;),&quot;JSON&quot;,&quot;TEXT&quot;)))]" sap2010:WorkflowViewState.IdRef="FlowSwitch`1_2">
            <FlowSwitch.Default>
              <FlowStep x:Name="__ReferenceID5" sap2010:WorkflowViewState.IdRef="FlowStep_8">
                <Sequence DisplayName="TEXT Load Settings" sap2010:WorkflowViewState.IdRef="Sequence_21">
                  <Assign DisplayName="Initialize dictionary" sap2010:WorkflowViewState.IdRef="Assign_16">
                    <Assign.To>
                      <OutArgument x:TypeArguments="scg:Dictionary(x:String, scg:Dictionary(x:String, x:Object))">[out_Config]</OutArgument>
                    </Assign.To>
                    <Assign.Value>
                      <InArgument x:TypeArguments="scg:Dictionary(x:String, scg:Dictionary(x:String, x:Object))">[new Dictionary(of String, Dictionary(of String, Object))]</InArgument>
                    </Assign.Value>
                  </Assign>
                  <ui:ReadTextFile Content="[text_Config]" DisplayName="Read text to get settings" FileName="[in_ConfigFile]" sap2010:WorkflowViewState.IdRef="ReadTextFile_1" />
                  <ui:ForEach x:TypeArguments="x:String" DisplayName="For each [parent] in text_Config" sap2010:WorkflowViewState.IdRef="ForEach`1_7" Values="[text_Config.Split({System.Environment.NewLine},StringSplitOptions.RemoveEmptyEntries).Where(Function(r) System.Text.RegularExpressions.Regex.IsMatch(r.Split({in_TextFileDelimiter},System.StringSplitOptions.RemoveEmptyEntries)(0).ToString.Trim,&quot;\[(.*)\]&quot;)).Select(Function(r) r.Split({in_TextFileDelimiter},System.StringSplitOptions.RemoveEmptyEntries)(0).ToString.Trim.Replace(&quot;[&quot;,&quot;&quot;).Replace(&quot;]&quot;,&quot;&quot;)).ToArray _&#xA;  .Take( text_Config.Split({System.Environment.NewLine},StringSplitOptions.RemoveEmptyEntries).Where(Function(r) System.Text.RegularExpressions.Regex.IsMatch(r.Split({in_TextFileDelimiter},System.StringSplitOptions.RemoveEmptyEntries)(0).ToString.Trim,&quot;\[(.*)\]&quot;)).Select(Function(r) r.Split({in_TextFileDelimiter},System.StringSplitOptions.RemoveEmptyEntries)(0).ToString.Trim.Replace(&quot;[&quot;,&quot;&quot;).Replace(&quot;]&quot;,&quot;&quot;)).ToArray.Count-1 )]">
                    <ui:ForEach.Body>
                      <ActivityAction x:TypeArguments="x:String">
                        <ActivityAction.Argument>
                          <DelegateInArgument x:TypeArguments="x:String" Name="parent" />
                        </ActivityAction.Argument>
                        <Sequence DisplayName="Add [parent] to dictionary with settings" sap2010:WorkflowViewState.IdRef="Sequence_19">
                          <Assign DisplayName="Add [parent] to key" sap2010:WorkflowViewState.IdRef="Assign_17">
                            <Assign.To>
                              <OutArgument x:TypeArguments="scg:Dictionary(x:String, x:Object)">[out_Config(parent.Trim)]</OutArgument>
                            </Assign.To>
                            <Assign.Value>
                              <InArgument x:TypeArguments="scg:Dictionary(x:String, x:Object)">[new Dictionary(of String, Object)]</InArgument>
                            </Assign.Value>
                          </Assign>
                          <ui:ForEach x:TypeArguments="x:String" DisplayName="For each setting in [parent]" sap2010:WorkflowViewState.IdRef="ForEach`1_9" Values="[text_Config.Split({System.Environment.NewLine},StringSplitOptions.RemoveEmptyEntries).Skip(Array.IndexOf(text_Config.Split({System.Environment.NewLine},StringSplitOptions.RemoveEmptyEntries),text_Config.Split({System.Environment.NewLine},StringSplitOptions.RemoveEmptyEntries).Where(Function(r) r.ToString.Trim=&quot;[&quot;+parent+&quot;]&quot;).ToList(0))+1 ) _&#xA;  .Take( Array.IndexOf( text_Config.Split({System.Environment.NewLine},StringSplitOptions.RemoveEmptyEntries),text_Config.Split({System.Environment.NewLine},StringSplitOptions.RemoveEmptyEntries).Skip(Array.IndexOf(text_Config.Split({System.Environment.NewLine},StringSplitOptions.RemoveEmptyEntries),text_Config.Split({System.Environment.NewLine},StringSplitOptions.RemoveEmptyEntries).Where(Function(r) r.ToString.Trim=&quot;[&quot;+parent+&quot;]&quot;).ToList(0))+1 ) _&#xA;  .Where(Function(r) System.Text.RegularExpressions.Regex.IsMatch(r.ToString.Trim,&quot;(?&lt;!&quot;+in_TextFileDelimiter+&quot;.*)\[(.*)\]&quot;)).ToList(0)) - Array.IndexOf(text_Config.Split({System.Environment.NewLine},StringSplitOptions.RemoveEmptyEntries),text_Config.Split({System.Environment.NewLine},StringSplitOptions.RemoveEmptyEntries).Where(Function(r) r.ToString.Trim=&quot;[&quot;+parent+&quot;]&quot;).ToList(0)) - 1 ) _&#xA;  .Where(Function(r) Not String.IsNullOrEmpty(r.ToString.Split({in_TextFileDelimiter},StringSplitOptions.RemoveEmptyEntries)(0).Trim)).ToList]">
                            <ui:ForEach.Body>
                              <ActivityAction x:TypeArguments="x:String">
                                <ActivityAction.Argument>
                                  <DelegateInArgument x:TypeArguments="x:String" Name="setting" />
                                </ActivityAction.Argument>
                                <Sequence DisplayName="Add setting to dictionary" sap2010:WorkflowViewState.IdRef="Sequence_22">
                                  <TryCatch DisplayName="Try to parse Array, if not, store as a string" sap2010:WorkflowViewState.IdRef="TryCatch_3">
                                    <TryCatch.Try>
                                      <Assign DisplayName="Add Array to key/value pair" sap2010:WorkflowViewState.IdRef="Assign_32">
                                        <Assign.To>
                                          <OutArgument x:TypeArguments="x:Object">[out_Config(parent.Trim)(setting.Split({in_TextFileDelimiter},System.StringSplitOptions.RemoveEmptyEntries)(0).ToString.Trim)]</OutArgument>
                                        </Assign.To>
                                        <Assign.Value>
                                          <InArgument x:TypeArguments="njl:JToken[]">[JArray.Parse(setting.Split({in_TextFileDelimiter},System.StringSplitOptions.RemoveEmptyEntries)(1).ToString.Trim).Select(Function(x) If(x.ToString.Contains(" "),x.ToString.Trim,x)).ToArray]</InArgument>
                                        </Assign.Value>
                                      </Assign>
                                    </TryCatch.Try>
                                    <TryCatch.Catches>
                                      <Catch x:TypeArguments="s:Exception" sap2010:WorkflowViewState.IdRef="Catch`1_3">
                                        <ActivityAction x:TypeArguments="s:Exception">
                                          <ActivityAction.Argument>
                                            <DelegateInArgument x:TypeArguments="s:Exception" Name="exception" />
                                          </ActivityAction.Argument>
                                          <Assign DisplayName="Add Value to key/value pair" sap2010:WorkflowViewState.IdRef="Assign_34">
                                            <Assign.To>
                                              <OutArgument x:TypeArguments="x:Object">[out_Config(parent.Trim)(setting.Split({in_TextFileDelimiter},System.StringSplitOptions.RemoveEmptyEntries)(0).ToString.Trim)]</OutArgument>
                                            </Assign.To>
                                            <Assign.Value>
                                              <InArgument x:TypeArguments="x:Object">[setting.Split({in_TextFileDelimiter},System.StringSplitOptions.RemoveEmptyEntries)(1).ToString.Trim]</InArgument>
                                            </Assign.Value>
                                          </Assign>
                                        </ActivityAction>
                                      </Catch>
                                    </TryCatch.Catches>
                                  </TryCatch>
                                  <WriteLine DisplayName="Write line - Setting" sap2010:WorkflowViewState.IdRef="WriteLine_12" Text="[&quot;---  &quot;+parent.Trim+&quot; =&gt; &quot;&quot;&quot;+setting.Split({in_TextFileDelimiter},System.StringSplitOptions.RemoveEmptyEntries)(0).ToString.Trim+ &quot;&quot;&quot;: &quot;+&quot;&quot;&quot;&quot;+If(IsArray(out_Config(parent.Trim)(setting.Split({in_TextFileDelimiter},System.StringSplitOptions.RemoveEmptyEntries)(0).ToString.Trim)),String.Join(&quot;; &quot;,CType(out_Config(parent.Trim)(setting.Split({in_TextFileDelimiter},System.StringSplitOptions.RemoveEmptyEntries)(0).ToString.Trim),Object())),out_Config(parent.Trim)(setting.Split({in_TextFileDelimiter},System.StringSplitOptions.RemoveEmptyEntries)(0).ToString.Trim).ToString.Trim)+&quot;&quot;&quot;&quot;]" />
                                </Sequence>
                              </ActivityAction>
                            </ui:ForEach.Body>
                          </ui:ForEach>
                        </Sequence>
                      </ActivityAction>
                    </ui:ForEach.Body>
                  </ui:ForEach>
                </Sequence>
                <FlowStep.Next>
                  <FlowStep x:Name="__ReferenceID0" sap2010:WorkflowViewState.IdRef="FlowStep_7">
                    <WriteLine DisplayName="Write line - Initializing" sap2010:WorkflowViewState.IdRef="WriteLine_11" Text="&gt;&gt;&gt; END OF SETTINGS &gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;&gt;" />
                  </FlowStep>
                </FlowStep.Next>
              </FlowStep>
            </FlowSwitch.Default>
            <FlowStep x:Key="CSV" x:Name="__ReferenceID3" sap2010:WorkflowViewState.IdRef="FlowStep_5">
              <Sequence DisplayName="CSV Load Settings" sap2010:WorkflowViewState.IdRef="Sequence_10">
                <Assign DisplayName="Initialize dictionary" sap2010:WorkflowViewState.IdRef="Assign_13">
                  <Assign.To>
                    <OutArgument x:TypeArguments="scg:Dictionary(x:String, scg:Dictionary(x:String, x:Object))">[out_Config]</OutArgument>
                  </Assign.To>
                  <Assign.Value>
                    <InArgument x:TypeArguments="scg:Dictionary(x:String, scg:Dictionary(x:String, x:Object))">[new Dictionary(of String, Dictionary(of String, Object))]</InArgument>
                  </Assign.Value>
                </Assign>
                <ui:ReadCsvFile Encoding="{x:Null}" DataTable="[table_Config]" Delimitator="Comma" DisplayName="Read CSV to get settings" FilePath="[in_ConfigFile]" sap2010:WorkflowViewState.IdRef="ReadCsvFile_1" IncludeColumnNames="False" />
                <ui:ForEach x:TypeArguments="x:String" DisplayName="For each [parent] in table_Config" sap2010:WorkflowViewState.IdRef="ForEach`1_6" Values="[table_Config.AsEnumerable.Where(Function(r) System.Text.RegularExpressions.Regex.IsMatch(r(0).ToString.Trim,&quot;\[(.*)\]&quot;)).Select(Function(r) r(0).ToString.Trim.Replace(&quot;[&quot;,&quot;&quot;).Replace(&quot;]&quot;,&quot;&quot;)).ToArray _&#xA;  .Take( table_Config.AsEnumerable.Where(Function(r) System.Text.RegularExpressions.Regex.IsMatch(r(0).ToString.Trim,&quot;\[(.*)\]&quot;)).Select(Function(r) r(0).ToString.Trim.Replace(&quot;[&quot;,&quot;&quot;).Replace(&quot;]&quot;,&quot;&quot;)).ToArray.Count-1 )]">
                  <ui:ForEach.Body>
                    <ActivityAction x:TypeArguments="x:String">
                      <ActivityAction.Argument>
                        <DelegateInArgument x:TypeArguments="x:String" Name="parent" />
                      </ActivityAction.Argument>
                      <Sequence DisplayName="Add [parent] to dictionary with settings" sap2010:WorkflowViewState.IdRef="Sequence_14">
                        <Assign DisplayName="Add [parent] to key" sap2010:WorkflowViewState.IdRef="Assign_14">
                          <Assign.To>
                            <OutArgument x:TypeArguments="scg:Dictionary(x:String, x:Object)">[out_Config(parent.Trim)]</OutArgument>
                          </Assign.To>
                          <Assign.Value>
                            <InArgument x:TypeArguments="scg:Dictionary(x:String, x:Object)">[new Dictionary(of String, Object)]</InArgument>
                          </Assign.Value>
                        </Assign>
                        <ui:ForEachRow DataTable="[table_Config.AsEnumerable.Skip(table_Config.Rows.IndexOf(table_Config.AsEnumerable.Where(Function(r) r(0).ToString.Trim=&quot;[&quot;+parent.Trim+&quot;]&quot;).ToArray(0))+1 ) _&#xA;  .Take( table_Config.Rows.IndexOf( table_Config.AsEnumerable.Skip(table_Config.Rows.IndexOf(table_Config.AsEnumerable.Where(Function(r) r(0).ToString.Trim=&quot;[&quot;+parent.Trim+&quot;]&quot;).ToArray(0))+1 ) _&#xA;  .Where(Function(r) System.Text.RegularExpressions.Regex.IsMatch(r(0).ToString.Trim,&quot;\[(.*)\]&quot;)).ToArray(0)) - table_Config.Rows.IndexOf(table_Config.AsEnumerable.Where(Function(r) r(0).ToString.Trim=&quot;[&quot;+parent.Trim+&quot;]&quot;).ToArray(0)) - 1 ) _&#xA;  .Where(Function(r) Not String.IsNullOrEmpty(r(0).ToString.Trim)).CopyToDataTable]" DisplayName="For each setting in [parent]" sap2010:WorkflowViewState.IdRef="ForEachRow_5">
                          <ui:ForEachRow.Body>
                            <ActivityAction x:TypeArguments="sd:DataRow">
                              <ActivityAction.Argument>
                                <DelegateInArgument x:TypeArguments="sd:DataRow" Name="setting" />
                              </ActivityAction.Argument>
                              <Sequence DisplayName="Add setting to dictionary" sap2010:WorkflowViewState.IdRef="Sequence_17">
                                <TryCatch DisplayName="Try to parse Array, if not, store as a string" sap2010:WorkflowViewState.IdRef="TryCatch_2">
                                  <TryCatch.Try>
                                    <Assign DisplayName="Add Array to key/value pair" sap2010:WorkflowViewState.IdRef="Assign_30">
                                      <Assign.To>
                                        <OutArgument x:TypeArguments="x:Object">[out_Config(parent.Trim)(setting(0).ToString.Trim)]</OutArgument>
                                      </Assign.To>
                                      <Assign.Value>
                                        <InArgument x:TypeArguments="x:Object">[JArray.Parse(setting(1).ToString.Trim).Select(Function(x) If(x.ToString.Contains(" "),x.ToString.Trim,x)).ToArray]</InArgument>
                                      </Assign.Value>
                                    </Assign>
                                  </TryCatch.Try>
                                  <TryCatch.Catches>
                                    <Catch x:TypeArguments="s:Exception" sap2010:WorkflowViewState.IdRef="Catch`1_2">
                                      <ActivityAction x:TypeArguments="s:Exception">
                                        <ActivityAction.Argument>
                                          <DelegateInArgument x:TypeArguments="s:Exception" Name="exception" />
                                        </ActivityAction.Argument>
                                        <Assign DisplayName="Add Value to key/value pair" sap2010:WorkflowViewState.IdRef="Assign_15">
                                          <Assign.To>
                                            <OutArgument x:TypeArguments="x:Object">[out_Config(parent.Trim)(setting(0).ToString.Trim)]</OutArgument>
                                          </Assign.To>
                                          <Assign.Value>
                                            <InArgument x:TypeArguments="x:Object">[setting(1).ToString.Trim]</InArgument>
                                          </Assign.Value>
                                        </Assign>
                                      </ActivityAction>
                                    </Catch>
                                  </TryCatch.Catches>
                                </TryCatch>
                                <WriteLine DisplayName="Write line - Setting" sap2010:WorkflowViewState.IdRef="WriteLine_9" Text="[&quot;---  &quot;+parent.Trim+&quot; =&gt; &quot;&quot;&quot;+setting(0).ToString.Trim + &quot;&quot;&quot;: &quot;+&quot;&quot;&quot;&quot;+If(IsArray(out_Config(parent.Trim)(setting(0).ToString.Trim)),String.Join(&quot;; &quot;,CType(out_Config(parent.Trim)(setting(0).ToString.Trim),Object())),out_Config(parent.Trim)(setting(0).ToString.Trim).ToString.Trim)+&quot;&quot;&quot;&quot;]" />
                              </Sequence>
                            </ActivityAction>
                          </ui:ForEachRow.Body>
                        </ui:ForEachRow>
                      </Sequence>
                    </ActivityAction>
                  </ui:ForEach.Body>
                </ui:ForEach>
              </Sequence>
              <FlowStep.Next>
                <x:Reference>__ReferenceID0</x:Reference>
              </FlowStep.Next>
            </FlowStep>
            <FlowStep x:Key="JSON" x:Name="__ReferenceID6" sap2010:WorkflowViewState.IdRef="FlowStep_9">
              <Sequence DisplayName="JSON Load Settings" sap2010:WorkflowViewState.IdRef="Sequence_26">
                <Assign DisplayName="Initialize dictionary" sap2010:WorkflowViewState.IdRef="Assign_19">
                  <Assign.To>
                    <OutArgument x:TypeArguments="scg:Dictionary(x:String, scg:Dictionary(x:String, x:Object))">[out_Config]</OutArgument>
                  </Assign.To>
                  <Assign.Value>
                    <InArgument x:TypeArguments="scg:Dictionary(x:String, scg:Dictionary(x:String, x:Object))">[new Dictionary(of String, Dictionary(of String, Object))]</InArgument>
                  </Assign.Value>
                </Assign>
                <ui:ReadTextFile Content="[text_Config]" DisplayName="Read text to get settings" FileName="[in_ConfigFile]" sap2010:WorkflowViewState.IdRef="ReadTextFile_2" />
                <ui:DeserializeJson x:TypeArguments="njl:JObject" DisplayName="Deserialize JSON Config" sap2010:WorkflowViewState.IdRef="DeserializeJson`1_1" JsonObject="[json_Config]" JsonString="[text_Config]" />
                <ui:ForEach x:TypeArguments="njl:JProperty" DisplayName="For each [parent] in json properties" sap2010:WorkflowViewState.IdRef="ForEach`1_16" Values="[json_Config.Properties]">
                  <ui:ForEach.Body>
                    <ActivityAction x:TypeArguments="njl:JProperty">
                      <ActivityAction.Argument>
                        <DelegateInArgument x:TypeArguments="njl:JProperty" Name="parent" />
                      </ActivityAction.Argument>
                      <Sequence DisplayName="Add [parent] to dictionary with settings" sap2010:WorkflowViewState.IdRef="Sequence_34">
                        <Assign DisplayName="Add [parent] to key" sap2010:WorkflowViewState.IdRef="Assign_24">
                          <Assign.To>
                            <OutArgument x:TypeArguments="scg:Dictionary(x:String, x:Object)">[out_Config(parent.Name.Trim)]</OutArgument>
                          </Assign.To>
                          <Assign.Value>
                            <InArgument x:TypeArguments="scg:Dictionary(x:String, x:Object)">[new Dictionary(of String, Object)]</InArgument>
                          </Assign.Value>
                        </Assign>
                        <ui:ForEach x:TypeArguments="njl:JProperty" DisplayName="For each setting in [parent]" sap2010:WorkflowViewState.IdRef="ForEach`1_17" Values="[json_Config(parent.Name.Trim).Children]">
                          <ui:ForEach.Body>
                            <ActivityAction x:TypeArguments="njl:JProperty">
                              <ActivityAction.Argument>
                                <DelegateInArgument x:TypeArguments="njl:JProperty" Name="setting" />
                              </ActivityAction.Argument>
                              <Sequence DisplayName="Add setting to dictionary" sap2010:WorkflowViewState.IdRef="Sequence_32">
                                <If Condition="[setting.Value.Select(Function(x) x).ToArray.Count&gt;0]" DisplayName="If Value is an Array store as Array type" sap2010:WorkflowViewState.IdRef="If_1">
                                  <If.Then>
                                    <Assign DisplayName="Add Array to key/value pair" sap2010:WorkflowViewState.IdRef="Assign_26">
                                      <Assign.To>
                                        <OutArgument x:TypeArguments="x:Object">[out_Config(parent.Name.Trim)(setting.Name.Trim)]</OutArgument>
                                      </Assign.To>
                                      <Assign.Value>
                                        <InArgument x:TypeArguments="x:Object">[setting.Value.Select(Function(x) x).ToArray]</InArgument>
                                      </Assign.Value>
                                    </Assign>
                                  </If.Then>
                                  <If.Else>
                                    <Assign DisplayName="Add Value to key/value pair" sap2010:WorkflowViewState.IdRef="Assign_25">
                                      <Assign.To>
                                        <OutArgument x:TypeArguments="x:Object">[out_Config(parent.Name.Trim)(setting.Name.Trim)]</OutArgument>
                                      </Assign.To>
                                      <Assign.Value>
                                        <InArgument x:TypeArguments="x:Object">[setting.Value.ToString]</InArgument>
                                      </Assign.Value>
                                    </Assign>
                                  </If.Else>
                                </If>
                                <WriteLine DisplayName="Write line - Setting" sap2010:WorkflowViewState.IdRef="WriteLine_15" Text="[&quot;---  &quot;+parent.Name.Trim+&quot; =&gt; &quot;&quot;&quot;+setting.Name.Trim+ &quot;&quot;&quot;: &quot;+&quot;&quot;&quot;&quot;+If(IsArray(out_Config(parent.Name.Trim)(setting.Name.Trim)),String.Join(&quot;; &quot;,CType(out_Config(parent.Name.Trim)(setting.Name.Trim),Object())),out_Config(parent.Name.Trim)(setting.Name.Trim).ToString)+&quot;&quot;&quot;&quot;]" />
                              </Sequence>
                            </ActivityAction>
                          </ui:ForEach.Body>
                        </ui:ForEach>
                      </Sequence>
                    </ActivityAction>
                  </ui:ForEach.Body>
                </ui:ForEach>
              </Sequence>
              <FlowStep.Next>
                <x:Reference>__ReferenceID0</x:Reference>
              </FlowStep.Next>
            </FlowStep>
            <FlowStep x:Key="EXCEL" x:Name="__ReferenceID1" sap2010:WorkflowViewState.IdRef="FlowStep_1">
              <ui:ExcelApplicationScope Password="{x:Null}" AutoSave="False" DisplayName="EXCEL Load Settings" sap2010:WorkflowViewState.IdRef="ExcelApplicationScope_1" Visible="False" Workbook="[wb_Config]" WorkbookPath="[in_ConfigFile]">
                <ui:ExcelApplicationScope.Body>
                  <ActivityAction x:TypeArguments="ui:WorkbookApplication">
                    <ActivityAction.Argument>
                      <DelegateInArgument x:TypeArguments="ui:WorkbookApplication" Name="ExcelWorkbookScope" />
                    </ActivityAction.Argument>
                    <Sequence DisplayName="EXCEL Load Settings" sap2010:WorkflowViewState.IdRef="Sequence_3">
                      <Assign DisplayName="Initialize dictionary" sap2010:WorkflowViewState.IdRef="Assign_1">
                        <Assign.To>
                          <OutArgument x:TypeArguments="scg:Dictionary(x:String, scg:Dictionary(x:String, x:Object))">[out_Config]</OutArgument>
                        </Assign.To>
                        <Assign.Value>
                          <InArgument x:TypeArguments="scg:Dictionary(x:String, scg:Dictionary(x:String, x:Object))">[new Dictionary(of String, Dictionary(of String, Object))]</InArgument>
                        </Assign.Value>
                      </Assign>
                      <ui:ForEach x:TypeArguments="x:String" DisplayName="For each sheet in Settings File" sap2010:WorkflowViewState.IdRef="ForEach`1_1" Values="[wb_Config.GetSheets]">
                        <ui:ForEach.Body>
                          <ActivityAction x:TypeArguments="x:String">
                            <ActivityAction.Argument>
                              <DelegateInArgument x:TypeArguments="x:String" Name="sheet" />
                            </ActivityAction.Argument>
                            <Sequence DisplayName="Add sheet to dictionary with settings" sap2010:WorkflowViewState.IdRef="Sequence_2">
                              <Assign DisplayName="Add sheet to key" sap2010:WorkflowViewState.IdRef="Assign_2">
                                <Assign.To>
                                  <OutArgument x:TypeArguments="scg:Dictionary(x:String, x:Object)">[out_Config(sheet.Trim)]</OutArgument>
                                </Assign.To>
                                <Assign.Value>
                                  <InArgument x:TypeArguments="scg:Dictionary(x:String, x:Object)">[new Dictionary(of String, Object)]</InArgument>
                                </Assign.Value>
                              </Assign>
                              <ui:ExcelReadRange AddHeaders="True" DataTable="[table_Config]" DisplayName="Read Range to get settings" sap2010:WorkflowViewState.IdRef="ExcelReadRange_1" SheetName="[sheet]">
                                <ui:ExcelReadRange.Range>
                                  <InArgument x:TypeArguments="x:String">
                                    <Literal x:TypeArguments="x:String" Value="" />
                                  </InArgument>
                                </ui:ExcelReadRange.Range>
                              </ui:ExcelReadRange>
                              <ui:ForEachRow DataTable="[table_Config.AsEnumerable.Where(Function(r) NOT String.IsNullOrEmpty(r(0).ToString.Trim)).CopyToDataTable]" DisplayName="For each setting in sheet" sap2010:WorkflowViewState.IdRef="ForEachRow_1">
                                <ui:ForEachRow.Body>
                                  <ActivityAction x:TypeArguments="sd:DataRow">
                                    <ActivityAction.Argument>
                                      <DelegateInArgument x:TypeArguments="sd:DataRow" Name="setting" />
                                    </ActivityAction.Argument>
                                    <Sequence DisplayName="Add setting to dictionary" sap2010:WorkflowViewState.IdRef="Sequence_1">
                                      <TryCatch DisplayName="Try to parse Array, if not, store as a string" sap2010:WorkflowViewState.IdRef="TryCatch_1">
                                        <TryCatch.Try>
                                          <Assign DisplayName="Add Array to key/value pair" sap2010:WorkflowViewState.IdRef="Assign_27">
                                            <Assign.To>
                                              <OutArgument x:TypeArguments="x:Object">[out_Config(sheet.Trim)(setting(0).ToString.Trim)]</OutArgument>
                                            </Assign.To>
                                            <Assign.Value>
                                              <InArgument x:TypeArguments="njl:JToken[]">[JArray.Parse(setting(1).ToString.Trim).Select(Function(x) If(x.ToString.Contains(" "),x.ToString.Trim,x)).ToArray]</InArgument>
                                            </Assign.Value>
                                          </Assign>
                                        </TryCatch.Try>
                                        <TryCatch.Catches>
                                          <Catch x:TypeArguments="s:Exception" sap2010:WorkflowViewState.IdRef="Catch`1_1">
                                            <ActivityAction x:TypeArguments="s:Exception">
                                              <ActivityAction.Argument>
                                                <DelegateInArgument x:TypeArguments="s:Exception" Name="exception" />
                                              </ActivityAction.Argument>
                                              <Assign DisplayName="Add Value to key/value pair" sap2010:WorkflowViewState.IdRef="Assign_29">
                                                <Assign.To>
                                                  <OutArgument x:TypeArguments="x:Object">[out_Config(sheet.Trim)(setting(0).ToString.Trim)]</OutArgument>
                                                </Assign.To>
                                                <Assign.Value>
                                                  <InArgument x:TypeArguments="x:Object">[setting(1).ToString.Trim]</InArgument>
                                                </Assign.Value>
                                              </Assign>
                                            </ActivityAction>
                                          </Catch>
                                        </TryCatch.Catches>
                                      </TryCatch>
                                      <WriteLine DisplayName="Write line - Setting" sap2010:WorkflowViewState.IdRef="WriteLine_2" Text="[&quot;--- &quot;+sheet.Trim+&quot; =&gt; &quot;&quot;&quot;+setting(0).ToString.Trim+ &quot;&quot;&quot;: &quot;+&quot;&quot;&quot;&quot;+If(IsArray(out_Config(sheet.Trim)(setting(0).ToString.Trim)),String.Join(&quot;; &quot;,CType(out_Config(sheet.Trim)(setting(0).ToString.Trim),Object())),out_Config(sheet.Trim)(setting(0).ToString.Trim).ToString.Trim)+&quot;&quot;&quot;&quot;]" />
                                    </Sequence>
                                  </ActivityAction>
                                </ui:ForEachRow.Body>
                              </ui:ForEachRow>
                            </Sequence>
                          </ActivityAction>
                        </ui:ForEach.Body>
                      </ui:ForEach>
                      <ui:ExcelCloseWorkbook DisplayName="Close Settings Workbook" sap2010:WorkflowViewState.IdRef="ExcelCloseWorkbook_1" Workbook="[wb_Config]" />
                    </Sequence>
                  </ActivityAction>
                </ui:ExcelApplicationScope.Body>
              </ui:ExcelApplicationScope>
              <FlowStep.Next>
                <x:Reference>__ReferenceID0</x:Reference>
              </FlowStep.Next>
            </FlowStep>
          </FlowSwitch>
        </FlowStep.Next>
      </FlowStep>
    </Flowchart.StartNode>
    <x:Reference>__ReferenceID1</x:Reference>
    <x:Reference>__ReferenceID2</x:Reference>
    <x:Reference>__ReferenceID3</x:Reference>
    <x:Reference>__ReferenceID4</x:Reference>
    <x:Reference>__ReferenceID0</x:Reference>
    <x:Reference>__ReferenceID5</x:Reference>
    <x:Reference>__ReferenceID6</x:Reference>
    <sads:DebugSymbol.Symbol>d1VcXHBlcHdhcDEwNzQyXFVpUGF0aFxUWF9DRlNfRFdcVVMgRm9vZHMgSW52U3RhdHVzXEZyYW1ld29ya19MaWJyYXJ5XEluaXRTZXR0aW5ncy54YW1sdgGuAQGxAQEDAWIBhQEBAlIDqAMPAgEBWwlbmQEDAZQBXW1digMDAZMBYBGmARwCAWupARWpAc4BAgFpwQIPlwMqAgFC+wEPuwIaAgEgrwEP9QEaAgECW3BblgEDAZUBYRNoHAMBjwFpE2myAQMBigFqE6UBIAIBbKkBfKkBywECAWrBAsMBwQLQAQIBZ8EC3gHBAu8BAgFlxwIVlAMgAgFD/AERgwIaAgE+hAIRhAKwAQIBOYUCEYUC1wECATSGAhG6Ah4CASGwARG3ARoCARy4ARG4AfMBAgEXuQER9AEeAgEDZnJmrAEDAZIBY3NjfwMBkAFpbWl+AwGNAWksaTsDAYsBap4BatIIAwGJAXAZogEkAgFtyAIXzwIgAgFh0AIXkgMkAgFHkwMXkwOkAQIBRIECcIECqgECAUH+AXH+AX0CAT+EAmuEAnwCATyEAiqEAjkCATqFAsUBhQLUAQIBN4UCqgGFArkBAgE1hgKmAYYCwAECATOMAhe3AiICASK1AXC1AaoBAgEfsgFxsgF9AgEduAE/uAFPAgEauAGUAbgBpQECARi5AZ0BuQGtBQIBFr8BF/EBIgIBBHEbeCQDAYQBeRuhASgCAW7NAnbNArABAgFkygJ3ygKDAQIBYtACoQHQArgBAgFg1gIdjwMoAgFIkwOUAZMDoQECAUWNAhmUAiICATCVAhm2AiYCASPAARnHASICARHIARnwASkCAQV2YHaDAQMBiAFzYXN6AwGFAXmiAXm6DAMBgwF/IZ4BLAIBb9cCH94CKAIBW98CH+UCMwIBVeYCH44DLwIBSZICXpICgQECATKPAl+PAn0CATGVAqYBlQLQAQIBL5sCH7MCKgIBJMUBXsUBgQECARXCAV/CAXgCARLIATLIAa4GAgEQzgEf7QEqAgEGgAEjnAEuAgFynQEjnQG5BgIBcNwCZNwChwECAV/ZAmXZAn0CAVzfAk7fAl4CAVniAiXiAlQCAVjfAsUB3wLOAQIBVuYCOOYCpQECAVTsAiWLAzACAUqcAiGxAiYCASeyAiGyAv4DAgElzwEh6wEsAgEJ7AEh7AGLBAIBB4IBJ4kBMAIBfJEBK5gBNAIBc50BhQGdAbYGAgFx7QIniQMyAgFNigMnigOLBAIBS5wCL5wCaQIBKJ4CJaUCLgIBLKgCJa8CLgIBKbICgwGyAvsDAgEm0QEl2AEuAgEN4AEp5wEyAgEK7AGCAewBiAQCAQiHAVaHAZQCAwGCAYQBU4QB0QECAX2WAVaWAbsBAgF5kwFXkwHVAQIBdO8CK/YCNAIBUf4CL4UDOAIBTooDiAGKA4gEAgFMowJQowJ9AgEuoAJRoAKCAQIBLa0CUK0CaAIBK6oCUaoCggECASrWAVDWAcMBAgEP0wFR0wGEAQIBDuUBVOUBbgIBDOIBVeIBiAECAQv0Alr0As0BAgFT8QJX8QKJAQIBUoMDWoMDdAIBUIADW4ADjQECAU8=</sads:DebugSymbol.Symbol>
  </Flowchart>
  <sap2010:WorkflowViewState.ViewStateManager>
    <sap2010:ViewStateManager>
      <sap2010:ViewStateData Id="WriteLine_10" sap:VirtualizedContainerService.HintSize="211,61" />
      <sap2010:ViewStateData Id="Assign_16" sap:VirtualizedContainerService.HintSize="490,60">
        <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="ReadTextFile_1" sap:VirtualizedContainerService.HintSize="490,59" />
      <sap2010:ViewStateData Id="Assign_17" sap:VirtualizedContainerService.HintSize="452,60" />
      <sap2010:ViewStateData Id="Assign_32" sap:VirtualizedContainerService.HintSize="242,60" />
      <sap2010:ViewStateData Id="Assign_34" sap:VirtualizedContainerService.HintSize="242,60" />
      <sap2010:ViewStateData Id="Catch`1_3" sap:VirtualizedContainerService.HintSize="400,133">
        <sap:WorkflowViewStateService.ViewState>
          <scg:Dictionary x:TypeArguments="x:String, x:Object">
            <x:Boolean x:Key="IsExpanded">True</x:Boolean>
            <x:Boolean x:Key="IsPinned">False</x:Boolean>
          </scg:Dictionary>
        </sap:WorkflowViewStateService.ViewState>
      </sap2010:ViewStateData>
      <sap2010:ViewStateData Id="TryCatch_3" sap:VirtualizedContainerService.HintSize="414,295" />
      <sap2010:ViewStateData Id="WriteLine_12" sap:VirtualizedContainerService.HintSize="414,61" />
      <sap2010:ViewStateData Id="Sequence_22" sap:VirtualizedContainerService.HintSize="436,520">
        <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="ForEach`1_9" sap:VirtualizedContainerService.HintSize="452,658" />
      <sap2010:ViewStateData Id="Sequence_19" sap:VirtualizedContainerService.HintSize="474,882">
        <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="ForEach`1_7" sap:VirtualizedContainerService.HintSize="490,1020" />
      <sap2010:ViewStateData Id="Sequence_21" sap:VirtualizedContainerService.HintSize="200,51">
        <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="WriteLine_11" sap:VirtualizedContainerService.HintSize="211,61" />
      <sap2010:ViewStateData Id="FlowStep_7">
        <sap:WorkflowViewStateService.ViewState>
          <scg:Dictionary x:TypeArguments="x:String, x:Object">
            <av:Point x:Key="ShapeLocation">34.5,479.5</av:Point>
            <av:Size x:Key="ShapeSize">211,61</av:Size>
            <av:PointCollection x:Key="ConnectorLocation">150,250.5 150,320 245,320</av:PointCollection>
          </scg:Dictionary>
        </sap:WorkflowViewStateService.ViewState>
      </sap2010:ViewStateData>
      <sap2010:ViewStateData Id="FlowStep_8">
        <sap:WorkflowViewStateService.ViewState>
          <scg:Dictionary x:TypeArguments="x:String, x:Object">
            <av:Point x:Key="ShapeLocation">440,284.5</av:Point>
            <av:Size x:Key="ShapeSize">200,51</av:Size>
            <av:PointCollection x:Key="ConnectorLocation">640,310 670,310 670,510 245.5,510</av:PointCollection>
          </scg:Dictionary>
        </sap:WorkflowViewStateService.ViewState>
      </sap2010:ViewStateData>
      <sap2010:ViewStateData Id="Assign_13" sap:VirtualizedContainerService.HintSize="508,60">
        <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="ReadCsvFile_1" sap:VirtualizedContainerService.HintSize="508,59" />
      <sap2010:ViewStateData Id="Assign_14" sap:VirtualizedContainerService.HintSize="470,60" />
      <sap2010:ViewStateData Id="Assign_30" sap:VirtualizedContainerService.HintSize="242,60" />
      <sap2010:ViewStateData Id="Assign_15" sap:VirtualizedContainerService.HintSize="242,60" />
      <sap2010:ViewStateData Id="Catch`1_2" sap:VirtualizedContainerService.HintSize="404,21">
        <sap:WorkflowViewStateService.ViewState>
          <scg:Dictionary x:TypeArguments="x:String, x:Object">
            <x:Boolean x:Key="IsExpanded">False</x:Boolean>
            <x:Boolean x:Key="IsPinned">False</x:Boolean>
          </scg:Dictionary>
        </sap:WorkflowViewStateService.ViewState>
      </sap2010:ViewStateData>
      <sap2010:ViewStateData Id="TryCatch_2" sap:VirtualizedContainerService.HintSize="418,287" />
      <sap2010:ViewStateData Id="WriteLine_9" sap:VirtualizedContainerService.HintSize="418,61" />
      <sap2010:ViewStateData Id="Sequence_17" sap:VirtualizedContainerService.HintSize="440,512">
        <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="ForEachRow_5" sap:VirtualizedContainerService.HintSize="470,664" />
      <sap2010:ViewStateData Id="Sequence_14" sap:VirtualizedContainerService.HintSize="492,888">
        <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="ForEach`1_6" sap:VirtualizedContainerService.HintSize="508,1026" />
      <sap2010:ViewStateData Id="Sequence_10" sap:VirtualizedContainerService.HintSize="200,51">
        <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="FlowStep_5">
        <sap:WorkflowViewStateService.ViewState>
          <scg:Dictionary x:TypeArguments="x:String, x:Object">
            <av:Point x:Key="ShapeLocation">440,184.5</av:Point>
            <av:Size x:Key="ShapeSize">200,51</av:Size>
            <av:PointCollection x:Key="ConnectorLocation">640,210 670,210 670,510 245.5,510</av:PointCollection>
          </scg:Dictionary>
        </sap:WorkflowViewStateService.ViewState>
      </sap2010:ViewStateData>
      <sap2010:ViewStateData Id="Assign_19" sap:VirtualizedContainerService.HintSize="585,60">
        <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="ReadTextFile_2" sap:VirtualizedContainerService.HintSize="585,59" />
      <sap2010:ViewStateData Id="DeserializeJson`1_1" sap:VirtualizedContainerService.HintSize="585,60">
        <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="Assign_24" sap:VirtualizedContainerService.HintSize="547,60" />
      <sap2010:ViewStateData Id="Assign_26" sap:VirtualizedContainerService.HintSize="242,60" />
      <sap2010:ViewStateData Id="Assign_25" sap:VirtualizedContainerService.HintSize="242,60" />
      <sap2010:ViewStateData Id="If_1" sap:VirtualizedContainerService.HintSize="509,208" />
      <sap2010:ViewStateData Id="WriteLine_15" sap:VirtualizedContainerService.HintSize="509,61" />
      <sap2010:ViewStateData Id="Sequence_32" sap:VirtualizedContainerService.HintSize="531,433">
        <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="ForEach`1_17" sap:VirtualizedContainerService.HintSize="547,567" />
      <sap2010:ViewStateData Id="Sequence_34" sap:VirtualizedContainerService.HintSize="569,791">
        <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="ForEach`1_16" sap:VirtualizedContainerService.HintSize="585,925" />
      <sap2010:ViewStateData Id="Sequence_26" sap:VirtualizedContainerService.HintSize="200,51">
        <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="FlowStep_9">
        <sap:WorkflowViewStateService.ViewState>
          <scg:Dictionary x:TypeArguments="x:String, x:Object">
            <av:Point x:Key="ShapeLocation">440,384.5</av:Point>
            <av:Size x:Key="ShapeSize">200,51</av:Size>
            <av:PointCollection x:Key="ConnectorLocation">640,410 670,410 670,510 245.5,510</av:PointCollection>
          </scg:Dictionary>
        </sap:WorkflowViewStateService.ViewState>
      </sap2010:ViewStateData>
      <sap2010:ViewStateData Id="Assign_1" sap:VirtualizedContainerService.HintSize="508,60">
        <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="Assign_2" sap:VirtualizedContainerService.HintSize="470,60" />
      <sap2010:ViewStateData Id="ExcelReadRange_1" sap:VirtualizedContainerService.HintSize="470,59" />
      <sap2010:ViewStateData Id="Assign_27" sap:VirtualizedContainerService.HintSize="242,60" />
      <sap2010:ViewStateData Id="Assign_29" sap:VirtualizedContainerService.HintSize="242,60" />
      <sap2010:ViewStateData Id="Catch`1_1" sap:VirtualizedContainerService.HintSize="404,21">
        <sap:WorkflowViewStateService.ViewState>
          <scg:Dictionary x:TypeArguments="x:String, x:Object">
            <x:Boolean x:Key="IsExpanded">False</x:Boolean>
            <x:Boolean x:Key="IsPinned">False</x:Boolean>
          </scg:Dictionary>
        </sap:WorkflowViewStateService.ViewState>
      </sap2010:ViewStateData>
      <sap2010:ViewStateData Id="TryCatch_1" sap:VirtualizedContainerService.HintSize="418,287" />
      <sap2010:ViewStateData Id="WriteLine_2" sap:VirtualizedContainerService.HintSize="418,61" />
      <sap2010:ViewStateData Id="Sequence_1" sap:VirtualizedContainerService.HintSize="440,512">
        <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="ForEachRow_1" sap:VirtualizedContainerService.HintSize="470,659" />
      <sap2010:ViewStateData Id="Sequence_2" sap:VirtualizedContainerService.HintSize="492,982">
        <sap:WorkflowViewStateService.ViewState>
          <scg:Dictionary x:TypeArguments="x:String, x:Object">
            <x:Boolean x:Key="IsExpanded">True</x:Boolean>
            <x:Boolean x:Key="IsPinned">False</x:Boolean>
          </scg:Dictionary>
        </sap:WorkflowViewStateService.ViewState>
      </sap2010:ViewStateData>
      <sap2010:ViewStateData Id="ForEach`1_1" sap:VirtualizedContainerService.HintSize="508,1115">
        <sap:WorkflowViewStateService.ViewState>
          <scg:Dictionary x:TypeArguments="x:String, x:Object">
            <x:Boolean x:Key="IsExpanded">True</x:Boolean>
            <x:Boolean x:Key="IsPinned">False</x:Boolean>
          </scg:Dictionary>
        </sap:WorkflowViewStateService.ViewState>
      </sap2010:ViewStateData>
      <sap2010:ViewStateData Id="ExcelCloseWorkbook_1" sap:VirtualizedContainerService.HintSize="504,59" />
      <sap2010:ViewStateData Id="Sequence_3" sap:VirtualizedContainerService.HintSize="530,1438">
        <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="200,51">
        <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="FlowStep_1">
        <sap:WorkflowViewStateService.ViewState>
          <scg:Dictionary x:TypeArguments="x:String, x:Object">
            <av:Point x:Key="ShapeLocation">440,84.5</av:Point>
            <av:Size x:Key="ShapeSize">200,51</av:Size>
            <av:PointCollection x:Key="ConnectorLocation">640,110 670,110 670,510 245.5,510</av:PointCollection>
          </scg:Dictionary>
        </sap:WorkflowViewStateService.ViewState>
      </sap2010:ViewStateData>
      <sap2010:ViewStateData Id="FlowSwitch`1_2" sap:VirtualizedContainerService.HintSize="70,87">
        <sap:WorkflowViewStateService.ViewState>
          <scg:Dictionary x:TypeArguments="x:String, x:Object">
            <av:Point x:Key="ShapeLocation">235,216.5</av:Point>
            <av:Size x:Key="ShapeSize">70,87</av:Size>
            <av:PointCollection x:Key="EXCELConnector">287.5,216.5 287.5,110 440,110</av:PointCollection>
            <av:PointCollection x:Key="Default">305,281.75 335,281.75 335,310 440,310</av:PointCollection>
            <x:String x:Key="DefaultCaseDisplayName">TEXT</x:String>
            <av:PointCollection x:Key="CSVConnector">305,238.25 335,238.25 335,210 440,210</av:PointCollection>
            <av:PointCollection x:Key="JSONConnector">287.5,303.5 287.5,410 440,410</av:PointCollection>
          </scg:Dictionary>
        </sap:WorkflowViewStateService.ViewState>
      </sap2010:ViewStateData>
      <sap2010:ViewStateData Id="FlowStep_6">
        <sap:WorkflowViewStateService.ViewState>
          <scg:Dictionary x:TypeArguments="x:String, x:Object">
            <av:Point x:Key="ShapeLocation">34.5,129.5</av:Point>
            <av:Size x:Key="ShapeSize">211,61</av:Size>
            <av:PointCollection x:Key="ConnectorLocation">140,190.5 140,260 235,260</av:PointCollection>
          </scg:Dictionary>
        </sap:WorkflowViewStateService.ViewState>
      </sap2010:ViewStateData>
      <sap2010:ViewStateData Id="Flowchart_1" sap:VirtualizedContainerService.HintSize="746,938">
        <sap:WorkflowViewStateService.ViewState>
          <scg:Dictionary x:TypeArguments="x:String, x:Object">
            <x:Boolean x:Key="IsExpanded">False</x:Boolean>
            <av:Point x:Key="ShapeLocation">110,10</av:Point>
            <av:Size x:Key="ShapeSize">60,75</av:Size>
            <av:PointCollection x:Key="ConnectorLocation">140,85 140,129.5</av:PointCollection>
            <x:Double x:Key="Width">732</x:Double>
            <x:Double x:Key="Height">620</x:Double>
            <x:Boolean x:Key="IsAnnotationDocked">True</x:Boolean>
          </scg:Dictionary>
        </sap:WorkflowViewStateService.ViewState>
      </sap2010:ViewStateData>
      <sap2010:ViewStateData Id="InitSettings_1" sap:VirtualizedContainerService.HintSize="786,1018" />
    </sap2010:ViewStateManager>
  </sap2010:WorkflowViewState.ViewStateManager>
</Activity>