Sopra Steria Group SA (commonly referred to as Sopra Steria) is a European information technology consultancy established in September 2014 upon the merger of Sopra Group SA and Groupe Steria SCA (commonly referred to as Sopra and Steria, respectively). Technically, Sopra was the company to adopt the new name, retaining its legal personality.

The primary business areas of the company include consulting services, systems integration and solutions, integration of ERP solutions, implementation of application solutions, as well as subcontracting solutions for providing technical support to users and application maintenance and outsourcing services and operation of professional processes.

2871183a-78d5-4e86-9ef7-3ddb308a13d8.png

Manager

Email details can be retrieved easily using ‘Get Outlook mail message’ activity within UiPath, however, using the filter property requires multiple syntaxes to be used to filter contents from an email.

  

We have created an email activity for UiPath where all the required options such as Body, Email Received Date, Subject etc. would be available within Filter section, which can be easily used to filter emails along with the customised filter option. This will also eradicate the requirement of using syntaxes to filter emails.

  

Benefits

*   Effort reduction in BOT designing where identified processes requires emails to be filtered as per the business requirement.
*   Simplify BOT development for Outlook activities, especially beneficial for developers with no programming background.
*   Customised Outlook Activity details.

This activity can be deployed to fetch Outlook mail messages from the specified folder from the Outlook Mailbox based upon the optional input of filters. The input includes:

  

**Inputs**

*   Account Name - Name of the Outlook account.
*   Folder Name - Name/path of Outlook folder from which mails are to be retrieved.
*   Body: Text to search for in the body of the mail message.
*   Mark As Read: Mark retrieved messages as Read. Specifies whether the retrieved messages should be marked as read. By default, it is set to false.
*   Only Unread mail: Retrieve only unread mails from mail folder. Specifies whether to read only unread messages. By Default, it is set to false.
*   Recipient Email Address: Filter on recipient’s email address. It retrieves all the mails sent to specified email address.
*   Sender Email Address: Filter on sender’s email address. It retrieves all the mails received from the specified email address.
*   Start Date: Retrieve mails between specified start and end dates. If no end date is specified, mails between specified start date to current date are retrieved. Retrieves all the mails with the date between specified Start Date and End Date parameters. If End Date input is not specified, all the mails till current date are retrieved. Specify input date string in the format yyyy-MM-dd hh:mm:ss. If time is not specified, default time is added as 00:00:00.
*   End Date: Retrieve mails between specified start and end dates. If no start date is specified , all the mails till specified end date are retrieved. Retrieves all the mails with the date between specified Start Date and End Date parameters. If Start Date input is not specified, all the mails till specified end date are retrieved. Specify input date string in the format yyyy-MM-dd hh:mm:ss. If time is not specified, default time is added as 23:59:59.
*   Exact Match for subject: Specify if subject should be matched exactly to input text. Specifies whether input specified in Subject field should be matched exactly with the subject of emails in mailbox. By Default, it is set to false.
*   Subject: Text to search for in subject of mail message. Retrieves all the mails which contain the specified input in subject line

  

The Output of this activity is a List of MailMessage. This activity can be easily integrated with existing activities for Outlook.

Microsoft Outlook is widely used in many processes automated via UiPath. One of the key challenges which developers are facing with Outlook activity is related to filtering the emails.

Consultant

While downloading reports in Internet Explorer sometimes a pop up appears to save the password, which doesn’t allow to click on Save/Save As option to download the report.

As there are no shortcut keys available to overcome this challenge, this snippet will disable the password option. 

The snippet uses the screen navigation to achieve this as the screen is the standard one which is used everywhere.

This Snippet helps with disabling the option in Internet Explorer to show pop up windows

The bot executes an embedded VBA script to add borders in specified cells in Excel. If the cell addresses are dynamic/unknown, then leave starting and ending cell entry blank and the activity will add borders to all updated cells in conjuction with cell A1.

Please ensure to check "Trust access to the VBA project obejct model" in Excel trust center options before using this activity.

RPA Developer

This activity allows you to add the font style in your specified Excel cells as Bold, Italic and Underline as per your requirement. It executes a VBA script to apply font on cells. 

To use this activity the user just needs to specify the Excel file name, sheet name, cell range and font style which the user wants to apply on a cell. 

  

Please ensure to check "Trust access to the VBA project object model" in Excel Trust Center options before using this activity.

Format font style in Excel cells as Bold, Italic or Underline

One of the challenges faced by Excel users is to delete a specified sheet. Currently, there is no activity available which can be used to overcome the above challenge except for this Snippet.

 This snippet can be used in any domain which supports Microsoft Excel services.

This activity allows you to automate Excel files and delete the desired Excel worksheet from it

The snippet can be used to create the current date folder using current year and monthand as an option, it overwrites the folder and its contents if it already exists.

The given activity already handles the validations of existence of the folders and creates a new folder if it does not exist. The user is required to input the base location where the folders are to be created and this activity will automatically create the folders. If the folder already exists the user has an option to choose if the folder and its contents need to be overwritten.

**Example**: Let us assume today's date is January 1st 2020 and the user wants to create the folder at C:\\UIPATH, the activity will create the folders in the given manner:

C:\\UIPATH\\ 2020\\Jan\\1

**Inputs:**

1\. In\_FolderPath: The base location where the user wants to create the folders.

2\. in\_OverwriteFolder: This is the flag which is used by the user to instruct to overwrite the folders and its contents if the path already exists. If left blank, the activity will assume it to be false.

**Output:**

1\. out\_FolderCreated: This will give the output i.e. True or False. True in case the action is completed and the folders are created, else False.

2\. out\_FolderPath: This will return the absolute Path of the created folder.

Many projects require to create the current date folder using Year and Month. This snippet will create the folders and overwrite as per user's input

Email details can be retrieved easily using ‘Get Exchangemail message’ activity within UiPath, however, filtering option is not available so we get only top mails. 

  

This activity is used to filter the mails using exchange on the basis of Subject, Body ,Received Date & unread mail. The output of this activity can be used with other exchange activities of UiPath.

  

**Customized Exchange Activity Details**

  

Custom Activity to fetch mail messages from the specified folder of Exchange Mailbox based upon the optional input of filters. 

The Inputs include:

  

*   **Body:** Text to search in body of the mail message
*   **Mark As Read:** Mark retrieved messages as Read. Specifies whether the retrieved messages should be marked as read. By default, it is set to false.
*   **Only Unread mail:** Retrieve only unread mails from mail folder. Specifies whether to read only unread messages. By Default, it is set to false.
*   **Start Date:** Retrieves all the mails with the date between specified Start Date and End Date parameters. If End Date input is not specified, all the mails till current date are retrieved. Specify input date string in the format MM-dd-yyyy hh:mm:ss AM/PM. If time is not specified, default time is added as 00:00:00
*   **End Date:** Retrieve mails between specified start and end dates. If no start date is specified, all the mails till specified end date are retrieved. Retrieves all the mails with the date between specified Start Date and End Date parameters. If Start Date input is not specified, all the mails till specified end date are retrieved. Specify input date string in the format MM-dd-yyyy hh:mm:ss AM/PM. If time is not specified, default time is added as 23:59:59.
*   **Subject:** Text to search for in subject of mail message. Retrieves all the mails which contain the specified input in subject line. This can read from the shared mailbox also.

The **Output** of this activity is a List of MailMessage. This activity can be easily integrated with existing activities for Exchange.

Filter the mails in Exchange on the basis of specific criteria like Subject, Body, Date,etc.The output can be used with other exchange activities.

This customized UiPath form has been integrated with Salesforce CRM tool via Salesforce Lightning Platform REST API in such a manner that all the required information of the caller will be displayed within the form on real time basis, which can be used by agent for verification purpose. Analysis Tab within the form will populate callers last call details and open case details, if any. This will help the agent to view caller’s historic call details within the form itself and a personized customer service can be imparted.

  

The form was further integrated with Python where a ML/ NLP script will be invoked to perform sentiment analysis based on last 5 calls which will give the agent an insight about caller’s previous calls. Any request or queries on HR/Payroll can be initiated using the form and upon submission a new call log entry will be added into Salesforce CRM tool and the details are further stored within SQL database which will further be used by Performer BOT to process the transactions on ERP system.

**An end to end solution was provided where a contact center agent can follow the BAU process by using UiPath customized form only without having access to any of the client system.**

Customized UiPath form which has been integrated with Salesforce CRM tool, SQL Server, Python to automate HR Advise and Guidance contact center process.

Here are the process steps:

  

**Pre-requisites/pre-conditions:**

*   The company has to register their account on h[ttps](https://developer.twitter.com/en/apps)[://developer.twitter.com/en/apps](https://developer.twitter.com/en/apps)  to obtain the consumer key and callback URL.
*   The Bot will read the tweets from the status list sheet.
*   _Consumer key_ and _callback URL_ are fetched from Orchestrator through Assets so add in the assets as shown in the project description's attached document.
*   Through API calls the authentication token and secret key will be generated.
*   Through API calls the tweet will be posted on the Twitter account.
*   All the information is available in the description document attached in the Resources section.

This bot is created to post the tweets without logging into Twitter account. It will handle all the tweets and their media according to the scheduled time along with few more parameters