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.

95328908-bbf5-43dd-a973-72bcb66390eb.png

Scalable and Robust Automation solutions with optimized license usage so as to minimize subscription and operational costs. If you have already implemented your automations or starting afresh it makes sense to visit the license usage and costs. Also projecting the license costs based on the automation pipeline helps in the long run.

  

Our holistic approach towards a fully automated enterprise allows us to work as a consultancy with the process owners and SMEs to define a long term strategy and design their automation operating model. Our technical capabilities include requirement analysis, design, infrastructure management, license optimization, development, testing UAT and deployment.

**We specialize in transforming a business to become a fully automated enterprise** and realize a near, quick ROI. Our focus and niche have been process automation and supporting services like Process Mining, Document Understanding, Machine Learning (AI) and Infra Management. Please visit our [case studies](https://www.auxiliobits.com/work/) and [blogs](https://www.auxiliobits.com/insights/).

  

**Analytics Around License Usage:**

  

*   How many unattended and attended bots needed
*   Bot hours calculation (occupied bot hours and free bot hours)
*   Cost per bot-hour calculation (taking into account the infra and maintenance costs)
*   UiPath SKU usage and understanding
*   UiPath SKU requirement and projections

**Methods used to optimize licenses:**

*   Parallel processes making use of different browsers
*   Background processes run along with foreground processes
*   Analytics on transaction porocessing times and thus optimizing them
*   Process automation implementation reviews to remove unoptimized code
*   Follow best automation practices to not compromise on robustness and scalability
*   Calculating cost per bot-hour spend and optimizing it

  

**Verticals and Domains**

  

*   US Healthcare
*   BFSI
*   Manufacturing
*   Real Estate

  

**Services Provided**

  

*   Business Analysis
*   Solution Architecture
*   Solution Design to optimize license usage
*   Setting up Test and Production environments
*   Solution Implementation and Development
*   Infrastructure Setup and Management
*   Process Analytics using tools like Elastic Search and Kibana
*   Building Automation Operating Model
*   Fully outsourced or Hybrid CoE
*   RPA Best Practices including documentaton

  

**Automation Types Supported:**

*   Attended
*   Unattended
*   Hybrid

**UiPath Products Used:**

*   Studio
*   Orchestrator
*   AI Center
*   Document Understanding (DU)
*   Action Center
*   Test Manager
*   Process Mining
*   Automation Hub

Design your automation solutions in a way so as to optimize UiPath license usage and get the most out of your investment. Efficient running of the bots deployed on an optimized infrastructure is key!

112f0ba9-227e-416a-9833-d9d81c5e8514.png

Scalable and Robust Automation solutions for automating periodic material ledger closing for better efficiency and minimal operational costs.

  

Our holistic approach towards a fully automated enterprise allows us to work as a consultancy with process owners and SMEs to define a long term strategy and design their automation operating model. Our technical capabilities include requirement analysis, design, infrastructure management, license optimization, development, testing UAT and deployment.

  

**We specialize in transforming a business to become a fully automated enterprise** and realize a near, quick ROI. Our focus and niche have been process automation and supporting services like Process Mining, Document Understanding, Machine Learning (AI) and Infra Management. Please visit our [case studies](https://www.auxiliobits.com/work/) and [blogs](https://www.auxiliobits.com/insights/).

  

**MLC (Material Ledger Closing)**: For this process, a BOT creates costing jobs to close materials of different company codes and then runs those jobs to execute the closing process. To accomplish this, the BOT first logs in to the SAP NetWeaver portal and downloads SAP Business Suite, navigates to the costing cockpit to create costings and execute jobs. After jobs execution, the BOT checks for job failures; in case of any job failure, it creates a ServiceNow ticket and sends an email.

  

**Overview of Process Automation Steps**

1.  On Day 1 the RPA bot allows the price determination and allows the closing entry. It rechecks the price determination and closing entry, checks the lock, the previous and current status of the plant.
2.  On Day 2 the RPA bot checks price determination and closing entry, lock, current and previous status.
3.  On Day 3 the bot first checks the current status. If the current status is not successful then it sends a mail to stakeholder/business users and creates a ServiceNow ticket. Then the bot checks the status of the query. If the query is finished successfully, it checks the post-execution, and the current status. If failed then the bot sends an email to the business user and creates a ServiceNow ticket.

**Verticals and Domains**

*   Retail
*   Manufacturing
*   ECommerce

**Services Provided**

*   Business Analysis
*   Solution Architecture
*   Solution Design to optimize license usage
*   Setting up Test and Production environments
*   Solution Implementation and Development
*   Infrastructure Setup and Management
*   Process Analytics using tools like Elasticsearch and Kibana
*   Building Automation Operating Model
*   Fully outsourced or Hybrid CoE
*   RPA Best Practices including documentaton

**Automation Types Supported:**

*   Attended
*   Unattended
*   Hybrid

**UiPath Products Used:**

*   Studio
*   Orchestrator
*   AI Center
*   Document Understanding (DU)
*   Action Center
*   Test Manager
*   Process Mining
*   Automation Hub

Automate your tedious and time consuming periodic Material Ledger Closing SAP process with RPA.