ADROSONIC is an innovative, business-focused Digital consulting firm/solution provider which focuses on developing advanced technological solutions and has emerged as a trusted partner for both service and product-based companies. Possessing competencies in the fields of Robotic Process Automation, Data Analytics, CRM services, Application Services, Digital Quality Assurance and Software Testing, ADROSONIC strives to pave the Digital Roadmap for traditional business organisations and emerging start-ups. Catering to domestic as well as overseas clients in the UK, USA, UAE and Singapore, ADROSONIC marks a global presence with its offices in India and UK.

b0e51f2b-413d-4dfd-803e-c9b0fe3e542d.png

RPA Lead Engineer

These custom Audit Logging UiPath activities have been developed with the view of being event listeners for every process that’s developed. This will help in making sure that the audit logs developed can be used for Auditing and compliance.

Also, the logs, because of being in XML and JSON formats can be further uploaded or used by BI tools for analysis.

It will create a log file in 2 formats – XML or JSON which is decided by the User in the dropdown provided for each activity.

There are 2 activities in the Package:

**Append Audit Log Activity:**

*   This will append the Audit Log Message in an existing Audit Log File.
*   If the Audit Log file is not present, it will create a new one.

Input Parameters:

*   AuditLogType (select) – XML / JSON
*   FilePath (freetext) – Path at which the Audit Log will be stored.
*   Message Description (freetext) – Description of the Audit Log
*   Message Type (freetext) – Info / Warning / Error

**End Audit Log Activity:**

*   Only to be used if Log Type used for the project is in XML Format.
*   This audit log activity will close the Audit log XML.

Input Parameters:

*   FilePath (freetext) – Path at which the Audit Log will be stored.

Creating a Custom Audit Log in XML/JSON format and store it at a user specified location

This custom activity is a comprehensive text comparison tool that handles special characters and accents from a text. It's a very easy to use solution and is a great help to make sure you get accurate results for text comparison.

Below are some of the activities available in this package:

*   **Special Characters Exist** - verify if a particular text has any special character, which may lead to getting unhandled exceptions when processing.

If the return value is True - You can replace the special characters using the activity below.

If the return value is False - Your text is good for further processing.

*   **Replace Special Characters** - replace any special character in your text with its corresponding alphabetic character.

If there are no special characters in the text it will return it in its original form.

We will be developing a few more activities to make this package a complete Text Comparison Tool for all your needs.

Easily handle special characters and accents from a text

Business Consultant (R&I - RPA)

066cabb8-98a6-4b7a-a9b2-28301aa46ec8.png

In emails, .msg or .eml formats are particularly utilized universally and are preferred to other formats. This activity facilitates saving an email from .Net Mail Message object to .msg or .eml formats. This works irrespective of whether the Outlook application is installed in the target system or not.

This saved email, in .msg or .eml formats, can then be used for later pieces of automation for various purposes like keeping a record, uploading to a Document Management System like SharePoint or sending as an attachment through emails etc. The activities in this package can also save the attachments from .Net Mail Message object to the user-specified output location.

  

This package consists of the following activities:

  

1\. MailMessage to Eml

This activity helps in saving the .Net MailMessage format to .eml file in a user-specified location.

  

**Activity Parameters:**

**Inputs:**

· Eml File Name: File name of the email (.eml file) which is to be saved into a specified location.

· Mail Message: MailMessage object

· Output Location: Folder path in which the email file is to be saved.

**Options:**

· Save Attachments: Saves the attachments from .Net Mail Message object to the output location provided by the user.

  

  

2\. MailMessage to Msg

This activity helps in saving the .Net MailMessage format to .msg file in a user-specified location.

  

**Activity Parameters:**

**Inputs:**

· Msg File Name: File name of the email (.msg file) which is to be saved into a specified location.

· Mail Message: MailMessage object

· Output Location: Folder path in which the email file is to be saved.

**Options:**

· Save Attachments: Saves the attachments from .Net Mail Message object to the output location provided by the user.

It does not have an output. Rather, this activity saves the email at the desired location.

These activities save emails from .Net MailMessage format to .msg or .eml files at a user-specified location.

In emails, .msg or .eml formats are particularly utilized universally and are preferred to other formats. This activity facilitates saving an email from .Net Mail Message object to .msg or .eml formats. This works irrespective of whether the Outlook application is installed in the target system or not.

This saved email, in .msg or .eml formats, can then be used for later pieces of automation for various purposes like keeping a record, uploading to a Document Management System like SharePoint or sending as an attachment through emails etc. The activities in this package can also save the attachments from .Net Mail Message object to the user-specified output location.

  

This package consists of the following activities:

  

**1\. MailMessage to Eml**

  

This activity helps in saving the .Net MailMessage format to .eml file in a user-specified location.

  

**Activity Parameters**

  

**Inputs:**

  

· Eml File Name: File name of the email (.eml file) which is to be saved into a specified location.

· Mail Message: MailMessage object.

· Output Location: Folder path in which the email file is to be saved.

  

  

**2\. MailMessage to Msg**

  

This activity helps in saving the .Net MailMessage format to .msg file in a user-specified location.

  

**Activity Parameters**

  

**Inputs:**

  

· Msg File Name: File name of the email (.msg file) which is to be saved into a specified location.

· Mail Message: MailMessage object.

· Output Location: Folder path in which the email file is to be saved.

4c45c675-2713-4222-a130-616a086cd4a1.png

In a very general scenario, a RPA process may require retrieval of attributes of a saved email. This activity would come in handy when a Bot tries to retrieve email attributes in the background, without the need to open an email on UI.

  

A typical use case scenario would include an email (.msg file) saved locally in a folder. Since the information cannot be obtained directly, one needs to open it and then read the content manually. Automating this by UI Automation will create UI based dependencies and use of string manipulation which is not very reliable. The automation is performed in the background.

  

**Input Parameters:**

FilePath: File Location (Full Path)

  

**Output Parameters:**

Output: Mail Message Object (From, To, Cc, Bcc, Subject, Body, received/sent date (extracts date if the value is not null or empty, else it gives current date as an output) attributes can be retrieved).

  

For any queries you can reach out to us on: support@adrosonic.freshdesk.com

Extracts attributes of a saved email (.msg) in the background without opening the file.

In a very general scenario, a RPA process may require retrieval of attributes of a saved email. This activity would come in handy when a Bot tries to retrieve email attributes in the background, without the need to open an email on UI.

  

A typical use case scenario would include an email (.msg file) saved locally in a folder. Since the information cannot be obtained directly, one needs to open it and then read the content manually. Automating this by UI Automation will create UI based dependencies and use of string manipulation which is not very reliable. The automation is performed in the background.

  

**Input Parameters:**

FilePath: File Location (Full Path)

  

**Output Parameters:**

Output: Mail Message Object (From, To, Cc, Bcc, Subject, Body, received/sent date (extracts date if the value is not null or empty, else it gives current date as an output) attributes can be retrieved).

  

For any queries you can reach out to us on: support@adrosonic.freshdesk.com.

2b9fd8b4-bc36-4969-b4dd-c68044dcfa77.png

A typical use-case scenario would include an email (.msg file) and a requirement of extracting the attachments and their details, as it helps in obtaining valuable information directly from email and also helps in deciding the next steps of automation.

Extracting details of an email attachment proves to be troublesome since UI automation and String manipulation are not very reliable. Hence, this activity extracts the attachments, its details like size, type, creation date etc, and has the feature to save them in an user-defined location.

  

**Inputs Parameters:**

  

Save Msg Attachments: 

1\. Msg File Path: Full Path of the email (.msg file).

2\. Folder Path: Full path of the Folder where you want to save the attachments.

  

Msg Attachments: 

1\. Msg File Path: Full Path of the email (.msg file).

  

**Options:**

  

Save Msg Attachments:

1\. Delete Files: If checked then deletes existing files in the folder (location) selected to save the attachments.

  

**Output Parameters:**

  

Msg Attachments:

Attachments: A variable to extract all the attachments into a List.

  

For any queries you can reach out to us on: support@adrosonic.freshdesk.com

The activities in this package save and extract attachments and their details for a locally saved email (.msg file).

48d9c15f-3612-4503-a900-8b5f2e0e4383.png

A typical use-case scenario would include an email automation which requires creating and deleting various Outlook folders. The custom activities help in easily handling the Outlook folders with better accuracy and greater pace. They can be used along with larger processes, wherever required.

  

Activities present in this package:

  

**1.** **Create Folder**

This activity is used to create a main folder in Outlook. It is helpful in sorting the emails according to the usage and categorize them into folders. If the user-specified folder already exists, the activity does not overwrite the same.

  

Input Parameters:

FolderName: Folder name with which a main folder is to be created.

  

**2.** **Create SubFolder**

This activity is used to create a SubFolder under any main folder in Outlook. For a specific user, there might be a scenario where all the email automation folders have to be under a specific main folder based on their conditions. In such cases, this activity creates a subfolder automatically.

If the user-specified subfolder does not exist under a main folder, then this activity creates a new subfolder with the user-specified name. If the user-specified main folder also does not exist, then it creates a main folder along with the subfolder under it.

  

Input Parameters:

FolderName: Folder name under which a subfolder is to be created.

SubFolderName: Folder name with which a subfolder is to be created under any user-defined main folder.

  

**3.** **Delete Folder**

This activity deletes a user-specified main folder, except the default folders. In some scenarios, while working with email automation there might be a case to delete some main folders based on a few conditions.

  

Input Parameters:

FolderName: Folder name which is to be deleted.

  

**4.** **Delete SubFolder**

This activity deletes a user-specified subfolder under any main folder. In some scenarios, while working with email automation there might be a case to delete some subfolders based on a few conditions.

  

Input Parameters:

FolderName: Folder name under which a subfolder exists.

SubFolderName: Subfolder name that is to be deleted under a specified main folder name.

  

**5.** **Rename Folder**

This activity renames a user-specified folder. It might help in some cases, where renaming a folder could be a requirement.

  

Input Parameters:

ExistingFolderName: Folder name that is to be renamed.

NewFolderName: New folder name that is to be replaced with the existing name.

  

**6.** **Rename SubFolder**

This activity renames a user-specified subfolder existing under any main folder. It might help in some cases, where renaming a subfolder could be a requirement.

  

Input Parameters:

FolderName: Folder name under which a subfolder is present.

ExistingSubFolderName: Subfolder name that is to be renamed under the specified folder name.

NewSubFolderName: New subfolder name that is to be replaced with the existing subfolder name.

  

For any queries you can reach out to us on: support@adrosonic.freshdesk.com

These custom activities deal with Outlook main folders and subfolders.

88cb3362-18c2-4f91-b5de-5985ec975a96.png

Emails are an integral part of everyday automation processes across industries. In general, a RPA process may require conversion of email files to other formats. These activities come in handy when a bot tries to convert .eml to .msg file and .msg to .eml file, without the need to open an email on UI. This works irrespective of whether the Outlook application is installed in the target system or not.

  

A typical use case scenario would include an email i.e., (.eml or .msgfile) and a requirement of converting it to other formats i.e., .msg or .eml file respectively and saving into a user specified location. These saved emails, in .msg or .eml format, can then be used for later pieces of automation for various purposes like keeping records, uploading to a Document Management System like SharePoint or sending as an attachment through emails etc.

  

This package consists of the following activities:

**1\. Eml to Msg**

This activity helps in converting the locally saved .eml file to .msg file and saves into a user-specified location.

Activity Parameters:

· Eml File Path: Full path of the email (.eml file).

· Output Folder Path: Path of the folder where .msg file is to be saved after conversion.

· Msg File Name: File name of the email (.msg file) that is to be saved into a specified location.

  

**2\. Msg to Eml**

This activity converts a locally saved .msg file to .eml file and saves into a user-specified location.

Activity Parameters:

· Msg File Path: Full path of the email (.msg file).

· Output Folder Path: Path of the folder where .eml file is to be saved after conversion.

· Eml File Name: File name of the email (.eml file) that is to be saved into a specified location.

  

If the user-defined location does not exist, then these activities create folders and save the converted .msg or .eml file to that location.

The activities in this package convert .eml file to .msg file and viceversa.

9367f803-a8d7-4c99-8a8e-0b02ec87fe60.png

There are various folders and different forms of files which anyone deals with in their day to day lives. They come across various duplicate files which are difficult to find and segregate them based on certain norms. These custom activities would come in handy when the bot tries to discover and copy/move the files with specific extensions, duplicates or matched files to the user-specified location, without the need to open and verify them on UI.

  

If the user-defined destination folder does not exist, then these activities create folders and copy or move the files & folders into them.

  

This package consists of the following activities:

  

**1.** **Copy or Move Duplicate Files**

This activity copies or moves all the duplicate files present in a folder and its subfolders to the user-specified destination folder.

  

**Activity Parameters**

**Inputs:**

· Root Folder Path: Full path of the source folder.

· Destination Folder Path: Full path of the storage folder where all the duplicate files are to be copied or moved.

**Options:**

· Is Copy: If true, then files will be copied to the destination folder, else moved.

· Delete Files: Deletes the files and folders from destination folder if any exist.

  

**2.** **Copy or Move Files and Folders**

It copies or moves all the files to destination folder if opted for only files, else it copies or moves all the files and subfolders.

  

**Activity Parameters**

**Inputs:**

· Root Folder Path: Full path of the source folder.

· Destination Folder Path: Full path of the storage folder where all the duplicate files are to be copied or moved.

**Options:**

· Is Copy: If true, then files will be copied to the destination folder, else moved.

· Delete Files: Deletes the files and folders from destination folder if any exist.

· Only Files: If true, the activity copies or moves only files, else it copies or moves all the files and folders.

  

**3.** **Copy or Move Files with Extensions**

This activity copies or moves all the files which are of user-specified extensions from source folder to the destination folder.

  

**Activity Parameters**

**Inputs:**

· Root Folder Path: Full path of the source folder.

· Destination Folder Path: Full path of the storage folder where all the files are to be copied or moved.

· Extensions: Array of extensions, which will be used for copying or moving the files.

**Options:**

· Is Copy: If true, then files will be copied to the destination folder, else moved.

· Delete Files: Deletes the files and folders from destination folder if any exist.

  

**4.** **Copy or Move Matched Files**

It copies or moves all the matched files between two folders to a destination folder.

  

**Activity Parameters**

**Inputs:**

· First Folder Path: Full path of the first folder.

· Second Folder Path: Full path of the second folder.

· Destination Folder Path: Full path of the storage folder where all the duplicate files are to be copied or moved.

**Options:**

· Is Copy: If true, then files will be copied to the destination folder, else moved.

· Delete Files: Deletes the files and folders from destination folder if any exist.

The activities in this package copy or move files and folders based on certain criteria like duplicate, matched files, and file extensions.