b08830ca-c044-46f7-a91a-a33e3187279c.JPG

80caeae1-269c-4ffe-91ea-b206b47d2bba.png

In REFramework model it is easy to initialize the configuration through **InitAllSettings** workflow, but in a normal flowchart process, it is a very time-consuming task to read configure variable from an Excel file and then save it in a Dictionary object.

This listing solves this problem in an easy way.

  

Settings are read from a local Excel file (.xls or .xlsx) that stands for Input. This activity takes one Input that is the **Path of the Excel file (.xls or .xlsx) as String.**

  

The Output is the collection variable as Dictionary .

  

**NOTE:** If you are familiar with REFramework, this component does the same thing as **InitAllSettings** workflow does.

This package outputs a Settings Dictionary with key/value pairs.

In REFramework model it is easy to initialize the configuration through **InitAllSettings** workflow, but in a normal flowchart process it is a very time-consuming task to read configure variable from an Excel file and then save it in a Dictionary object.

This listing solves this problem in an easy way.

  

Settings are read from a local Excel file (.xls or .xlsx) that stands for Input. This activity takes one Input that is the **Path of the Excel file (.xls or .xlsx) as String.**

  

The Output is the collection variable as Dictionary .

  

**NOTE:** If you are familiar with REFramework, this activity does the same thing as **InitAllSettings** workflow does.

The listing efficiently solves the problem that most activities return the output as DataTable or Excel. 

If you are required to send the value of a DataTable to the web or other external services APIs, you will need a JSON string format.

  

This activity easily converts DataTable to JSON format.

This activity converts DataTable to JSON String.

The listing efficiently solves the problem that most activities return the output as DataTable or Excel. If you are required to send the value of a DataTable to the web or other external services APIs, you will need a JSON string format.

  

This activity easily converts DataTable to JSON format.

This Activity Perform Set Operation between two DataTable as we do in RDBMS.

  

1) Minus Operation: MINUS (also known as EXCEPT) returns the difference between the first and second SELECT statement. It is the one where we need to be careful which statement will be put first because we will get only those results that are in the first SELECT statement and not in the second.

This activity takes the following Input:

1) Primary DataTable

2) secondary Datatable

3) Column Name as String

The Output is the Filtered DataTable.

  

2) INTERSECT: INTERSECT is opposite to MINUS as it returns the results that are both to be found in first and second SELECT statement.

This activity takes the following Input:

1) Primary DataTable

2) Secondary Datatable

3) Column Name as String

  

The Output is the Filtered DataTable.

  

3) Union: It returns a union of two select statements. It is returning unique (distinct) values of them.

This activity takes the following Input:

1) Primary DataTable

2) Secondary Datatable

Output is the Filtered DataTable.

  

Note: Column Name Must be same in both DataTable

This activity performs a set of operations like Minus, InterSect, Union between two DataTable as we do in RDBMS

This package consists of the following activities:

  

1) **Minus Operation:** MINUS (also known as EXCEPT) returns the difference between the first and second SELECT statement. It is the one where we need to be careful which statement will be put first because we will get only those results that are in the first SELECT statement and not in the second.

  

This activity takes the following Input:

1) Primary DataTable

2) secondary Datatable

3) Column Name as String

  

The Output is the Filtered DataTable.

  

2) **INTERSECT:** INTERSECT is the opposite of MINUS as it returns the results that are both to be found in first and second SELECT statement.

  

This activity takes the following Input:

1) Primary DataTable

2) Secondary Datatable

3) Column Name as String

  

The Output is the Filtered DataTable.

  

3) **Union:** It returns a union of two select statements. It is returning unique (distinct) values.

  

This activity takes the following Input:

1) Primary DataTable

2) Secondary Datatable

  

Output is the Filtered DataTable.

  

**Note:** Column Name must be the same in both DataTables.

This activity performs a set of operations like Minus, InterSect, Union between two DataTable as we do in RDBMS.

This Activity takes the following **Input**:

1) DataTable

2) FilePath with FileName as String

3) WriteMode (IgnoreSchema by default) as String

  

The **Output** will be a Boolean value. The user can check the result of the operation (true if successful or false otherwise).

This Custom Activity converts Datatable to a XML File.

This Activity takes the following **Inputs:**

  

1) DataTable

2) FilePath with FileName as String

3) WriteMode (IgnoreSchema by default) as String

  

The **Output** will be a Boolean value. The user can check the result of the operation (true if successful or false otherwise).

This activity converts DataTable to a XML File.

The automatic addition of names and addresses from a database to letters and envelopes in order to facilitate sending mail, especially advertising, to many addresses

Mail merge is a feature within most data processing applications that enables users to send a similar letter or document to multiple recipients. It enables connecting a single form template with a data source that contains information about the recipient's name, address and other predefined and supporting data.

  

This template contains the following steps:

1) Read .txt file that contains letter or document.

2) Read Excel file that contains email and predefined information that the user want to replace in content.

3) Replace predefined value from actual value.

4) Send mail to recipients.

  

You can use this in any project as well as a standalone workflow.

  

NOTE: The predefined value in Content is the same as column name in Excel and before using this template, set your email credential, server detail and sender details also.

This package consists of the following two activities:

  

1\. **Inbound Activity** - It uploads the files into Vidado platform. It returns an ID and Name after successful upload of files.

  

2\. **Outbound Activity** - We can fetch the files based on the status argument. For files that are 'Ready to Export' we shall receive JSON and Dictionary result.  'Reviewing' status helps to get the names of files under reviewing state in Vidado.

This component helps integrating Vidado OCR with UiPath. Vidado helps to achieve digitization of human handwritten text. The platform provides reading, enriching and delivering data from paper-based source.

About me